Thickness Monitoring Export

About Thickness Monitoring Export

The Thickness Monitoring Export workspace allows you to review Thickness Measurement Locations (TMLs) that you can select for the export with the related Thickness Monitoring data. You can also export the Thickness Monitoring data in the Thickness Monitoring (TM) Data Loader template format for easy data modification and re-importing.

Note: When exporting the existing TM Asset and TML data in the Thickness Monitoring Export workspace, the (Picklist) sheet in the Thickness Monitoring (TM) Data Loader template is excluded. To reference the valid values for picklist fields, you can download the Thickness Monitoring (TM) Data Loader template.

When to Export

You can export TM data in the following scenarios:

You want to re-assess existing TM data based on triggers such as time, process variations, inspection, or thickness updates.
You want to quickly modify existing TM data in bulk. After exporting the records into an Excel spreadsheet, make the changes as needed, and re-import the records using the Thickness Monitoring (TM) Data Loader.

What to Export

The list of assets that appears in the Thickness Monitoring Export workspace is based on the following catalog query: Public\Meridium\Modules\Thickness Monitoring\Queries\Export Select Asset Query. By default, this query returns the assets whose Asset Controlling Next Inspection Date field contains a value and fall within the selected level of Asset Hierarchy.

The Export Select Asset Query has the Asset parameter; the query returns the underlying assets of the selected value in the Asset Hierarchy. By default, the Asset parameter is set to the current asset context provided in the Thickness Monitoring Overview page.

The export tool takes the TML Entity Keys and Asset Entity Key from the selected query results to determine which data to export. The following families are considered on each exported worksheet:

Table 1. For Non-Piping Assets
Worksheet	Family
Assets	Equipment and Functional Location
Asset_CAS	Corrosion Analysis Settings
TML_Group	TML Group
TML_Group_CAS	Corrosion Analysis Settings
TML	Thickness Measurement Location
TML_CAS	Corrosion Analysis Settings
Measurements	Thickness Measurement

Table 2. For Piping Assets
Worksheet	Family
Assets	Equipment and Functional Location
Asset_CAS	Corrosion Analysis Settings
Piping_Component	TML Group
Piping_Component_CAS	Corrosion Analysis Settings
Piping_Band	TML Group
Piping_Band_CAS	Corrosion Analysis Settings
TML	Thickness Measurement Location
TML_CAS	Corrosion Analysis Settings
Measurements	Thickness Measurement

Thickness Monitoring Export Data

The Thickness Monitoring Export allows you to review the TML and related data in bulk, and then import it to APM. The data is exported in the same format used by the Thickness Monitoring (TM) Data Loader to enable importing and updating data.

To match the Thickness Monitoring (TM) Data Loader format, the following lookup fields are included in each worksheet:

Table 3. For Non-Piping Assets
Worksheet	Lookup Fields
Asset	Equipment ID, CMMS System, and Equipment Technical Number
Asset_CAS	Component and Inspection Type in addition to the Asset lookup fields
TML_Group	TML Group ID in addition to the Asset lookup fields
TML_Group_CAS	Inspection Type in addition to the TML_Group lookup fields
TML	TML ID in addition to the TML_Group lookup fields
TML_CAS	Inspection Type in addition to the TML lookup fields
Measurements	Same as the TML lookup fields

Table 4. For Non-Piping Assets
Worksheet	Lookup Fields
Asset	Equipment ID, CMMS System, and Equipment Technical Number
Asset_CAS	Component and Inspection Type in addition to the Asset lookup fields
Piping_Component	Component ID in addition to the Asset lookup fields
Piping_Component_CAS	Inspection Type in addition tot he Piping_Component lookup fields
Piping_Band	Piping Band ID in addition to Piping_Component lookup fields
Piping_Band_CAS	Inspection Type in addition to Poping_Band lookup fields
TML	Position in addition to the Piping_Band lookup fields
TML_CAS	Same as the TML lookup fields
Measurements	Same as the TML lookup fields

After the lookup fields, datasheet fields for each family associated with the template worksheet are exported with the following exceptions:

System Fields: You cannot edit these fields. These fields are maintained by APM.
Output Fields: These fields are calculated. You cannot set these fields.

The default datasheet set in Family Management determines the fields to be exported for each family. If there is no datasheet marked as default for a family, the fields from the first available datasheet are used.

For Piping_Component, the MI_PIP_COMP datasheet is used to retrieve the fields.
For Piping_Band, the MI_PIP_BAND datasheet is used to retrieve the fields.

Note: Data will be exported using your login and culture settings.

Important: Only users with the same unit of measure and culture settings can re-import through the Thickness Monitoring (TM) Data Loader.

Access the Thickness Monitoring Export Workspace for a Single Asset

About This Task

This topic describes how to access the Thickness Monitoring Export workspace for a single asset. You can also access the workspace for multiple assets.

Procedure

Access the Analysis Overview workspace for the asset for which you want to access the Thickness Monitoring Export workspace.
Select , and then select Export.
The Thickness Monitoring Export workspace appears, displaying the Select TMLs section, which contains a hierarchical list of TMLs linked to the selected asset. This list also includes TMLs linked to any TML Groups in the asset.

Access the Thickness Monitoring Export Workspace for Multiple Assets

About This Task

This topic describes how to access the Thickness Monitoring Export workspace for multiple assets. You can also access the workspace for a single asset.

Procedure

Access the Analysis Overview workspace for the functional location that contains the assets for which you want to access the Thickness Monitoring Export workspace.
Select , and then select Export..
The Select Assets to Load for Export window appears, displaying a list of assets in the functional location.
In the rows containing the assets for which you want to access the Thickness Monitoring Export workspace, select the check boxes.

Important: The assets that you select must be all non-piping or all piping assets.

Note: We recommend that you select the same type of assets (that is, either Equipment or Functional Locations).
Select Done.
The Thickness Monitoring Export workspace appears, displaying the Select TMLs section. The Select TMLs pane contains a hierarchical list of TMLs linked to the selected assets. This list also includes TMLs linked to any TML Groups in the assets.

Export TMLs

Procedure

Access the Thickness Monitoring Export workspace.
In the Select TMLs pane, perform one of the following steps:
- Select Select Assets to navigate through the Asset Hierarchy, and select the check boxes corresponding to the TMLs whose records you want to export. To select all TMLs from an Asset, TML Group, Component, or Band, select the check box next to each item.
- Search for a TML using the Search box. Enter the TML ID of the TML that you want to search for in the Search field. From the search results, select the check boxes corresponding to the TMLs whose records you want to export.
  Tip: You can also search for Assets, TML Groups, Components, or Bands using their IDs. If you want to select items at a different level, you must select Apply before entering the next search item.
Note:
- For an asset, if there are more than 1000 linked TMLs, a message appears, and the TMLs do not appear in the pane. However, you can select the check box next to the Asset or TML Group to select all the linked TMLs.
- Selecting assets using the Select Assets option adds the assets to the existing list of items; it will not replace the existing selection. If you want to add assets afresh, refresh the page, or revisit the Thickness Monitoring Export workspace.
Select Apply.
The selected TMLs appear in the Selected TMLs section.
Note:
- For non-piping assets, TMLs are sorted in the ascending order of Asset ID, TML Asset ID, and TML ID. For assets that have Piping Rotation enabled, TMLs are sorted in the ascending order of Asset ID, Component ID, Distance From Inlet, Piping Band ID, and Position.
- If the total number of TMLs across all the selected assets is more than 5,000, the TMLs do not appear in the Selected TMLs section. However, the Confirm Send window appears, asking you to confirm that you want to send all the selected items to the device. For Oracle databases, the aforementioned limit is 1,000 TMLs.
Note: Select to access the Table Settings window, where you can set the column preferences.
Select Export.
The Export to a File message box appears, asking for a file name.
Select Include Measurements checkbox to include existing Thickness Measurement records in the exported content. By default, the checkbox is selected, which indicates that all measurements will be exported. If the checkbox is not selected, the Measurements workbook will include all the lookup fields populated without the Measurement data.

Note: If you do not select the Include Measurements checkbox, and export the excel, you need to add Measurement details and then upload the exported excel through Data Loader.
Enter the file name, and then select Export.
An Excel spreadsheet is downloaded, containing the data that you want to export.