Adding Excel File Upload option to product_csv module

[johnjames84]

Does this work for VM 1.1.0 with PHP version < 5.

Thanks
James

[crittle1]

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]

Thanks,
its great.
Lev

[Vinh]

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]

Preview should work. Looks like something wrong with the excel file. You can post your xls here. What vm version are you using?

[Vinh]

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]

Are you having the excel file opened when you upload the file?

[Vinh]

no nothing is open at that time. Do I have a VM version which is maybe not supported?

[Joseph Kwan]

Strange. I have no problem uploading your file.

[volt]

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]

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]

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.

[ceemjay]

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]

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.

[webdew]

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]