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 Rave SmartLoader specification attached below.
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 MUST be included in the file.
- At a minimum, the header row must contain the four required fields in the table below, plus any optional fields listed in the table below that you want to include.
- Field Names must be EXACTLY as indicated in the "Field Name" column below, including spaces, underscores, etc.
- Included fields in the .csv can be in any order.
- 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. |
Importing the CSV data file
Your completed csv file can be loaded into the system one of two ways: if you have a SmartLoader automation, you can simply drop the file in the WebDAV or SFTP folder that you set up during your implementation. The automation will pull the file into the system at the specified time.
If you do not have automation set up, upload the file to your WebDAV or SFTP folder and manually click on the "Run Smart Loader" button on the SmartLoader page.
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.
Next Steps
You are now ready to upload your file. Visit the following article for instructions: Connecting to the Upload Server: SFTP, WebDAV, and Mapped Drive.