2,186
edits
Changes
no edit summary
==XLS Import==
{{Reference guide header|To import auxiliary data or field report data in an XLS-file format, you must have the ''XLS Import'' permission.
The XLS Import feature allows you to import field report data or auxiliary data (organisations, explosive ordnance, places, and country structure levels) into IMSMA using a Microsoft Excel file. This allows mine action personnel without IMSMA access to collect data in a format that can be entered into the system. The XLS Import feature also aids in data migration activities.
}}
To import auxiliary data or field report data using an XLS file:
<li>From the File menu, select '''Import'''.</li>
<li>From the Export menu, select XLS File.</li>
:The XLS Import window displays.
Figure 213: XLS Import window
<li>Click the '''Browse''' button next to the Import Ordering File field.</li>
:The Open window displays.
<li>From the Open window:</li>
<ol type="a">
<li>Navigate to the directory where the file that you would like to import is located.</li>
<li>Select the file name.</li>
<li>Click the '''Open''' button.</li>
:In the XLS Import window, the location of the XLS file is displayed in the Processing Directory section of the window. The location of the import mapping files is displayed in the Import Data Directory section.
</ol>
<li>Click the '''Import''' button.</li>
:The Import Results window displays with the contents of the migration.log, migration_errors.log, and migration_dataissues.log. In addition, log files are generated and can be found in the IMSMA_HOME\migration directory.
<li>Verify that the import was successful, and click the '''Done''' button.</li>