Data can be loaded into the MIM via the MIM Excel Add-in. It is first necessary to install the data load servlets to setup the Web server. For instructions on setting up the Web server, please see the “Data Loader: Server Setup Instructions” chapter in the MIM Data and Development Guide on the LIM Web site.
The following gives detailed instructions on how to load data using the Load Data selection on the MIM menu.
The first step in using the data loader feature is to enter the data on the Excel spreadsheet in the following format:
First cell contains the relation name.
The relation name can either be a new name, or one that is currently in the database.
The next cell, moving horizontally across the spreadsheet, contains the column name.
The column name must be a name that is already assigned in the MIM database. To see what column names can be used, see the column catalog located at: http://www.lim.com/menu/column_catalog.htm.
The third cell should contain the date in any format that Excel will accept. If you add a time to this column, the data loader will assume the data is of an intra-day format (i.e., minutely).
Data at less than minute frequency (tick) is not supported. The time entry is optional and the format should be HH.MM.
The data will usually be loaded by default into TopRelation:User but custom locations may be configured for some systems. For more information see the “Data Loader: Server Setup Instructions” chapter in the MIM Data and Development Guide.
The fourth cell contains the data. The data can be either an integer or a float, depending on the column assigned. The data will be converted to the correct format by the system if necessary.
The fifth cell contains the description for the symbol. If more than one description is entered for a symbol only the first entry will be used, any other entries will be ignored.
Column F must be left blank otherwise you will get an error message. You may enter text in Column G and beyond, but in order for the data loader to work you must have a blank column after the description column (fifth column).
In the last blank row type
END_OF_DATAexactly as shown in the first column. This marker designates to stop loading data at this point.
The following scenarios may apply:
The relation name is one that is already in the system.
The relation name is a new name.
The column name does not exist.
The updates package is running and the data is waiting in the queue to load.
Each of these scenarios will be covered in further detail.
The following shows the steps for running the data loader from the MIM menu.
After the data is entered in the spreadsheet, click off of the cell containing the last entry and then click back anywhere on the spreadsheet.
From the MIM menu, select Load Data. Each of the items below shows a possible scenario when loading data:
If the relation name is new, the dialog box will prompt the user to Submit the Data as 5 Day Series, Submit the Data as 7 Day Series or Cancel.
If the relation name is not new and no problems are found, the user is prompted to Submit the Data or Cancel.
If a problem is encountered. For example: the following graphic shows the user loading the data with the column set to Closex. If the column name does not exist, the message The following columns are not supported will return.
Fix the column name, then resubmit the data. Select Submit Data to load this data.
After the data is submitted, the data will be put into the queue for loading. If an updates package is running, the data will remain in the queue until the package has finished loading. When the data has loaded successfully, a confirmation window will display.