Alnaucler at 17:43, 17 June 2017

2017-06-17T17:43:38Z

← Older revision		Revision as of 19:43, 17 June 2017
Line 11:		Line 11:

	<ol>		<ol>
	<li>~~From~~ the '''File''' menu~~, select~~ '''Import'''~~.</li>~~		<li>In the '''File''' menu → '''Import''' → '''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'']]

Alnaucler at 18:01, 26 May 2017

2017-05-26T18:01:02Z

← Older revision		Revision as of 20:01, 26 May 2017
Line 54:		Line 54:

	</ol>		</ol>

			{{NavBox Manage Information}}
			[[Category:NAA]]

Alnaucler: 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..."

2017-05-26T17:27:11Z

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..."

New page

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>

Import XLS data - Revision history

Alnaucler at 17:43, 17 June 2017

Alnaucler at 18:01, 26 May 2017

Alnaucler: 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..."