The Rave Alert SmartLoader lets you easily maintain User information in Rave Alert. SmartLoader accepts complete User files, processes them for differences, and applies any changes to Rave Alert. SmartLoader can add users, delete users, or change user information. Smartloader can be automated to help reduce effort required to keep users in sync with your database of record.
View the full specification here: Adding Users to Rave Alert.pdf
Additional information on the new "Role" column can be found here: Rave Alert July 2024 Release Notes.pdf
Creating the CSV file
Download the file here: Rave People File Template
Note:
- The first row of the CSV file is the header row, and you MUST include it in the file.
- Field names must be EXACTLY as indicated in the "Field Name" column below.
- Subsequent load files MUST contain a full set of data.
- Empty columns/missing data in the file will overwrite any existing data for that user (note exceptions in load control section below).
- The final file name MUST be "rave-people.csv" or the SmartLoader will not perform the upload.
Required Fields
|
Field Name |
Description/Notes |
|
Unique Loader ID |
Rave uses this ID to match records during updates. The value must be unique within the site for each user and must stay consistent for each user as long as the user is in the Rave Alert database |
|
First Name |
User's first name |
|
Last Name |
User's last name |
|
Registration Email Address |
User's primary email. The value must be unique within the site for each user. |
Optional Fields
| Field Name | Description/Notes |
| Mobile Phone 1 |
Primary mobile phone number. For US numbers, 10 integer digits. No special characters or country codes. Correct: 3235551234, Incorrect: +1 (323) 555-1234 For International numbers, include the + followed by number including country code |
| Site Username | User’s authentication system login value - Used for CAS authentication only |
| Role | User's Role in Alert (e.g. Domain Admin or system created Role). Roles must already exist in in your Rave Alert domain and cannot be created by the file. You can go to "System>People>Manage Role Permissions" to create roles. |
| Email Address 2 | |
| Email Address 3 | |
| Mobile Phone 2 | |
| Mobile Phone 3 | |
| Mobile 1 Voice | Option to deliver voice to mobile 1: 0 = No, 1 = Yes, null = use site default |
| Mobile 2 Voice | Option to deliver voice to mobile 2: 0 = No, 1 = Yes, null = use site default |
| Mobile 3 Voice | Option to deliver voice to mobile 3: 0 = No, 1 = Yes, null = use site default |
| Landline Phone 1 | Voice Only provider |
| Landline 1 Extension | Valid values: 0 - 9, “#” (pound) , * (asterisk) or “p” |
| Landline Phone 2 | |
| Landline 2 Extension | |
| Landline Phone 3 | |
| Landline 3 Extension | |
| Language Preference | 2 character language code. See specifications for details |
| Notify By SMS | Send text alerts to the user. |
| 0 = No, 1 = Yes, null = use site default | |
| Notify by Email | Send email alerts to the user. |
| 0 = No, 1 = Yes, null = use site default | |
| Optional Custom Attributes | Rave Alerts supports 20 string attributes, 5 integer attributes, 5 true/false attributes, and 5 date-time attributes. You can manage attributes by adding them through the loader or through the Rave Alert console. For header column layout, please see full documentation. |
Load Control
User profiles can be partially in load control if some of their fields are edited through the Rave Alert UI instead of the rave-people.csv file. For example, if a user changes their "Email Address 2" in the Rave Alert UI, SmartLoader can still update the user’s first and last name, phone number, and registration email address as specified by the load file. Data is pulled back into load control when a SmartLoader load is run and the data matches the data in the system.
Additional Related Resources
Rave SmartLoader full specifications
Connecting to the Upload Server: SFTP, WebDAV, and Mapped Drive