PT> Utilities> Import/Export Parking Tickets

Import and Export Parking Tickets

 

Summary

 

The PT Import and Export Parking Ticket windows allow you to import citations from a PDA or export citations to create a tow list. Follow this process to import parking tickets or create the export files.

 

Related Links

 

Click here for information on import file layouts.

Click here for information on Status Maintenance.

 

Step by Step

 

1     Import parking tickets. 

 

  • Open the Import Parking Tickets window (PT> Utilities> Import Parking Tickets).
  • Enter a File Name path or click the field label to browse to the import file.
    • The import file must be in comma-separated value (.csv) format.
    • Click the Display icon to display the expected .csv file layout.
      • The expected import will include the Record Type, Citation Number, Citation Date/Time, Vehicle Tag Number, Tag State, Tag Expiration Date, Vehicle Make, Model and Color, Citation Location, and Officer Badge Number as separate columns on the .csv spreadsheet.
      • Click here for information on import file layouts.
  • Enter the Status that the imported parking tickets will be assigned.
  • Click the Confirm icon to import the parking tickets.

 

2     Export parking tickets files. 

 

  • Open the Export Parking Tickets window (PT> Utilities> Export Parking Tickets).
  • Select each Status that you would like to include in the export file. 
    • Click the Select All or Deselect All icon to select or deselect all of the displayed statuses. All statuses are selected by default.
    • Statuses are created and maintained on the Status Maintenance window (PT> Maintenance> Status).
  • The Waiting Period field is used to specify a waiting period for any excessive tickets you would like to include in the export.
    • For example, enter 30 if you would like the tow list to include any vehicles that have been in excessive ticket status for over 30 days. Any vehicles in excessive ticket status for less than 30 days would not be included in the export file.
  • Check the Include all excessive tickets toggle to include all the excessive tickets in the system in the export files.
    • Checking this toggle will override the Waiting Period specified above.
  • Click the Confirm icon to generate the .dat export files.
  • Once the export has finished processing, the Export Settings window will open. This window is used to specify the export path for the violations, locations and tow list for the exported tickets.
    • The Violations .dat export file includes the fee details associated with the included citations. These details include the fee identification number, the fee code, the fixed amount of the fee, and the late fees associated with the fee.
    • The Locations .dat export file includes the location details associated with the included citations. These details include the location identification number, the location code, and the location description.
    • The Tow List .dat export file includes the vehicle tag details associated with the included citations. These details include the vehicle tag number and tag state.
  • Check the Open toggles if you would like to open the exported files after they are saved locally.
  • Enter the export path locations and click the Save icon to export the files to the local paths.