Difference between revisions of "Import XLS data"

From IMSMA Wiki
Jump to: navigation, search
 
Line 11: Line 11:
  
 
<ol>
 
<ol>
<li>From the '''File''' menu, select '''Import'''.</li>
+
<li>In the '''File''' menu &rarr; '''Import''' &rarr; '''XLS File'''.</li>
<li>From the '''Import''' menu, select '''XLS File'''.</li>
 
:The XLS Import window displays.
 
 
   
 
   
 
[[Image:XLSImport.png|500px|center|''XLS Import window'']]
 
[[Image:XLSImport.png|500px|center|''XLS Import window'']]

Latest revision as of 18:43, 17 June 2017

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. In the File menu → ImportXLS File.
  2. XLS Import window

    XLS Import window

  3. 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.
  4. 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.
  5. 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.
  6. Click the Import button.
  7. 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.
  8. Verify that the import was successful, and click the Done button.
  9. XLS/CSV Import Results window

    XLS/CSV Import Results window