Changes

Jump to: navigation, search

Importing and Exporting Data with IMSMANG

2,401 bytes removed, 18:20, 26 May 2017
no edit summary
{{Rewrite| This page is being rewritten. }}
{{TOC right}}
__NOEDITSECTION__
{{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.}}
 
{{ 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>
 
<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>
==Translations==__NOEDITSECTION__
Alnaucler
NoPublic, bureaucrat, administrator
6,632
edits
Retrieved from "http://mwiki.gichd.org:8090/IM/Special:MobileDiff/22935"

Navigation menu