The FileLoader type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
| FileLoader | Overloaded. |
Methods
| Name | Description | |
|---|---|---|
| AddTextReplacement |
Adds to a list of text strings to replace
| |
| DropReloadDataTable |
Drop the contents of a table and reload the new data
| |
| Equals | (Inherited from Object.) | |
| Finalize |
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.) | |
| GetHashCode |
Serves as a hash function for a particular type.
(Inherited from Object.) | |
| GetType |
Gets the Type of the current instance.
(Inherited from Object.) | |
| ImportDataFile |
Imports a data file into a sql table
| |
| LoadReplaceDictionaryFile |
Loads a list of text replacements from a tab delim file
| |
| MemberwiseClone |
Creates a shallow copy of the current Object.
(Inherited from Object.) | |
| SetConnectionString |
Set up the Fileloader to use given connection string
| |
| SetDBInfo |
Set up the Fileloader to use given db server and dbname
| |
| ToString | (Inherited from Object.) |
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.
|