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

Revision as of 18:09, 22 March 2013

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

Geospatial Data

• Importing Geospatial Data

Field Reports

Importing Field Reports

• HowTo:Import Field Reports
• HowTo:Import a Field Report from an MDML File to the Workbench
• HowTo:Import a Field Report from a MaXML File

Exporting Field Reports

• HowTo:Export Approved Field Reports
• HowTo:Export a Field Report to an MDML File from the Workbench
• HowTo:Export a Field Report to a MaXML File

Map Data

Importing Map Data

To import an IMSMA map:

1. From the File menu, select Import.
2. From the Import menu, select Map.

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.

A message stating that the map import was successful displays.

Exporting Map Data

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.

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.

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.

The map is saved in .apm format. The Map Export Complete window displays.

9. Click the OK button.

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.

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.

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.

The map is saved in the .pdf format. The Map Export Complete window displays.

9. Click the OK button.

The Map Export window closes.

Auxiliary Data

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.

To import auxiliary data or field report data using an XLS file:

1. From the File menu, select Import.
2. From the Export menu, select XLS File.

The XLS Import window displays (XLS Import window).



XLS Import window

3. Click the Browse button next to the Import Ordering File field.

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.

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 Import button.

The Import Results window displays with the contents of the migration.log, migration_errors.log, and migration_dataissues.log (XLS/CSV Import Results window). In addition, log files are generated and can be found in the IMSMA_HOME\migration directory.

6. Verify that the import was successful, and click the Done button.


XLS/CSV Import Results window

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.

The following windows allow you to export selected row(s) to a file by clicking the button:

• Explosive Ordnance List
• Explosive Ordnance Selection
• Field Report Templates
• Organisation List
• Organisation Selection
• Place List
• Place Selection
• Reports
• Report Templates
• Search Manager
• User List
• Workbench

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:

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