![]() |
Command Line Parameters Add Hidden Features |
Post Reply ![]() |
Page 123 4> |
Author | |
Administrator ![]() Admin Group ![]() Joined: 01 October 2003 Status: Offline Points: 2940 |
![]() ![]() ![]() ![]() ![]() Posted: 21 October 2008 at 9:28am |
FOR THE LATEST ON COMMAND LINE PARAMETERS IN TPI, VISIT THIS LINK: Did you know you can set your text file, transaction type, and delimiter and other settings when starting the importer? Here are some tips for taken advantage of "hidden" features in the product: (simply edit the shortcut that starts TxnPro 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 Target Example: This sets the text file, delimiter, and transaction type in the command line. "C:\Program Files\01 Transaction Pro Importer\Transaction Pro Import Wizard.exe" -TEXT_FILE=C:\Program Files\01 Transaction Pro Importer\Sample Import Files\CREDIT MEMO SAMPLE.TXT -DELIMITER=Tab -TXN_TYPE=Credit Memo Usage: To set the file name: To Set the delimiter use one of the three values (Comma, Tab, Pipe) To Set the transaction type use one of the values from the list Transaction Pro Import Wizard.exe -TEXT_FILE=C:\My Text File.txt -DELIMITER=Comma ?TXN_TYPE=Sales Receipt |
|
![]() |
|
Angela ![]() Newbie ![]() Joined: 22 July 2010 Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() |
Is the switch for ADDR_LINE5 supposed to work when importing the Customer list? If not, it would be a great feature.
If it is supposed to work with the Customer list, please check the following for errors: "C:\Program Files (x86)\01 Transaction Pro Importer 5.0\Transaction Pro Importer 5.0.exe" /ADDR_LINE5 /CUST_COMPANY /CUSTOMFIELDS /INVOICECREDITMEMO /ITEMACCT /LOG_ERROR Thank you for your help! |
|
![]() |
|
QBKaren ![]() Admin Group ![]() ![]() Joined: 26 March 2011 Location: Sarasota, FL Status: Offline Points: 4051 |
![]() ![]() ![]() ![]() ![]() |
We will add this functionality to the next build of Transaction Pro Importer 5.0.
|
|
Visit our blog at http://www.blog.transactionpro.com for more tips and how to examples
|
|
![]() |
|
EddieC ![]() Newbie ![]() ![]() Joined: 15 August 2013 Location: United States Status: Offline Points: 15 |
![]() ![]() ![]() ![]() ![]() |
Is there a parameter code to add the price level field to the sales order mapping screen?
Currently, I have to import the customer list first, then the sales order, if I want the discounts applied correctly.
|
|
![]() |
|
QBKaren ![]() Admin Group ![]() ![]() Joined: 26 March 2011 Location: Sarasota, FL Status: Offline Points: 4051 |
![]() ![]() ![]() ![]() ![]() |
No there is no command line that adds price levels to a sales order import. The price level needs to exist on the customer pre-import.
|
|
Visit our blog at http://www.blog.transactionpro.com for more tips and how to examples
|
|
![]() |
|
EddieC ![]() Newbie ![]() ![]() Joined: 15 August 2013 Location: United States Status: Offline Points: 15 |
![]() ![]() ![]() ![]() ![]() |
So the best way to import new customers w/ price levels is customer list, then sales transactions?
|
|
![]() |
|
QBKaren ![]() Admin Group ![]() ![]() Joined: 26 March 2011 Location: Sarasota, FL Status: Offline Points: 4051 |
![]() ![]() ![]() ![]() ![]() |
Yes import the customers first and then the sales transactions.
|
|
Visit our blog at http://www.blog.transactionpro.com for more tips and how to examples
|
|
![]() |
|
msbodner ![]() Newbie ![]() Joined: 13 May 2014 Location: Ann Arbor MI Status: Offline Points: 12 |
![]() ![]() ![]() ![]() ![]() |
Two questions. How gan I get Item Receipt w/Bill to work from the command line? I have been having to manually override it each time the batch file runs.
Second - can I "preload" the accounts for an added item on the last page? I do several different imports for several different objects and have to manually enter these each time that they change.
|
|
Michael Simon Bodner, Ph.D.
|
|
![]() |
|
Administrator ![]() Admin Group ![]() Joined: 01 October 2003 Status: Offline Points: 2940 |
![]() ![]() ![]() ![]() ![]() |
Item Receipt w/Bill is unfortunately not supported in the command line because it uses the forward slash. This is a known bug but we don't have a fix date.
Yes you can manually set these values but you have to use the switch /NO_COA along with the values you wish to set. /NO_COA_ACCT=Full Account Name /NO_COA_COGS_ACCT=Full Account Name (if necessary) /NO_COA_INCOME_ACCT=Full Account Name (if necessary) /NO_COA_ASSET_ACCT=Full Account Name (if necessary) Note the Item Type above the accounts cannot be set via the command line. It defaults to the same item type as the last import.
|
|
![]() |
|
msbodner ![]() Newbie ![]() Joined: 13 May 2014 Location: Ann Arbor MI Status: Offline Points: 12 |
![]() ![]() ![]() ![]() ![]() |
What is the correct syntax?
/NO_COA_COGS_ACCT=RAW MATERIALS (50000-00) /NO_COA_INCOME_ACCT=RETAIL SALES (40100-00) /NO_COA_ASSET_ACCT=INVENTORY (11000-00) or do I need quotes around the account names? do I need the /NO_COA to activate this usage? And how do I set the Item Type to Inventory Part or Other Charge?
|
|
Michael Simon Bodner, Ph.D.
|
|
![]() |
Post Reply ![]() |
Page 123 4> |
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |