To create multiple plate permits at once with a CSV file, make sure to prepare your CSV file based on the template file (use the link below).
You can populate your CSV file with permits by adding relevant data in rows under each of the headers. Headers and other fields marked as required must be included otherwise the file will be rejected. Optional fields should be removed completely if not being used.
Below is a list of the fields available and their functionalities.
PLATE
Required field.
e.g. ABC123
PERMIT_CATEGORY
Required field.
e.g. Staff Parking
Choose a permit category name which corresponds to a permit category that already exists in your organisation. If the Permit Category does not already exist, no permits will be created.
ZONE
Optional field.
e.g. Zone A
If a zone name is specified in this field a plate permit will be created for this one zone only. Additional rows will then be required to allocate the plate to more zones. If the Permit Category has ‘Restrict to Zones’ activated the specified zone must be included in this restricted list for the permit to upload successfully.
The specified zone name must also exactly match a zone that exists in your organisation or this permit will be skipped.
If the ZONE field is left blank, the system will check the permit category's configuration and upload in one of the following ways:
If the permit category has ‘Restrict to Zones’ disabled, a plate permit will be created and linked to all zones in your organisation
If the permit category has ‘Restrict to Zones’ configured, a plate permit will be created for the restricted zones only.
STATE
Optional field.
e.g. NSW
VEHICLE_MAKE
Optional field.
e.g. Toyota
VEHICLE_MODEL
Optional field.
e.g. Corolla
VEHICLE_COLOUR
Optional field.
e.g. Blue
VEHICLE_YEAR
Optional field.
e.g. 2010
VALID_FROM
Optional field.
2022-03-16T06:02:12+0000
Optional date representing when the permit will become valid and active within the Aero Ranger system. If no date is supplied, the permit will be set as active immediately after creation. Must be in ISO 8601 Date format, with UTC+0 timezone.
VALID_TO
Optional field.
2028-04-16T06:02:12+0000
Optional date representing when the permit will expire and no longer be active within the Aero Ranger system. If no date is supplied, the system defaults to no expiry date.
Must be in ISO 8601 Date format, with UTC+0 timezone.
Before you upload a CSV file check that:
· Each permit includes a value for the 'PLATE' heading
· Each permit includes a value for the 'PERMIT_CATEGORY' heading
· Zone names and permit category match exactly what's in Aero Ranger Dashboard (case-insensitive)
· No special characters are included under any heading
· 'YEAR' value is not less than 1900 (leave blank for unknown)
· No empty lines are included in the file
'PLATE' and 'PERMIT_CATEGORY' are the only compulsory fields. Fields under other headings are optional and can be left blank or removed completely.
There are two ways to upload permit CSV files into Aero Ranger.
The preferred method is uploading via the "Plate Permits" page. Click into the "Upload CSV" field and select your file. It will be automatically uploaded and processed.
Advanced users may consider using SFTP to upload a permit CSV. This is useful if you are going to use automation to upload a CSV periodically.
If you are uploading via FTP, please ensure your FTP client supports SFTP - we suggest using FileZilla.
FTP Connection Details
Protocol: SFTP
FTP address: sftp.api-aeroranger.com
Username: [Your Aero Ranger account email]
Password: [Your Aero Ranger account password]
Once connected, you will see a subfolder labeled 'bulk_permit_csvs'.
Please ensure all CSV files are uploaded into this subfolder or they will not be processed. Depending on the total number of permits in your CSV file, this may take several minutes to be reflected in your Aero Ranger Dashboard.
To delete all of the permits created via a CSV upload, use the 'CSV Delete' button on the "Plate Permits" page.
Alternatively, you can simply upload an empty CSV file with the same filename as the CSV file previously uploaded, following the same instructions above.
Uploading a CSV with the same file name as a previous upload will compare the files, delete plates that aren't on the new CSV file, and create new entries for any plates added to the new CSV file.