Adding Excel File Upload option to product_csv module

[aivo]

In Russian. The problem was that the hack does not support the Russian language.

[aivo]

Here is a solution to the problem!
File ps_xls.php
edit strings
63     if (function_exists('iconv')) {
а
63 if (function_exists('mb')) {

and
68 $this->xls->setOutputEncoding('utf-8');
a
68 $this->xls->setOutputEncoding('cp1251');

enjo

[Maris]

Hi,
Is there a solution how to get rid of the Javascript errors in IE7?
It is impossible to upload an file, most likely because of these JS errors - after submitting the file upload the browser simply redirects to the top of the page and nothing happens, the upload just doesn't start. 

Here are the error messages, I collected from IE7:

Code: [Select]

Line: 1075
Char: 171
Error: Unterminated string constant
Code: 0
URL: administrator/index2.php?pshop_mode=admin&page=product.csv_upload&option=com_virtuemart
----
Line: 433
Char: 2
Error: Object expected
Code: 0
URL: administrator/index2.php?pshop_mode=admin&page=product.csv_upload&option=com_virtuemart
Thanx in advance!

[Joseph Kwan]

Probably problems with the data uploaded. Please post the file you are using.

[Maris]

Hi Joseph,

The problem is, that when I enter the CVS upload module (../administrator/index2.php?pshop_mode=admin&page=product.csv_upload&option=com_virtuemart), browse the file to upload and click Submit button - a "#" sign is added at the end of the URL and the page is redirected to the top. The upload process doesn't even start.
That kind of situation basically is observed only on IE7, so are there any suggestions, how to get rid of this problem?

When clicking on the file upload submit button with script error notification enabled on IE7 - the previously posted errors appear.

Maris..

[gwnail]

Excellent job...this tool works far better than any of the CSV upload tools...Thank you!

Merry Christ*mas to all of y'all....

[NickyV]

Hi, this hack is fantastic, first time I've ever managed to do the CSV upload! 

One question - the related_products field doesn't seem to be available.  It would be really useful if I could set this up as part of the upload.  Is there a way to add it?

Cheers,
Nicky

[BenDover]

Hi Joseph, is it possible to export direct utf-8 from the excel export module?

Import works fine after saving the excel file and changing a few special characters.
Later I used a program to convert from iso->utf-8 and that is working also, but it's an extra step.

[Joseph Kwan]

Nicky,
related_products is not a supported field in CSV upload and consequently is not supported by XLS upload. You can add this function to ps_csv.php if you are comfortable with php and mysql programming. It doesn't seem to an easy task, though.

Ben,
Right now the export is getting the encoding from your site. If the site encoding is iso, export is in iso. If the site encoding is utf-8 output will be likewise.

[RolandD]

Hey Nicky,

I want to jump in here. Related products is supported by the CSV Improved component. You can also upload XLS files with this component. Maybe this is of help for you.

[NickyV]

Hi, thanks for your responses. :-)  Roland, I did test the CSV_improved as well but I got a bit confused with all the options (perhaps if I didn't test it at midnight it might be easier to understand!).  Anyway, I've decided to stick with Joseph's hack for now and also implement the random selection of related_products as detailed here (http://forum.virtuemart.net/index.php?topic=13589.msg25124#msg25124) and see how that works.  If it doesn't then I'll re-test the CSV_improved at a slightly earlier time of day :-)
Cheers,
Nicky

[jean.roux]

Hi, installed the 0.6 version, and used upload. Wow, this is so cool! But have about 4 products that loads very funny characters, example:

D�i�e� �A�r�g�i�t�e�k�t�u�u�r� �v�a�n� � � n� �G�o�d�d�e�l�i�k�

I attach the file I uploaded, in the attached file, the following numbers producs the funny characters: SKU 1085, 1048, 1054, 1100, 1077, 1027. I saved the Excel in version '97. I also cannot find funny characters in the text fields in aboivr SKU's.

Any ideas?

[attachment cleanup by admin]

[RolandD]

jean.roux,

See this thread: http://www.csvimproved.com/index.php?option=com_fireboard&Itemid=23&func=view&id=953&catid=1

Check carefully for strange characters.

[MiHu]

Is this parent child product works?

1st try
1. I copied and pasted one of item (child product) and name it L04 (unique new sku).
2. save and upload
3. it becomes a regular product

2nd try
1. I export to xls and figure out I miss a "product_parent_sku" field, which is not in sample.xls file either.
2. I create a new column called "product_parent_sku" in sample.xls fields and filled corresponding parent_sku and upload
3. the product still a regular product (of course I deleted it before uplaod)

3rd try
1. create a corresponding child item product
2. upload ... this time it works ... but I don't wanna create all child product all via web interface

4th try
1. I delete all of my products and remove image fields from sample.xls
2. all products are regular product and there is no parent child product at all


Could someone please teach me how to create parent child product via this hack?

Thanks,

[Joseph Kwan]

I wish I have time to update the hack with the problem fixes found so far. Anyway, thanks for all your interests.
jean,
your problem seems to be encoding related. The hack assumed utf-8 encoding and so could cause problem. You can try the modifications in Reply #181.

MiHu,
Can you provide a sample xls for testing?