CSV files: Difference between revisions

From VisionaireWiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 3: Line 3:
* OpenOffice: Start OpenOffice Calc, Open the previously exported csv file. In the "Text Import" dialog select "Unicode (UTF-8)" as "character set". Set the separator to "Semicolon" (instead of "Colon"). Leave the "Text delimiter" as ". Press "OK" to import the csv file. After all changes are made and the file is ready for import in Visionaire go to "Save as" and select "Text CSV (.csv)" for file type. This exported .csv file can then be imported in the Visionaire Editor. Go to the menu "Extras" - "Import texts...", select the .csv file and import the fields you need.
* OpenOffice: Start OpenOffice Calc, Open the previously exported csv file. In the "Text Import" dialog select "Unicode (UTF-8)" as "character set". Set the separator to "Semicolon" (instead of "Colon"). Leave the "Text delimiter" as ". Press "OK" to import the csv file. After all changes are made and the file is ready for import in Visionaire go to "Save as" and select "Text CSV (.csv)" for file type. This exported .csv file can then be imported in the Visionaire Editor. Go to the menu "Extras" - "Import texts...", select the .csv file and import the fields you need.


* MS Excel: Before the previously exported .csv file can be imported in Excel you have to add a BOM (Byte Order Marker) to the .csv file so that Excel recognizes the file with UTF-8 encoding. You can easily change this with a good text editor. E.g. in Notepad++ go to menu "Encoding" and set the option "Encode in UTF-8" ("Encode in UTF-8 without BOM" should be selected before). Now you can open this saved .csv file in Excel. When you open this file a "Text Import Wizard" is shown. Select the option "Delimited" for the "Original data type". Leave the "File origin" option as "65001: Unicode (UTF-8)". Then click on "Next >". Select only the "Semicolon" Delimiter (you probably have to deselect "Tab"). Leave the "Text delimiter" as ". Then click on "Finish". After all changes are made and the file is ready for import in Visionaire go to "Save as" and select "CSV (Comma delimited) (*.csv)" for "Save as type". Before you can import this file in the Visionaire Editor you have to correct the file encoding to UTF-8. It seems like that Excel uses ANSI character encoding for the exported file. E.g. in Notepad++ go to menu "Encoding" and select the option "Convert to UTF-8" and then save the file. This .csv file can now be imported in the Visionaire Editor. Go to the menu "Extras" - "Import texts...", select the .csv file and import the fields you need.
* MS Excel: Before the previously exported .csv file can be imported in Excel you have to add a BOM (Byte Order Marker) to the .csv file so that Excel recognizes the file with UTF-8 encoding. You can easily change this with a good text editor. E.g. in Notepad++ go to menu "Encoding" and set the option "Encode in UTF-8" ("Encode in UTF-8 without BOM" should be selected before). Now you can open this saved .csv file in Excel. When you open this file a "Text Import Wizard" is shown. Select the option "Delimited" for the "Original data type". Leave the "File origin" option as "65001: Unicode (UTF-8)". Then click on "Next >". Select only the "Semicolon" Delimiter (you probably have to deselect "Tab"). Leave the "Text delimiter" as ". Then click on "Finish". After all changes are made and the file is ready for import in Visionaire go to "Save as" and select "CSV (Comma delimited) (*.csv)" for "Save as type". Before you can import this file in the Visionaire Editor you have to correct the file encoding to UTF-8. It seems like that Excel uses ANSI character encoding for the exported file. Sometimes a different encoding is used, then you have to find the correct character set. E.g. in Notepad++ go to the menu "Encoding" - "charcater sets" (available in Notepad 5.6.8, maybe also in earlier versions) and try to find the correct character set so that all special characters are shown correctly. Then go to menu "Encoding" and select the option "Convert to UTF-8" and save the file. This .csv file can now be imported in the Visionaire Editor. Go to the menu "Extras" - "Import texts...", select the .csv file and import the fields you need.

Revision as of 00:46, 6 March 2010

All texts in a Visionaire project can be exported to a csv (comma separated value) file. Go to the menu "Extras" - "Export texts...", set all options as you need them, set export to "into CSV file" and press ok. The exported csv file can be opened and modified with OpenOffice, MS Excel or any other application which can handle csv files. It is recommended to use OpenOffice because it has better support for character enconding.

  • OpenOffice: Start OpenOffice Calc, Open the previously exported csv file. In the "Text Import" dialog select "Unicode (UTF-8)" as "character set". Set the separator to "Semicolon" (instead of "Colon"). Leave the "Text delimiter" as ". Press "OK" to import the csv file. After all changes are made and the file is ready for import in Visionaire go to "Save as" and select "Text CSV (.csv)" for file type. This exported .csv file can then be imported in the Visionaire Editor. Go to the menu "Extras" - "Import texts...", select the .csv file and import the fields you need.
  • MS Excel: Before the previously exported .csv file can be imported in Excel you have to add a BOM (Byte Order Marker) to the .csv file so that Excel recognizes the file with UTF-8 encoding. You can easily change this with a good text editor. E.g. in Notepad++ go to menu "Encoding" and set the option "Encode in UTF-8" ("Encode in UTF-8 without BOM" should be selected before). Now you can open this saved .csv file in Excel. When you open this file a "Text Import Wizard" is shown. Select the option "Delimited" for the "Original data type". Leave the "File origin" option as "65001: Unicode (UTF-8)". Then click on "Next >". Select only the "Semicolon" Delimiter (you probably have to deselect "Tab"). Leave the "Text delimiter" as ". Then click on "Finish". After all changes are made and the file is ready for import in Visionaire go to "Save as" and select "CSV (Comma delimited) (*.csv)" for "Save as type". Before you can import this file in the Visionaire Editor you have to correct the file encoding to UTF-8. It seems like that Excel uses ANSI character encoding for the exported file. Sometimes a different encoding is used, then you have to find the correct character set. E.g. in Notepad++ go to the menu "Encoding" - "charcater sets" (available in Notepad 5.6.8, maybe also in earlier versions) and try to find the correct character set so that all special characters are shown correctly. Then go to menu "Encoding" and select the option "Convert to UTF-8" and save the file. This .csv file can now be imported in the Visionaire Editor. Go to the menu "Extras" - "Import texts...", select the .csv file and import the fields you need.