Importing Tasks from InfoAsset Planner

Work orders and inspection tasks can be imported into any type of InfoAsset Manager network from an InfoAsset Planner Geodatabase.

To import tasks:

  1. Open the InfoAsset Manager network which is to be updated with the InfoAsset Planner work orders and inspection tasks.
  2. Select Network | Import | Import tasks from InfoAsset Planner.

    The Import Tasks from InfoAsset Planner dialog is displayed.

  3. Click the ellipsis button to display the Select Data window, then find the InfoAsset Planner Geodatabase from which the work orders and inspection tasks are to be imported.
  4. When you have selected the applicable Geodatabase, click Add.

    The work orders and inspection tasks are extracted from the Geodatabase, and the Select Data window is closed.

    If any of the extracted work orders and inspection tasks types and sub tasks did not originate in InfoAsset Manager, these will be displayed in the mapping grids and will require mapping as described in Step 5. If they originated in InfoAsset Manager, the grids will not be displayed and the data can be imported as described in Step 6.

  5. If the mappings you want to use have been saved to a configuration file, click the Load Config button, then select the appropriate cfg file from the Windows Open dialog.

    Any invalid mappings from the configuration file are listed in a Configuration Warnings window, and can subsequently be manually mapped in the grids as described below.

  6. If a suitable configuration file is not available, use the Work Orders and Inspection Tasks grids to map the work orders and inspection tasks types and sub types from InfoAsset Planner to InfoAsset Manager tasks types and sub types as applicable.

    Currently defined InfoAsset Manager task types and sub type options are displayed in the dropdown lists. A sub type field is enabled only if sub types are available for the selected task type.

    If the sub type option you want to use is not included in the relevant InfoAsset Manager dropdown list, you can type in a new one.

    Tip: New sub types options can be made available in InfoAsset Manager by adding them to the applicable choice lists. When the import is complete, you can validate the network. Error messages will highlight any unrecognised (new) task sub types.

  1. When you are satisfied that the InfoAsset Planner work orders and inspection tasks types and sub types have been correctly mapped to InfoAsset Manager tasks and subtypes, click the OK button to complete the import.

Imported data will be highlighted by an IAP flag in the property sheets for the relevant objects.

Saving and Reloading Configurations

You can save and reload the mappings between InfoAsset Planner and InfoAsset Manager that are displayed in the Work Orders and Inspection Tasks grids.

Import Notes

The following provides the default mappings between the fields (properties) in InfoAsset Planner work order and inspection tasks and those in InfoAsset Manager.

Work Orders
InfoAsset Planner Field InfoAsset Manager Field
ID ID
Facility ID Node reference/ Asset ID
Type Type
X X
Y Y
Status Status
Description Notes
Priority Priority
Location Location
Cost Cost
Frequency Repeat period
Interval Interval
InitiatedDate Date opened
DateClosed Date closed
ActualFinishDate Date completed
ProjFinishDate Estimated completion date
ProjStartDate Date/time planned
ActualStartDate Date/time started
Supervisor Team Leader
Contractor Contractor
Work Order Tasks
InfoAsset Planner Field   Line title in Notes field
TaskID These are written into the Notes field of the associated InfoAsset Manager task. Task
Type Type
Cost Cost
Distance Distance
Length Length
Inspection Tasks
InfoAsset Planner Field InfoAsset Manager Field
ID ID
Type Type
X X
Y Y
Facility ID Asset ID
Status Status
Description Notes
Priority Priority
Location Location
Cost Cost
Frequency Repeat period
Interval Interval
InitiatedDate Date opened
DateClosed Date closed
ActualFinishDate Date completed
ProjFinishDate Estimated completion date
ProjStartDate Date/time planned
ActualStartDate Date/time started
Supervisor Team leader
Contractor Contractor

Importing Network Data

Import Tasks From InfoAsset Planner Dialog

User Defined Choice Lists