Documentation and SupportV5 User Manual Auto Import WizardNaming Auto Import Files and Using Triggers

Naming Auto Import Files and Using Triggers

The triggers can be used with any import made into the system (the exception being Copy & Paste imports).  When importing with triggers in the file name the file name triggers will overrule any options selected from the UI.

Naming Files

UserGUID_TableGUID_File Name_Triggers.file extension

 

Example: 552bd6fbeab33_559a89b4e0def_SmallGear_skp3lns.txt

The above file has the User GUID of 552bd6fbeab33, the Table GUID of 559a89b4e0def, the file name of SmallGear, the trigger to skip 3 lines before import, and is a text file.

User and Table GUIDs can be found in the Info block of the respected User and Table.

File detection defaults based on file extension.

There are times that our algorithms are unable to determine a file's type by its contents. In this situation the software looks to the file extension to determine the default file type. The default associations are as follows:

  • 'csv': Comma delimited values.
  • 'tsv': Tab delimited values.
  • 'txt': Tab delimited values.
  • 'tab': Tab delimited values.
  • 'psv': Pipe delimited values.
  • 'pipe': Pipe delimited values.
  • 'xls': Excel 2003 Workbook.
  • 'xlsx': Excel 2007 Workbook.

Triggers

  • _trntrue_

           Truncate before inserting New Records

  • _datecolN_

          Force Column N to be formated as a date

  • _skpNlns_

          Skip N lines of the file

  • _brgroupGUID_

          Run the business rule identified by GUID after import is complete

  • _prebrgroupGUID_

          Run the business rule identified by GUID befor the import starts

  • _mrgcolN_

          Update existing records and insert new using column N as the key (can use multiple)

  • _sysidN_

          Update existing records using column N as the system identifier

  • _insnewN_

          Insert New records only using column N as the key (can use multiple)

  • _runcftrue_

          Run custom fields on insert

  • _rtrnid_

          Return the system identifiers for each row inserted

  • _frcnull_

          Force empty values to be NULL instead of an empty string

  • _sheetN_

          Import sheet index N into the table (can use multiple)

  • _sheetN[alt_table_guid]_

          Import sheet index N into table with table guid alt_table_guid (can use multiple)

  • _enc{encoding}_

          Convert file from a valid encoding type.

          Supported Encoding Types:

            UTF16
            UTF16LE
            UTF16BE
            ISO8859
            WINDOWS1251
            WINDOWS1252