Adding Excel File Upload option to product_csv module

[Joseph Kwan]

Look like you are having problem with CSV_Improved. Your question should be directed to their web site.

[webdew]

Hi Mr. Kwan,

Don't you have a sample file of all fields that virtuemart use and whats supported by this.

[soca]

Hi,

I am a newbie tasked with taking over a project that runs on VM 1.0.12. As of now, an up grade to 1.0.15 is out of the question.

I have installed the excel file upload hack and tried uploading afew products without images and that works fine. I am strugling to see how I can upload product images

Is there a step by step on what to do? where the images should be uploaded to?

Also, if there are hundreds of products and I want to delete all the products, is there a simple way to do this?

regards
Soca

[Joseph Kwan]

The simplest way to upload images is to name your image file according to your product sku. Put the file name in the xls file in the column product_full_image and product_thumb_image. Image files should be uploaded by ftp to the directory components/com_virtuemart/images/product/. You should have the dynamic generate thumb in vm config checked.

[Rookie18]

Hello Mr.Kwan,

I have downloaded the pack, and installed it like the instruction said.
I work with VM 1.1.0 stable and Joomla dutch version.
Wen i want to integrate the functions i get a error massage:
Fatal error: Cannot redeclare class ps_csv in /administrator/components/com_virtuemart/classes/ps_csv.php on line 2761
Wat can i have done wrong ?
Can you help me ?

Thanks
Ron

[Joseph Kwan]

Hi Ron,
This hack is for vm1.0.x and will not work in vm1.1. Actually the CSV module for vm1.1 have been removed completely.

[alexdaydreaming]

Hi Joseph,

I am new to VM and have recently installed VM 1.1.3. And now I have 800+ item to upload to my site. I surely need this hack to help.

Can you pls post an update hack for VM1.1.3?

Thanks a million!
Alex

[Joseph Kwan]

Alex,
CSV upload is not in the core vm 1.1 and above. You can consider using CSVI instead. If you need further help, please PM me.

[stijn81]

Hi There,

I assume I've followed the installation correctly, but a csv export button does not appear in my virtuemart menu (backend). Only csv export with a link to csv improved.

Have you got any clue what might have gone wrong? I use vm 1.1.2

Thanks

[stijn81]

Or should I use CSVI as well?

Thanks,

[Joseph Kwan]

Please check the posting above.

[stijn81]

Hi Joseph,

Thanks, saw that. However CSVI is not very user-friendly to my opinion. I would like to work with direct Excel files. I''ve tried CSVI, and used a ";" as seperator, which is most friendly with Excel. However, still quite some error-notifications. Have you got any other lead towards a more user-friendly (excel) solution than CSVI?

Thanks,

[Joseph Kwan]

It's a decision of the development team to drop CSV upload support from vm1.1. The duty has been offloaded to CSVI. While I am not in a position to explain how CSVI works (you should direct your questions to them), I believe you can upload XLS file without using any of those separators. Just make your xls file properly formatted and upload it. CSVI will handle the translation. I mean XLS file, not TXT or CSV file. If you need further help, PM me.

[stijn81]

Thanks, I'll try and get CSVI to work... Thanks for the replies.

[lenny1988]

i downloaded the hack and upload to the server and i tryed to add the functions to the product modul but i get an error as so as i select ps_xls

see attach

greets lenny

[attachment cleanup by admin]