Plate File Format and Upload Instructions

Please follow the following instructions to prepare a plate file for upload using Microsoft Excel.

1. Select all rows/columns - Ctrl-A


2. Change font to Arial


3. Change font size to 8


4. Align Left


5. Effective Date and Expiration Date Change Format Cells - Click on Custom, select one of the options provided and then you will need to type in the highlighted field: YYYYMMDD.





6. Change all columns with your information:
   
   Column A (Plate Number) - 8 chars,
   Column B (Plate State) - 2 chars,
   Column C (Plate Type) - 3 chars,
   Column D (Effective Date) - 8 chars,
   Column E (Corp #) - 5 chars,
   Column F (Indicator) - 1 char,
   Column G (Expiration Date) - 8 chars,
   Column H (Register Last Name) - 45 chars,
   Column I (Register First Name) - 30 chars


7. Delete the Header Row - first row should be the first record.


8. Save file as space delimited - *.prn (see screen shot) - two popup messages click OK and Yes.







9. Open the .prn file using Notepad.





10. File save as *.txt format (extension)





11. Upload plate file using link Upload Plate File.


12. Check status of uploaded file using link View Upload Status.