Importing and Exporting

How To
Export Data Entry Form from Advanced Search Export Data Entry Form from Workbench Import Translations Export Translations Export Auxiliary Data Import of data from other sources

IMSMA^NG provides extensive data export/import capabilities and formats designed to support a variety of purposes and needs. Using IMSMA^NG’s import and export functions, Information Managers can exchange data directly with other IMSMA^NG installations and export data for use in external tools.

Contents

Data Entry Forms

The primary mechanism IMSMA^NG uses for sharing information is the Data Entry Forms. Data Entry Forms contain the vast majority of IMSMA^NG data and are the sole repository for entering operational information into the database. So, exporting and importing Data Entry Forms let Information Managers easily share information between IMSMA^NG installations and other IMSMA^NG tools such as IMSMA Remote Entry.

Data Entry Forms may be exported and imported in xml format.

When importing Data Entry Forms in xml format into IMSMA^NG , there are occasionally problems with the data that cause the data to not be fully imported. These import issues are tracked on each Data Entry Form and must be resolved before the Data Entry Form can be approved from the Workbench. Typically, import issues are the result of references to Data Entry Form Template, Locations or Auxiliary data such as Places, Organisations, Ordnance or Country Structure elements that do not exist in the importing database. These issues can be resolved easily by creating the necessary auxiliary data and complete the Data Entry Forms. This functionality is designed to permit imports to continue even if some of the linked data is missing.

Translations

In addition to Data Entry Forms, the translations of enumeration values can be exported and imported into IMSMA^NG. Using this functionality, Information Managers can export translations that already exists for a language or create a completely new translation file so it may be edited with Rosetta-J instead of translating one by one in the Data Inventory Manager.

Auxiliary Data

IMSMA^NG supports the export of Auxiliary data in two different formats:

• xml, for external tools such as IMSMA Remote Entry
• csv, for use in e.g. in Excel.

Note that neither xml or csv/xls cannot be imported back into an IMSMANG system without the help of a GICHD IM advisor.

Map Exports

The map is possible to export in two formats; pdf or apm (ESRI Arc Pad Map).

Non-Exportable Data

Certain data within IMSMA^NG , particularly the administrative data, is not exportable to any external format. These include:

• Saved searches,
• Impact scoring schemes
• Permissions
• Tasks and Work items and
• Summary templates.

Contact your GICHD IM advisor if you need to export any of these.

Import of data from other sources

It is possible to import data from other sources or the Auxiliary data as mentioned above by using importing scripts. Contact your GICHD IM advisor if you have questions about import scripts.