Adding Excel File Upload option to product_csv module

[Kevin]

Hi Joseph,

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

Thanks,
Kevin

[Joseph Kwan]

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.

[abrownleo]

Hi Joseph

Here is the link for excel doc.

Thanks Again
Andrea

[attachment cleanup by admin]

[Joseph Kwan]

There's a blank column in your file. Blank column is not allowed.

[abrownleo]

Joseph... You know what you are... A legend!!! Thankyou so much, its all working great now. Thanks Again for your time and help!!

[smkjr]

Does this hack work in Joomla 1.5 & the latest 1.1.0 release?

[smkjr]

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]

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.

[cliffclof]

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]

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.

[cliffclof]

I select excel file, click upload.   I get a window asking me to open an excel sheet and nothing uploads.

[Joseph Kwan]

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.

[cliffclof]

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]

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]

Is there a version of VirtueMart - Excel Upload hack that will work with Joomla_1.0.15_eCommerce_Edition_VM_1.0.15?

Thanks.