You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

Automate Microsoft Access Data Imports into QuickBooks using Transaction Pro Importer

QUESTION

Can a Transaction Pro import that uses a Microsoft Access database file be automated?

RESOLUTION

Yes, imports that use a Microsoft Access database file as the import file type can be automated. Below are some tips on how to automate the import process once several successful manual imports are have been completed.

All the command line parameters that are used in the example below can be found in this KNOWLEDGE BASE ARTICLE about command lines. 

If the command lines on the example below are being used, the only thing that the user needs to do is launch Importer and the wizard will run on its own from there. A batch file could also be created, and the process scheduled via Windows Scheduler.

NOTE: Transaction Pro does not support the automation feature or assist with writing batch files. If assistance is needed, several helpful articles on writing batch files exist on the internet as well as helpful videos explaining the process on YouTube.

Below is an example command line that can be used to automate the import process.

For example purposes, the following are being assumed:

  1. The correct QBDT company file is already open
  2. Query in Access is named Query1
  3. Access database is located in c:\db1.mdb
  4. Import type is invoice
  5. Map file is located at c:\Invoice Map.dat

Version 7: Use the following command line (assuming Importer is installed at the path below):

C:\Program Files (x86)\ 01 Transaction Pro Importer 7.0\Transaction Pro Importer 7.0.exe /AUTORUN /TEXT_FILE=c:\db1.mdb /XL_SHEET=Query1 /TXN_TYPE=Invoice /MAP_FILE=c:\Invoice Map.dat

Version 8: Use the following command line (assuming Importer is installed at the path below):

C:\Program Files (x86)\Transaction Pro\Transaction Pro Importer 8.0.exe /ACTIVATED /AUTORUN /TEXT_FILE=c:\db1.mdb /XL_SHEET=Query1 /TXN_TYPE=Invoice /MAP_FILE=c:\Invoice Map.dat

If preferred to have Importer run in the system tray, add the command line /HIDE after the /AUTORUN parameter.

Make sure to have a working import before attempting to set /AUTORUN. Also, make sure that there is always a space before each forward slash (/).

  • 374
  • 11-Aug-2020
  • 1888 Views