Importing Data from EDM Exposure Databases

 

Even when data is not stored in an open data format, AIR ImportExpress supports the import of data that is stored in proprietary RMS EDM (exposure data model) databases. The exposure data must be on the same server.

  AIR also provides a data conversion tool, the EDM Data Converter (EDC) that converts data from EDM format into a format compatible with either the CLASIC/2™ or the Touchstone application. You can use the standalone EDC with CLASIC/2 or with Touchstone. The integrated EDC is available only in Touchstone. The EDC produces a collection of three CSV files that you can import into CLASIC/2 or Touchstone. For information about choosing the most suitable tool and about installing and using it, refer to the AIR EDM Data Converter User's Guide on the AIR Client Portal.

Process overview

To import data from EDM exposure databases, perform the following steps:

1.      On the ribbon or on the title bar, click AIR ImportExpress . The application opens to the Import & Mapping Data tab.

2.      In the Import Type list, select EDM Format.

3.      Select the import file.

4.      Set the destination for the imported data by specifying the database and (optional) exposure view or exposure view suffix for the data that you want to import.

5.      Configure the import options.

6.      Submit the import.

7.      Open the Activity Monitor and check the activity log. When the status of the import activity is “Completed,” open the activity log for the completed import. Check the log for records that were imported, validation errors, and indication of rejected records.

 

© 2016 AIR Worldwide. All rights reserved.

Click here for information about AIR Worldwide, including copyright, trademarks, confidentiality, and contact information.

Touchstone V3.0 Updated December 01, 2016