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

aivo

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #180 on: November 21, 2007, 11:41:55 am »
In Russian. The problem was that the hack does not support the Russian language.

aivo

  • Beginner
  • *
  • Posts: 4
Re: Adding Excel File Upload option to product_csv module
« Reply #181 on: November 25, 2007, 01:03:41 am »
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

  • Beginner
  • *
  • Posts: 13
Re: Adding Excel File Upload option to product_csv module
« Reply #182 on: November 29, 2007, 09:44:38 am »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #183 on: November 29, 2007, 20:22:31 pm »
Probably problems with the data uploaded. Please post the file you are using.
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.

Maris

  • Beginner
  • *
  • Posts: 13
Re: Adding Excel File Upload option to product_csv module
« Reply #184 on: November 30, 2007, 09:04:44 am »
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

  • Beginner
  • *
  • Posts: 6
Re: Adding Excel File Upload option to product_csv module
« Reply #185 on: December 10, 2007, 05:29:13 am »
Excellent job...this tool works far better than any of the CSV upload tools...Thank you! ;D

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

NickyV

  • Beginner
  • *
  • Posts: 46
    • WebSolutionZ
Re: Adding Excel File Upload option to product_csv module
« Reply #186 on: January 15, 2008, 10:33:02 am »
Hi, this hack is fantastic, first time I've ever managed to do the CSV upload!  ;D

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

  • Beginner
  • *
  • Posts: 15
Re: Adding Excel File Upload option to product_csv module
« Reply #187 on: January 15, 2008, 14:04:00 pm »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #188 on: January 16, 2008, 01:55:07 am »
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.
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.

RolandD

  • Full Member
  • ***
  • Posts: 780
    • Home of CSVI
Re: Adding Excel File Upload option to product_csv module
« Reply #189 on: January 16, 2008, 08:32:55 am »
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.
Regards,

RolandD

CSVI
http://www.csvimproved.com/

NickyV

  • Beginner
  • *
  • Posts: 46
    • WebSolutionZ
Re: Adding Excel File Upload option to product_csv module
« Reply #190 on: January 16, 2008, 10:36:59 am »
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

  • Beginner
  • *
  • Posts: 4
Excel tool success, but for some funny characters displayed.
« Reply #191 on: January 20, 2008, 23:17:53 pm »
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

  • Full Member
  • ***
  • Posts: 780
    • Home of CSVI
Re: Adding Excel File Upload option to product_csv module
« Reply #192 on: January 20, 2008, 23:29:20 pm »
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.
Regards,

RolandD

CSVI
http://www.csvimproved.com/

MiHu

  • Beginner
  • *
  • Posts: 43
Re: Adding Excel File Upload option to product_csv module
« Reply #193 on: January 21, 2008, 07:31:05 am »
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

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #194 on: January 21, 2008, 20:46:40 pm »
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?
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.