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

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #285 on: January 29, 2009, 06:39:03 am »
Look like you are having problem with CSV_Improved. Your question should be directed to their web site.
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 #286 on: January 29, 2009, 09:25:21 am »
Hi Mr. Kwan,

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

soca

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv module
« Reply #287 on: March 18, 2009, 13:54:35 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #288 on: March 18, 2009, 17:37:53 pm »
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.
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.

Rookie18

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv module
« Reply #289 on: July 13, 2009, 17:07:21 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #290 on: July 13, 2009, 19:53:14 pm »
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.
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.

alexdaydreaming

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv module
« Reply #291 on: September 28, 2009, 12:35:59 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #292 on: September 28, 2009, 19:26:51 pm »
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.
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.

stijn81

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #293 on: October 14, 2009, 20:03:30 pm »
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

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #294 on: October 14, 2009, 20:06:03 pm »
Or should I use CSVI as well?

Thanks,

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #295 on: October 15, 2009, 07:56:53 am »
Please check the posting above.
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.

stijn81

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #296 on: October 15, 2009, 16:20:02 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #297 on: October 15, 2009, 17:51:19 pm »
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.
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.

stijn81

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #298 on: October 16, 2009, 12:14:54 pm »
Thanks, I'll try and get CSVI to work... Thanks for the replies.


lenny1988

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv module
« Reply #299 on: November 29, 2009, 17:18:45 pm »
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]