To create multiple Plate Permits at once with a CSV file uploaded via SFTP, please make sure to prepare your CSV file based on the template file (download button below) and connect via your preferred FTP client with the following details before uploading your CSV file.
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. Required fields must be included. Optional fields can be left blank or removed completely.
Please find an example Permit CSV upload file here:
PLATE
Required field.
e.g. 1ABC123
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 left blank, 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.
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.