Import settings
KEY VALUE	What it does ...
IMPORT-CSV-CHECK-4-VALUES	This setting instructs the import routine to check each input line to validate that there are 4 and only 4 comma separated values on each input line.
IMPORT-POST-IMPORT-SQL-[SOURCE]	NONE In some situations you need to run a special SQL command to complete the import process once the initial import step is completed. For example, you may wish to adjust account numbers imported by adding a prefix or suffix to them, adjust certain characters such as changing dashes to periods, etc. If you need to do something like this the command associated with this key value will allow this to be done. Please check with Quadrant support before using this option as it can be quite powerful and you can easily inflict a lot of chaos in your database with an invalid SQL statement. There is limited checking possible with this function so extra care is required to ensure that no unintended consequences result.
IMPORT-CSV-A/R
IMPORT-CSV-CHECK-4-VALUES
IMPORT-CSV-EZPASS
IMPORT-CSV-ONLY-ALLOW-THESE-DESC-CHARS
IMPORT-CSV-PARKING
IMPORT-CSV-PARKS
IMPORT-CSV-REC
IMPORT-CSV-RECREATION
IMPORT-CSV-SAFARI
IMPORT-CSV-SHIFT-DESC
IMPORT-CSV-TAXES
IMPORT-CSV-TIDEMARK-TABBED-ONLY-ALLOW-THESE-DESC-C
IMPORT-CSV-TIDEMARK-TABBED-SHIFT-DESC
IMPORT-CSV-TM-TAB-0-ONLY-ALLOW-THESE-DESC-CHARS
IMPORT-CSV-TM-TAB-0-SHIFT-DESC
IMPORT-CSV-TM-TAB-0TMK-ONLY-ALLOW-THESE-DESC-CHARS
IMPORT-CSV-TM-TAB-0TMK-SHIFT-DESC
IMPORT-CSV-TM-TAB-1-ONLY-ALLOW-THESE-DESC-CHARS
IMPORT-CSV-TM-TAB-1-SHIFT-DESC
IMPORT-CSV-TM-TAB-1PRN-ONLY-ALLOW-THESE-DESC-CHARS
IMPORT-CSV-TM-TAB-1PRN-SHIFT-DESC
IMPORT-CSV-TM-TAB-2-ONLY-ALLOW-THESE-DESC-CHARS
IMPORT-CSV-TM-TAB-2-SHIFT-DESC
IMPORT-CSV-TM-TAB-2FLX-ONLY-ALLOW-THESE-DESC-CHARS
IMPORT-CSV-TM-TAB-2FLX-SHIFT-DESC
IMPORT-CSV-UTILITIES
IMPORT-CSV-UTILITY
IMPORT-OPEN-AR-ITEMS-ACCOUNT-NAME-SIZE
IMPORT-OPEN-AR-ITEMS-ACCOUNT-NAME-START
IMPORT-OPEN-AR-ITEMS-BALDUE-COL-SIZE
IMPORT-OPEN-AR-ITEMS-BALDUE-COL-START
IMPORT-OPEN-AR-ITEMS-CUSTNUM-COL-SIZE
IMPORT-OPEN-AR-ITEMS-CUSTNUM-COL-START
IMPORT-OPEN-AR-ITEMS-FILE-NAME
IMPORT-OPEN-AR-ITEMS-INV#-COL-START-SIZE
IMPORT-OPEN-AR-ITEMS-INV#-COL-START-START
IMPORT-OPEN-AR-ITEMS-INVAMT-COL-SIZE
IMPORT-OPEN-AR-ITEMS-INVAMT-COL-START
IMPORT-OPEN-AR-ITEMS-TABLE-NAME
IMPORT-REFORMATTER-CAPTION-1
IMPORT-REFORMATTER-CAPTION-2
IMPORT-REFORMATTER-CAPTION-3
IMPORT-REFORMATTER-CAPTION-4
IMPORT-REFORMATTER-CAPTION-5
IMPORT-REFORMATTER-CAPTION-6
IMPORT-REFORMATTER-CAPTION-7
IMPORT-REFORMATTER-CAPTION-8
IMPORT-REFORMATTER-CAPTION-9
IMPORT-REFORMATTER-EXE-1
IMPORT-REFORMATTER-EXE-2
IMPORT-REFORMATTER-EXE-3
IMPORT-REFORMATTER-EXE-4
IMPORT-REFORMATTER-EXE-5
IMPORT-REFORMATTER-EXE-6
IMPORT-REFORMATTER-EXE-7
IMPORT-REFORMATTER-EXE-8
IMPORT-REFORMATTER-EXE-9
IMPORT-TAB-CHECK-7-VALUES
IMPORT-TAB-CHECK-8-VALUES
TIDEMARK-IMPORT-PAYER-NAME
TM-TAB-0-PAYER-NAME
TM-TAB-1-PAYER-NAME
TM-TAB-2-PAYER-NAME
TRANSACTION-IMPORT-PATH