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

Henk

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #210 on: February 01, 2008, 22:03:58 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #211 on: February 01, 2008, 23:13:43 pm »
Can you be more specific with your problems?
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.

SureGrowth

  • Beginner
  • *
  • Posts: 2
Re: Adding Excel File Upload option to product_csv module
« Reply #212 on: February 02, 2008, 17:54:07 pm »
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. :D

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

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #213 on: February 02, 2008, 19:50:49 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #214 on: February 02, 2008, 20:17:20 pm »
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."'");
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.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #215 on: February 04, 2008, 07:48:50 am »
please be more specific in your problems.
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.

Azzam

  • Beginner
  • *
  • Posts: 8
Re: Adding Excel File Upload option to product_csv module
« Reply #216 on: February 05, 2008, 14:47:14 pm »
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

  • Beginner
  • *
  • Posts: 5
Re: Adding Excel File Upload option to product_csv module
« Reply #217 on: February 06, 2008, 03:24:39 am »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #218 on: February 06, 2008, 07:58:09 am »
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]
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.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #219 on: February 06, 2008, 18:40:22 pm »
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?
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.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #220 on: February 06, 2008, 20:03:06 pm »
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.
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.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #221 on: February 20, 2008, 06:52:53 am »
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]
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.

pineshop

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv module
« Reply #222 on: February 22, 2008, 07:41:15 am »
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

  • Beginner
  • *
  • Posts: 16
Re: Adding Excel File Upload option to product_csv module
« Reply #223 on: March 05, 2008, 03:02:31 am »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #224 on: March 05, 2008, 03:09:49 am »
Did you try the fix 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.