Changes

Jump to: navigation, search

Importing and Exporting Data with IMSMANG

520 bytes removed, 20:05, 17 June 2017
no edit summary
{{TOC right}}
__NOEDITSECTION__
Several windows in IMSMA allow allows you to import and export selected rows various types of data, including map files, auxiliary data files, geospatial points, translations, and data entry forms. The sections below describe how and from the window to either XML or to a comma-separated values (CSV) file (Figure 107). Figure 107where you can import/export data in IMSMA. Export to File Icon==Importing Field Reports to IMSMA==
==Map Data=How To Import Field Reports=__NOEDITSECTION__===Importing Map Data===*[[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]]__NOEDITSECTION__
===How To Export Field Reports===*[[HowTo:Export Approved Field Reports]] *[[HowTo:Export {{note| The .mxd of the map file and corresponding shapefiles should be located on a Field Report to local drive on your computer. The .mxd should have an MDML File from unique name and has never been imported into {{IMSMANG}} before. Recommended size of the Workbench]] *[[HowTo:Export a Field Report to a MaXML File]]file should not exceed 2 GB.}}
==Importing Maps to IMSMA==<ol>===How To <li>In the '''File''' menu &rarr; '''Import an IMSMA Map======How To Export IMSMA Map Data=======How To Export Map Data For Use in ArcPad========How To Export ''' &rarr; '''Map Data as a PDF File===='''.</li>
==Importing Auxiliary Data <li>Navigate to IMSMA== The XLS Import feature allows the location of the .mxd file that you would like to import field report data or auxiliary data (organisations, explosive ordnance, places, and country structure levels) into IMSMA using a Microsoft Excel .</li> <li>Select the .mxd file. This allows mine action personnel without IMSMA access to collect data in a format </li><li>Click the '''Import''' button.</li>:A message stating that can be entered into the system. The XLS Import feature also aids in data migration activitiesmap import was successful displays.</ol>
{| style="border:2px solid lightgray; float:center; margin:10px;"|align="left" style="padding: 5px 10px 5px 10px"|[[Image:bulb2.png|25px|Represents a tip or note for using IMSMA Mobile.]]|alignExporting Map Data="left" style="padding: 5px 10px 5px 10px"| 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.=__NOEDITSECTION__
To import auxiliary data or field report data {{note| Before you export the map, you should zoom in an XLS-file formatas close as possible to the area on the map that you would like to export. The further out you are zoomed from your map, you must have the ''XLS Import'' permissionlonger it will take to export the map.|}}
<p>To import auxiliary 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 field report data using to a .pdf file as an XLS file:un-editable visual snapshot.</p>
<ol><li>From the File menu, select '''Import'''.</li><li>From the Export menu, select XLS File.</li>:The XLS Import window displays ([[:Image:XLSImportMapManagerExport.png|XLS Import window]]). [[Image:XLSImport.png400px|center|''XLS Import Map Manager Export window'']]
<div align="center">
''XLS Import Map Manager Export window''
</div>
====Exporting Map Data For Use in ArcPad====__NOEDITSECTION__<ol><li>Click In the '''BrowseFile''' menu &rarr; '''Export''' &rarr; '''Map''' button next to . </li><li>Enter the file name in the Import Ordering File '''Name''' field.</li>:The Open window displays.<li>From Select the Open window:'''.apm, ESRI Arc Pad Map''' option from the '''Format''' menu.</li><ol type="a"li>Click the '''Browse''' button.</li><li>Navigate to the directory folder where the file that you would like to import is located.</li><li>Select save a copy of the file namemap.</li>
<li>Click the '''Open''' button.</li>
<li>Click the '''Export''' button.</li>:In The map is saved in .apm format. <li>Click the XLS Import '''OK''' button.</li>:The Map Export window, closes.</ol> ====Exporting Map Data as a PDF File====__NOEDITSECTION__<ol><li>In the location of '''File''' menu &rarr; '''Export''' &rarr; '''Map'''.</li><li>Enter the XLS file is displayed name in the Processing Directory section of '''Name''' field.</li><li>Select the window'''. The location of the import mapping files is displayed in pdf, Adobe PDF''' option from the Import Data Directory section'''Format''' menu.</li>
</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 ([[:Image:XLSImportResults.png|XLS/CSV Import Results window]]). In addition, log files are generated and can be found in the IMSMA_HOME\migration directory.
<li>Verify that the import was successful, and click the '''Done''' button.</li>
[[Image:XLSImportResults.png|center|''XLS/CSV Import Results window'']]
<div align="center">
''XLS/CSV Import Results window''
</div>
{{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.</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 '''Export''' button.</li>
:The map is saved in the .pdf format.
<li>Click the '''OK''' button.</li>
:The Map Export window closes.
</ol>
==TranslationsGeospatial 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 ==Data Entry Forms (xml)==__NOEDITSECTION__Data Entry Forms may be export in four different ways to import field report data or auxiliary data xml file(organisations, explosive ordnance, places, and country structure levelss) into IMSMA using :# from the [[Search for Exporting Data Entry Form | Advanced search functionality]]# from the [[Export Data Entry Form from Workbench | Workbench ]]# from the [[Export a Microsoft Excel file. This allows mine action personnel without IMSMA access to collect data in a format that can be entered into Data Entry Form from the Summary Window | Summary Window]]# from the [[Use the system. The XLS Import feature also aids in data migration activities.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: * 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* Import of Data Entry Forms is started from Workbench{{HowTo's|[[HowTo:Export Approved Field Reports|HowTo:Export Approved Field Reports]]|, see [[HowTo:Import Field Reports|HowTo:Import Field Reports]]|[[HowTo:Export a Field Report to Data Entry Form from a MaXML xml File|Export Import a Field Report to Data Entry Form from a MaXML xml 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:* 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{{NavBox Working with IMSMA}}
4. Click the OK button.[[Category:NAA]]
6,632
edits

Navigation menu