Mapping target data configuration

Overview

The target data can be selected from RDB, CSV , Execel or JSON.
* Before mapping configuration,, complete the connection configuration first.

No	Item	Description
1	Target Connection	Select the connection that was configured on the connection configuration form.
2	Table	Once you have selected the connection, a list of RDB tables will appear, select the table from the list.
3	Data Update Mode	Select how to update the target table. `Merge` - Merge the data into the target table using the primary key of the target table as a search condition. If the result is true, then updates the row with the corresponding data from the source table. In case the result is false for any rows, then inserts the corresponding row from the source table into the target table. *If the primary key is not defined on the target table, this method cannot be selected `Append` - Insert the data into the target table. `Custome` - Write a SQL statement for updating data. (Do it on the detailed setting form)
4	View Data	Open a form that allows you to view existing data.

No	Item	Description
5	CSV Filename	Enter the name for the CSV export file. There are two ways to set, the fixed name and the pattern configuration. 1. If the CSV name is fixed, input the filename as it is. 2. In case of pattern configuration, it is possible to place the output time in the filename. e.g : `EMP{yyyyMMddHHmmss}.csv` If you execute the mapping on March 5, 2019 at 6:32:47 p.m., the file name will be EMP20190305183247.csv. Reference：Custom date and time format strings
6	Encoding	Enter the encoding of the CSV file.<br /e.g.：UTF-8、Shift_JIS
7	Use header columns	Whether the CSV file has a header row.
8	Delimiter	Select the delimiter from comma (,) and TAB.
9	Quoting	You can select from None, single quotation or double quotation.

No	Item	Description
10	Excel Filename	Enter the name for the Excel export file. There are two ways to set, the fixed name and the pattern configuration. 1. If the Excel name is fixed, input the filename as it is. 2. In case of pattern configuration, it is possible to place the output time in the filename. e.g : `EMP{yyyyMMddHHmmss}.xlsx` If you execute the mapping on March 5, 2019 at 6:32:47 p.m., the file name will be EMP20190305183247.xlsx. Reference：Custom date and time format strings
11	Sheet Name	Specify the sheet name for the output Excel file.

No	Item	Description
12	JSON Filename	Enter the name for the JSON export file. There are two ways to set, the fixed name and the pattern configuration. 1. If the JSON name is fixed, input the filename as it is. 2. In case of pattern configuration, it is possible to place the output time in the filename. e.g : `EMP{yyyyMMddHHmmss}.json` If you execute the mapping on March 5, 2019 at 6:32:47 p.m., the file name will be EMP20190305183247.json. Reference：Custom date and time format strings
13	Root Key	Specify the root object name for the output JSON file. Leaving it empty is allowed.

No	Item	Description
14	XML Filename	Enter the name for the XML export file. There are two ways to set, the fixed name and the pattern configuration. 1. If the XML name is fixed, input the filename as it is. 2. In case of pattern configuration, it is possible to place the output time in the filename. e.g : `EMP{yyyyMMddHHmmss}.xml` If you execute the mapping on March 5, 2019 at 6:32:47 p.m., the file name will be EMP20190305183247.xml. Reference：Custom date and time format strings
15	Root Element	Specify the root element name for the output XML file. Empty values are not allowed.
16	Table Element	Specify the table element name for the output XML file. Empty values are not allowed.