Adding Excel File Upload option to product_csv module

[Henk]

Joseph,,
Thank you for all your work. But......I do need some extra help.    I did alle the install etc. as mentioned in your file.zip. What do I do next. Do I use the original csv upload. How do I do a download from my website. Maybe some stupid question but after installing I just don't know what to do.

Thanks a lot

Henk

[Joseph Kwan]

Can you be more specific with your problems?

[SureGrowth]

MiHu,
Can you provide a sample xls for testing?

I just downloaded the hack file again and remove the image and image thumb field.

I removed all the product and then import from this file.
All products appear as normal product but not child-parent product.

thanks for the response.

Did You solve the problem?

I can't get VM to accept my product_parent_sku - ever time I make a upload - the Product_parent_sku is changed to the products own Sku.... ?

[Henk]

Hi Jospeh,

I have found out that after I changed the the language form Dutch in English I suddely found the export to xls button. I have uploaded your sample file. that worked. Till so far I managed to fix the problems. I get further and furter

Thank you for your work

Bye

Henk

[Joseph Kwan]

SureGrowth & MiHu

I spot a problem in the ps_csv class that may be the cause of this.
Try replace line 2450 of ps_csv.php with
            $db_product_parent_id->query("SELECT product_id FROM #__{vm}_product WHERE product_sku = '".$this->product_parent_sku."'");

[Joseph Kwan]

please be more specific in your problems.

[Azzam]

Hi,

i have looked at the hack and must commend you first on the excellent work you provide.  thank you.
Is there a way to add digital products via this hack, can I add a list that will check the tickbox that this is a digital product or would this have to be done manually?
Do you know which file states where these digital files will be located and if this can be amended to host them in a sub-category folder, currently i see them hosted in the root folder.

thanks

[~ Stephan]

Hello,

I added your modification for the xls upload on Virtuemart 1.0.14, I am receiving an error "unable to verify your security token" while trying to submit the file.  All other fucntions appear to be fine.

Any ideas??

Thanks,
Stephan

[Joseph Kwan]

entrancey,
Your problem seems to be language-related. Please copy and paste the additional language elements from the language file in the hack to your default language file.

Stephan,
Upgrading to VM 1.0.14 will definitely break many customizations. While I have a way that may help alleviate this upgrade problem, I'm not sure whether this will work. If you are comfortable in taking some risk (of course you need to backup your files), you may try replacing the file admin.virtuemart.php (in the administrator/components/com_virtuemart directory) with the attachment.

Azzam,
By digital products, I guess you mean downloadable products. I have no documentation how downloadable products are configured. But you may try to see this works:
In your excel file, add the attribute_values column (if it's not already there). Put download::filename for the product you want to set as downloadable. (filename should be replaced with the file path in your root download directory). Let us know if this works.

[attachment cleanup by admin]

[Joseph Kwan]

entrancey,

the language file is for VM language and is stored in administator/components/com_virtuemart/languages. If you installed the hack, it should already be there. What is the default language for your site?

[Joseph Kwan]

Not sure what your problem is. The export to xls button should be in VM products->csv/xls upload page. On your right, there should be 2 buttons. The one on the far right is the export function. If you don't see the text, it's because of the language file. But the function should still works.

[Joseph Kwan]

I understand the hack doesn't work after upgrade to VM 1.0.14 because of the new Security Token and has posted a file to solve that several days ago. I finally got some time to test this and confirm the file works. So if you are troubled by the upgrade, you can download the file, unzip it and put the file in your VM administrator directory (ie administrator/components/com_virtuemart off your Joomla root directory). Of course you need to back up the original file before replacing.

This file is not specific for the excel upload hack alone and may work for other hacks as well especially those make use of the toolbar button. So installing this will help to solve some of your Security Token problems as a bonus. (The excel upload hack is not needed for the file to work.)

The file is attached to this post again for convenience.



[attachment cleanup by admin]

[pineshop]

Here is an updated version (0.6) of the hack which include
1. several bug fixes including problems with ps_csv and Excel Reader.
2. Added export to Excel file function (the file is actually Excel XML format and is not actual XLS file. But it can be read by Excel recent versions)
3. Added multi-language support which detects your encoding automatically and uses it to set the import encoding.

Let me know if there are problems.

Thank You Joseph,
After 3 days of struggling with the default CSV upload, I was able to quickly and easily upload to a VM 1.014 site using your latest version (above).  I am extracting my data out of MYOB using MSACESS queries and copy/paste into MSEXCEL 2003. A bit of finessing in excell and then upload using your hack.

I am still fishing around a bit in VM and finding my way around, but did notice a problem with discount_item_id.  The values I enter in my xls file are not corellating well in the upload.  I see it was a problem, is there still some issues I am not aware of? 

I will try and get some specific details to try and point to, but for the most part, this hack is a big breakthrough, thank you once again.

[characterdriven]

Although the CSV export was working before this hack I'm now getting this error when I try to export CSV or Excel data:
'we could not verify your security token. go back.'
Any suggestions as to a fix?

[Joseph Kwan]

Did you try the fix above?