All triggers start with an underscore. When an auto importer has more than
one trigger, then the triggers all appear in the filename, for example:
- Filename with one trigger:
filename_addnewcols.txt
- Filename with two triggers:
filename_addnewcols_adjustfields.txt
- Add New Columns: _addnewcols_
- Automatically add new columns to the table if they appear in the file.
Renamed columns will be treated as new.
Example: Use filename_addnewcols.txt.
- Adjust Columns: _adjustfields_
- Automatically adjust data types and lengths if needed. Utilizes the
_nopad_ options to force read of full file to determine data types and lengths
without padding.
Example: Use
filename_adjustfields.txt.
- Auto Adjust: _autoadjust_
- Combination of _addnewcols_ and _adjustfields_.
Example: Use
filename_autoadjust.txt.
- Auto Commit: _autocommit_
- Do not use a transaction for insert. Use to increase the speed of
large imports.
Example: Use
filename_autocommit.txt.
- _brgroupGUID_
- Run data process identified by GUID after the file import is complete.
Example: Use
filename_brgroup123456789qwer.txt to run data process GUID
123456789qwer after import.
- Default Value: _dfltN[VAL123]_
- Set VAL123 as a default value for Column 'N'. If the field in column
'N' is empty during import, it is populated with the value that you set. Do not
use special characters in the value.
Example: Use
filename_dflt4[10].txt when the default value is 10 for the
4th column.
- Encoding: _encENCODING_
- Specify the character encoding of the file. By default, the encoding
is UTF8. Triggers support the following encoding types:
- UTF16
- UTF16LE
- UTF16BE
- ISO8859
- WINDOWS1251
- WINDOWS1252
Example: Use
filename_encISO88591.txt for a file with character encoding of
ISO-8859-1.
- _estGUID_
- Create a new table inside of folder identified by GUID to import file
into. If the file is a compressed file with multiple files, a table for each
file is created. Can be used in conjunction with _nst[NEWFOLDER]_ to create a
new folder in an existing folder.
Example: Use
filename_est1234456789qwer_nst[SampleData].zip to create a new
folder called 'SampleData' inside a folder identified by GUID 123456789qwer.
Create new tables for each file in the zip.
- Force Null: _frcnull_
- Force empty values to be NULLs in the database. The default is an
empty string.
Example: Use
filename_frcnull.txt.
- Force Text: _frctext_
- Force all fields to text fields.
- Include Empty Records: _incempty_
- Include empty records in the import. By default, empty records are
ignored.
Example: Use
filename_incemptytxt.
- Insert Only New Records Based On: _insnewN_
- Insert new records using column 'N' as the unique key. Can use
multiple.
Example: Use
filename_insnew5.txt to use column 5 of the files as unique key
for inserting new records.
- Minimum Text Field Length: _mrgcolN_
- Insert new records and update existing records using column 'N' as the
unique key.
Example: Use
filename_mrgcol3_mrgcol5.txt to use column 3 and 5 of the file
as a unique key for merging.
- Merge New Records Based On: _mstGUID_
- Merge sub files from a compressed file into a folder.
- If a table exists in the folder, specified by the GUID, that has
the same name as the file, it will import into that table.
- If a table does not exist in the folder, it will create a new table
using the filename.
- If no GUID is provided, then it will use the folder of the table
specified.
Example: Use
fileName_mst.zip to search the folder for the table names that
match filenames in the zip file. Import into the tables that match, or create
new tables for the ones that do not match.
Example: Use
filename_mst1234567890qwer.zip to search the folder identified
by GUID 1234567890qwer for table names that match filenames in the zip file.
Import into the tables that match, or create new tables for the ones that do
not.
- _mtlN_
- Force all newly created text fields to have a minimum length of 'N'.
Example: Use
filename_mtl150.txt to create text fields from this import that
have a minimum length of 150.
- No Padding: _nopad_
- Combination of _nopadtxt_ and _nopadnum_.
Example: Use
filename_nopad.txt.
- No Padding (Number): _nopadnum_
- Do not add padding to newly created number fields. Force reads the
full file to determine data types and lengths without padding.
Padding adds 2 digits to the left of the decimal. Usually, padding is
not added to the right unless:
- Digits to the right of the decimal and the value is not currency,
then padding is added 1 digit to the right.
- The value is currency and includes more than 2 digits to the right,
then padding is added 1 digit to the right.
Example: Use
filename_nopadnum.txt.
- No Padding (Text): _nopadtxt_
- Do not add padding to newly created text fields. Force reads the full
file to determine data types and lengths without padding. The default padding
is the length + 25%, rounded up to a full character.
Example: Use
filename_nopadtxt.txt.
- Merge Compressed File Into Folder: _nst[FOLDERNAME]_
- Create a new folder, named 'FOLDERNAME', that will contain a new table
to import file into. If the file is a compressed file with multiple files, a
table for each file is created. Must be simple value for use in filename
trigger, no special characters.
Example: Use
filename_nst[NewFolder].zip to create a new folder called
'NewFolder' at the root level, and create a table for each file in the zip.
- Pre Data Process: _prebrgroupGUID_
- Run data process identified by GUID before a file import starts.
Example: Use
filename_prebrgroup123456789qwer.txt to run data process GUID
123456789qwer before import.
- _rtrnid_
- Return the system identifiers for each row inserted. For API use.
Example: Use
filename_rtrnid.txt.
- Run Custom Fields: _runcftrue_
- Run custom fields on insert. The default is set to off.
When uploading via Fix View or Forms, _runcftrue_ is on by default.
Example: Use
filename_runcftrue.txt.
- Worksheet to Import: _sheetN_
- When importing an Excel file, import worksheet number 'N'. All
selected sheets import into the default destination table. Can use multiple
instances.
Note
Will also import hidden sheets.
Example: Use
filename_sheet3.xlsx to import the 3rd sheet of a
workbook.
- _sheetN[GUID]_
- When importing an Excel file, import worksheet number 'N' into the
table specified by GUID. Can use multiple instances.
Example: Use
filename_sheet3_sheet5[123456789qwer].xlsx to import sheet 3 of
a workbook into the selected table, and import sheet 5 into the table with GUID
123456789qwer.
- Skip Columns: _skpcolN_
- Ignore the Nth column in the file.
Example: Use
filename_skpcol1.txt to skip the first column of a file.
- Skip Rows: _skpNlns_
- Skip the first 'N' lines of the file.
Example: Use
filename_skp10lns.txt to skip the first 10 lines of a file.
- _sysidN_
- Update existing records using column 'N' as the system identifier.
Example: Use
filename_sysid1.txt to use the first column as the system
identifier.
- Truncate Table: _trntrue_
- Truncate destination table before inserting new records.
Example: Use
filename_trntrue.txt.
