CSV files - Revision history

EK: Redirected page to Text

2023-08-30T17:23:48Z

Redirected page to Text

David Stoffel: Text replacement - "{{toc}}" to ""

2014-11-03T23:51:23Z

Text replacement - "{{toc}}" to ""

AFRLme at 17:26, 21 August 2014

2014-08-21T17:26:35Z

David Stoffel: Created page with "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 exp..."

2013-11-26T15:50:50Z

Created page with "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 exp..."

New page

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.

← Older revision		Revision as of 17:23, 30 August 2023
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. The csv files are exported from Visionaire with UTF-8 character encoding and must also be in UTF-8 when they are imported again.	+	#REDIRECT [[Text]]
−
−	* 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.

← Older revision		Revision as of 23:51, 3 November 2014
Line 4:		Line 4:

	* 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 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.
−	~~{{toc}}~~

← Older revision		Revision as of 17:26, 21 August 2014
Line 4:		Line 4:

	* 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 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.
		+	{{toc}}