Exporting Intermapper Database Data - Truesight Network Automation 22.1

This topic provides instructions on creating an import source file that contains InterMapper database data to be used during a device import task.

Starting with version 4.3 of InterMapper, you can export the InterMapper data in XML format. You can use either the InterMapper GUI or command line interface to export data.

Both the export methods can be carried out on the computer hosting the InterMapper Console or any remote computer hosting the InterMapper Remote. The command line interface (CLI) is ideal for automating the export/import process by using the operating systems scheduling utility (that is, Microsoft Windows Scheduler or Linux cron).

Generating the source file by using the InterMapper Console or InterMapper Remote GUI

1. Log on to InterMapper using an account that has file export privileges.

   Note

   If you are logging in to the InterMapper Console, you might not be prompted for a username and password.

2. Select File > Export > Map Data.
3. Set the following in the Export Map Data window:
   1. Leave the Table field set to devices.
   2. Click Add All to export all tables.
   3. Select XML for the Output Format.
      Select accordingly for whether you want to export data from all maps, this map, or only selected items. Export this map is the default.
4. Click Export and specify the filename and location of the XML export file.

Generating the source file using the InterMapper Console CLI

Run the following command on the computer that hosts the InterMapper Console to export all device tables from all maps to an XML file:

java -jar InterMapper_Console.jar --host 127.0.0.1 --export "format=xml table=devices fields=*" > filename.xml

filename.xml is the path and file name of the resulting XML file.