NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
The XLS Import feature allows you to import data into {{IMSMANG}} using from an Excel file. This allows large amount of data being imported in another format than maXML.
{{note| Before you can import data in XLS format, system administrators must create scripts and mapping files that specify how the data fields contained in the XLS files are be mapped to the data fields in IMSMA, the import order, import logic, reconciliation rules and any error handling. The client's configuration in ''migration.properties'' and ''coordRefSys.properties'' should also be verified.}}
{{ Note | To use import XLS-file, you must have [[Defining Roles, Permissions and Users | XLS Import permission]]. Contact your IMSMA administrator if you have questions on permissions.}}
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)
<p>To import an XLS file:</p>
<li>Click the '''Browse''' button next to the Import Ordering File field.</li>
<ol type="a">
<li>The Open window displays.</li><li>Navigate to the directory where the file that you would like to import Import Ordering File is located.</li><li>Select the file name(.txt or mtxt).</li>
<li>Click the '''Open''' button.</li>
:In the XLS Import window, the location of the XLS folder and file is name are displayed in the Processing Directory section of the window. The location of the import mapping files is displayed Import Ordering File field in the Import Data Directory sectionwindow.
</ol>
<li>Click the '''Browse''' button next to the Processing Directory field to select the directory.</li>
<ol type="a">
<li>The Open window displays.</li>
<li>Navigate to the directory where the script file(s) are located.</li>
<li>Click the '''Open''' button.</li>
:In the XLS Import window, the folder name is displayed in the Processing Directory field in the Import window.
</ol>
<li>Click the '''Browse''' button next to the Import Data Directory field to select the directory.</li>
<ol type="a">
<li>The Open window displays.</li>
<li>Navigate to the directory where the Excel file(s) that you would like to import is located.</li>
<li>Click the '''Open''' button.</li>
:In the XLS Import window, the folder name is displayed in the Import Data Directory field in the Import window.
</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, The log files are generated and can be found in the IMSMA_HOME\migration directoryProcessing Directory specified during the import.
<li>Verify that the import was successful, and click the '''Done''' button.</li>
