What is SFTP used for?

• The SFTP allows secure data exchange of a live course/section roster, and live student enrollment data
• BibliU uses this integration to automatically check for additional classes/sections as they are added throughout the semester that affect Access Program implementation.
• BibliU uses this integration to make sure that students enrolled in a particular Access Program class will be provided for.
• The institution sets up an automated data pull from their SIS system into CSV files, which are sent to BibliU daily via the SFTP feed.
   
  • File 1 = ‘CourseSchedule’: list of all classes, including added and cancelled classes, as per the Course Schedule Template
  • File 2 = ‘CourseEnrollment’: list of all students enrolled in each class, as per the Enrollment Data Template

• Please see the details below on exact formatting requirements for each of these files. Note that without the correct formatting there may be issues that block student access, so this is very important.

SFTP integration steps 

1. BibliU identify the Institution’s technical point of contact for SFTP Integration at the Integration & technical set up meeting
2. BibliU and the technical contact decide on the steps needed at the Kick-off meeting
3. SFTP connection details are shared with BibliU by the technical contact
4. The automated data pull is set up by the institution
   1. File 1 = ‘Course/Section Roster’
   2. File 2 = ‘Course Enrollment’:
5. SFTP integration is tested to check that the CSV files are received by BibliU in the correct format and include all the necessary data fields, at the Integrations check-in meeting

Course Schedule File Specification

The table below presents the default column names and values supported by the course management service.

Supported Date Formats

We prefer ISO dates which are unambiguous; however, the enrollment service does support US date formats. Examples of acceptable date formats include:

1. `2025-04-01` 

2. `2025/04/01` 

3. `01/03/2025` 

4. `01-03-2025` 

Note that numbers 3-4 would be interpreted as the US date of **January 3rd, 2025** and _not_ the UK interpretation of **March 1st, 2025**.

Supported File Formats

The enrollment service only supports CSVs encoded using UTF-8.

Additional Behaviour

When a course is removed from the CSV then it is treated as cancelled and removed from our system.

Enrollment File Specification

The table below presents the default column names and values supported by the enrollment service. 

Please note in particular that students who have opted out of a course should NOT be deleted from the Enrollment File. Instead, please set this up so that students who have opted out/aren’t taking a class are marked as ‘inactive’. This is to ensure that students are not wrongly included for Billing purposes.

 

Supported Date Formats

We prefer ISO dates which are unambiguous; however, the enrollment service does support US date formats. Examples of acceptable date formats include:

1. `2025-04-01` 

2. `2025/04/01` 

3. `2025.04.01` 

4. `01/03/2025` 

5. `01-03-2025` 

6. `01.03.2025` 

Note that numbers 4-6 would be interpreted as the US date of **January 3rd, 2025** and _not_ the UK interpretation of **March 1st, 2025**.

Supported File Formats

The enrollment service only supports CSVs encoded using UTF-8.

SFTP Credentials

The username and password will be sent directly to the technical contact at your institution via an encrypted link at the right time.

 

SFTP Endpoint: sftp://files.bibliu.com

Port number: 22

Once you have uploaded the initial files for us, please let us know so we may check that the files work correctly with our database and make any necessary changes.