Back to Asset Essentials Main Menu

Mapping filters and format

Mapping Filters and Mapping Format allows you to customize what data gets imported and exported as well as the display format of that data. *Note: The Connector Tool is available to Asset Essentials clients for an additional cost. Please contact your Sales Representative or Client Services if you are interested in purchasing this feature.

Mapping filters

Mapping Filters allow you to set rules to filter specific sets of data when exporting or importing data in your account.

  • Click on the plus icon () next to the Mapping Filters field.
  • In the Filter Builder window, you can set up specific rules to filter out your data.  For example, to export only records with Asset listed as the SourceType:
    • Click the add icon ().
    • Click the green text to select the SourceType field from the drop down.
    • The blue text represents the operator and will change depending on which field name (green text) was selected. For example, if a date field is selected, the operator will change to date range values.
    • Click <enter a value>, then select Asset from the drop down.

  • You can continue to add additional filters by clicking the add icon ().
  • To change the operator of the filter, click the red text. This allows you to create a variety of different rule expressions for your filters. For example, you can create a filter to export only work orders with the SourceType of Asset OR the OriginType of PM.

  • Click OK to apply the Mapping Filter.

Mapping format

  • Click the pencil icon next to a field name to change the data format options for that field. *Note: If you plan on exporting data, then importing it back in, we recommend leaving these settings unchanged.

 

 

  • In the Mapping Format window, enter the specific formatting for the data in this field.
  • Click Save.