Difference between revisions of "Importing and Exporting Data with IMSMANG"

From IMSMA Wiki
Jump to: navigation, search
 
(12 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
{{note| The .mxd of the map file and corresponding shapefiles should be located on a local drive on your computer. The .mxd should have an unique name and has never been imported into {{IMSMANG}} before. Recommended size of the file should not exceed 2 GB.}}
 
{{note| The .mxd of the map file and corresponding shapefiles should be located on a local drive on your computer. The .mxd should have an unique name and has never been imported into {{IMSMANG}} before. Recommended size of the file should not exceed 2 GB.}}
  
−
<p>To import an IMSMA map:</p>
 
 
<ol>
 
<ol>
−
<li>From the '''File''' menu, select '''Import'''.</li>
+
<li>In the '''File''' menu &rarr; '''Import''' &rarr; '''Map'''.</li>  
−
<li>From the '''Import''' menu, select '''Map'''.</li>  
+
 
−
:The Map Manager window displays.
 
 
<li>Navigate to the location of the .mxd file that you would like to import.</li>  
 
<li>Navigate to the location of the .mxd file that you would like to import.</li>  
 
<li>Select the .mxd file.</li>
 
<li>Select the .mxd file.</li>
Line 31: Line 29:
  
 
====Exporting Map Data For Use in ArcPad====__NOEDITSECTION__
 
====Exporting Map Data For Use in ArcPad====__NOEDITSECTION__
−
 
−
<p>To export the IMSMA map extent for use in ArcPad for more advanced geoprocessing:</p>
 
 
<ol>
 
<ol>
−
<li>From the '''File''' menu, select '''Export'''.</li>
+
<li>In the '''File''' menu &rarr; '''Export''' &rarr; '''Map'''. </li>
−
<li>From the '''Export''' menu, select '''Map'''. </li>
 
−
:The Map Manager: Export window displays.
 
 
<li>Enter the file name in the '''Name''' field.</li>  
 
<li>Enter the file name in the '''Name''' field.</li>  
 
<li>Select the '''.apm, ESRI Arc Pad Map''' option from the '''Format''' menu.</li>
 
<li>Select the '''.apm, ESRI Arc Pad Map''' option from the '''Format''' menu.</li>
 
<li>Click the '''Browse''' button.</li>
 
<li>Click the '''Browse''' button.</li>
−
<li>Navigate to the directory where you would like to save a copy of the map.</li>  
+
<li>Navigate to the folder where you would like to save a copy of the map.</li>  
 
<li>Click the '''Open''' button.</li>
 
<li>Click the '''Open''' button.</li>
 
<li>Click the '''Export''' button.</li>
 
<li>Click the '''Export''' button.</li>
−
:The map is saved in .apm format. The Map Export Complete window displays.  
+
:The map is saved in .apm format.  
 
<li>Click the '''OK''' button.</li>
 
<li>Click the '''OK''' button.</li>
 
:The Map Export window closes.
 
:The Map Export window closes.
Line 49: Line 43:
  
 
====Exporting Map Data as a PDF File====__NOEDITSECTION__
 
====Exporting Map Data as a PDF File====__NOEDITSECTION__
−
 
−
<p>To export the map in a .pdf format:</p>
 
 
<ol>
 
<ol>
−
<li>From the '''File''' menu, select '''Export'''.</li>
+
<li>In the '''File''' menu &rarr; '''Export''' &rarr; '''Map'''.</li>
−
<li>From the '''Export''' menu, select '''Map'''.</li>
 
−
:The Map Manager: Export window displays.
 
 
<li>Enter the file name in the '''Name''' field.</li>
 
<li>Enter the file name in the '''Name''' field.</li>
 
<li>Select the '''.pdf, Adobe PDF''' option from the '''Format''' menu.</li>
 
<li>Select the '''.pdf, Adobe PDF''' option from the '''Format''' menu.</li>
Line 61: Line 51:
 
{{note| Selecting the .pdf option creates a visual snapshot of the map as it displays in the Map pane, and this image cannot be manipulated further. Before exporting, you should display the map exactly as you want it to look (show or hide icons, shapes, and pins, recentre the map, zoom in or out, and so on).}}
 
{{note| Selecting the .pdf option creates a visual snapshot of the map as it displays in the Map pane, and this image cannot be manipulated further. Before exporting, you should display the map exactly as you want it to look (show or hide icons, shapes, and pins, recentre the map, zoom in or out, and so on).}}
  
−
<ol start="5">
 
 
<li>Click the '''Browse''' button.</li>
 
<li>Click the '''Browse''' button.</li>
−
<li>Navigate to the directory where you would like to save a copy of the map.</li>  
+
<li>Navigate to the folder where you would like to save a copy of the map.</li>  
 
<li>Click the '''Open''' button.</li>
 
<li>Click the '''Open''' button.</li>
 
<li>Click the '''Export''' button.</li>
 
<li>Click the '''Export''' button.</li>
−
:The map is saved in the .pdf format. The Map Export Complete window displays.  
+
:The map is saved in the .pdf format.  
 
<li>Click the '''OK''' button.</li>
 
<li>Click the '''OK''' button.</li>
 
:The Map Export window closes.
 
:The Map Export window closes.
Line 75: Line 64:
  
 
==XLS Import==__NOEDITSECTION__
 
==XLS Import==__NOEDITSECTION__
−
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.
+
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| 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| 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 directory 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 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. 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__
 
==Translations==__NOEDITSECTION__
 
See [[Language and Translations]].
 
See [[Language and Translations]].
  
−
==Data Entry Forms (maXML)==__NOEDITSECTION__
+
==Data Entry Forms (xml)==__NOEDITSECTION__
−
Data Entry Forms are imported and exported from the Search function and from the Workbench.
+
Data Entry Forms may be export in four different ways to xml file(s):
−
{{HowTo's
+
# from the [[Search for Exporting Data Entry Form | Advanced search functionality]]
−
|[[Import Data Entry Forms]]
+
# from the [[Export Data Entry Form from Workbench | Workbench ]]
−
|[[Import a Data Entry Form from a MaXML File]]
+
# from the [[Export a Data Entry Form from the Summary Window | Summary Window]]
−
|[[Export a Data Entry Form to a MaXML File]]
+
# from the [[Use the Data Entry Form Editor Window | Data Entry Form Editor Window]]
−
 
 
−
}}
 
  
 +
Import of Data Entry Forms is started from Workbench, see [[Import a Data Entry Form from a xml File|Import a Data Entry Form from a xml File]].
  
 
{{NavBox Working with IMSMA}}
 
{{NavBox Working with IMSMA}}
  
−
[[Category:ELR]]
+
[[Category:NAA]]

Latest revision as of 19:05, 17 June 2017

IMSMA allows you to import and export various types of data, including map files, auxiliary data files, geospatial points, translations, and data entry forms. The sections below describe how and from where you can import/export data in IMSMA.

Map Data

Importing Map Data

Note.jpg The .mxd of the map file and corresponding shapefiles should be located on a local drive on your computer. The .mxd should have an unique name and has never been imported into IMSMANG before. Recommended size of the file should not exceed 2 GB.
  1. In the File menu → Import → Map.
  2. Navigate to the location of the .mxd file that you would like to import.
  3. Select the .mxd file.
  4. Click the Import button.
    5. A message stating that the map import was successful displays.

Exporting Map Data

Note.jpg Before you export the map, you should zoom in as close as possible to the area on the map that you would like to export. The further out you are zoomed from your map, the longer it will take to export the map.

The export map feature allows you to save a copy of the map extent either to an .apm format so that it can be imported into ArcPad for more advanced geoprocessing, or to a .pdf file as an un-editable visual snapshot.

Map Manager Export window

Map Manager Export window

Exporting Map Data For Use in ArcPad

  1. In the File menu → Export → Map.
  2. Enter the file name in the Name field.
  3. Select the .apm, ESRI Arc Pad Map option from the Format menu.
  4. Click the Browse button.
  5. Navigate to the folder where you would like to save a copy of the map.
  6. Click the Open button.
  7. Click the Export button.
    8. The map is saved in .apm format.
  8. Click the OK button.
    9. The Map Export window closes.

Exporting Map Data as a PDF File

  1. In the File menu → Export → Map.
  2. Enter the file name in the Name field.
  3. Select the .pdf, Adobe PDF option from the Format menu.
Note.jpg Selecting the .pdf option creates a visual snapshot of the map as it displays in the Map pane, and this image cannot be manipulated further. Before exporting, you should display the map exactly as you want it to look (show or hide icons, shapes, and pins, recentre the map, zoom in or out, and so on).
  • Click the Browse button.
  • Navigate to the folder where you would like to save a copy of the map.
  • Click the Open button.
  • Click the Export button.
    • The map is saved in the .pdf format.
  • Click the OK button.
    • The Map Export window closes.

    </ol>

    Geospatial Data

    Note.jpg Find information on how to import geospatial data from Excel and shapefile to Task, Auxiliary data or to a Data Entry Form.

    XLS Import

    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.jpg 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 GICHD IM advisor for help.

    Translations

    See Language and Translations.

    Data Entry Forms (xml)

    Data Entry Forms may be export in four different ways to xml file(s):

    1. from the Advanced search functionality
    2. from the Workbench
    3. from the Summary Window
    4. from the Data Entry Form Editor Window

    Import of Data Entry Forms is started from Workbench, see Import a Data Entry Form from a xml File.

    Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Importing_and_Exporting_Data_with_IMSMANG&oldid=23615"