Extracting Student Journal data from Blackboard

Blackboard Journal ExportAt St. Edward’s University, a faculty member requested to extract student journal entries from Blackboard. After contacting Blackboard support and researching online, we were unable to find a simple solution to this issue. Our instructional technology staff then discovered a method to retrieve this data by parsing Blackboard data files found in the course archive. Special thanks to Ling Chen who found the journal entries embedded in an archived XML data file.

We were able to extract the student journal entries into an Excel file for the faculty member. Here are the instructions if others are interested in gaining access to the student journal entries.

Getting the XML file of student journal entries

  1. Archive your Blackboard course
  2. Open the zip file of the archive
  3. Look for the data file “res00013.dat” (this might be a different file name for you)

Parsing the XML file into Excel

Once the XML file is identified, the data can be parsed. I wrote a quick XML parser in the ColdFusion markup language to extract the XML, strip out the HTML tags(via a regular expression) and organize the data into an HTML table. That HTML table can then be copied and pasted into an excel file. There are likely more elegant solutions (via C, PHP or VB), but CFML was handy for us. Here is the file with the CFML and file directory structure: BbXMLParserCFML

Using our code to parse your own XML file

If you’d like to run this code on your own computer.

  1. Download a copy of ColdFusion server (free single seat license called a Developers License).
  2. Copy the “index.cfm” and the data folder to the wwwroot folder.
  3. Move the “res00013.dat file into the “data” folder and change the file extension from “.dat” to “.xml”
  4. change the data referenced in the <CFSET> tag to your XML file path.
  5. load the index.cfm page in your web browser.
  6. copy the HTML output into a blank Excel file.


As an FYI, here is the XML DOM for the Blackboard student journal file

XML meta data for Blackboard Student Journal

Effective Strategies for Online Disscussions in Your Course

Planning Your Online Course v2 -Giulia ForsytheOnline discussions can serve as a great opportunity for your students to reflect on the ideas presented in your course and allow them a safe place for challenging academic discourse. This blog post shares a few starting points for thinking about the format of your discussions, the roles students can play in the discussion space, and ways you can assess and incorporate the online discussions back into your face-to-face class. Illustration by Giulia Forsythe

Continue reading

Integrating Digital Material from the Library into your Course

8137660881_846c3012f6_qInspired by this Friday’s presentation “Killing the Course Pack: New Methods for Providing Access to Course Readings” co-sponsored by The Center for Teaching Excellence, Instructional Technology and the Munday Library, we wanted to share some information to assist you in integrating digital supplemental course material (and course reserves) into your Canvas or Blackboard course. Photo Credit: Mariusz Kluzniak’s Lincoln’s Inn Library. Continue reading

Higher Ed Highlights from SXSWEdu

In March, Austin hosted the fifth annual SXSWEdu, the education-focused sibling to SXSW’s larger Interactive, Music and Film festivals. SXSWEdu brings together researchers and practitioners to discuss innovative solutions to pressing issues facing higher education as well as K-12.

SXSWEduSt. Edward’s was well represented with faculty presenting in two sessions. Professors Corinne Weisgerber and Shannan Butler provoked one of the more spirited debates at the conference in their session “Disrupting the Disruption in Higher Education”. Continue reading