How to run the command prompt for Zed Axis

Overview of the command line feature

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.

Here is an example of a command line:

"C:\Program Files (x86)\Zed\Axis 13.0\Zed Axis.exe" /Connection=QBD /Import_File="D:\Sales Order.txt" /Delimiter=tab /Mapping="sales oder dsktp"
 

Command Line Options

The various command line options that can be used with Zed Axis are described in detail below.

 
Run the application

How to start the app, Note the location of the executable will depend upon the release you have 
"C:\Program Files (x86)\Zed\Axis 13.0\Zed Axis.exe"


Sets the version of QuickBooks to connect to

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

/Connection=<VersionOfQB>


Sets the saved unattended QuickBooks desktop file to connect to

The file name of the saved unattended QuickBooks company file  . Eg. /UnattendedFile=”ACME Inc” assuming the file was named C:\Users\documents\ACME Inc.qbw
/UnattendedFile="<CompanyFileName>" 

Import module command line options


Sets the file name and path to the file to import

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


Sets the Excel sheet name to be imported

The name of the Excel sheet to be imported.  Eg. /SheetName="My Sheet"
/SheetName="<Sheet Name>"

 

Sets the delimiter for text file

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

/Delimiter=<delimiter>


Sets the IIF Transaction Type

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


Sets the Mapping to use

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
/Mapping="<MappingName>"


Export module command line options


Sets the data type to be exported

This is the data type that should be exported ie Customer, Vendor, Invoice

/Export_Type=<DataType>


Sets the filter dates

Sets to date from and date to filter options.  eg /Filter_DateFrom=2020/01/15  /Filter_DateTo=2020/06/30
/Filter_DateFrom=yyyy/mm/dd /Filter_DateTo=yyyy/mm/dd

Set the Since Last Export option

Set the option to use the date that the export was last performed as the from date 
/Filter_SinceLastExport=true

Sets the Reference Number from and to

Set the Reference number from and reference number to range filter eg /Filter_RefFrom=10001  /Filter_RefTo=10009
/Filter_RefFrom=<nnnnn> /Filter_RefTo=<nnnnn>

Set the filter for PaidStatus 

Set the option to use the filter to only include transactions that are either PaidOnly or NotPaidOnly
/Filter_PaidStatus=PaidOnly

Sets the export template for the export file

Sets the preconfigured export template to be used for the export
/Export_Template="<TemplateName>"

Sets the export file format

Possible values are Ie Text, Excel  /Export_Format="Text"
/Export_Format="<FileFormat>"


Sets the path for the export file to be save to

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


Sets the saved filters

Sets the saved filter to apply to the export 
/Saved_Filter="My Saved filter"


Sets the option to close the Axis app

To close the Axis application once the command has successfully run
/Close

Feedback

Wow! Thanks, this is great!
Jeremiah Horstick (10/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 (8/9/2019 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 (9/6/2019 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 (10/8/2019 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 (11/22/2019 at 3:48 AM)