Loading Data from a File (MIM File Loader)

Overview

This chapter describes the method whereby customer data is loaded into the MIM from a file using the MIM File Loader Utility.

When loading data using the MIM File Loader Utility, the data file used may either be a comma separated file (.csv) or an XML file (.xml). This document describes how to set up both data file formats.

When loading data using a .csv file, the data is loaded by default to the TopRelation:User:[x]:[x] category in the MIM unless an alternate category path is specified. The categories underneath the TopRelation:User category are determined by the first two letters of the relation name. For example, the relation WID.LONESTAR_2 will reside in the following location in the MIM: “TopRelation:User:w:wi”.

When loading data using an .xml file, the data location is specified in the XML file. For the example outlined below, data is loaded to the TopRelation:User:WidgetsInc:Equities:w:wi hierarchy path.

There are two options for running the MIM File Loader Utility: (1) you can run the utility either from a command prompt or (2) from a browser window. Both options are outlined below.

A trading pattern can not be specified using the MIM File Loader, but if the data being loaded has values on Sunday or Saturday the trading pattern will be changed from MTWThF to MTWThFSaS.