Advice and answers from the Regroup Mass Notification Team

Our integration with Colleague enables Regroup to synchronize with directory information so that the groups are always up-to-date regardless of whether students have entered or left the system. We do this via scripts on the Colleague side that export a .csv file on a regular basis (e.g. nightly) and upload them to Regroup's secure FTP. Regroup then syncs its database with the new information.

The process:

1. We will create a Secure FTP for the client to upload files

2. CSV files are generated from the database. Sample fields below:

a. FirstName, LastName, Email#1;Email#2;Email#3, UserId, Phone#1|Carrier; Phone#2|Carrier; Phone#3|Carrier, GroupName#1; GroupName#2; GroupName#3

Please see the topic on Database Integration under "Regroup Optional Features" for more information on fields that can be added to the .csv.

b. Note: Emails added to the system will default to receive emails from groups, and Phone #s added to the system will default to receive both text and voice messages.

3. CSV files are set to upload to Regroup's FTP on a regular basis, sample file name below:

a. <Network-coded-name>-<current date>_<number of upload>.csv

4. Regroup receives the file

5. File is automatically processed and members are added to groups

6. Confirmation email sent to network administrators communicating successful upload

Automated Datatel Uploads

1.  We will create a Secure FTP for the client to upload files

2. The client generates CSV files from Colleague, sample fields below:

a.FirstName, LastName, Email#1;Email#2;Email#3, UserId, Phone#1|Carrier; Phone#2|Carrier; Phone#3|Carrier, GroupName#1; GroupName#2; GroupName#3

b.Note: Emails added to the system will default to receive emails from groups, and Phone #s added to the system will default to receive both text and voice messages.

3. Client automates scripts to upload files to Regroup, sample file name below:

a. <Network-coded-name>-<current date>_<number of upload>.csv

4. Regroup receives the file

5. File is automatically processed and members are added to groups

6. Confirmation email sent to network administrators communicating successful upload

Did this answer your question?