Blackboard Mass Notification

Modified on Tue, Oct 17, 2023 at 4:07 PM

Blackboard Mass Notification

This task can export the results to:

Secure FTP (SFTP)
FTP (Both Active and Passive)
Email
Directory on the Genesis Server

File Layout

The filename is organizations.csv.

The file generated is a COMMA delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

Column	Description	Sample
organizationid	School Code
name	School Name
type	School Type Code
address1	Address 1
address2	Address 2
city	City
state	State
zip	Zipcode
phoneNumber	Office Phone
faxNumber	Office Fax
emailAddress	School Email
url	School URL

File Layout

The filename is students.csv.

The file generated is a COMMA delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

Column	Description	Sample
organizationid	School Code
studentid	Student ID
lastName	Last Name
firstName	First Name
middleName	Middle Name
birthDate	Birth Date
gender	Gender
gradeLevel	Grade Level
gradYear	Graduation Year
preferredLanguage1ID	Home or Primary Language Code
address1	Mailing Line 1
address2	Mailing Line 2
city	City
state	State
zip	Zipcode
emailAddress1	Primary Email
phoneNumber	Primary Phone
mobilephoneNumber	Cell Number
otherphoneNumber	Home Number
AM busID	AM Bus Route Code
PM busID	PM Bus Route Code

The filename is parents.csv.

The file generated is a COMMA delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

File contains student's guardians who do NOT have an "Individual Contact Custody Permissions" set to NO.

Column	Description	Sample
organizationid	School Code
studentid	Student ID
parentid	Parent ID
lastName	Last Name
firstName	First Name
middleName	Middle Name
title	Contact Prefix
preferredLanguage1ID	Home or Primary Language Code
address1	Mailing Line 1
address2	Mailing Line 2
city	City
state	State
zip	Zipcode
emailAddress1	Primary Email
emailAddress2	Second email
phoneNumber	Primary Phone
workphoneNumber	Work Number
mobilephoneNumber	Home Number

The filename is staff.csv.

The file generated is a COMMA delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

Column	Description	Sample
organizationid	School Code
teacher	Teacher ID
lastName	Last Name
firstName	First Name
middleName	Middle Name
title	Contact Prefix
gender	Gender
address1	Mailing Line 1
address2	Mailing Line 2
city	City
state	State
zip	Zipcode
emailAddress1	Address1
phoneNumber	Primary Phone
mobilephoneNumber	Home Number

The filename is languageCodes.csv.

The file generated is a COMMA delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

Column	Description	Sample
language	Language Description
languageCode	Language Code

The filename is todaysAttendance.csv.

The file generated is a COMMA delimited file using the standard ISO-8859-1 characters.

The first row in the file contains headers.

Dailies marked with DNC will not be included. Other codes included based on options set.

Column	Description	Sample
organizationid	School Code	GHS
studentid	Student ID
date	Date of File	01/01/20
category	"tardy" or "absent"
description	Attendance Code Description	Unexcused Absent

Optional Files:

terms.csv

Column	Description	Sample
organizationid
termid
name
startDate
endDate
track

courses.csv

Column	Description	Sample
organizationid
courseid
name
subject
description
credit

sections.csv

Column	Description	Sample
organizationid
sectionid
courseid
period
number
teacherid
room
url
termid

schedules.csv

Column	Description	Sample
organizationid
studentid
sectionid
startDate
endDate

lunchBalance.csv

Column	Description	Sample
organizationid
studentid
balance
mealType

busRouteCodes.csv

Column	Description	Sample
organizationid
studentid
busid

groupDefinition.csv (athletics)

Column	Description	Sample
organizationid
accountID
accounttype
groupdefinitionid

groupMember.csv

Column	Description	Sample
organizationid
groupdefinitionid
name