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.

ArgumentDescription
PROFILEIdentifies 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.
TFPath of the Sage 300 Construction and Real Estate data folder.
TUSage 300 Construction and Real Estate operator ID.
TPSage 300 Construction and Real Estate password.
FILEPath and filename of the file to be imported.
REJECTSPath 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.