FinalSite / Blackboard Mass Notification Export

Modified on Thu, May 2 at 1:44 PM

Options

Add Another Relationship (Used for Reunification Relationship)
Only include phone numbers and emails with the Broadcast flag checked
Export all locations (unchecked = primary locations only)
All staff are exported as Role Id 10
Use Alternate Role Ids - Superintendent (5), Administrator (4), Principal (6), Vice Principal (6), Supervisor (3), Director (3), Teacher (8), Staff (10)
Export only staff members with (primary/any) location from the list of locations

The file created is a CSV Delimited file using the ISO-8859-1 character set (Windows).

A row is created for each staff member (or active staff member).

Column	Sample Data	Where it comes from
organizationid	123456789	Staff's School Code, Location Code, SIS Code, or 3rd Party Export Code
teacherid	1234	Staff Id
roleid	10	Superintendent (5), Administrator (4), Principal (6), Teacher (8), Staff (10)
lastname	Zinn	Staff Last Name
firstname	Chris	Staff First Name
middlename	M	Staff Middle Name
title	Teacher	Staff Title
emailAddress1	sales@genesisedu.com	First email on the Staff Contact
emailAddress2	sales@genesisedu.com	Second email on the Staff Contact
smsNumber	973-555-1212	First mobile phone number on the Staff Contact
smsNumber2	555-555-5555	Second mobile phone number on the Staff Contact
phoneNumber	555-555-5555	First phone number on the Staff Contact
phoneNumber2	555-555-5555	Second phone number on the Staff Contact
R-contacttype	REUNIFICATION	Relationship code if Add Another Relationship is selected
R-firstname	Jane	First name of first person matching relationship code
R-lastname	Smith	Last name of first person matching relationship code
R-primaryphone	555-555-5555	First phone number of first person matching relationship code
R-primaryemail	sales@genesisedu.com	First email of first person matching relationship code