Re: Exporting CSV file with hebrew

2010-07-31 Thread Ori Idan
I have tested google docs with the same file translated using iconv to UTF-8 and it works great. I still have a problem with excel, my customer claims he can not see the hebrew in the file. Does someone on this list has access to Excel and can tell me how to tell excel the right encoding so it can

Re: Exporting CSV file with hebrew

2010-07-31 Thread Omer Zak
Hello Ori, I suggest that you ask your client for a screenshot of the Excel window displaying the sample imported *.csv file. How can this benefit: 1. Clear up any miscommunication - maybe the client is viewing a view not containing the cells having the Hebrew text; or another equally ridiculous

Re: Exporting CSV file with hebrew

2010-07-31 Thread shimi
On Sat, Jul 31, 2010 at 11:30 PM, shimi linux...@shimi.net wrote: 2010/7/31 Ori Idan o...@helicontech.co.il I have tested google docs with the same file translated using iconv to UTF-8 and it works great. I still have a problem with excel, my customer claims he can not see the hebrew in

Re: Exporting CSV file with hebrew

2010-07-31 Thread Ori Idan
I will ask him to do it, however my guess is that he was not aware of the encoding and tried to use the default encoding which was probably windows-1251 (Latin-1) and thus got the gibrish. In open office it also happened. Open office recognized UTF-8 by itself but could not recognize windwos-1255

Re: Exporting CSV file with hebrew

2010-07-31 Thread shimi
2010/7/31 Ori Idan o...@helicontech.co.il I have tested google docs with the same file translated using iconv to UTF-8 and it works great. I still have a problem with excel, my customer claims he can not see the hebrew in the file. Does someone on this list has access to Excel and can tell

Re: Exporting CSV file with hebrew

2010-07-31 Thread Tzafrir Cohen
On Sat, Jul 31, 2010 at 11:30:56PM +0300, shimi wrote: When you import CSV data in Excel through the Text Import Wizard (Data - External Data - From Text) [1], one the options there is to state File origin, which is basically a list of all the encodings Windows(R) supports. If you tell the

Exporting CSV file with hebrew

2010-07-30 Thread Ori Idan
I am trying to export a file in CSV format that some of it's columns are hebrew. I would like people to be able to import it to excel, open-office and google docs. In open-office I had no problem importing the file in any encoding I used, however I could not import it to google docs. Other people

Re: Exporting CSV file with hebrew

2010-07-30 Thread Omer Zak
My experience is limited to whatever my CPA is using (I think he uses Excel). By experimenting with utf-8, cp862, iso_8859-8 and windows-1255 encodings, we found that windows-1255 worked for him. If you find that Google Docs and Excel have contradictory expectations, then I suggest that you

Re: Exporting CSV file with hebrew

2010-07-30 Thread Ori Idan
On Sat, Jul 31, 2010 at 12:17 AM, Omer Zak w...@zak.co.il wrote: My experience is limited to whatever my CPA is using (I think he uses Excel). By experimenting with utf-8, cp862, iso_8859-8 and windows-1255 encodings, we found that windows-1255 worked for him. If you find that Google Docs

Re: Exporting CSV file with hebrew

2010-07-30 Thread Omer Zak
On Sat, 2010-07-31 at 00:20 +0300, Ori Idan wrote: On Sat, Jul 31, 2010 at 12:17 AM, Omer Zak w...@zak.co.il wrote: My experience is limited to whatever my CPA is using (I think he uses Excel). By experimenting with utf-8, cp862, iso_8859-8 and