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.
|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 Timberline Office data folder.|
|TU||Sage Timberline Office operator ID.|
|TP||Sage Timberline Office password.|
|FILE||Path and filename of the file to be imported.|
|REJECTS||Path and filename of the rejected records file to be used.|
All selections are controlled by the profile:
"C:Program FilesEvent 1Office Connector Importe1Import.exe" PROFILE="\LibertyTSDataWeeklyMWImport.XML"
No profile is used and all selections are provided on the command-line:
"C:Program FilesEvent 1Office Connector Importe1Import.exe" TF="\LibertyTSData" TU="joe" TP="crabshack" FILE="\LibertyTSDataCTCEntries.TXT" REJECTS="\LibertyTSDataRejectedMW.txt"
Profile is used to control everything but the specific name of the file being imported:
"C:Program FilesEvent 1Office Connector Importe1Import.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.