How to correct data for Texas DPS upload

The Texas DPS data upload will reject the entire file if any data fails validation. For this reason, we recommend uploading data for one business day at a time. The validation process will provide a list of invalid records. Each item of bad data will have an item number and a failure reason. The item number is used to identify the specific ticket that contains the invalid data. The invalid data for each item must be corrected in Scrap Dragon and the entire export & upload process will have to be repeated. The data problems can be corrected as follows:

Open the XML Upload File

  1. Open the xml upload file using either notepad or xml editor.
  2. The xml file consists of individual transactions for each ticket line.
  3. Each data field is identified by a label enclosed in brackets < >
  4. The item number is contained in an xml field named
  5. To find a specific item, use the editor find feature to search for the string ‘ks>n’ where n is the item number (do not include the quotes). For example, to find item 12 you would search for ks>12
  6. Once you are on the correct item number, look up a few lines for the xml field this will be the Scrap Dragon ticket number.
  7. Also look for the invalid data as described in the failure reason on the Texas DPS web site.
  8. You can minimize this file but keep it open as you work through all of the data problems.

Edit Scrap Dragon Data

  1. If the ticket has not been paid, then it can be reopened and repaired in scrap buying from the view closed list.
  2. If the ticket has already been paid, then it can be edited and repaired using Edit Paid Ticket. To access this screen, either use the View Paid list in scrap buying or use the Edit Paid Ticket option from the User Menu.
  3. If the issue is with the delivery vehicle, then make sure to change the data in the ticket and in the customer’s file.
  4. If the issue is with the customer data, then make the corrections using the Customer Master file Maintenance of use the Edit Customer button in Edit Paid Ticket.

When all of the corrections have been made in Scrap Dragon, close the xml file and run the Export – Texas DPS process again and upload the resulting xml file to the Texas DPS web site.

Related Articles:
Uploading the Texas DPS Report
Preparing Scrap Dragon for Texas DPS Report Upload

Leave a Reply

Your email address will not be published. Required fields are marked *