Legacy Migration Tool

About Legacy Migration Tool

The APM Entity and Relationship families in Rounds Pro are significantly different from Legacy Rounds. Using the Legacy Rounds Migration tool you can migrate data from Legacy Rounds to Rounds Pro.

Following are the highlights of the Migration tool:
  • You can run the tool multiple times for the same route. For instance, if you find any issues with the data during the migration process, you can correct the data and re-run the migration utility for the same route. When you re-run the utility for the same route, it updates all the related migrated data in Rounds Pro and may create new records if they were not created in the previous run.
  • You can use the tool to migrate all data or subset of data. For example, you can use a query to filter and migrate a single Route for testing purposes or migrate multiple Routes belonging to a specific site.
  • Migration tool will not delete any data in Legacy Rounds.

Terminology

The following table provides the terminology in Legacy Rounds versus Rounds Pro:
Table 1. Legacy Rounds Vs Rounds Pro
Legacy Rounds Rounds Pro Notes
Allowable Values Picklists None
Measurement Location Measurement Step None
Route Route Master/Route Instance When a Route Master is due a separate Route Instance is created.
Measurement Location Template Step Template None
Condition Conditional Step Conditional Steps are part of the Measurement Step.
ReadingStep ReadingNone
Operator Rounds Recommendation Operator Rounds Recommendation Same family is used in both Legacy Rounds and Rounds Pro.

Key Considerations

In the current release, following data from Legacy Rounds is migrated to Rounds Pro:
  • Routes
  • Measurement Locations
  • Category/Allowable values
  • Checkpoint Conditions
  • Health Indicators: New Health Indicators are created and then associated with the Measurement Steps. The original Health Indicators associated with Measurement Locations are not updated and will continue to stay.
  • Users and Teams assigned to Routes.

Limitations

In the current version, following limitations exist:
  • Data: The Migration tool will migrate the data structure, but not the data generated from Legacy Rounds. The following items will not be migrated to Rounds Pro:
    • Readings
    • Route History records
    • Operator Rounds Recommendations
    • Reference Documents
    • GIS Data
  • Functionality: The following functionality will not be migrated to Rounds Pro:
    • Step Scheduling: If your Measurement Locations have schedules defined, those schedules will not be migrated to Rounds Pro.
    • Lubrication Requirements and Lubrication Templates: Lubrication Requirements are currently not available in Rounds Pro and hence lubrication requirements will not be migrated. If your route has a lubrication requirement, routes will be migrated without lubrication requirements.
    • Templates Groups: Template Groups are currently not available in Rounds Pro and will not be migrated.
    • Localization Data: Only English language is supported in Rounds Pro
  • Other Modules: Data related to the following modules will not be migrated:
    • Policies: Policies created based on the Measurement Location node will not be upgraded to Measurement Steps.
    • Health Indicators: New Health Indicators will be created in Rounds Pro. The original Health Indicators associated with Measurement Locations will not be updated.
    • Strategy: Measurement Locations with links to Asset Strategy will be migrated as Measurement Steps in Rounds Pro but the measurement steps will not be linked to Asset Strategy.
  • Customization:
    • Fields: Any custom fields, custom rules that are created on the Legacy Rounds families will not be migrated to Rounds Pro Families
    • Catalog Items (Queries/Reports/Graphs): Any custom catalog items using Legacy Rounds Families will not be migrated to Rounds Pro.
  • Others:
    • Checkpoint Images: If there are checkpoint images associated with the Measurement location, they will not be migrated.
    • Measurement Location not linked to Assets: Measurement Steps in Rounds Pro needs an Asset to be linked, which is not required in Legacy Rounds. If there are any Measurement Locations that are not linked to an Asset or unknown assets, they will not be created in Rounds Pro. However, you can create dummy Functional Locations before running the Migration tool, then these will steps be linked with the newly created Functional Locations. Functional Locations should follow the exact naming convention as below:
      • Catch-All for unknown Asset: Measurement Locations that are linked to an Unknown asset will be migrated as Measurement Steps and are linked to this Functional Location.
      • Catch-All for no Asset: Measurement Locations that are not linked to an asset will be migrated as Measurement Steps and are linked to this Functional Location.
    • Actions: Actions in the Measurement Location are not migrated.
    • Route Schedule: Route Schedule is not migrated.

Route Migration

When Migration Type is selected as Routes, the complete Route is migrated from Legacy Rounds to Rounds Pro and a new Route Master is created in Rounds Pro. During this process, several other records that are part of the Route will be created like the Picklists/Picklist item, Measurement Steps, and Conditional steps.

Legacy Rounds records are migrated in the following way to Rounds Pro records:

  • Measurement Locations are migrated as Measurement Steps
  • Routes are migrated as Route Masters
  • Allowable Values are migrated as Picklists

Measurement Location to Measurement Step

During the migration process, the Legacy Rounds Migration tool performs the following tasks in the background.
  • If there is no Measurement Step (Same Name and Asset relationship) in Rounds Pro, a new Measurement Step is created.
  • If there is an existing Measurement Step in Rounds Pro with same Name and Asset relationship, a new Measurement Step is created and the Step Name is appended with the last four digits of the Entity Key. For example, Step Name [1234].
  • Since the information related to Conditions is part of the Measurement Step in Rounds Pro, the Conditions under the parent Measurement Location are now part of the Measurement Step in Rounds Pro.
  • In Rounds Pro, it is required for all the Measurement Steps in the Route Master should belong to the same site. Hence, in Legacy Rounds if a Route has Measurement Locations from different sites, these routes and the associated Measurement Locations will not be migrated.
  • In Rounds Pro, it is required that all Measurement Steps should belong to an Asset. Hence in Legacy Rounds if there are any routes which have Measurement Locations not related to any Asset, then these Measurement Locations will not be migrated to Rounds Pro, unless dummy Functional Locations are created as mentioned in the previous section.
Table 2. Measurement Location to Measurement Step
Measurement LocationMeasurement StepNotes
Checkpoint IDThis field is not available in the Step Family.None
Checkpoint ImageAdditional Instructions - ImageThis component is not migrated yet
TemplateTemplateThis component is not migrated yet
AssetRelated Asset KeyNone
Asset IDRelated Asset IDGets the current Asset ID based on the Asset Key (If the Asset ID is modified in the corresponding Asset family, then this field will have the modified Asset ID, which can be different from the current Asset ID shown on the Measurement Location)
Equipment Technical NumberEquipment Technical NumberThis component is not migrated yet
Asset DescriptionAsset DescriptionThis component is not migrated yet
ML DescriptionStep Name
  • If there are multiple Measurement Locations with the name same description within the Asset, the Step Name is appended with four digits of the Entity Key. For example. <Step Name> [3456].
  • If the description is longer than 50 characters, it is truncated.
ML TypeReading Type
  • The following criterion is used to assign the reading type on the Step.
  • Text Entry: Numeric – Assigned when ML Type is Numeric and Category is blank.
  • Text Entry: Character – Assigned when ML Type is Character and Category is blank.
  • Picklist: Single select – Assigned when the Category has a valid value and there are valid allowable values. If there are no valid allowable values, then corresponding Text Entry: Numeric/Text Entry: Character is selected based on the ML Type.
Unit of MeasureUnit of MeasurementNone
CategoryReading PicklistNone
Allowable ValuesPicklist ValuesNone
Maximum Valid ValueMaximum Valid ValueThis component is not migrated yet.
Minimum Valid ValueMinimum Valid Value
Maximum Target ValueMaximum Target Value
Minimum Target ValueMinimum Target Value
More InformationMore Information
StatusStatusThis component is not migrated yet.
Scan IDScan IDNone
Scan to UnlockIs Locked?None
Download Stored DocumentEquivalent is not availableNone
Requires Equipment shutdownRequires Equipment shutdownThis component is not migrated yet
Include as Health Indicator SourceInclude as Health Indicator Source
  • Limits are required for a Health Indicator to be created in Rounds Pro.
  • If there are either Numeric or character Limits or Messages defined, then a New Health Indicator is created. If there are no limits or messages defined, then a Health Indicator is not created.

Routes to Route Masters

During the migration process, the Legacy Rounds Migration tool performs the following tasks in the background.
  • Route is migrated as a Route Master in Rounds Pro. If the Route belongs to an asset, then the new route master created in Rounds Pro is linked to the same asset.
  • The new route master in Rounds Pro is assigned the same site that the route belonged to in legacy.
  • All allowable values and measurement locations that are part of the Legacy Rounds are migrated to Rounds Pro. The measurement locations in legacy are migrated in the same sequence as they exist in Legacy Rounds.
  • Any conditions and conditional measurement locations that exist in the route are migrated to Rounds Pro as conditions and conditional steps in the new route master.
  • All new measurement locations in Rounds Pro after migration belong to the same site as in Legacy Rounds.
Table 3. Routes to Route Masters
RouteRoute MasterNotes
Route IDRoute NameNone
Route DescriptionRoute DescriptionNone
StatusActivate RouteThis component is not migrated yet. Active Route field is set to False for all the routes migrated to Rounds Pro.
Route Scan IDThis functionality is not available yetNone
Last dateLast done DateThis component is not migrated yet
Next DateNext due DateThis component is not migrated yet
ScheduleSchedule SummaryThis component is not migrated yet

Allowable Values to Picklists

During the migration process, the Legacy Rounds Migration tool performs the following tasks in the background.
  • If there is no Picklist with the same name as the Category in Rounds Pro a new Picklist is created.
  • If the Picklist does not have the Picklist Item, a new Picklist item is added to the Picklist.
  • If both the Picklist and Picklist Items are available, the existing ones are used.
Table 4. Allowable Values to Picklists
Allowable ValuesPicklistsComments
Category NamePicklist NameNone
TypePicklist TypeNone
ValuesValueNone

Access the Legacy Rounds Migration Page

Before You Begin

  • You must be a Super User.
  • You must have active Legacy Rounds and Rounds Pro licenses.
  • If you are have data in Rounds Pro, you must review the existing Rounds Pro data before starting the migration process to avoid any unnecessary updates to your existing Rounds Pro data.

Procedure

  1. Access the Rounds Designer administration page.
  2. Select the Legacy Rounds Migration tab.
    The Legacy Rounds Migration workspace appears.

Migrate Legacy Rounds Data

Procedure

  1. Access the Legacy Rounds Migration Page
  2. Select Migration Type.
  3. Under Migration Scope, select one of the following options:
    • Migrate from query: Using this option, you can migrate a subset or subsets of data. You can use the query located at Public/Meridium/Modules/Rounds Pro/Queries/Legacy Migration/Routes to migrate a single Route for testing purposes or multiple Routes belonging to a specific site. You can customize this query as needed.
    • Migrate All: Using this option you can migrate all of the data.
  4. Select Initiate Migration.
    The Review migration window appears.
  5. Select Migrate Data to initiate migration.
    Your migration job is started.
    Note: If more than 10 Routes are selected for migration, then separate migration jobs are created for each batch of 10 routes.

Access Migration Results

About This Task

After each migration run, one or more log entries gets created, providing detailed information about the action taken on each record. These logs enable you to take necessary actions.

Procedure

  1. Access the Legacy Rounds Migration Page
  2. Select the Job ID, for which you want to view the logs details.
    A Master-Details record opens in the Record Manager displaying the following fields.
    Table 5. Legacy Rounds Migration Job
    FieldData TypeDescriptionBehavior and Usage
    Job IDCharacterEach migration is a unique job, and each job has an ID.This is automatically created when you start a migration task.
    Note: If more than 10 Routes are selected for migration, then separate migration jobs are created for each batch of 10 routes.
    Job StatusCharacterThe status of the migration job.

    The following status are available:

    • Completed – Migration job completed successfully.
    • CompletedWithError - Migrated job is completed with errors.
    • In Progress – Migration job is still running.
    Migration Component TypeCharacterDefines the component types that will be migrated, such as Routes, Measurement Location.Only Routes is supported.
    Processed Item CountNumericNumber of items processed in the current migration.None
    Total Item CountNumericTotal items selected for the migration.None
    Migration LogTextHigh level Summary log.Summary log entry for each Route, with status set as either of the following:
    • Success
    • Completed with Warning
    • Failed with Error
    Migration Starts OnDateMigration start date and time.None
    Migration Ends OnDateMigration end date and time.None
  3. Select Legacy Rounds Migrated Item family in the Record Manager.
    The following available fields appear:
    Table 6. Legacy Rounds Migrated Item
    FieldData TypeDescriptionBehavior and Usage
    Migrated Item Family IDCharacterFamily ID of the migrated itemAs of now only Routes are being migrated.
    Migrated Item Entity KeyNumericEntity Key of the migrated itemAs of now only Routes are being migrated.
    StatusCharacterIt could be either Insert or UpdateNone
    Source Item Family KeyCharacterFamily Key of the migrated itemNone
    Source Item Entity KeyCharacterEntity Key of the migrated itemNone
  4. Select Legacy Rounds Migration Log family in the Record Manager.
    The following available fields appear:
    Table 7. Legacy Rounds Migration Log
    FieldData TypeDescriptionBehavior and Usage
    Job IdCharacterIdUnique Job ID
    Source Item Family KeyNumericFamily keyFamily key of the item processed
    Source Item Entity KeyCharacterEntity keyEntity key of the item processed
    Source IDCharacterSource IDNone
    Error MessageCharacterError or warning message None
    StatusCharacterSuccess, Warning, ErrorNone
    LogTextDetailed Migration LogNone