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

From IMSMA Wiki
Jump to: navigation, search
Line 72: Line 72:
  
 
==Geospatial Data==__NOEDITSECTION__
 
==Geospatial Data==__NOEDITSECTION__
−
{{note| Find information on how to import geospatial data from [[Import Geospatial Data from Excel|Excel]] and [[Import Geospatial Data from Shapefile|shapefile]].}}
+
{{note| Find information on how to import geospatial data from [[Import Geospatial Data from Excel|Excel]] and [[Import Geospatial Data from Shapefile|shapefile]] to Task, Auxiliary data or to a Data Entry Form.}}
  
 
==Auxiliary Data==__NOEDITSECTION__
 
==Auxiliary Data==__NOEDITSECTION__
  
−
The XLS Import feature allows you to import data entry form data or auxiliary data (organisations, explosive ordnance, places, assistance classifications, needs classifications, cause classifications, and country structure levels) into IMSMA using a Microsoft Excel file. This allows mine action personnel without IMSMA access to collect data in a format that can be entered into the system. The XLS Import feature also aids in data migration activities.
+
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 set up 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, and business rules, and any data normalization required for import.}}
+
{{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.}}
  
−
{| style="border-top:2px solid lightgray; border-bottom:2px solid lightgray; margin:10px;"
+
{{ 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.}}
−
|align="left" style="padding: 5px 10px 5px 10px"| To import auxiliary data or data entry form data in an XLS-file format, you must have the [[Defining Roles, Permissions and Users|XLS Import permission]].
 
−
|}
 
  
−
<p>To import auxiliary data or data entry form data using an XLS file:</p>
+
<p>To import an XLS file:</p>
  
 
<ol>
 
<ol>
Line 122: Line 120:
  
 
==Data Entry Forms==__NOEDITSECTION__
 
==Data Entry Forms==__NOEDITSECTION__
 +
Data Entry Forms are imported and exported from the Search function and from the Workbench.
 
{{HowTo's
 
{{HowTo's
 
|[[Import Data Entry Forms]]
 
|[[Import Data Entry Forms]]

Revision as of 22:27, 2 June 2014

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.

To import an IMSMA map:

  1. From the File menu, select Import.
  2. From the Import menu, select Map.
    3. The Map Manager window displays.
  3. Navigate to the location of the .mxd file that you would like to import.
  4. Select the .mxd file.
  5. Click the Import button.
    6. 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

To export the IMSMA map extent for use in ArcPad for more advanced geoprocessing:

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

Exporting Map Data as a PDF File

To export the map in a .pdf format:

  1. From the File menu, select Export.
  2. From the Export menu, select Map.
    3. The Map Manager: Export window displays.
  3. Enter the file name in the Name field.
  4. 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).
  1. Click the Browse button.
  2. Navigate to the directory where you would like to save a copy of the map.
  3. Click the Open button.
  4. Click the Export button.
    5. The map is saved in the .pdf format. The Map Export Complete window displays.
  5. Click the OK button.
    6. The Map Export window closes.

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.

Auxiliary Data

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.jpg 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.
Note.jpg To use import XLS-file, you must have XLS Import permission. Contact your IMSMA administrator if you have questions on permissions.

To import an XLS file:

  1. From the File menu, select Import.
  2. From the Import menu, select XLS File.
    3. The XLS Import window displays.
    XLS Import window

    XLS Import window

  3. Click the Browse button next to the Import Ordering File field.
    4. The Open window displays.
  4. From the Open window:
    1. Navigate to the directory where the file that you would like to import is located.
    2. Select the file name.
    3. Click the Open button.
      4. In the XLS Import window, the location of the XLS file is displayed in the Processing Directory section of the window. The location of the import mapping files is displayed in the Import Data Directory section.
  5. Click the Browse button next to the Processing Directory field to select the directory.
  6. Click the Browse button next to the Import Data Directory field to select the directory.
  7. Click the Import button.
    8. The Import Results window displays with the contents of the migration.log, migration_errors.log, and migration_dataissues.log. In addition, log files are generated and can be found in the IMSMA_HOME\migration directory.
  8. Verify that the import was successful, and click the Done button.
    9. XLS/CSV Import Results window

    XLS/CSV Import Results window

Translations

See Language and Translations.

Data Entry Forms

Data Entry Forms are imported and exported from the Search function and from the Workbench.

How To


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