Often times business utilize SQL Server applications to manage their day to day operations and need an easy way to transfer or import this data into their QuickBooks company file. This article will give you some tips on how to automate the import process once you have had several successful manual imports.
You will find all the command line parameters used below in this article. If you use the command lines at the bottom of this article all the user needs to do is just launch Transaction Pro Importer 5.0 for QuickBooks and the wizard will run on its own from there. To take it a step further you could create a batch file and schedule the process via Windows Scheduler. If you need assistance or writing batch files just do a Google search for “creating batch files” and you will see a lot of helpful web sites.
Now we will give you an example command line that you could use to automate this process. For purposes of the example below assume the following:
- File source is DSN
- Query/View is named Query1
- Import type is invoice
- Map file is located at c:\invoice map.dat.
Use the following command line (assume TPI 5.0 is installed at the path below):
“C:\Program Files\ 01 Transaction Pro Importer 5.0\Transaction Pro Importer 5.0 .exe” /AUTORUN /FILE_SOURCE=DSN /TEXT_FILE=CopyAndPasteFromTPIConnectionTextBoxToTheLeftOfConnectButton /XL_SHEET=Query1 /TXN_TYPE=Invoice /MAP_FILE=c:\Invoice Map.dat
If you want it to run in the system tray you can add /HIDE after the /AUTORUN parameter. Just be sure you have a working import before you attempt to set /AUTORUN.
If you do not already have Transaction Pro Importer 5.o for QuickBooks you can request a free demo here. In the free demo you can test out all of these powerful command line features.