Transaction Pro Blog

Transaction Pro Importer for QuickBooks Desktop – Troubleshooting Requests

Problem Solved

When you contact the Transaction Pro for QuickBooks team we may ask you to send us certain files to help us resolve error messages that you are seeing. The purpose of this article is to show you where to find these files and also explain how they are used. For some of our users you may wish to look at some of these documents.

Import File

This is the excel, csv or txt file that contains the details of the transactions that you are importing. It is the file that you select when you select the browse button on the first screen of Transaction Pro Importer.

Transaction Pro Importer Browse Button

Map File

This is the file that you created when you filled out the Transaction Pro Importer mapping screen. Be sure to attach the actual map file and not a screen shot of the mapping screen. If you do not remember where you saved the map file you can sees it location at the top of the mapping screen.

Transaction Pro Importer mapping screen

If you want to see what the map file looks like you can open this file with the Notepad application on your computer. When browsing for this file be sure to change the file type to All Files in the lower right. The data before the first comma is the name of the QuickBooks Field that appears on the left hand side of the mapping screen. If you are just matching the data to an import file column after the first comma you will see the header name from your import file. If you provided data in the Static Value/Formula column you will see the word Static: followed by the header name from your import file.

Dat File

Settings.txt File

This file is located in your documents directory in the 01 Transaction Pro Importer 6.0 sub-directory. This file tells us which options are selected, the QuickBooks version and other information. You can open this file up in notepad. You can see a sample file settings file below.

Transaction Pro settings file

Number of List Items

We may also ask how many account or customers that you have in the QuickBooks company file or to confirm the version and release of QuickBooks that you are running. You can locate this info while the QuickBooks company file is open by selecting the F2 function key on your keyboard.

QuickBooks Statistics

Troubleshooting Log

We may also ask for the troubleshooting log which provides us with the details of what info that Transaction Pro passes to QuickBooks and then the returns that are received from QuickBooks.

Here is how to generate that troubleshooting log:

  1. Create a one line import file that can recreate this error message
  2. Make sure you are on the latest build of Transaction Pro Importer by selecting the about and check for updates buttons within Transaction Pro Importer.  If you are not on the latest build download and install the latest build.
  3. Select the Advanced tab and check the box next to the last option on this screen, Output all communications with QuickBooks to XML log file….
  4. Proceed with the import
  5. After import send us the following file my documents\01 Transaction Pro Importer 6.0\[Import Type] error log.txt

I hope this article is helpful. If you have any questions or comments feel free to post them below.