MIM Excel Add-in Tour:
Load Data

  
Next  Previous  MIM Excel Add-in Main Menu

Load Data

Before loading data, it is first necessary to install the data loader servlets to setup the Web Server. For instructions on setting up the Web Server, please see the chapter "Data Loader: Server Setup Instructions" in the document, "MIM Data, Development and Systems Administration Guide".

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.  Note:  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.  Note:  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 file: “column_names.txt”.

·        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). Note:  Data at less then minute frequency (tick) is not supported. The time entry is optional and the format should be HH.MM.

If you are creating new relations for the data, their data pattern (5 day or 7 day) will be determined automatically by the dates in this column. If there are weekend dates, a 7 day pattern will be assigned.

The data will usually be loaded by default into TopRelation:User but custom locations my be configured for some systems.

·        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.

After entering the spreadsheet information, select "Load Data" from the MIM menu.
The following scenarios may apply:

  • If the relation name already exists in the system, the dialog box will display a message that the data loaded successfully

  • If the relation name is new, the dialog box will prompt the user to submit the data or cancel.

  • If the column name does not exist, the message 'The following Columns are not supported" will return. Fix the column name, and then resubmit the data.

Next, let's see how to get options from the Options Facility.