CSV dataset name

dataset name

Starting row number

The starting number of ROW INDEX for dynamic dataset. The value must be in range of 0~2147483647 and the default is zero.

CSV file location

CSV file path on the server. It can be set with the parameter wizard by clicking [Parameter] button and also be selected by [Browse] button.

Temp CSV file location in design

A temporary design time CSV file path on the local system. It can be set with the parameter wizard by clicking [Parameter] button and also be selected by [Browse] button.

Field delimiter

Set the field delimiter. Select one of TAB, SPACE, SEMICOLON, COLON, COMMA, or enter your delimiter.

You can also set the field delimiter with the parameter wizard by clicking [Parameter] button.

Include field type information

Check if CSV file includes field type. If not check, all field types are regarded as "VARCHAR".

Line delimiter

Set the line delimiter. You can enter your delimiter and the default is LINEFEED.

You can also set the line delimiter with the parameter wizard by clicking [Parameter] button.

Null mark

A string to represent the NULL value.

Character set

Character set of a file. The default is default locale of the system.

Error indication code

Set the code to notice a data error. If the code value appears at the first line of the file, an error message box will be displayed with no report preview. For example, if a CSV file have "ERR" at the first line and you set the error indication code to "ERR", "ERR" won't be recognized as data and a message box shows saying the file is not valid CVS file.

Enclosed with Double Quotes

Check if the data enclosed in double quotes is treated as one data.

Alias

Check if use dataset alias defined in datasource.properties file on the server and enter the alias name.

Alias filename: configuration file for dataset alias

View Data

Preview data of the CSV file.

Save Dataset Information

Save dataset information (field name, field type) as CSV file. This button is activated only when modifying the dataset. Check "Include field type information" option to save field type information with data.