Versions Compared

Version Old Version 3 New Version Current
Changes made by

Elizabeth Storrs

Elizabeth Storrs

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties
idrequest-details

Slate Instance

TUV

Requestor

Maddy Yardumian

Date

Status

Status
colourBlueGreen
titlePENDINGCOMPLETE

Summary Description

Build out a view in to VMCAS Prereq data

...

Maddy would like to see the DVM prerequisite data in the new format used in the Slate hosted applications.Research:

Prerequisite update and transition to entities

Should just be a matter of copying courses portal and changing the queries to look for the entity fields. Even if pre-req data is required for reading, we can just do a single download of pre-req data in October, [until we find the work around for the lack of unique identifiers on the data that would allow for matching].

Research:

https://help.liaisonedu.com/WebAdMIT_Help_Center/WebAdMIT_Manual/Extracting_Data_from_WebAdMIT/Working_with_SFTP_Features

Prerequisite update and transition to entities

In VMCAS, there are canned (uneditable) report for Prerequisites, and for Coursework - coursework report is ALL courses; we need the Prerequisite report. There is no custom way to get this data out--the report is it.

Expand
titleSetting up SFTP destination subfolders

In TUSMGP

...

  • Get on the VPN

  • Using Filezilla, log into Vet with personal (not Liaison Service) account

  • in the ‘remote site’ section, drill down into the incoming folder

  • right click to be given the option to create a directory

  • best practice: mirror syntax/organizational structure used for TUSMGP’s imports

image-20241219-154039.pngImage Added

In 2023 when the entity was created, the Criterion name was set as a free text field. This had to be inactivated, and a new Criterion Name field linked to the same course_type prompt added.

The problem of bringing pre-req data over on a ongoing basis and not having it just create new rows was addressed by Helen in TUP Prerequisite Course Data missing; to align with that, I inactivated the old Designation field and added a new one that is unique for merging (-u suffix in name).

Tweaked the formatting, added portal to Reader in ‘testing’ visibility.

At the end, when trying to sort out order, I see that the PreReqs term field is not prompts, but free text, which makes sorting a bear. Leaned into getting this to the school; if it is terrible for them, can fix it at some future point.

Outcome:

https://help.liaisonedu.com/Integration/WebAdMIT

Prerequisites for SFTP Delivery has been created in the Report manager in WebAdmit; I uploaded that .csv file to the WebAdMIT API - VMCAS Prerequisite Courses as a starting point for mapping.

English wasn't mapped properly, so I uploaded those again, matching on Designator. Need to find a way to review for duplication if we are ever going to move to an SFTP process.

Portal visibility set to ‘testing' only’; send to Rebecca and Maddy.