How to run the command prompt for Zed Axis

Zed Axis (new in V13) has a feature that will it enable it to be run by other applications and not require it to be controlled by a user with a graphical interface, the feature is commonly called a Command Prompt.   Before starting to use the command line feature you will need:
  • To have already established connections and permissions to connect to QuickBooks
  • To have configured the mapping that will be used on the import
  • To hold a valid license for the software for continued use. 
This support article is not intended to be a definitive guide to use command line prompts, and assumes that the users already has knowledge and experience.
 
The various command line options that can be used with Zed Axis are described in detail below.
 

Have the option to run Zed Axis from a command prompt

Usage Syntax
Run the application
"C:\Program Files (x86)\Zed\Axis 13.0\Zed Axis.exe" (with double quotes)

/Connection=<VersionOfQB>
Eg. /Connection=QBD
The version of QuickBooks to connect to (QBD|QBO|QBPOS)

/Import_File=”<Pathtofile>”
Eg. /Import_File=”C:\Users\Steve Batten\Invoices.txt”
This is the full path to the file that will be imported, the extension of the file must be one of the supported file formats (ie txt, csv, xls, xlsx, iif, ods)

 

/SheetName="<Sheet Name>"

Eg. /SheetName="My Sheet"

The name of the Excel sheet to be imported

/Delimiter=<delimiter>
Eg. /Delimiter=comma
If importing a text based file then the options include comma, tab, pipe

/IIF_Trans_Type=<TransactionType>
eg. /IIF_Trans_Type=INVOICE
If importing an IIF transaction file then this is the type of transaction to import ie INVOICE, ORDER, BILL, CHECK etc..

/Mapping="<MappingName>"
This is the name of the mapping to use with the import, the mapping will exist in the settings.xml file and also stores settings for AutoNumbering, Update Contact, Skip-Duplicate-Modify-Append, Import At Row, Gross to Net, Skip List Validation, and VendorLookup. It also includes any functions for search and replace.  The settings file is configured only when using Zed Axis via the user interface or can be copied into the location C:\Users\Public\Documents\Zed\Axis

/Export_Type=<DataType>
This is the data type that should be exported ie Customer, Vendor, Invoice

/Filter_DateFrom=yyyymmdd

/Filter_DateTo=yyymmdd

/Filter_RefFrom=

/Filter_RefTo=

/Export_Format=<FileFormat>
eg /Export_Format=xls
Ie xlsx|xls|txt

/Export_FilePath=<FilePath>
eg /Export_FilePath="C:\Users\Public\Documents"
 

 
 

Feedback

Add Feedback
Wow! Thanks, this is great!
Jeremiah Horstick (October 9, 2018 at 7:08 AM)
Whenever I try this feature here is what I get:

Win10Pro reports a DCOM timeout in the Event manager

QB reports there is more that one company file open

Zed reports there is no company file open

However opening from the desktop shortcut works fine.

And just to be sure, I tested my previously working scripts using Tipro6 designed for QBPro 2012 and the same 3 errors occur but only when using command line options. Any ideas on how to fix?

Robin (August 9 at 9:53 PM)
Just saw this, this is not a solution to your problem as I am looking to basically do the same thing as you are. So I see you have Win10Pro and QBPro 2012, What version of Zed Axis are you running?
Masaaki Yamamoto (September 6 at 3:12 PM)
Hi Robin, Can you please check that you can connect Zed Axis to QuickBooks using the User Interface. It could be that QuickBooks is running with Elevated Permissions in which case Axis will need to run Elevated too.
Steve (October 8 at 4:07 AM)
Sorry, I just saw this now. I am using v13 for Zed and now have QBPro Desktop 2019. I haven't gotten any further in trying out the command line options. I did check for elevated permissions and they are not. I will try it again with a simple script and see if I can get it to work. In the meantime calling the Zed desktop shortcut with Ctrl+Alt+Z is working fine...
Robin (November 22 at 3:48 AM)

Add Feedback