Uploading a CSV vehicle alert list via FTPS

Create multiple alerts at once with a CSV file uploaded via FTPS
Written by John
Updated 6 months ago

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

Click here to download the CSV vehicle alert template.

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.

Header name

Required?

Example data

Notes

PLATE

Required field.

1ABC123

VEHICLE_MAKE

Optional field.

Toyota

VEHICLE_MODEL

Optional field.

Camry

VEHICLE_COLOUR

Optional field.

Blue

VEHICLE_YEAR

Optional field.

2010

ALERT_MESSAGE

Optional field.

This vehicle's parking has expired

This message will be displayed in alert notification emails and read aloud on the Edge Companion app when the vehicle is detected.

CATEGORY_NAME

Required field.

Parking Expired

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 Edge Companion app, or 'NO' to ignore alerts for this vehicle in the app.

EMAIL

Optional field.

[email protected]; [email protected]

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.

VALID_FROM

Optional field.

2022-03-16T06:02:12+0000

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

2022-04-16T06:02:12+0000

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.

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 FTPS - we suggest using FileZilla.

  • Protocol: FTP with TLS/SSL
  • Encryption: Explicit FTP over TLS
  • FTP address: ftps.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?