Create Meta Data for File Import

The Create Meta Data For File Import page is used to import multiple file details at one time. It is recommended to use import files option rather than maintaining manually.

Fields | Description
File | All the files with the extension .txt or .csv existing in <System Drive>:\<iBCA Installation directory>\Data\Infiles are listed here. You can select the files one by one from which the data must be imported and define the values for the other fields.
First Row Has Column Names | If this check box is selected, it indicates the first row of the file containing field names.
Format | The format in which the data is stored. Allowed values Fixed: The size of record of every line in the file is fixed. Each column value must occupy fixed number of characters on every line. Delimited: The size of record of every line in the file is not fixed. A unique character must delimit each column value. Following are the possible values: Comma: Example 001,Baan Company, NL. Tab: Example 002 Baan Company NL. Semicolon: Example 001;Baan Company; NL . Other: If the value of each column is delimited by a character other than Comma, Tab or Semicolon, then it has to be specified in the provided text box.
Type | The format of the data stored in the file. Allowed values ANSI: Used by Windows XX. OEM: Used by some versions of DOS. Unicode: Used by Windows. Occupies 2 bytes for storing each character. Supports Japanese, Chinese character sets
Row Separator | The row delimiter which separates the two records. Allowed values {CR}{LF}: Carriage Return Line Feed. {CR}: Carriage Return. {LF}: Line Feed.
Skip First | The initial number of rows that must be skipped from file before importing the data. Some files can have some initial lines giving description about the data.
Rows Scan | The number of rows that must be scanned for guessing the number of columns and the data types of the columns. If required, you can change the data types.
Null | If this check box is selected, it indicates that the Null word is to be taken as NULL value in RDBMS.
Field Name | The name of the field. The name of the field can be different from the source file field from where the data is coming.
Field Type | The data type of the field. Following are the possible values: Bit Byte Short Long Currency Single Double DateTime Text/String Memo

Commands | Description
Add | Use this option to add a new field details. A new blank row is added at the end of the existing rows. You must click the Update button once you enter the Field Name and select the Field Type to save the changes.
Delete | Deletes the selected field details.
Update | Saves the changes after entering/modifying the field details.
Preview | Use this option to preview the data that exists in the selected file. The data is displayed in File Preview group box.
Create | Use this option to create the file definitions.
Cancel | Cancels the process.

| Send Us Your Feedback About this Help Page