The FileLoader type exposes the following members.

Constructors

  NameDescription
FileLoaderOverloaded.

Methods

  NameDescription
AddTextReplacement
Adds to a list of text strings to replace
DropReloadDataTable
Drop the contents of a table and reload the new data
Equals
Determines whether the specified Object is equal to the current Object.
(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
Returns a String that represents the current Object.
(Inherited from Object.)

Properties

  NameDescription
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.

See Also