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 just populate your CSV file with alerts by adding relevant data in rows under each of the headers. Required fields must be included. Optional fields can be left blank or removed completely.
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 provided, a permit will be created only for the specified zone, regardless of the Permit Category's ‘Restrict to Zones’ configuration.
The zone name must exactly match a zone that exists in your organisation or this permit will be skipped.
If the ZONE field is not included, the system will check the permit category's configuration:
· If the permit category has ‘Restrict to Zones’ disabled, the permit will be created for all zones in your organization
· If the permit category has ‘Restrict to Zones’ configured, the 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 Aero Ranger Dashboard > Plate Permits > Upload CSV. 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 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.