Difference between revisions of "CSV files"

From VisionaireWiki
Jump to navigation Jump to search
(Die Seite wurde neu angelegt: 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, ...)
 
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
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.
+
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. The csv files are exported from Visionaire with UTF-8 character encoding and must also be in UTF-8 when they are imported again.
  
* 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.
+
* 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.
  
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: When you open the previously exported csv 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.
 
 
* MS Office:
 

Latest revision as of 00:02, 30 September 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. The csv files are exported from Visionaire with UTF-8 character encoding and must also be in UTF-8 when they are imported again.

  • 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: When you open the previously exported csv 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.