Adding Excel File Upload option to product_csv module

[alexrjhb]

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]

Yep. product_parent_id is not supported. Use product_parent_sku instead.

[alexrjhb]

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]

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.

[volt]

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]

try the fix on the previous page and let us know if that works.

[mlsuf]

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]

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.

[mlsuf]

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]

Allright i have instal it, but how en where can i upload my XLS file? With the CSV upload?

[Joseph Kwan]

Yes. Menu item will be updated to show CSV/XLS upload.

[mart3223]

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]

Did you add the proper permissions to the function table?

[mart3223]

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]

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