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

From IMSMA Wiki
Jump to: navigation, search
(→‎XLS Import)
 
(84 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
{{TOC right}}
 
{{TOC right}}
 
__NOEDITSECTION__
 
__NOEDITSECTION__
−
Several windows in IMSMA allow you to export selected rows from the window to either XML or to a comma-separated values (CSV) file (Figure 107).  
+
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.
−
 
−
Figure 107. Export to File Icon
 
−
==Field Reports==
 
  
−
*[[HowTo:Import Field Reports]]
+
==Map Data==__NOEDITSECTION__
−
*[[HowTo:Export Approved Field Reports]]
+
===Importing Map Data===__NOEDITSECTION__
−
*[[HowTo:Import a Field Report from an MDML File to the Workbench]]
 
−
*[[HowTo:Export a Field Report to an MDML File from the Workbench]]
 
−
*[[HowTo:Import a Field Report from a MaXML File]]
 
−
*[[HowTo:Export a Field Report to a MaXML File]]
 
  
−
==Maps==
+
{{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.}}
−
==Auxiliary Data==
 
  
−
==XLS Import==
+
<ol>
−
{{Reference guide header|To import auxiliary data or field report data in an XLS-file format, you must have the ''XLS Import'' permission.
+
<li>In the '''File''' menu &rarr; '''Import''' &rarr; '''Map'''.</li>
 +
 
 +
<li>Navigate to the location of the .mxd file that you would like to import.</li>
 +
<li>Select the .mxd file.</li>
 +
<li>Click the '''Import''' button.</li>
 +
:A message stating that the map import was successful displays.
 +
</ol>
 +
 
 +
===Exporting Map Data===__NOEDITSECTION__
 +
 
 +
{{note| 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 XLS Import feature allows you to import field report data or auxiliary data (organisations, explosive ordnance, places, 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.
+
<p>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.</p>
−
}}
 
  
−
To import auxiliary data or field report data using an XLS file:
+
[[Image:MapManagerExport.png|400px|center|''Map Manager Export window'']]
 +
<div align="center">
 +
''Map Manager Export window''
 +
</div>
  
 +
====Exporting Map Data For Use in ArcPad====__NOEDITSECTION__
 
<ol>
 
<ol>
−
<li>From the File menu, select '''Import'''.</li>
+
<li>In the '''File''' menu &rarr; '''Export''' &rarr; '''Map'''. </li>
−
<li>From the Export menu, select XLS File.</li>
+
<li>Enter the file name in the '''Name''' field.</li>
−
:The XLS Import window displays.
+
<li>Select the '''.apm, ESRI Arc Pad Map''' option from the '''Format''' menu.</li>
−
+
<li>Click the '''Browse''' button.</li>
−
Figure 213: XLS Import window
+
<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 '''Export''' button.</li>
 +
:The map is saved in .apm format.  
 +
<li>Click the '''OK''' button.</li>
 +
:The Map Export window closes.
 +
</ol>
  
 +
====Exporting Map Data as a PDF File====__NOEDITSECTION__
 +
<ol>
 +
<li>In the '''File''' menu &rarr; '''Export''' &rarr; '''Map'''.</li>
 +
<li>Enter the file name in the '''Name''' field.</li>
 +
<li>Select the '''.pdf, Adobe PDF''' option from the '''Format''' menu.</li>
 +
</ol>
 +
 +
{{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).}}
  
−
<li>Click the '''Browse''' button next to the Import Ordering File field.</li>
+
<li>Click the '''Browse''' button.</li>
−
:The Open window displays.
+
<li>Navigate to the folder where you would like to save a copy of the map.</li>  
−
<li>From the Open window:</li>
 
−
<ol type="a">
 
−
<li>Navigate to the directory where the file that you would like to import is located.</li>
 
−
<li>Select the file name.</li>
 
 
<li>Click the '''Open''' button.</li>
 
<li>Click the '''Open''' button.</li>
−
: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.
+
<li>Click the '''Export''' button.</li>
−
</ol>
+
:The map is saved in the .pdf format.  
−
<li>Click the '''Import''' button.</li>
+
<li>Click the '''OK''' button.</li>
−
: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.
+
:The Map Export window closes.
−
<li>Verify that the import was successful, and click the '''Done''' button.</li>
 
 
</ol>
 
</ol>
  
−
==Translations==
+
==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]] to Task, Auxiliary data or to a Data Entry Form.}}
 +
 
 +
==XLS Import==__NOEDITSECTION__
 +
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.}}
  
 +
==Translations==__NOEDITSECTION__
 +
See [[Language and Translations]].
  
−
The XLS Import feature allows you to import field report data or auxiliary data (organisations, explosive ordnance, places, 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.
+
==Data Entry Forms (xml)==__NOEDITSECTION__
 +
Data Entry Forms may be export in four different ways to xml file(s):
 +
# from the [[Search for Exporting Data Entry Form | Advanced search functionality]]
 +
# from the [[Export Data Entry Form from Workbench | Workbench ]]
 +
# from the [[Export a Data Entry Form from the Summary Window | Summary Window]]
 +
# from the [[Use the Data Entry Form Editor Window | Data Entry Form Editor Window]]
  
−
The following windows allow you to export selected row(s) to a file by clicking the  button:
+
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]].
−
* Explosive Ordnance List
 
−
* Explosive Ordnance Selection
 
−
* Field Report Templates
 
−
* Handheld Template List
 
−
* Organisation List
 
−
* Organisation Selection
 
−
* Place List
 
−
* Place Selection
 
−
* Reports
 
−
* Report Templates
 
−
* Search Manager
 
−
* User List
 
−
* Workbench
 
−
{{HowTo's
 
−
|[[HowTo:Export Approved Field Reports|HowTo:Export Approved Field Reports]]
 
−
|[[HowTo:Import Field Reports|HowTo:Import Field Reports]]
 
−
|[[HowTo:Export a Field Report to a MaXML File|Export a Field Report to a MaXML File]]
 
−
}}
 
−
To export data from the selected row(s) to a file:
 
−
1. Select the row(s) that you would like to export to a file.
 
−
2. Click the  button.
 
−
The Export Options window displays. By default the XML Export option is selected (Figure 108).
 
−
 
−
Figure 108. Export Options Window
 
  
−
3. Select one of the following options:
+
{{NavBox Working with IMSMA}}
−
* XML Export – exports the file in XML format. You can also select the MaXML or MDML (on select windows) option.
 
−
* Text Export – exports the file in CSV format. If you select the Text Export option, you can select the columns that you would like to include in the export file (Figure 109).
 
−
 
−
Figure 109. Export Options Window – Text Export
 
  
−
4. Click the OK button.
+
[[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"