Author Topic: Adding Excel File Upload option to product_csv module  (Read 320617 times)

johnjames84

  • Beginner
  • *
  • Posts: 24
Re: Adding Excel File Upload option to product_csv module
« Reply #270 on: July 31, 2008, 06:53:56 am »
Does this work for VM 1.1.0 with PHP version < 5.

Thanks
James

crittle1

  • Jr. Member
  • **
  • Posts: 58
Re: Adding Excel File Upload option to product_csv module
« Reply #271 on: August 18, 2008, 05:17:56 am »
Although this was for Joomla, I tried in on Mambo.
(I am getting the security token pop up too.)
I'm running vm 1.1.2 and mambo 4.6.5
This does keep the token from coming up, but it does mess around with positioning
of the admin panel, the save/cancle icons disappear and some functions do not work. So, Mambo users may want to try something else.

kiskavics

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv module
« Reply #272 on: September 04, 2008, 11:06:14 am »
Thanks,
its great.
Lev

Vinh

  • Beginner
  • *
  • Posts: 19
Re: Adding Excel File Upload option to product_csv module
« Reply #273 on: September 30, 2008, 06:14:46 am »
I have been trying for a couple of hours now but somehow cannot get it up and running. I have installed the 0.6 version of the hack and the csv upload now shows "csv/excel file upload". I'm also able to select the sample excel file for upload so I assume the installation went fine.

However the results table always shows "Count Total: 0" and nothing seems to have changed in the database. Any clue why that could be?
I've turned on "Collect debug information" but nothing special is outputed (actually nothing). The preview function I think is not implemented?!

I'm on a mac. But that shouldn't be a problem, especially since I haven't even touch the sample.xls with the Mac version of Excel.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #274 on: September 30, 2008, 18:30:14 pm »
Preview should work. Looks like something wrong with the excel file. You can post your xls here. What vm version are you using?
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

Vinh

  • Beginner
  • *
  • Posts: 19
Re: Adding Excel File Upload option to product_csv module
« Reply #275 on: October 03, 2008, 08:01:35 am »
Hi Joseph,

sorry for the late reply. Have been outstation for some days.

I'm using "Joomla! 1.0.12 Stable (Sunfire) eCommerce Edition" with
VirtueMart 1.0.10. The xls file is attached (taken from the v0.6 zip file).

Thanks a lot for your help!

[attachment cleanup by admin]

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #276 on: October 04, 2008, 07:15:05 am »
Are you having the excel file opened when you upload the file?
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

Vinh

  • Beginner
  • *
  • Posts: 19
Re: Adding Excel File Upload option to product_csv module
« Reply #277 on: October 04, 2008, 07:25:40 am »
no nothing is open at that time. Do I have a VM version which is maybe not supported?

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #278 on: October 04, 2008, 08:18:21 am »
Strange. I have no problem uploading your file.
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

volt

  • Beginner
  • *
  • Posts: 6
Re: Adding Excel File Upload option to product_csv module
« Reply #279 on: October 09, 2008, 11:08:53 am »
try the fix on the previous page and let us know if that works.
not work
I,m problem
vm 1.0.14 jooma 1.0.13
export/import product's
MESSENGER
Sorry but we could not verifi your Security Token. Go bac and try again please

ceemjay

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #280 on: October 23, 2008, 21:04:28 pm »
I think I am being really dense and missing something! It might be in the 19 pages of this topic somewhere but I can't find it. First a few questions:

1. Is there a 'native' CSV upload that comes with the VM installation?
2. Does this hack require any CSV upload to be installed first eg CSVI?
3. I have installed CSVI and the hack - how do I upload XLS files?

I have scoured around for ages looking for an "idiot's guide to XLS and CSV import" but seem to have missed it - please could someone point me in the right direction. Posting here seems to be an admission of failure!

Thanks for your help in advance
Clive

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #281 on: October 23, 2008, 21:17:04 pm »
The answer depends on what vm version you are using.
VM 1.0.x used to have a CSV upload module included. This module is removed from the core in VM 1.1. Instead they recommend using CSVI.

This hack is for VM 1.0.x and has nothing to do with CSVI.
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

ceemjay

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #282 on: October 24, 2008, 20:07:04 pm »
Thanks Joseph

I am using the latest VM. Did I miss than in the documentation somewhere?

Cheers
Clive



The answer depends on what vm version you are using.
VM 1.0.x used to have a CSV upload module included. This module is removed from the core in VM 1.1. Instead they recommend using CSVI.
This hack is for VM 1.0.x and has nothing to do with CSVI.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #283 on: October 27, 2008, 07:30:57 am »
Sorry for vm 1.1 and later, CSV upload function is not provided. This hack will not work either. There is a link to CSVI website in the default vm menu.
Joomla/VM Upgrade Services. Problems with your migration? We can help.
Custom extensions to VM. Performance Tuning. Template modifications and advices.
Pay service to make VM work according to your needs. Your Joomla/VM solutions are just a PM away.

webdew

  • Beginner
  • *
  • Posts: 2
Re: Adding Excel File Upload option to product_csv module
« Reply #284 on: January 29, 2009, 05:25:18 am »
Hi Mr. Kwan,

I'm new to the import/export business and like to find some help. I've downloaded your code and installed everything fine. Now when I import I can see the tables and everything but I get Incorrect Column count errors?

Also need to seek novice help with the com_csv_improved module I've attached a view images maybe you can help me with the general settings to set this thin up correctly?

Got no errors like the other people did so I think my install was correct, followed all your instructions.

Thank you for all the help.

j

[attachment cleanup by admin]