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

Transaction Pro Exporter Command Line Codes

Transaction Pro Exporter Command Line Codes

Some additional features exist for Transaction Pro Exporter that are not included with the standard installation. These additional features can be accessed by adding Command Line Codes to the Transaction Pro properties. For more information about how to add a Command Line Code, please reference THIS ARTICLE.

The chart below explains the additional features that are available for Exporter, with which export type the feature will work, and for which version of Exporter the feature is available. In addition, there is a download file attached to this article on either the right-hand side or below the article (depending on browser) that also contains this information.

Command Line Use with
Export Type
Feature V6 V7 V8
/INCLUDE_INACTIVE Account List, Customer List, Employee List, Group Item List, Item List, and Vendor List Retrieves both ACTIVE and INACTIVE status for the specified list types.
/NO_CRLF All Removes embedded carriage returns within fields and replaces with a single space. Useful when exporting to text format as it removes line breaks.
/SHOW_CUSTOMER_MESSAGE Estimate, Invoice, Sales Order, and Sales Receipt Retrieves CUSTOMER MESSAGE on specified transactions.
/SHOW_EMAIL Credit Memo, Estimate, Invoice, Sales Order, and Sales Receipt Retrieves CUSTOMER EMAIL ADDRESS on the specified transactions
/SHOW_GROUP Estimate, Invoice, Purchase Order, Sales Order, and Sales Receipt Expands line items to show the Items with the Group Item.
/SHOW_TEMPLATE Credit Memo, Estimate, Invoice, Purchase Order, Sales Order, and Sales Receipt Retrieves the TEMPLATE NAME field for the specified transactions.
/SHOW_TO_BE_PRINTED_E-MAILED Credit Memo, Estimate, Invoice, Sales Order, and Sales Receipt Retrieves the TO BE PRINTED and TO BE E-MAILED fields to the specified transactions.
/USER_FIELDS=xx All except Journal Report, Payroll Detail Report, and Transaction Detail Report Specifies the number of user defined fields to add to mapping, where xx equals the number. Valid values are 1-100.

In addition, there are some OPTIONS in Exporter that can either be selected manually within the application by clicking the OPTIONS tab in Exporter or a Command Line Code can be used to preset these options or to set options with an automated export.

The chart below explains these options, with which export type the option will work, and for which version of Exporter the option is available. In addition, there is a download file attached to this article on either the right-hand side or below the article (depending on browser) that also contains this information.

Command Line Use with
Export Type
Feature V6 V7 V8
/AUTORUN All

Starts and runs Exporter and automatically proceeds through all steps. Interface still loads and shows each step in the wizard. Be sure export and settings are valid before enabling this feature.

NOTE: UNSUPPORTED FEATURE

NOTE: When using with Version 8, you must add /ACTIVATED before /AUTORUN if using as a bat file to launch a specific application. See this ARTICLE for more information.

/AUTORUN 1 All

Same as above only retrieve transactions with selected fields.

NOTE: UNSUPPORTED FEATURE

NOTE: When using with Version 8, you must add /ACTIVATED before /AUTORUN if using as a bat file to launch a specific application. See this ARTICLE for more information.

/EXPORTFORMAT=TAB or
/EXPORTFORMAT=CSV or
/EXPORTFORMAT=EXCEL
All Specifies export file format.
/FILENAME=(file location and name) All Specifies export file location and name.

Example
/FILENAME=c:\my dir\my file.txt
/FILTER=REFNO or
/FILTER=DATE or
/FILTER=SINCELASTEXPORT
All Specifies filter to be used.
/NOEXCEL All Selects to not open Excel after export is complete.
/PAIDSTATUS=UNPAID Bill and Invoice Retrieves only UNPAID transactions.
/PAIDSTATUS=PAID Bill and Invoice Retrieves only PAID transactions.
/QB_COMPANY_PATH=full file path and file name All Specifies QB company file name from which to export. Requires Integrated app preference in QB file to be set to ALLOW THIS COMPANY TO LOGIN AUTOMATICALLY.
/RANGEFROM=# or
/RANGEFROM=mm-dd-yyyy
All Specifies the FROM range number or date
/RANGETO=6000 or
/RANGETO=mm-dd-yyyy 
All Specifies the TO range number or date
/SUPPRESSHEADER=0 All UNCHECKS box to suppress header row in export file.
/SUPPRESSHEADER=1 All CHECKS box to suppress header row in export file.
/SUPPRESSLINES=0 Bill, Check, Credit Card Charge, Credit Card Credit, Credit Memo, Estimate, Invoice, Purchase Order, Sales Order, Sales Receipt, and Vendor Credit UNCHECKS box to suppress detail lines in export file.
/SUPPRESSLINES=1 Bill, Check, Credit Card Charge, Credit Card Credit, Credit Memo, Estimate, Invoice, Purchase Order, Sales Order, Sales Receipt, and Vendor Credit CHECKS box to suppress detail lines in export file.
/TXN=(transaction type) All Specifies the export type

Example
/TXN=CHECK
/USEDATEMODIFIED All Selects the USE MODIFIED DATE checkbox.