Import XLS data

From IMSMA Wiki
Revision as of 19:01, 26 May 2017 by Alnaucler (talk | contribs)
Jump to: navigation, search

The XLS Import feature allows you to import data into IMSMANG using an Excel file. This allows large amount of data being imported in another format than xml.

Note.jpg In order to import data in XLS format, scripts files that specify how the data fields contained in the XLS file(s) should be processed e.g. the import order, import logic, reconciliation rules and any error handling must be developed. Contact your GICHD IM advisor for help.

The import functionality has three parameters:

  • Import Ordering File - defines which script files to be run and in what order
  • Processing Directory - where are the script files
  • Import Data Directory - where are the Excel file(s)

To import an XLS file:

  1. From the File menu, select Import.
  2. From the Import menu, select XLS File.
  3. The XLS Import window displays.
    XLS Import window

    XLS Import window

  4. Click the Browse button next to the Import Ordering File field.
    1. The Open window displays.
    2. Navigate to the folder where the Import Ordering File is located.
    3. Select the file (.txt or mtxt).
    4. Click the Open button.
    5. In the XLS Import window, the folder and file name are displayed in the Import Ordering File field in the Import window.
  5. Click the Browse button next to the Processing Directory field.
    1. The Open window displays.
    2. Navigate to the folder where the script file(s) are located.
    3. Click the Open button.
    4. In the XLS Import window, the folder name is displayed in the Processing Directory field in the Import window.
  6. Click the Browse button next to the Import Data Directory field.
    1. The Open window displays.
    2. Navigate to the directory where the Excel file(s) that you would like to import is located.
    3. Click the Open button.
    4. In the XLS Import window, the folder name is displayed in the Import Data Directory field in the Import window.
  7. Click the Import button.
  8. The Import Results window displays with the contents of the migration.log, migration_errors.log, and migration_dataissues.log. The log files are generated in the Processing Directory specified during the import.
  9. Verify that the import was successful, and click the Done button.
  10. XLS/CSV Import Results window

    XLS/CSV Import Results window