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.
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
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”
Sets the Excel sheet name to be imported
The name of the Excel sheet to be imported. Eg. /SheetName="My Sheet"
Sets the delimiter for text file
If importing a text based file then the options include comma, tab, pipe. Eg. /Delimiter=comma
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
Sets to 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
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
Sets the filter dates
Sets to date from and date to filter options. eg /Filter_DateFrom=2020/01/15 /Filter_DateTo=2020/06/30
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
Sets the export file format
Possible values are Ie xlsx xls txt /Export_Format="xls"
Sets the path for the export file to be save to
Sets the option to close the Axis app
To close the Axis application once the command has successfully run