Blackboard Connect Integration

Modified on Thu, Jun 29, 2023 at 10:04 AM

Blackboard Connect Integration

Blackboard Connect (Daily Attendance) Task

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 dailyAttendance.txt.

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

The first row in the file contains headers.

The file generates data for both Staff and Students in one file.

Column	Description	Sample
Student ID	Student Id
Attendance Phone	First phone number of Guardian 1

If using the alternate layout option:

Column	Description	Sample
ReferenceCode	Student Id
Institution	School Code of student

Logic

A record is created for each student that has an attendance daily code posted today that is flagged for use in the autodialer

There is an option to include Guardian 2 information.

There is also an option to populate the Institution field (Alternate Layout) with values from a User Text field.

Options:

Append this value to the end of the filename:
Use alternate file layout (see online help)
Only include students where User Text field (CODE) is set to (VALUE)
Populate "Institution" with this User Text field

Blackboard Connect (Staff and Students) Task

This task can export the results to:

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

File Layout (Staff and Students)

The filename is staffAndStudents.txt.

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

The first row in the file contains headers.

Student Data

All students from selected schools that have an enrollment status of ACTIVE are exported.

Columns marked with an * only appear if the options for those columns are checked-off/selected when configuring the task. You will need to do so in order to export G2 information.

Column	Description	Sample
ReferenceCode	Local Student Id	123
Institution	Student's current school name	Genesis Public Schools
FirstName	Student first name	Chris
LastName	Student last name	Zinn
Gender	Student Gender	M
PIN	Student Lunch Pin	8086
Language	Student primary language code (NJSmart Standard)	eng
Contacttype	Always the word "Student" for students (not staff)	Student
PrimaryPhone	First phone number of Guardian 1	732-521-2002
AdditionalPhone*	First phone number of Guardian 2	732-521-2002
AttendancePhone	First phone number of Guardian 1	732-521-2002
HomePhone	First phone number flagged as home/land of Guardian 1	732-521-2002
WorkPhone	First phone number flagged as work of Guardian 1	732-521-2002
Mobilephone	First phone number flagged as mobile of Guardian 1	732-521-2002
HomePhoneAlt*	First phone number flagged as home/land of Guardian 2	732-521-2002
WorkPhoneAlt*	First phone number flagged as work of Guardian 2	732-521-2002
MobilePhoneAlt*	First phone number flagged as mobile of Guardian 2	732-521-2002
SMSPhone	First phone number flagged as mobile of Guardian 1	732-521-2002
SMSPhone2*	First phone number flagged as mobile of Guardian 2	732-521-2002
EmailAddress	First email address of Guardian 1	[email protected]
EmailAddressAlt*	First email address of Guardian 2	[email protected]
EmailAddress3	Guardian 1 secondary email	[email protected]
EmailAddress4*	Guardian 2 secondary email (or student's e-mail if using option)	[email protected]
HomeAddress	Home Address of Guardian 1 (Mailing line 1 + 2 on one line)
HomeCity	City of Guardian 1
HomeState	State of Guardian 1
HomeZip	Zipcode of Guardian 1
Grade
RefreshGroup	Student's homeroom	D327
RefreshGroup	Student's AM Bus Route	B-11
RefreshGroup	Student's PM Bus Route	B-11
RefreshGroup	Special Ed Status (labeled as "Special Ed")	Special Ed
SpecEd	Special Ed Status (Y or N)	Y
ELL	Student's ELL Status (Y or N)	Y
RefreshGroup	Student's rotation group	VIRTUAL

Staff Data

Staff data is exported in the same file. All staff that are Active and not marked as Shared Teacher are exported.

Staff that do not have school assignments are always exported. Staff that do have school assignments are exported based on the selected schools.

Column	Description	Sample
ReferenceCode	Local Staff Id (Teacher ID)	123
Institution	Blank of name of first School Assignment	Genesis Public Schools
FirstName	Staff First Name	Dave
LastName	Staff last name	Sponheimer
Gender	Staff Gender	M
PIN	Always blank
Language	Language spoken by teacher (Usually blank)	spa
Contacttype	Defaults to Staff. If teacher: Teacher, If Principal: Admin If Nurse: Nurse	Admin
PrimaryPhone	Phone Number	732-555-1212
AttendancePhone	Always Blank
Mobilephone	Always Blank
EmailAddress	Staff E-mail
HomeAddress	Staff Mailing Line 1 + 2 on same line
HomeCity	City
HomeState	State
HomeZip	Zip

File Layout (Groups)

Include Groups Files (From Awards)

The Include Groups Files option produces two files. The first file groupDefinition.txt is a list of off groups setup in the SETUP → CODES list of "Activity Codes (Transcript)".

The second file groupMember.txt contains a list of all qualifying students and lists all "Activity Codes (Transcript)" they may have on the Student Data → Student ->Awards tab.

Export File Options

A record is created for each student and each staff member. There is an option to have a row for each school a staff member is in.

There are also options to...

Include Organization File
Include Groups Files (from Awards)
Include Students
Include Staff
Include row for each school a staff member is in
Exclude staff without a primary school assignment
Populate 'EmailAddressAlt' field for staff using Extra Data 1
Use school code instead of school name for 'Institution' field
Include Staff Mobile Numbers

Use this custom contact flag to determine which G2/Alternate phone numbers and emails to include (applies to Student file)
Only include phones with the this flag set in SMS Phone fields

Replace blank phone numbers with asterisks. Applies to PrimaryPhone, AdditionalPhone and AttendancePhone.
Set contact type to 'STAFF' for all staff members.
Set "PM-Bus" header to "Group".
Home Language instead of Primary Language.
Exclude Administrators.
Show only awards for the current year

Populate "Institution" with this User Text field