Print Page | Close Window

Command Line Parameters Add Hidden Features

Printed From: Transaction Pro
Category: QuickBooks Products
Forum Name: 01 Transaction Pro Importer 5.0/6.0/7.0
Forum Description: Post or discuss issues regarding the QuickBooks 01 Transaction Pro Importer 5.0/6.0/7.0
URL: http://www.transactionpro.com/forum/forum_posts.asp?TID=572
Printed Date: 23 January 2022 at 12:30am
Software Version: Web Wiz Forums 10.16 - http://www.webwizforums.com


Topic: Command Line Parameters Add Hidden Features
Posted By: Administrator
Subject: Command Line Parameters Add Hidden Features
Date Posted: 21 October 2008 at 9:28am

FOR THE LATEST ON COMMAND LINE PARAMETERS IN TPI, VISIT THIS LINK:

http://bscdownload.com/downloads/Command_Line_Parameters.htm - http://bscdownload.com/downloads/Command_Line_Parameters.htm  

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:
e.g. -TEXT_FILE=C:\My Text File.txt 

To Set the delimiter use one of the three values (Comma, Tab, Pipe)
e.g. -DELIMITER=Comma

To Set the transaction type use one of the values from the list
e.g. ?TXN_TYPE=Sales Receipt
So for the above example your command line would be:

Transaction Pro Import Wizard.exe -TEXT_FILE=C:\My Text File.txt -DELIMITER=Comma ?TXN_TYPE=Sales Receipt




Replies:
Posted By: Angela
Date Posted: 11 May 2013 at 1:17pm
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!


Posted By: QBKaren
Date Posted: 15 May 2013 at 10:24am
We will add this functionality to the next build of Transaction Pro Importer 5.0.

-------------
Visit our blog at http://www.blog.transactionpro.com" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: EddieC
Date Posted: 18 September 2014 at 6:21pm
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.


Posted By: QBKaren
Date Posted: 19 September 2014 at 10:37am
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" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: EddieC
Date Posted: 19 September 2014 at 4:50pm
So the best way to import new customers w/ price levels is customer list, then sales transactions?


Posted By: QBKaren
Date Posted: 22 September 2014 at 9:57am
Yes import the customers first and then the sales transactions.

-------------
Visit our blog at http://www.blog.transactionpro.com" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: msbodner
Date Posted: 28 April 2015 at 1:59pm
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.


Posted By: Administrator
Date Posted: 29 April 2015 at 4:26pm
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.


Posted By: msbodner
Date Posted: 30 April 2015 at 9:05am
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.


Posted By: msbodner
Date Posted: 30 April 2015 at 11:52am
If I do an import with Bill and then a second import with Item Receipt, will that be equivalent to a single import with Item Receipt w/Bill?

-------------
Michael Simon Bodner, Ph.D.


Posted By: Administrator
Date Posted: 30 April 2015 at 12:18pm
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.
 
Syntax is as follows: (no quotes around names)
 
Assume the following for accounts:
 
Account = Sales
Income Account = Sales
COGS Account = Cost of Goods Sold
Asset Account = Inventory
 
Yes you need to specify /NO_COA first for any of these to be read.
 
Example syntax (assuming you have account numbering turned off. If you have account numbering turned on then just use the account number. Don't use both in either case)
 
/NO_COA /NO_COA_ACCT=Sales /NO_COA_INCOME_ACCT=SALES /NO_COA_COGS_ACCT=Cost of Goods Sold  /NO_COA_ASSET_ACCT=Inventory


Posted By: Administrator
Date Posted: 30 April 2015 at 12:19pm
Why do both? Just do a bill import. On the Bill import mapping screen you will see the fields for items. This will increase your inventory for the items and create a bill from the vendor.


Posted By: msbodner
Date Posted: 30 April 2015 at 12:23pm
Great. Thanks.

-------------
Michael Simon Bodner, Ph.D.


Posted By: msbodner
Date Posted: 01 May 2015 at 1:08pm
I am trying the NO_COA commands.

Not working.

I have tried with three options

1. Just the account number (ex 110000)
2. Account name: INVENTORY (11000-00)
3. Both: 1100000 INVENTORY (11000-00)

The syntax is a follows:


"C:\Program Files\01 Transaction Pro Importer 5.0\Transaction Pro Importer 5.0.exe"   /TEXT_FILE=\SIS\LSQB\QBAPFILE.TXT /MAP_FILE=\SIS\LSQB\LSAPIMP.DAT /TXN_TYPE=Bill /DELIMITER=Comma /NO_COA /NO_COA_ACCT=4010000 /NO_COA_INCOME_ACCT=4010000 /NO_COA_COGS_ACCT=5000000  /NO_COA_ASSET_ACCT=1100000


"C:\Program Files\01 Transaction Pro Importer 5.0\Transaction Pro Importer 5.0.exe"   /TEXT_FILE=\SIS\LSQB\QBAPFILE.TXT /MAP_FILE=\SIS\LSQB\LSAPIMP.DAT /TXN_TYPE=Bill /DELIMITER=Comma /NO_COA /NO_COA_ACCT=RETAIL SALES (40100-00) /NO_COA_INCOME_ACCT=RETAIL SALES (40100-00) /NO_COA_COGS_ACCT=RAW MATERIALS (50000-00)  /NO_COA_ASSET_ACCT=INVENTORY (11000-00)

"C:\Program Files\01 Transaction Pro Importer 5.0\Transaction Pro Importer 5.0.exe"   /TEXT_FILE=\SIS\LSQB\QBAPFILE.TXT /MAP_FILE=\SIS\LSQB\LSAPIMP.DAT /TXN_TYPE=Bill /DELIMITER=Comma /NO_COA /NO_COA_ACCT=4010000 RETAIL SALES (40100-00) /NO_COA_INCOME_ACCT=4010000 RETAIL SALES (40100-00) /NO_COA_COGS_ACCT=5000000 RAW MATERIALS (50000-00)  /NO_COA_ASSET_ACCT=1100000 INVENTORY (11000-00)


In QuickBooks the Account number is 1100000 and the account name is INVENTORY (11000-00)

Any suggestions?



-------------
Michael Simon Bodner, Ph.D.


Posted By: Administrator
Date Posted: 04 May 2015 at 3:05pm
Try using just the name. Example: INVENTORY
 
If you need more help manually use the dropdown list to find out what you need to send.


Posted By: mograce2u
Date Posted: 15 September 2015 at 10:32pm
I first posted this in a moderated forum and thought perhaps it should go here instead.

I am currently using Alpha5 v11 as my import source.  Previously I was exporting from A5 to a csv file and then with scripting, importing that into QBPro12 thru TiPro5.  But I see there is a way to omit that step using DSN.

I have created a ODBC connection string to use the DSN option using the Visual FoxPro 6 driver and have a couple of questions on automating my 'shortcut'.

I have my other command line options set up for a Journal Entry and have changed the /TEXT_FILE=
with this string I copied from the connection string - notice there is a space after each ' ; ' - is that Ok or should I remove them?

DSN=TiPro5; UID=; PWD=; SourceDB=s:\; SourceType=DBF; Exclusive=No; BackgroundFetch=Yes; Collate=GENERAL; Null=Yes; Deleted=No;

Once DSN is selected as the file type, I would like to automatically set the OBJECT to the table I want to use. 

Is there a command line parameter I can use to specify the table object name?

Edit:  My plan is to use /AUTORUN since I have QB set up to let TiPro login automatically. 

Also, SourceDB=s:\ is the folder I mapped to on the server.  I didn't see that it would let me select the dbf in the connection string.


-------------
Thanks,
Robin


Posted By: Administrator
Date Posted: 16 September 2015 at 3:56pm
First of all, are you able to select the Alpha Five table when using a DSN without executing the command line? If so then what you want is to use the following to specify the connection and table name:

/FILE_SOURCE=DSN /TEXT_FILE=Note1 /XL_SHEET=Note2


Note1 Copy and paste exactly what is in the text box to the left of the Connect button. Make sure you have a good connection to the database

Note2 This is your Alpha Five table name


Posted By: mograce2u
Date Posted: 16 September 2015 at 4:46pm
That's interesting, so is this correct for my table - using the path and file extension? Because when I select the table object, no path or file extension shows.

 /XL_SHEET=s:\temp_pr.dbf

or

/XL_SHEET=temp_pr




-------------
Thanks,
Robin


Posted By: Administrator
Date Posted: 17 September 2015 at 11:33am
You need to first make a connection to the database using the 32 bit Visual Foxpro ODBC driver. You can do an internet search for the driver. Once you have the connection you should see the list of database objects populate. Once you get that info you would take it as described above and set your command line parameters.


Posted By: TGC
Date Posted: 18 September 2015 at 11:55am
So will using the AUTORUN command skip the verification /validation steps?


Posted By: QBKaren
Date Posted: 21 September 2015 at 4:56pm
The validation will still occur.

-------------
Visit our blog at http://www.blog.transactionpro.com" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: HankMcSpank
Date Posted: 28 January 2016 at 9:34am
Can the TPI 'e-commerce option'  data fields be accesses from the TPI command line?  So for example, can I use the TPI command line to nominate the text  sales (EC) for the Quickbooks Tax account, or sales (EC) for the Quickbooks Tax    item as well as the other fields?


Posted By: QBKaren
Date Posted: 28 January 2016 at 4:09pm
HankMcSpank AKA Groupie Member:

There is no command line to set these however you can access and change them via the system registry under the following key:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\BSC_TPI5\ItemSettings



-------------
Visit our blog at http://www.blog.transactionpro.com" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: HankMcSpank
Date Posted: 28 January 2016 at 5:28pm
Many thanks, I've now got everything working from within VBA...

    Dim WshShell As Object
  
    Set WshShell = CreateObject("WScript.Shell")
    WshShell.RegWrite "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\BSC_TPI5\FilePath\FilePath", "Z:\Exported_Sales_EC.xlsx", "REG_SZ"
    WshShell.RegWrite "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\BSC_TPI5\ItemSettings\QB-ShipItem", "Shipping (EC)", "REG_SZ"
    WshShell.RegWrite "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\BSC_TPI5\ItemSettings\QB-TaxItem", "Shipping (EC)", "REG_SZ"
    WshShell.RegWrite "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\BSC_TPI5\ItemSettings\QB-TaxAccount", "Shipping (EC)", "REG_SZ"
    WshShell.RegWrite "HKEY_CURRENT_USER\Software\VB and VBA Program Settings\BSC_TPI5\ItemSettings\QB-ShipAccount", "Shipping and Delivery Income:shipping income (EC) ", "REG_SZ"
  
    Set WshShell = Nothing



Posted By: lcros
Date Posted: 14 July 2016 at 3:47pm
Is there a way to prevent the error pop-ups when using the command line?


Posted By: QBKaren
Date Posted: 14 July 2016 at 4:49pm
There is no command line to turn off pop ups.  Just make sure your data in your import file is clean prior to import to prevent errors.

-------------
Visit our blog at http://www.blog.transactionpro.com" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: lcros
Date Posted: 15 July 2016 at 12:45am
Thank you. Actually the issue is a bit more complex...the reason it's erroring is because the data has credits mixed in. How do I go about processing credits at the same time as bills?


Posted By: QBKaren
Date Posted: 15 July 2016 at 1:43pm
You need to do a separate import selecting an Import Type of Vendor Credits and change the amounts to a positive number.

-------------
Visit our blog at http://www.blog.transactionpro.com" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: lcros
Date Posted: 15 July 2016 at 1:52pm
Thanks. Right now, both are on the same document. I guess I'll need to split them out. Thank you.


Posted By: tascoli
Date Posted: 10 August 2016 at 5:04am
Hi - Is there are result code I can check after running a command line import in a batch file? Does not need to be sophisticated, just OK or Fail.

Thanks


Posted By: QBKaren
Date Posted: 10 August 2016 at 4:25pm
We do not but you can view the transaction log generated after import.  If the status column says anything other than Imported then the transactions did not import.

-------------
Visit our blog at http://www.blog.transactionpro.com" rel="nofollow - http://www.blog.transactionpro.com for more tips and how to examples


Posted By: tascoli
Date Posted: 11 August 2016 at 4:57am
Thanks I'll take a look at the file and check I can parse it from my script.



Posted By: tascoli
Date Posted: 11 August 2016 at 5:00am
This is a real newbie question and I'm sure the answer is in the documentation or help somewhere but does an automated command line import job (batch file running on task scheduler) work regardless of whether or not other users have the company file open?

I'm sure it must but I can't find anywhere you explicitly say it does.

Thanks



Print Page | Close Window

Forum Software by Web Wiz Forums® version 10.16 - http://www.webwizforums.com
Copyright ©2001-2013 Web Wiz Ltd. - http://www.webwiz.co.uk