.png)
.png)
1487
Rightworks 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: 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: 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. | ✔ | ✔ | ✔ |
