Data Migration Review Recommendations

Data Migration Review Recommendations

No one knows your data like you. This article provides recommendations on data QA/QC checks for reviewing data converted into ITpipes.

ITpipes SmartTabs will be invaluable for doing QA/QC on data and we recommend attending ITpipes Web Usage training for information on how to build SmartTabs. Clients with an active SSA can sign up for training here.

When doing QA/QC of migrated data, we recommend checking the following. This will require extensive use of SmartTabs with filtering, grouping, and sorting.

  • Confirm the total number of assets and inspections match what is expected based on previous knowledge of what was sent to ITpipes for conversion.

  • Check for duplicate assets - these can be manually merged after the data is approved, however, if there are many ITpipes can do this faster behind the scenes. To check this we recommend using grouping by PSR.

  • Check for Invalid  inspections i.e. that have no observations. To check this, create a SmartTab with filter Inspections that have codes that are empty.

  • Confirm mapped length and inspection length values transferred correctly by reviewing a sampling.

We recommend parsing out a percentage of inspections that the reviewer is extremely familiar with and reviewing those in detail, including: 

  • Asset fields - confirm the data is in the correct data field, for example pipe material contains the input concrete and not 8”

  • Inspection fields - confirm the data is in the correct data field, for example Operator contains the correct entry. 

  • Observation fields -  confirm the data is in the correct data field, for example the observation code OCR is in the observation code field and not in the description field and the description field is populated with the lengthier observation description

  • Confirm snapshots associated with an inspection are correct for that asset inspection.

  • Confirm videos associated with an inspection are correct for that asset inspection.

Please keep in mind that this migration was moving the existing data into ITpipes. ITpipes does offer data scrubbing and cleaning services that take this even further and compare your inspections to GIS, fix invalid data that doesn't meet compliance standards, improves inconsistent data, merges asset or inspection records en masse, splits records, reviews and cleans up redundant data or media, and more.

    • Related Articles

    • Legacy Data Migration - what to send to ITpipes?

      Prior to starting an implementation, that includes legacy data migration, the legacy data needs provided to ITpipes and a form needs completed. The data sent to us for migration should include the following: A single database that houses all assets ...
    • Legacy Data Migration - Interim Data during Services Project or Implementation

      During an implementation or services project, often interim data needs followed up on. This is data collected or obtained between the time of the data being sent to ITpipes and the data going back to the client and/or the new system being used. There ...
    • NASSCO PACP Version Changes

      ITpipes provides PACP versions1 inside ITpipes at no additional cost to clients with an active SL/SS agreement. If our software is certified in a format, such as PACP or SPICAP, any client can receive that template. With version changes however, the ...
    • PACP Import - Continuous Defect

      Problem: Import of NASSCO PACP data gives error that data can not be imported. The NASSCO documentation on PACP requires that finishing clock positions, on a continuous defect match. The screenshots here identify the details. Solution: Correct the ...
    • Prep to complete Data Migration Form

      When a data migration is performed, it is critical we know what you expect to be migrated, therefore we require this form be completed.  During the sales process, the ITpipes representative will have provided an estimate based on discussions and a ...