Re: Exporting CSV file with hebrew
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 import the hebrew? I myself don't have access to Exccel and thus can not test it. I can send a sample file. -- Ori Idan On Sat, Jul 31, 2010 at 12:47 AM, Omer Zak w...@zak.co.il wrote: 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 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 allow people to export the CSV file in either Google Docs compatible encoding or Excel compatible encoding. What is google docs compatible format? By trial, I found that utf-8 is the Google Docs compatible encoding: 1. Create in Google Docs a spreadsheet with Hebrew text. 2. Export it in CSV format to a file in your PC. 3. Open the file in gedit and modify some cells. 4. Import the file into Google Docs and demonstrate that it displays correctly the modified values. 5. By means of xxd -g 1 (or other means), confirm that the file is in utf-8 encoding. By the way, I expect Excel to be configurable to accept also other encodings - but you'll have to find how to do it, and to write clear instructions for the users. --- Omer -- Bottom posters are filthy heretics and infidels and ought to be burned on the stake after having been tarred, feathered and having rotten eggs thrown at their faces! My own blog is at http://www.zak.co.il/tddpirate/ My opinions, as expressed in this E-mail message, are mine alone. They do not represent the official policy of any organization with which I may be affiliated in any way. WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 misunderstanding. 2. From the gibberish which the client does see (and captured by the screenshot) you can guess which encoding did his Excel use to import the file. --- Omer On Sat, 2010-07-31 at 23:04 +0300, Ori Idan wrote: 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 import the hebrew? I myself don't have access to Exccel and thus can not test it. I can send a sample file. -- Ori Idan On Sat, Jul 31, 2010 at 12:47 AM, Omer Zak w...@zak.co.il wrote: 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 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 allow people to export the CSV file in either Google Docs compatible encoding or Excel compatible encoding. What is google docs compatible format? By trial, I found that utf-8 is the Google Docs compatible encoding: 1. Create in Google Docs a spreadsheet with Hebrew text. 2. Export it in CSV format to a file in your PC. 3. Open the file in gedit and modify some cells. 4. Import the file into Google Docs and demonstrate that it displays correctly the modified values. 5. By means of xxd -g 1 (or other means), confirm that the file is in utf-8 encoding. By the way, I expect Excel to be configurable to accept also other encodings - but you'll have to find how to do it, and to write clear instructions for the users. -- Every good master plan involves building a time machine. Moshe Zadka My own blog is at http://www.zak.co.il/tddpirate/ My opinions, as expressed in this E-mail message, are mine alone. They do not represent the official policy of any organization with which I may be affiliated in any way. WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 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 import the hebrew? I myself don't have access to Exccel and thus can not test it. I can send a sample file. -- Ori Idan 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 importer which encoding it is, and he selects the right option (and of course , I *think* it should work. Whoops, premature hit on the send button, sorry. Last sentence should have been: (and of course, the right delimiter options, etc.), I *think* it should work. -- Shimi ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 and gave by default windows-1251. -- Ori Idan On Sat, Jul 31, 2010 at 11:31 PM, Omer Zak w...@zak.co.il wrote: 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 misunderstanding. 2. From the gibberish which the client does see (and captured by the screenshot) you can guess which encoding did his Excel use to import the file. --- Omer On Sat, 2010-07-31 at 23:04 +0300, Ori Idan wrote: 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 import the hebrew? I myself don't have access to Exccel and thus can not test it. I can send a sample file. -- Ori Idan On Sat, Jul 31, 2010 at 12:47 AM, Omer Zak w...@zak.co.il wrote: 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 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 allow people to export the CSV file in either Google Docs compatible encoding or Excel compatible encoding. What is google docs compatible format? By trial, I found that utf-8 is the Google Docs compatible encoding: 1. Create in Google Docs a spreadsheet with Hebrew text. 2. Export it in CSV format to a file in your PC. 3. Open the file in gedit and modify some cells. 4. Import the file into Google Docs and demonstrate that it displays correctly the modified values. 5. By means of xxd -g 1 (or other means), confirm that the file is in utf-8 encoding. By the way, I expect Excel to be configurable to accept also other encodings - but you'll have to find how to do it, and to write clear instructions for the users. -- Every good master plan involves building a time machine. Moshe Zadka My own blog is at http://www.zak.co.il/tddpirate/ My opinions, as expressed in this E-mail message, are mine alone. They do not represent the official policy of any organization with which I may be affiliated in any way. WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 me how to tell excel the right encoding so it can import the hebrew? I myself don't have access to Exccel and thus can not test it. I can send a sample file. -- Ori Idan 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 importer which encoding it is, and he selects the right option (and of course , I *think* it should work. HTH, -- Shimi [1] http://shimi.net/excel-import.png ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 importer which encoding it is, and he selects the right option (and of course , I *think* it should work. You had the data in a well-defined format. But now you need a wizard to tell what it is? And no one is sure what the format is? Why not export the data as a spreadsheet? This does not require OO.o or anything similar. For instance: http://search.cpan.org/perldoc?Spreadsheet::WriteExcel http://search.cpan.org/perldoc?Spreadsheet::SimpleExcel -- Tzafrir Cohen | tzaf...@jabber.org | VIM is http://tzafrir.org.il || a Mutt's tzaf...@cohens.org.il || best tzaf...@debian.org|| friend ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Exporting CSV file with hebrew
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 with excel reported they can not see the hebrew also. Does someone have any idea how to export the file so that the hebrew will be readable? -- Ori Idan ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 allow people to export the CSV file in either Google Docs compatible encoding or Excel compatible encoding. --- Omer On Sat, 2010-07-31 at 00:02 +0300, Ori Idan wrote: 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 with excel reported they can not see the hebrew also. Does someone have any idea how to export the file so that the hebrew will be readable? -- No actual electrons, animals or children were harmed by writing this E-mail message. My own blog is at http://www.zak.co.il/tddpirate/ My opinions, as expressed in this E-mail message, are mine alone. They do not represent the official policy of any organization with which I may be affiliated in any way. WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 and Excel have contradictory expectations, then I suggest that you allow people to export the CSV file in either Google Docs compatible encoding or Excel compatible encoding. What is google docs compatible format? -- Ori Idan ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: Exporting CSV file with hebrew
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 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 allow people to export the CSV file in either Google Docs compatible encoding or Excel compatible encoding. What is google docs compatible format? By trial, I found that utf-8 is the Google Docs compatible encoding: 1. Create in Google Docs a spreadsheet with Hebrew text. 2. Export it in CSV format to a file in your PC. 3. Open the file in gedit and modify some cells. 4. Import the file into Google Docs and demonstrate that it displays correctly the modified values. 5. By means of xxd -g 1 (or other means), confirm that the file is in utf-8 encoding. By the way, I expect Excel to be configurable to accept also other encodings - but you'll have to find how to do it, and to write clear instructions for the users. --- Omer -- Bottom posters are filthy heretics and infidels and ought to be burned on the stake after having been tarred, feathered and having rotten eggs thrown at their faces! My own blog is at http://www.zak.co.il/tddpirate/ My opinions, as expressed in this E-mail message, are mine alone. They do not represent the official policy of any organization with which I may be affiliated in any way. WARNING TO SPAMMERS: at http://www.zak.co.il/spamwarning.html ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
