|
Title:
HOW TO:
Locate VINs with Duplicate Work Order Numbers
Overview:
In order to migrate FLEETMATE Standard Edition data to an Enterprise Edition
database, you will need to ensure that there are no duplicate work order numbers
in your existing Standard Edition database. The migration utility will not
migrate data if it locates any duplicate work order numbers. This document will
help you locate the asset records where duplicate work order numbers are found.
Procedure:
Start FLEETMATE Standard Edition to access your existing database. Use the File
| Database | Issue
SQL Statement... menu option to open the Issue SQL Statement
dialog. Copy and paste the SQL Statement below into the center pane of the Issue
SQL Statement dialog. Make sure that the Query Type is set to Select,
and click the Execute button for your
results.
| SQL
Statement |
SELECT [TX_VIN], [NO_ORDER] FROM Maintenance
WHERE [NO_ORDER] In (SELECT [NO_ORDER] FROM [Maintenance] As Tmp GROUP BY [NO_ORDER] HAVING Count(*)>1 ) ORDER BY [NO_ORDER]; |
Results:
For each duplicate work order number found, you will see the VIN
and the Order No from the work order, as
illustrated in the Sample Results below. You can copy/paste the results
into another application, such as NotePad so that you can print the results.
Using the VIN values in the results, you will be able to select the appropriate
asset records, locate the work orders, and edit each duplicate work order
number, making each order number unique.
In the Sample Results below, order number FM-1000191
was found three (3) times, two times for VIN 67890123456789012
and once for VIN 34567890123456789.
| Sample
Results |
Query
Start - 01/16/2009 2:39:56 PM
Rec:0000001 - 67890123456789012
FM-1000191
Rec:0000002 - 34567890123456789
FM-1000191
Rec:0000003 - 67890123456789012
FM-1000191
Query End - 01/16/2009 2:39:56 PM |
|