This section presents a series of fields used to describe the high-level qualities of a delimited file.
•Use delimiter: updateable. Set automatically during initial file analysis. Note that RPI will not be able to determine the delimiter if a custom character is used. A drop-down list exposes the following values:
o Comma
o Pipe
o Tilde
o Slash
o Backslash
o Semicolon
o Colon
o Space
o Tab
o Other
When you select Other, you must specify a single custom delimiter character in the field provided.
•Has header row: an updateable checkbox; checked if all of the first row's fields contain string values, and at least one other row contains a non-string value.
•Skip [n] row(s): updateable; this integer field is set to 1 if a header row is present, and to 0 if otherwise. It defines the number of initial rows within the file that are to be disregarded during file analysis.
•Post-initial load: this updateable drop-down field is used to define how RPI will handle the loading of a data project’s second or subsequent files. Available options are:
o Perform a complete table refresh
o Insert Only (Ignore Duplicates)
o Perform inserts and update existing records (default)
o Only perform updates
o Always Insert
o Perform deletes & insert records
Note that if either “update” option, or “Perform deletes…” is selected and no key is defined within the Field Analysis panel, a validation error is raised.
•Override table prefix: this checkbox is unchecked by default. When checked, the supplied Table prefix will be used. If unchecked, the value provided at system configuration setting DataProjectTablePrefixDefault will be used instead.
•Table prefix: this mandatory property can be a maximum of 5 characters in length. It defaults to the value of system configuration setting DataProjectTablePrefixDefault, which, in turn, defaults to the value 'UD'. It allows you to specify a prefix to be applied to the name of the table to be created at data project execution.
•Table name: the name of the table into which data is to be loaded defaults to the name of the data project. It can be a maximum of 50 characters in length and cannot contain database-invalid characters. A validation error is raised if these conditions are not met.
•Enable field width extension: this checkbox is unchecked by default. When checked, it facilitates editing of the data projects' fields' Data Type, Size, and Scale properties on subsequent loads.
The following data type changes are supported:
o Time to Datetime
o Date to Datetime
o Integer to Decimal
o Decimal to Integer
o Integer to String
o Decimal to String
A validation error is raised when attempting to convert a data type to an incompatible value. A validation error is also raised when decreasing a field's length on a subsequent load.
If you make changes to one or more of Use delimiter, Has header row or Skip [n] row(s), you will need to invoke Re-analyze to observe the ramifications of your modifications within the File and Field Analysis panels.