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)

/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

 
 

Add Feedback