INT OUT ERP

Command line parameter options

/auto    Batch mode

/IN       Import mode

/f          Import formulas

            /FUpd  Update existing formulas

            /F1=”code1”    First formula code

            /F2=”code2”    Last formula code

A company name parameter may be included, BUT ONLY AT THE END OF THE COMMAND LINE.

Company=ABC Company

The Company= parameter MUST be at the end of the command line.  Nothing is allowed to coll the compant name, or it will be assumed to be part of the company name.

Optional FORMULATOR Connection parameters

FMDSN=”DSN Name”           SQL or MySQL DSN

FMHOST=”FM Host”              SQL or MySQL Host Name

FMDBTYPE=”MySQL”           Indicates MySQL (as opposed to default of Microsoft)

FMUID=”Me”                          (optional) User ID

FMPWD=”12345”                   (optional) Password

For FORMULATOR Microsoft Access ONLY:

FMDBNAME=”Path to Access database”

Optional ERP Connection Parameters

ERPHOST=”My Host”                        ERP database host name

ERPDBNAME=”My Database”          ERP database name

ERPDSN=”MyDSN”                           ERP database host name

ERPDBTYPE={“MSSQL” | “AS400” | “DSN” }           Type of connection

ERPSECNTAUTH=Y             “Y” ONLY – indicates NT security on MS-SQL database

ERPUID=”Me”                        (optional) Database user ID

ERPPWD=”12345”                 (optional) Database password

Note that all parameter information is enclosed in double quotes.