This section presents a series of fields used to describe the high-level qualities of a fixed-width file.
Immediately following initial file analysis, the orange message shown above is displayed at the top of the section. The message is removed from display after invocation of Re-analyze. It will subsequently be redisplayed should field boundaries be changed again.
The following options are all populated during initial analysis:
•Allow short lines: a checkbox, checked if RPI determines during initial file analysis that the final field in a fixed-width file contains data of differing lengths. It may be overridden manually if required.
If you make changes to Allow short lines, you will need to invoke Re-analyze to observe the ramifications of your modifications within the File and Field Analysis panels.
•Post-initial load: this drop-down field if used to define how RPI will handle the loading of a data project’s second or subsequent file. 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 is selected and no key is defined within the Field Analysis panel, a validation error will be raised.
•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.