Transaction Pro Exporter 6.0 - Command Line Parameters – as of 5/18/2017 – version 6.0.06

 

Have an earlier version of the Transaction Pro Exporter? See the command line reference for those products here.


Did you know you can set your export file, transaction type, delimiter and other settings when starting the Transaction Pro Exporter? Here are some tips for taken advantage of "hidden" features in the product: (simply edit the shortcut that starts Transaction Pro Exporter and add the following "switches")

 

To add command line switches, make a copy of the program shortcut and add the custom switches you need in the "target" property of the shortcut

 

Example: This sets the export file, export file type and transaction type in the command line.

 

1. Right click on the Windows START button on the lower left of your desktop and left click OPEN

2. Double click Programs folder. Double Click the 01 Transaction Pro Exporter 6.0 folder.

3. You will see a shortcut named “Transaction Pro Exporter 6.0. Make a copy of this folder by clicking Edit/Copy then Edit/Paste.

4. Bring up the properties for this new program shortcut (right click on the shortcut and choose properties)

5. Edit the target from this:

 

 

"C:\Program Files (x86)\01 Transaction Pro Exporter 6.0\Transaction Pro Exporter 6.0.exe"

 

to this:

 

"C:\Program Files (x86)\01 Transaction Pro Exporter 6.0\

Transaction Pro Exporter 6.0.exe” /FILENAME=C:\My Text File.xls /EXPORTFORMAT=EXCEL /TXN=Check

 

Note users on 32 bit operating systems look for C:\Program Files\

 

Usage:

 

To set the file name:

e.g. /FILENAME=C:\My Text File.xls

 

To Set the export format use one of the three values (COMMA, TAB, EXCEL)

e.g. /EXPORTFORMAT=EXCEL

 

To Set the transaction type use one of the values from the list

e.g. /TXN=Check

 

So for the above example your target would be:

"C:\Program Files (x86)\01 Transaction Pro Exporter 6.0\

Transaction Pro Exporter 6.0.exe” /FILENAME=C:\My Text File.xls /EXPORTFORMAT=EXCEL /TXN=Check

 

Example of using the /AUTORUN parameter in the target shortcut:

 

/AUTORUN 1 /TXN=Invoice /FILTER=REFNO /RANGEFROM=900 /RANGETO=999 /EXPORTFORMAT=EXCEL /FILENAME=c:\output.xls /NOEXCEL

 

This outputs selected fields for the invoice transaction type, setting the filter to Ref No and the range from 900 to 999. It sets the export format to be Excel and outputs the file to c drive. It disables opening Excel after exporting the file.

 

Command Line

Feature

Version 6.0

/AUTORUN

Starts and runs TPI and automatically clicks through all buttons. Interface still loads and shows each step in the wizard. Be sure you have a valid import before enabling this.

NOTE: UNSUPPORTED FEATURE.

/AUTORUN 1

Same as above only retrieve transactions with selected fields

NOTE: UNSUPPORTED FEATURE.

/EXPORTFORMAT=TAB or
/EXPORTFORMAT=CSV or
/EXPORTFORMAT=EXCEL

To set export file format

/FILENAME=c:\my dir\my file.txt

 

To set export file name

/FILTER=REFNO or /FILTER=DATE or /FILTER=SINCELASTEXPORT

To set filter by as Ref Number, Date Range or Since Last Export

/INCLUDE_INACTIVE

Pulls both active and inactive for Account List, Customer List, Employee List, Item List, and Vendor List

/MULTICURRENCY

Show Currency and Exchange Rate fields for CA 2007 and UK 2005/2006 using multi-currency

/NOEXCEL

To not open Excel after exporting data

/NO_CRLF

Removes embedded carriage returns within fields and replaces them with a single space. Useful when exporting to text format as removes line breaks.

/PAIDSTATUS=UNPAID

Retrieve only unpaid Invoices or Bills

/PAIDSTATUS=PAID

Retrieve only paid Invoices or Bills

/QB_COMPANY_PATH=full file path and file name

Set QuickBooks file name to work with. Requires Integrated app preference in QB file to be set to “Allow this company to login automatically”

/RANGEFROM=3000 or
/RANGEFROM=mm-dd-yyyy

To set range from in either ref number or date)

/RANGETO=6000 or
/RANGETO=mm-dd-yyyy

 

To set range to in either ref number or date)

/SHOW_CUSTOMER_MESSAGE

Include customer message on sales transactions

/SHOW_EMAIL

Include customer email address on sales transactions

/SHOW_GROUP

Expands out line items with group items

/SHOW_TEMPLATE

Enables template field for invoice, sales order, sales receipt, purchase order and estimate.

/SHOW_TO_BE_PRINTED_E-MAILED

Enables To Be Printed and To Be E-Mailed fields are added to Credit Memos, Estimates, Invoices, Sales Orders and Sales Receipts.

/SUPPRESSHEADER=0
/SUPPRESSHEADER=1

To check/uncheck box to suppress header row in export file.
e.g. /SUPPRESSHEADER=1 checks box

/SUPPRESSLINES=0
/SUPPRESSLINES=1

To check/uncheck box to suppress line items checkbox.

/TXN=CHECK

To specify the transaction type – Invoice, Bill, etc

/USER_FIELDS=10

To specify the number of user defined fields to add to mapping. Valid values are 1-100.

/USEDATEMODIFIED

Sets use modified date checkbox