Uploading a CSV vehicle alert list

Create multiple alerts at once by uploading a CSV list.
Written by John
Updated 7 months ago

Click the link below to download the CSV Alert List template, and populate the template with a list of number plates and associated alert data.

Download CSV Template

The CSV file includes a header for the Alert Category - you can specify an Alert Category that you have already created within the Aero Ranger Dashboard, or you can enter the name of a new one here and it will be automatically generated and new alerts assigned to that category.

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.

If you don't follow the above instructions you may receive a 'Request Failed' error.

Get in touch with the Aero Ranger team at [email protected] if you need any help formatting your CSV file.

Save your new alert list CSV file with a unique filename. If you wish to overwrite (delete) alerts previously uploaded via the Upload CSV method, give your new CSV file the same filename as the file previously uploaded and alerts created with the previous CSV file upload will be deleted.

Once uploaded, the Aero Ranger Cloud creates an alert for each of the alert items included in the CSV list.

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?