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

Kevin

  • Jr. Member
  • **
  • Posts: 160
Re: Adding Excel File Upload option to product_csv module
« Reply #240 on: March 30, 2008, 15:52:36 pm »
Hi Joseph,

How can I add the field related_products to the excel export? 

Thanks,
Kevin

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #241 on: March 31, 2008, 08:16:24 am »
To add support for related_product, you will need to add the function to ps_csv.php. This is not a difficult task but will need some effort.
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.

abrownleo

  • Beginner
  • *
  • Posts: 3
Re: Adding Excel File Upload option to product_csv module
« Reply #242 on: April 09, 2008, 09:14:53 am »
Hi Joseph

Here is the link for excel doc.

Thanks Again
Andrea

[attachment cleanup by admin]

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #243 on: April 09, 2008, 18:38:35 pm »
There's a blank column in your file. Blank column is not allowed.
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.

abrownleo

  • Beginner
  • *
  • Posts: 3
Re: Adding Excel File Upload option to product_csv module
« Reply #244 on: April 09, 2008, 23:57:11 pm »
Joseph... You know what you are... A legend!!! Thankyou so much, its all working great now. Thanks Again for your time and help!!

smkjr

  • Beginner
  • *
  • Posts: 19
Re: Adding Excel File Upload option to product_csv module
« Reply #245 on: April 15, 2008, 16:45:45 pm »
Does this hack work in Joomla 1.5 & the latest 1.1.0 release?

smkjr

  • Beginner
  • *
  • Posts: 19
Re: Adding Excel File Upload option to product_csv module
« Reply #246 on: April 15, 2008, 16:59:25 pm »
When i am on the admin section of VM i get:

Fatal error: Cannot redeclare class vmLanguage in /home/discsem/public_html/cms/j15/administrator/components/com_virtuemart/languages/english.php on line 1896

ANy ideas?

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #247 on: April 15, 2008, 17:48:33 pm »
No, the hack doesn't work with 1.1.0. VM 1.1.0 has its official csv upload (which linked to csvimproved component). I will consider porting the hack to this new version unless there are popular demand.
For the fatal error, you are probably messing up the language 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.

cliffclof

  • Beginner
  • *
  • Posts: 24
Re: Adding Excel File Upload option to product_csv module
« Reply #248 on: April 16, 2008, 04:02:33 am »
I installed this tried all the hacks and fixes and can't seem to get a sheet to upload.  all it does is try to open some random excel file when i click the upload button.

Any ideas how to get passed the open popup?

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #249 on: April 16, 2008, 07:22:13 am »
Sorry, I don't quite understand your problem. You are suppose to select the excel file you to upload in the popup. And then click the upload button.
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.

cliffclof

  • Beginner
  • *
  • Posts: 24
Re: Adding Excel File Upload option to product_csv module
« Reply #250 on: April 17, 2008, 05:46:28 am »
I select excel file, click upload.   I get a window asking me to open an excel sheet and nothing uploads.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #251 on: April 17, 2008, 06:06:36 am »
The procedure should be
1. click browse button. a popup will open where you can select the file.
2. when you click open, a file path will be placed in the textbox.
3. click the submit link to upload the file.

Make sure you have the proper language file elements to the language file if your default language is not English.
If you followed this procedure and yet no file is uploaded, then there is some problem with the xls file you are uploading. You can then post the xls file here.
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.

cliffclof

  • Beginner
  • *
  • Posts: 24
Re: Adding Excel File Upload option to product_csv module
« Reply #252 on: April 18, 2008, 03:19:02 am »
yes i did that exactly and a few other things to troubleshoot.  I'll have to try the test xls file and see if it has the same problems, but I have a feeling it will do the same unless the code is meant to bring up an open dialog when it reads a bad xls file.

Thanks for the help btw

gwnail

  • Beginner
  • *
  • Posts: 6
Re: Adding Excel File Upload option to product_csv module
« Reply #253 on: May 07, 2008, 07:39:52 am »
Is the a version of VirtueMart - Excel Upload hack that will work with Joomla_1.0.15_eCommerce_Edition_VM_1.0.15?

Thanks.

gwnail

  • Beginner
  • *
  • Posts: 6
Re: Adding Excel File Upload option to product_csv module
« Reply #254 on: May 07, 2008, 07:40:49 am »
Is there a version of VirtueMart - Excel Upload hack that will work with Joomla_1.0.15_eCommerce_Edition_VM_1.0.15?

Thanks.