Skip to main content
Upload a CSV Permit List
Alex Tate avatar
Written by Alex Tate
Updated over a month ago

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.

Did this answer your question?