Import Transactions into QuickBooks from Excel, Databases, or Text Files
Features:
Use Excel, text, MS-Access or Connect to any ODBC compliant databases like MS-SQL Server, MySQL and Oracle for your import file data
Strong validation before import: TPI sets all import data field lengths to the maximum allowed by QuickBooks. TPI also checks for fields to be in the proper format. This almost completely eliminates all data validation errors when importing the file into QuickBooks.
Transaction Log. Ability to log transactions to an output window that can be saved to a file. Failed transactions can be saved to a file and imported or entered manually.
Load and save unlimited map files for each transaction type
Ability to skip transactions with reference numbers that already exist in QuickBooks
Ability to send a default value (Static value) to a QuickBooks field instead of mapping to a field in import file
Ability to set record terminators (CR/LF, CR, or LF) for text files
Ability to map columns and have them generated as new transaction lines
Ability to Zoom the data grids to fill the entire screen
New options to check for existing customers, vendors and items before import
Improved handling of errors returned from QuickBooks. For example, when adding a new customer and that customer already exists as a vendor, TPI 3.0 now adds a suffix to the new customer so it can be saved.
Extensive command line options to set virtually all program settings
ckBooks from Excel, Databases, or Text Files
