NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "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| In..."
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| 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 [[Information Management Team | 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)
<p>To import an XLS file:</p>
<ol>
<li>From the '''File''' menu, select '''Import'''.</li>
<li>From the '''Import''' menu, select '''XLS File'''.</li>
:The XLS Import window displays.
[[Image:XLSImport.png|500px|center|''XLS Import window'']]
<div align="center">
''XLS Import window''
</div>
<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 folder where the Import Ordering File is located.</li>
<li>Select the file (.txt or mtxt).</li>
<li>Click the '''Open''' button.</li>
:In the XLS Import window, the folder and file name are displayed in the Import Ordering File field in the Import window.
</ol>
<li>Click the '''Browse''' button next to the Processing Directory field.</li>
<ol type="a">
<li>The Open window displays.</li>
<li>Navigate to the folder 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.</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. The log files are generated in the Processing Directory specified during the import.
<li>Verify that the import was successful, and click the '''Done''' button.</li>
[[Image:XLSImportResults.png|500px|center|''XLS/CSV Import Results window'']]
<div align="center">
''XLS/CSV Import Results window''
</div>
</ol>
{{Note| 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 [[Information Management Team | 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)
<p>To import an XLS file:</p>
<ol>
<li>From the '''File''' menu, select '''Import'''.</li>
<li>From the '''Import''' menu, select '''XLS File'''.</li>
:The XLS Import window displays.
[[Image:XLSImport.png|500px|center|''XLS Import window'']]
<div align="center">
''XLS Import window''
</div>
<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 folder where the Import Ordering File is located.</li>
<li>Select the file (.txt or mtxt).</li>
<li>Click the '''Open''' button.</li>
:In the XLS Import window, the folder and file name are displayed in the Import Ordering File field in the Import window.
</ol>
<li>Click the '''Browse''' button next to the Processing Directory field.</li>
<ol type="a">
<li>The Open window displays.</li>
<li>Navigate to the folder 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.</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. The log files are generated in the Processing Directory specified during the import.
<li>Verify that the import was successful, and click the '''Done''' button.</li>
[[Image:XLSImportResults.png|500px|center|''XLS/CSV Import Results window'']]
<div align="center">
''XLS/CSV Import Results window''
</div>
</ol>
