This video is part of a larger help page that talks about the RBS data migration process including the details of what is migrated and what is not. For more information on that please use this link. 

https://support.tbndrives.com/portal/en/kb/articles/data-migration 

Overview

This module explains how to resolve issues caused by legacy data imports from previous software systems (such as RBS). Common issues include:

• Missing or incorrect route times

• Incomplete mileage and driving hour calculations

• Misordered pickup and drop-off segments

---

1. Identifying Migrated Data Issues

Symptoms:

• Routes have no calculated miles, driving hours, or on-site time.

• Departure and arrival times are identical (often both at midnight).

• Segments show “null” locations or incorrect yard order.

These symptoms indicate incomplete or malformed data from your prior system.

---

2. Fixing Time and Mileage Calculations

Steps:

1. Open the booking in question.

2. Click the Edit Segments button.

3. For each location (e.g., pickup or drop-off):

   • Click inside the address field

   • Press the space bar

   • Google Maps will prompt a suggested location

   • Click the suggestion to re-trigger time and mileage calculations

4. Review and adjust departure times to ensure chronological order

   • Example: If departure is listed at 04:56 but should be 05:30, update it manually

5. Confirm that all times are in order and hit Save

After saving, mileage, driving hours, and total trip time will be properly updated.

---

3. Handling “Null” Pickup Locations or Improper Yard Segments

If a route segment shows:

• A null first pickup location, or

• A yard listed as both start and destination

Steps:

1. Open the booking and click Edit Segments

2. Use the arrows to reorder the segments correctly (e.g., yard → pickup → drop-off → return yard)

3. Delete duplicate or incorrect entries (e.g., extra yard stops)

4. If the issue is tied to an inactive or mismatched yard entry, use the Switch Yard feature:

   • Click Switch Yard

   • Times will auto-calculate for the corrected yard

   • You can then switch back to the correct yard listing

5. Review and confirm that all stop times are correct and in order

6. Click Save

---

4. Final Result

After following the above steps, you’ll see:

• Proper mileage and trip time calculations

• Chronologically ordered stops

• Cleaned-up routes without data gaps or duplicates

---

Best Practices

• Always double-check time sequences after reordering or editing segments

• Use Switch Yard only when migrated yard data fails to recalculate properly

• Avoid editing pricing unless necessary during time corrections

• Flag complex imports with frequent issues for data review