The FileLoader type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | AppName |
Name of the app which is using the file loader
|
| BadQualifierEscape |
Deal with unescaped qualifiers in data. False by default.
|
| CheckHeaders |
Check stored file headers vs current text file. True by default.
|
| FileDelim |
Column delim for text file. Pipe by default.
|
| FirstRowContainsHeaders |
First row of file is column headers. True by default.
|
| IgnoreBadLines |
Ignore any line which contains an error and keep going. False by default
|
| IgnoreLongLines |
Imports any lines which are longer than the table. Dropping excess columns. False by default.
|
| IgnoreSingleExtraColumn |
Handle FNIS situation where column headers have 1 more column than data rows. False by default.
|
| PipeReplace |
Replaces any pipes in data file. True by default.
Note: Only works if pipe is not delim.
|
| Qualifier |
Text qualifier for text file.
|
| ReloadHeaders |
Reload stored file headers for given table. False by default.
|
| RequireOneLineOfData |
Require at least one line of data in text file. True by default.
|
| SquishShortLines |
Attempt to append the next line of data onto the current line if the current line is short. False by default.
|
| SurpressDups |
Ignores any lines which contain duplicate primary key. True by default.
|
| TrimData |
Trim excess white space from each data column. True by default.
|
