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

Marko Saraba

  • Beginner
  • *
  • Posts: 16
Re: Adding Excel File Upload option to product_csv module
« Reply #90 on: July 30, 2007, 17:19:09 pm »
Joseph,
I look around and found in
administrator/components/com_virtuemart/classes/ps_xls.php (about line 63. something like $this->xls->setOutputEncoding('CP1251'); ) and just change to
$this->xls->setOutputEncoding('UTF-8');

and it's work. :-).


Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #91 on: July 30, 2007, 19:22:30 pm »
Thanks Marco.

Yes, this works for some systems which has iconv installed. For systems which don't have iconv, this does not work even if they have mbstring. And there are some issues such as
1. Hard coding the encoding will presume utf-8, some user may prefer some other encoding.
2. Conversion will not be done if iconv and mbstring are not installed.

I am working on a update which will detect the encoding automatically and the existence of the conversion fucntion. Meanwhile, you may try Marko's solution to see if this fits your need. You can always revert back if it doesn't work.

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.

lazyNode

  • Beginner
  • *
  • Posts: 16
Re: Adding Excel File Upload option to product_csv module
« Reply #92 on: August 02, 2007, 03:29:52 am »
Worked beautifully.

This is what I have:
VirtualMart 1.0.12
Joomla 1.0.13
Excel 2007 12.0.6024.5000
XP Pro

I added my data into the provided sample.xls and uploaded it. Simple and easy. So far so good. All I wanted was a simple category management, as I'm not even using the online shopping components. Thanks!

Moog

  • Beginner
  • *
  • Posts: 26
Re: Adding Excel File Upload option to product_csv module
« Reply #93 on: August 12, 2007, 16:58:21 pm »
How can I add image link to the thumbnail and full image area ? If I add the location http://www.domain.com/asd.jpg then it doesn't work.

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #94 on: August 12, 2007, 17:30:02 pm »
If your image is located on your server, just use  "asd.jpg" in both the product_full_image and product_thumb_image column. Also, enable dynamic thumbnail resizing in your VM configuration / Layout..
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.

Moog

  • Beginner
  • *
  • Posts: 26
Re: Adding Excel File Upload option to product_csv module
« Reply #95 on: August 12, 2007, 21:06:15 pm »
Ok thanks. But possible to add url and then saves picture ?

Joseph Kwan

  • Advanced
  • Full Member
  • *****
  • Posts: 2344
Re: Adding Excel File Upload option to product_csv module
« Reply #96 on: August 13, 2007, 00:24:54 am »
If you mean adding pictures from an external server, yes and no.
You can add url of pictures from external server. But the picture will not be downloaded to your server. And the thumbnail dynamic resizing will not work.
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.

Moog

  • Beginner
  • *
  • Posts: 26
Re: Adding Excel File Upload option to product_csv
« Reply #97 on: August 13, 2007, 13:24:22 pm »
If you mean adding pictures from an external server, yes and no.
You can add url of pictures from external server. But the picture will not be downloaded to your server. And the thumbnail dynamic resizing will not work.

Thanks for the exact answer.

dan

  • Beginner
  • *
  • Posts: 1
Re: Adding Excel File Upload option to product_csv
« Reply #98 on: August 13, 2007, 13:38:15 pm »
does any one know if this xls hack works with the shopper group hack seen here: http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=4500.0

I really need this option and am willing to pay if someone can help,

Many thanks

Paulo

  • Beginner
  • *
  • Posts: 21
Re: Adding Excel File Upload option to product_csv module
« Reply #99 on: August 21, 2007, 21:17:52 pm »
hi guys.
I tried to install this hack at virtuemart 1.0.12, and i gess i did everything right. I copied the files to administrator folder (in com_virtuemart directory) and then created the list at virtuemart administration.
Because I didn't saw any new menu i tried to upload the sample file included. But it says:
Error: File Extension not allowed. Valid extensions are: csv, txt

Does it not work in this version?
 ???

Paulo

  • Beginner
  • *
  • Posts: 21
Re: Adding Excel File Upload option to product_csv
« Reply #100 on: August 21, 2007, 21:37:32 pm »
and i checked.. the ps_csv.php file was uploaded correctly :S

Paulo

  • Beginner
  • *
  • Posts: 21
Re: Adding Excel File Upload option to product_csv module
« Reply #101 on: August 21, 2007, 23:31:35 pm »
guys.. finally managed to get it working.. but it still gives an error. I'm just trying to upload the sample file... Nothing more!

[attachment cleanup by admin]

Paulo

  • Beginner
  • *
  • Posts: 21
Re: Adding Excel File Upload option to product_csv
« Reply #102 on: August 21, 2007, 23:52:59 pm »
anyone
ยป?

thomas_freeman

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 450
    • Kustom Services
Re: Adding Excel File Upload option to product_csv module
« Reply #103 on: August 22, 2007, 03:58:32 am »
Paulo, turn on your debug and see if it gives you any more info.

Paulo

  • Beginner
  • *
  • Posts: 21
Re: Adding Excel File Upload option to product_csv
« Reply #104 on: August 22, 2007, 15:48:53 pm »
hi. i figured out.. Been despered turned out good. don't ask me why but it seems all the files weren't copied to the server. so it couldn't work out good. I had to go to the server and delete one by one and then upload the hacked ones.
I noticed that on the menu it had "upload CSV" and then changed to "upload cvs/excel". And all started to work. Right now I go to the same menu and it shows again only "Upload Csv". But still works.. LOL don't mind!