3305 Main Street Ste 019 Vancouver, WA 98663

OCI MW – Command Line

The "Import Misc Worksheets" program can be launched by running the e1Import.exe file. By including command-line values that follow this filename, the program can be run in a manner that requires no user interaction. The following command-line options are available. When providing any of the below values, simply include the name of the value followed by an equal sign and then the value being assigned in double-quotes.

Argument Description
PROFILE Identifies the full path and filename of the profile to use. If using a profile, the other command-line options do not need to be included. If any of the other command-line options are included in conjunction with the profile, they will override the values specified in the profile.
TF Path of the Sage 300 Construction and Real Estate data folder.
TU Sage 300 Construction and Real Estate operator ID.
TP Sage 300 Construction and Real Estate password.
FILE Path and filename of the file to be imported.
REJECTS Path and filename of the rejected records file to be used.

Example 1

All selections are controlled by the profile:
32-bit
"C:\Program Files\Event 1\Office Connector Import\e1Import.exe" PROFILE="\LibertyTSDataWeeklyMWImport.XML"
64-bit
"C:\Program Files (x86)\Event 1\Office Connector Import\e1Import.exe" PROFILE="\LibertyTSDataWeeklyMWImport.XML"

Example 2

No profile is used and all selections are provided on the command-line:
32-bit Windows
"C:\Program Files\Event 1\Office Connector Import\e1Import.exe" TF="\LibertyTSData" TU="joe" TP="crabshack" FILE="\LibertyTSDataCTCEntries.TXT" REJECTS="\LibertyTSDataRejectedMW.txt"
64-bit Windows"C:\Program Files (x86)\Event 1\Office Connector Import\e1Import.exe" TF="\LibertyTSData" TU="joe" TP="crabshack" FILE="\LibertyTSDataCTCEntries.TXT" REJECTS="\LibertyTSDataRejectedMW.txt"

Example 3

Profile is used to control everything but the specific name of the file being imported:
32-bit Windows
"C:\Program Files\Event 1\Office Connector Import\e1Import.exe" PROFILE="\LibertyTSDataWeeklyMWImport.XML" FILE="\LibertyTSDataJob 03-001 Week 2011-01-17.TXT"
64-bit Windows
"C:\Program Files (x86)\Event 1\Office Connector Import\e1Import.exe" PROFILE="\LibertyTSDataWeeklyMWImport.XML" FILE="\LibertyTSDataJob 03-001 Week 2011-01-17.TXT"

To see a sample of how to construct your command-line for either a batch file or an Excel macro, click Tools - Command-Line.