New WO

Data & Imports

Migration of existing fleet data and historical records from Hiperweb, and the recurring import of fuel and current mileage from WEX fueling.

Records migrated from Hiperweb

119,527

99.9% of source records

Validated by the County

119,414

113 pending review

WEX fuel transactions, 21 days

2,600

126,036 gallons · $449,194

Rows held for review

7

Unmatched card numbers or odometer outliers
Migration waves
Existing fleet data and historical records extracted from Hiperweb, converted, loaded and validated against the source system.
RFP 4.1 · 4.4.7

Active asset records

1,045 validated of 1,045

Inactive / historical asset records

1,058 validated of 1,058

Historical work orders

37,991 validated of 38,104· 113 in review

Work order labor lines

61,470 validated of 61,470

Parts inventory and transactions

14,822 validated of 14,822

Vendors, departments and code tables

412 validated of 412

Employee records and rates

15 validated of 15

Attachments and photographs

2,601 validated of 2,764· 163 in review

Overall migration progress

119,414 of 119,690 source records validated.

Transition & cutover plan
The County continues to operate Hiperweb until migrated data is validated, testing and training are complete, and the new system is approved for production.

  1. Data extraction and conversion mapping

    Complete

  2. Trial migration into the staging environment

    Complete

  3. Validation of migrated current and historical data

    Complete

  4. 4

    System configuration and testing

    In progress

  5. 5

    Employee training prior to production use

    In progress

  6. 6

    Parallel operation with Hiperweb

    Scheduled

  7. 7

    Final production cutover

    Scheduled