View previous topic :: View next topic |
Author |
Message |
rfutrell Red Pill
Joined: Jun 28, 2010 Posts: 5
|
Posted: Mon Jun 28, 2010 10:11 am Post subject: CSV opens as trash |
|
Neooffice will save a .csv correctly, but when I open any .csv it comes up as trash. I'm using ver 3.1.1. |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Mon Jun 28, 2010 10:37 am Post subject: |
|
Have you installed NeoOffice 3.1.1 Patch 1? I ask because I fixed a bug in the CSV import options dialog that appears when you open a .csv file in that patch.
To check if you have Patch 1 installed, select the Help :: About NeoOffice menu and if you have the patch installed, it will show "NeoOffice 3.1.1 Patch 1" as the version. If you do not have the patch installed, can you install the patch from the NeoOffice patch download page and tell us if there is any change?
If the problem still occurs with Patch 1 installed, can you attach a sample .csv file that we can use to try to reproduce the problem? You can attach a sample file using the steps in this forum post.
Patrick |
|
Back to top |
|
|
sardisson Town Crier
Joined: Feb 01, 2004 Posts: 4588
|
Posted: Mon Jun 28, 2010 11:06 am Post subject: Re: CSV opens as trash |
|
rfutrell wrote: | Neooffice will save a .csv correctly, but when I open any .csv it comes up as trash. I'm using ver 3.1.1. |
Also, can you be more specific about what you mean by "trash"?
If you can take a screenshot of the result, you can attach it to your post by following the instructions here.
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Mon Jun 28, 2010 11:15 am Post subject: Re: CSV opens as trash |
|
sardisson wrote: | If you can take a screenshot of the result, you can attach it to your post by following the instructions here. |
Please don't attach a screen snapshot as we cannot do any troubleshooting with a screen snapshot. Instead, please attach a sample .csv file that we can use to try and reproduce the problem.
Patrick |
|
Back to top |
|
|
rfutrell Red Pill
Joined: Jun 28, 2010 Posts: 5
|
Posted: Mon Jun 28, 2010 11:21 am Post subject: |
|
I am using v 3.1.1 Patch 1.
By trash I mean unreadable characters. I can open the .csv with Open Office. I've attached the files. |
|
Back to top |
|
|
rfutrell Red Pill
Joined: Jun 28, 2010 Posts: 5
|
Posted: Mon Jun 28, 2010 11:22 am Post subject: NeoOffice Screenshots |
|
Here are the screenshots |
|
Back to top |
|
|
rfutrell Red Pill
Joined: Jun 28, 2010 Posts: 5
|
Posted: Mon Jun 28, 2010 11:23 am Post subject: Open Office screenshots |
|
Here are screenshots from Open Office |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Mon Jun 28, 2010 11:28 am Post subject: |
|
The problem is that you have set the Character Set option at the top to the import dialog to "Unicode". Also, check the "Separated by" checkbox instead of the "Fixed width" checkbox.
Changing it to "Unicode (UTF-8)". Unicode means each two characters in a file are interpreted as a single character whereas "Unicode (UTF-8)" is the format that NeoOffice and OpenOffice.org save .csv files by default.
Does changing the Character Set option to "Unicode (UTF-8)" fix the problem for you?
Patrick |
|
Back to top |
|
|
rfutrell Red Pill
Joined: Jun 28, 2010 Posts: 5
|
Posted: Mon Jun 28, 2010 11:34 am Post subject: |
|
10-4, that did it. Thanks for the quick reply.
Sorry for the newbie problem. |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Mon Jun 28, 2010 11:44 am Post subject: |
|
rfutrell wrote: | Sorry for the newbie problem. |
No problem. Character sets are always tricky to deal with.
One thing you might want to be aware of is if you import .csv files that have accented characters and the file was not created by NeoOffice, using "Unicode (UTF-8)" may cause the accented characters to be replaced by the wrong characters.
If this happens to you, I recommend that you try changing the Character Set option to "Western European (ISO-8859-1)" as that character set is commonly used by many programs that create .csv files.
Patrick
Edited by Lorinda; disabled Smilies interfering with UTF-8 references |
|
Back to top |
|
|
|