Table of Contents
Purpose: This page describes data mapping from the FOLIO Courses app to Alma. During the Alma implementation phase beginning in the fall of 2023, these pages serve as working documents for decision-making about data migration. Once the migration to Alma is complete, these guides will be retained for reference.
Data Cleanup
Erin posted this on the Basecamp message board on Oct 2:
All of our instructors in FOLIO are stored as strings. It appears that in Alma, the course instructor is tied to their Alma user ID. If that's correct, what would be the recommendation to get instructor names over to Alma? Will we have to do it manually?
Some analysis of instructor names via Google Refine shows we have expected "cruft" because we did not clean up strings from Aleph. Lots of typos, differing orders, "Staff Dept" and "Staff Department", etc. etc. Erin has stored analysis in excel sheet in Box folder.
Response from Chana at EL: If you are manipulating the data already you can start adding in the primary identifiers to the data directly so it migrates. You can also try to fix the data in Folio before you extract. If it's not possible before TL, then it can be a project for Cutover. If you are not comfortable with that route, or don't have time to fix the data, you can either do it manually or through the API for courses - https://developers.exlibrisgroup.com/console/?url=/wp-content/uploads/alma/openapi/courses.json#/Courses/get%2Falmaws%2Fv1%2Fcourses. Many institutions have to do this as it's not common to use the primary ID.
Alma course object
Field name - Alma Course Object | Maps to FOLIO object (Course or Courselisting) |
---|---|
id | n/a |
code | |
name | course.name |
section | |
academic_department | course.departmentObject |
processing_department | |
terms | |
status | inactive |
visibility | UNARCHIVED |
start_date | extract from courselisting.termObject |
end_date | extract from courselisting.termObject |
weekly_hours | N/A |
participants | |
year | |
instructors | (stored in FOLIO as strings; question added to spreadsheet) |
campuses | |
searchable_ids | |
notes | |
reading_lists | link to the reading list for the course |
created_by | n/a |
created_date | n/a |
last_modified_by | n/a |
last_modified_date | n/a |
rolled_from | n/a |
submit_by_date | n/a |
FOLIO Course object
FOLIO Course |
---|
name |
sectionName |
departmentId |
description |
courseListingId |
courseListingObject |
courseNumber |
numberOfStudents |
FOLIO courselisting object
FOLIO Course listing |
---|
registrarId |
externalId |
servicepointId |
servicepointObject |
locationId |
locationObject |
termId |
termObject |
courseTypeId |
courseTypeObject |
instructorObjects |
Alma reading list object
Field name |
---|
id |
code |
name |
due_back_date |
status |
syllabus |
score |
sticker_price |
covered_by_the_library |
visibility |
publishingStatus |
order |
notes |
citations |
description |
locked |
last_modified_date |
Alma citation object
Field name |
---|
id |
status |
copyrights_status |
secondary_type |
type |
metadata |
open_url |
legaton_permalink |
file_link |
public_note |
notes |
due_date |
license_type |
visibility_start_date |
visibility_end_date |
material_visibility_start_date |
material_visibility_end_date |
sipx_doc_id |
sipx_user_price |
sipx_list_price |
sipx_funded |
sticker_price |
source1 |
source2 |
source3 |
source4….source10 |
last_modified_date |
defined_fields.attribute |
defined_fields.attribute_type |
section_info.id |
section_info.name |
section_info.description |
section_info.start_date |
section_info.visibility |
section_info.section_tags |
section_info.section_locked |
citation_tags |