Files

Use the Files page to specify the details of a file details for which the legacy data exists.

Related topics

- Application Tables

Fields | Description
File Name | The name of the file to provide unique identification.
Description | The description of the file.
Source Directory | The directory path of the source data file.
Skip First Rows | The initial number of rows that must be skipped from the file before importing the data. Some files can have initial lines to provide the description of the data. To display the default Skip First Rows value, you must specify it at the application level.
Format | You must specify the format in which the data is stored. Allowed values Fixed: The size of record of every line in the file is fixed. The column value on every line must occupy a fixed number of characters . Delimited: The size of record for every line in the file is not fixed . A unique character must delimit each column value. Following are the possible values: Comma: For Example: 001, Baan Company, NL Tab: For Example: 002 Baan Company NL Semicolon: For Example: 001; Baan Company; NL Other: Specify the delimiter other than the Comma, Tab or Semicolon, in this text box. When you specify the format at the application level, the default Format is displayed.
First row has column names | If this check box is selected, it indicates that the first row of the file contains the field names. The default status of the control is displayed if specified .
Null values as "NULL" | If this check box is selected, it indicates that the Null word is to be taken as NULL value in RDBMS. The default status of the control is displayed if specified .
File Type | Select the format of the data storage in the file. Allowed values ANSI: Used by Windows XX. OEM: Used by certain versions of DOS. Unicode: Used by Windows. It occupies two bytes for the storage of each character and supports Japanese, Chinese character sets. The default File Type is displayed, if specified at the application level.
Row Delimiter | Select the row delimiter to separate two records. Allowed values {CR}{LF}: Carriage Return Line Feed. {CR}: Carriage Return. {LF}: Line Feed . The default Row Delimiter is displayed, if specified at the application level.
Text Qualifier | Select whether the text must be enclosed within a single quote or double quotes to differentiate it from the numerical data. Allowed values {none}: Within no specific character, text data is enclosed. Target table structure is created according to the field data stored in the file. Single Quote {'}: Text data is enclosed within Single Quote ('). Double Quote {"}: Text data is enclosed within Double Quotes ("). The default Text Qualifier is displayed.

Commands | Description
New | Creates a new file. You must provide the new file details in Create New File section. DCA stores the metadata of the file. The file with the data must exist in the specific folder.
Delete | Deletes the selected file information.
Import Files | Imports multiple files . The Create Meta Data for File Import page is displayed. It is recommended to use this option rather than creating it manually.
Fields | Displays the Fields page. Use the page to define the fields for the selected file.
Back | Navigates to the application page.
Modify | Modifies the selected file details in the File Details for <filename> section.
Save | Adds the details to a new file or saves the details of the updated file .
Cancel | Cancels the New or Modify file command.

| Send Us Your Feedback About this Help Page