Uploading a CSV vehicle alert list via FTPS

Create multiple alerts at once with a CSV file uploaded via FTPS

Written by John

Updated 1 year 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?