Introduction
Using the Import Manager for payment will give you the ability to bulk import payments directly into the system. This article will give you an overview of how to setup the import and how to configure it for different requirements.
Creating the Import File
The attached file provides the template format for the file and headings required to successfully import into the system.
Below is a list of all the headers than you can include on the spreadsheet:
Feild Name | Mandatory? | Description |
pcn ref | Yes | Any payment import added onto hub require you to include the PCN reference. This is how the import knows where to allocate the Payment.
|
paid date | Yes | All payment imports require a paid date. This is when the payment for the PCN was made. |
amount paid | Yes | The remaining field is the amount which had been paid against the PCN. This may not be the whole payment of the notice, in instances where you're facilitating an installment plan. You may also have a negative figure in here, to facilitate a refund. |
Please ensure the import file is formatted as a .csv (Comma Delimited) file.
Importing the File
Log into Tickit Hub and navigate to Parking Charge Management > Import Manager and then from within the Import Manager screen press Add. Complete the fields as per below.
The Import Reference & Name fields can use a naming convention of your choosing. - Attempt to Allocate Payment - if this option is selected, when the live import is processed the system will attempt to allocate the payment to the PCN. Leaving this plant will require you to manually allocate each payment after the import is processed.
- Check Reference Before Import - as the name suggests, if selected, the system will check the PCN reference you have included on the import file before attempting to allocate the payment.
- Test/ Live Import - This allows you to run the import as a test before you update the system. This is useful to see if you have any discrepancies in your spreadsheet that you may not have picked up on when formatting it. You will be displayed errors to notify you of this. Once you are happy to import it, then you can change this to Live, or select Live in the first instance. Once the Live import has been run, the system will be updated with the new PCN payments. This CANNOT be undone, so ensure you are happy with the PCN payments before making this live.
Once all of the above has been entered, press Add (At this point the file has been placed in a the queue).
Processing the File
Back within Utilities > Import Manager you’ll notice the import has been added (highlighted in blue) and the status set to NEW.
Press Import (page icon with an up arrow in the Action column), then acknowledge the accompanying confirmation message, at which point you will notice the row change from blue to yellow and the Status change to PENDING. At this stage the import is now waiting to be processed by the batch job.
Once the batch job has run, you’ll notice that the status of the import has changed to COMPLETED.
You can view the PCNs that have had payments imported by pressing List Items (list icon in the Action column).
If after the import has been processed by the system you are presented with an error, please list the items in the bacth (as above) and this will provide you with more information on why the error occurred for each item, and should give you an idea how how to rectify it.
Validating the PCN Payments
Navigate to PCN Admin > List PCNs, search for the required PCN. Select the PCN and navigate to the Charges and Payments tab, where you’ll be able to see Total Payments and Balance fields have been updated based on the values entered in the import file.
- If the payment is for the full amount owed, the PCN status will change to PAID IN FULL
- If the payment is for part of the amount owed, the PCN status will change to ISSUED - PARTIAL PAYMENT