Linking to the Data Converter (Import Function)

A CSV-format file or a XML-format file can be read into a file being edited.

An importable CSV-format file must meet the following conditions. A file described in any other format will cause an error when imported. Item Format Delimiter Items are separated with commas ( , ) Quotation Marks Data is expressed in one of these two ways: 1) No quotation marks are used on character or numeric items. 2) Each character item is enclosed in double quotes, but the numeric items are not enclosed in double quotes. Example: "data1", 1, "data2", 2, "data3", 3

An importable XML-format file must be in a format supported by Data Converter. A file described in any other format will cause an error when imported. Install Alchemy Solutions XML Library (version 2.3 or later) on your computer before importing XML-format files.

Note: See the limitations and precautions on the display contents and operation procedure.

Operation Procedure (Import)

1. In the Record Format View or Table Format View, select Link to Data Converter from the Options menu, or click the Link to Data Converter tool button.

2. The Linking to Data Converter dialog box is displayed.

	2-1. Select Import.
	2-2. Select CSV Format or XML Format for the Output Data Format.
	2-3. Specify the record number where the imported data is to be inserted.
	2-4. If the Output Data Format is CSV Format, select the type of quotation mark that will be used in the imported data from the Quotes field drop-down menu.
	2-5. Enter the full path of the output file in the Specify Output Data File field. You can use the Browse button to specify a file.
	2-6. If the Output Data Format is XML Format: - If a layout definition file has been created by Data Converter, select Existing File in the XML Layout Definition File section. - If Data Converter did not create a layout definition file, select New in the XML Layout Definition File section. Enter the full path of the layout definition file or click the Browse button to specify a file. In the layout definition file, the input should be XML format and the output should be Data File format.
3. When all settings are complete, click the Data Converter button.