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

alexrjhb

  • Beginner
  • *
  • Posts: 2
Re: Adding Excel File Upload option to product_csv module
« Reply #225 on: March 06, 2008, 00:07:45 am »
Hi

Thank you for the post. I fixed my token error, but now have another problem:

I did a quick test, managed to download all products into Excel, added a new test product and when I try to upload the saved Excel file back I get this error:
Error: CSV file contains unsupported fields: product_parent_id,

Please help!

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #226 on: March 06, 2008, 00:24:43 am »
Yep. product_parent_id is not supported. Use product_parent_sku instead.
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.

alexrjhb

  • Beginner
  • *
  • Posts: 2
Re: Adding Excel File Upload option to product_csv module
« Reply #227 on: March 06, 2008, 07:43:03 am »
Tx for the reply.

I did not create those fields, I clicked on download column headers, so they come from VirtueMart.

Here is my problem: I download all products to an XLS spreadsheet, open it, view it and so on.
When I try to upload the very same spreadsheet after adding 1 test product, it gives me the error "product_parent_id not supported",
so I go back and download a new spreadsheet without using column headers, add another product, upload the spreadsheet back and
no new product... It does not add products.

Maybe I am doing something wrong?

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #228 on: March 06, 2008, 08:06:16 am »
Not sure why you get this column. But anyway you can delete the column product_parent_id from the download. Add your new product and try again.
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.

volt

  • Beginner
  • *
  • Posts: 6
Re: Adding Excel File Upload option to product_csv module
« Reply #229 on: March 07, 2008, 13:07:42 pm »
I,m problem
vm 1.0.14 jooma 1.0.13
export/import product's
MESSENGER
Sorry but we could not verifi your Security Token. Go bac and try again please

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #230 on: March 07, 2008, 22:49:01 pm »
try the fix on the previous page and let us know if that 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.

mlsuf

  • Beginner
  • *
  • Posts: 7
Re: Adding Excel File Upload option to product_csv module
« Reply #231 on: March 10, 2008, 20:14:15 pm »
Hi Joseph

I am trying to do an export of all products (about 11,000) and I'm getting a

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 45 bytes) in home/brianmee/public_html/includes/database.php on line 489

I've tried this error in google and generally, this appears to be a common error message but all fixes go over my head - some talk of upping memory in php.ini.  Do you have answer for the non technical?

Thanks

Martin

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #232 on: March 10, 2008, 23:14:27 pm »
Exporting lots of products will need more memory. Whether you can increase the memory depends on your hosting package. You can contact your web host on that.
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.

mlsuf

  • Beginner
  • *
  • Posts: 7
Re: Adding Excel File Upload option to product_csv module
« Reply #233 on: March 10, 2008, 23:46:56 pm »
Thanks Joseph.

I am looking at using phpMyAdmin to get hold of the data.  The host was very helpful but can't go higher than 32mb.


mart3223

  • Beginner
  • *
  • Posts: 11
Re: Adding Excel File Upload option to product_csv module
« Reply #234 on: March 11, 2008, 21:58:56 pm »
Allright i have instal it, but how en where can i upload my XLS file? With the CSV upload?

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #235 on: March 11, 2008, 22:06:06 pm »
Yes. Menu item will be updated to show CSV/XLS upload.
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.

mart3223

  • Beginner
  • *
  • Posts: 11
Re: Adding Excel File Upload option to product_csv module
« Reply #236 on: March 11, 2008, 22:15:45 pm »
Allright i see, ive set my language to english then i see it. But if i upload a file i get te page:

The page can not be showed
HTTP403

What goes wrong, thats also with a CSV upload. I use VM 1.0.14

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #237 on: March 12, 2008, 02:07:16 am »
Did you add the proper permissions to the function table?
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.

mart3223

  • Beginner
  • *
  • Posts: 11
Re: Adding Excel File Upload option to product_csv module
« Reply #238 on: March 12, 2008, 13:54:09 pm »
Did you add the proper permissions to the function table?

I have VM migrated to 1.0.13a and it works without a problem :) nice.

Thnx!

movieman123

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv module
« Reply #239 on: March 18, 2008, 10:07:38 am »
i have a question ,
i want to make a mp3 shop in virtuemart
now i want to add the following fields ..
Artist
Song
Album
Year

I cant get it working even with the excel plugin ....
do you have an idea ? or are you able to make an xls file
wich i can import via csv i have installed the hack for xls files

my email address : royhofman@wanadoo.nl