This guide goes over the steps required to import a .CSV file for the License Plate Database of a Speco Blue Recorder
- Click the Hamburger menu ☰ icon in the top-right corner and select the option for Intelligent Analytics.
-
- This will open the Intelligent Analytics search function.
- At the top of the Intelligent Analytics Search page, there is an option called Sample Database. Please select Sample Database.
- From the Sample Database page, select the Plate option on the left side of the screen.
- On the bottom of this screen, click Add Group to create the group for your license plates.
- On the menu that appears, make sure to name the plate group and click OK
- If you already have a database group setup, skip the above step.
- Once a plate group has been created, or if there is one created already, click and highlight the group, and then click the Import and Export button on the bottom right of the screen.
- For the next step, there must be a USB Flash Drive that is formatted as a FAT32 format with the desired file on it, plugged into a USB port into the recorder.
- If there is not one inserted, insert one now, and after inserting the USB Flash Drive, select the Refresh button to have the recorder recognize it if the Import and page is already up.
- NOTE: When importing your database file out of Microsoft Excel, make sure it is .CSV with UTF-8 format
- If there is not one inserted, insert one now, and after inserting the USB Flash Drive, select the Refresh button to have the recorder recognize it if the Import and page is already up.
- The Import and Export page will automatically pull up the USB Flash Drive and its contents.
- Click on the desired file, then click Import and the entries in the file will be imported into your database group.
In case this is unsuccessful....
- For details on how the information in the spreadsheet needs to be laid out, click on Plate Information Description to see the fields needed for a successful upload.
Initial submission Date: August 13, 2024
Article Authored by: Christopher Cataldo