Skip to main content

Upload a CSV Alert List (Hotlist)

Ashleigh Byrne avatar
Written by Ashleigh Byrne
Updated over a week ago



To create multiple Plate Alerts at once with a CSV file uploaded via FTPS, 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.

PLATE

Required field.

1ABC123

STATE

Optional field.

WA

VEHICLE_MAKE

Optional field.

Toyota

VEHICLE_COLOUR

Optional field.

Blue

VEHICLE_YEAR

Optional field.

2010

VALID_FROM

Optional field.

2025-01-01T00:00:00.000Z

Optional date representing the date & time which the alert will become valid and active within the Aero Ranger system. If no date is supplied, alert will be set as active immediately after creation. Must be in ISO 8601 Date format, with UTC+0 timezone.

VALID_TO

Optional field.

2026-12-31T23:59:59.000Z

Optional date representing the date & time which the alert will expire and no longer be active within the Aero Ranger system. If no date is supplied, the system defaults to an expiry time of 30 days from alert creation. Must be in ISO 8601 Date format, with UTC+0 timezone.

ALERT_MESSAGE

Optional field.

Vehicle of interest

When the vehicle is detected, this message will be displayed in alert notification emails and read aloud on the Aero Ranger app.

CATEGORY_NAME

Required field.

Stolen Vehicle

Choose a category name which corresponds to an Alert Category that already exists, otherwise a new Alert Category will be created with the entered name.

IN_VEHICLE_NOTIFY

Optional field.

YES

Enter 'YES' to receive in-vehicle notifications from an EdgeAI device via the Aero Ranger app, or 'NO' to ignore alerts for this vehicle in the app.


EMAIL_NOTIFY
Optional field.

YES

Enter 'YES' to receive email notifications when this plate is scanned, or 'NO' to ignore alerts for this vehicle via email.

EMAIL

Optional field.

Leave this field blank if you don't want to receive email notifications for this alert, otherwise enter multiple email addresses separated by semicolons ';' to designate email notification recipients.

Before you upload a CSV file check that:

  • Each alert includes a value for the 'PLATE' heading

  • Each alert includes a value for the 'ALERT_CATEGORY' heading

  • No special characters are included under any heading except for 'ALERT_MESSAGE'

  • 'YEAR' value is not less than 1900 (leave blank for unknown)

  • No empty lines are included in the file

'PLATE' and 'ALERT_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.

  • 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_alert_csvs'. Please ensure all CSV files are uploaded into this subfolder or they will not be processed.

Depending on the total number of alerts in your CSV file, this may take several minutes to be reflected in your Aero Ranger Dashboard.

To delete all of the alerts created via a CSV upload (or a bulk alert creation from the Plate Search page), use the 'CSV Delete' button on the Plate Alerts 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?