Enter the following from a command prompt to load your data file.
 | Your |
$ run.file_process –f src_file –b database [-L]
where:
run.file_process is the executable that starts the File Loader utility
src_file is your source file in .csv or .xml format.
database is the path of the database you want to load your data to.
Parameters Defined:
-f (Required) The source file to be processed. Resulting packages are placed in the parent directory of
src_file.-b (Required) The database to load the data to.
-L (Optional) If present, skips running load_updates. If the –L option is absent, then
load_updates.shruns on the resulting package.
Example for loading a .csv data file:
$ run.file_process -f myfile.csv -b ~/data.cust -L
Example for loading an .xml data file:
$ run.file_process -f myfile.xml -b ~/data.cust -L
Requirements:
de-jakarta software: Go to the “Downloads” page on the LIM Web site (http://www.lim.com/download/index.html) and download the latest version of the de-jakarta software. Follow the installation instructions in Apache Tomcat Web Server Installation.
Java version 1.4 or higher.
To run the utility from a browser window, open a Web browser and go to:
http://yourserverhostname:9090/dataedit/servlet/com.lim.dataedit.servlet.PostFile
The following window displays:
For this example, the host name is acme.widgets.com. When running the browser servlet, enter your host name in place of acme.widgets.com. You may load either a .csv file or .xml data file. Format the .xml or .csv file as outlined in the section above. The following shows how to load an XML file. The instructions will be the same for either type file.
Use the Browse button to locate your file then select the Submit button.
The following window displays:
Select the Continue button to start loading the data.
The following window displays when the data has completed loading.
Use XMIM or MIMIC to check that the data loaded successfully. The data is always loaded by default to TopRelation:User unless a path is specified in the .csv file. The data (symbol name WID.LONESTAR_2) for this example is located in the following hierarchy path.
TopRelation:User:WidgetsInc:Equities:w:wi