Issue:
TUSMGP requested a change to the CNAME/sub-domain for their database (from phpd.admissions.tufts.edu to tusmgp.admissions.tufts.edu) When this change went into effect on 8/25/2023, the CAS/Liaison service account username was also changed in their instance of Slate (from liaison_service@phpd.admissions.tufts.edu to liaison_service@tusmgp.admissions.tufts.edu). This caused the existing API subscriptions to fail and data to stop importing between the CAS and Slate.
Solution:
Existing API subscriptions were deleted, the subscription configurations updated with the correct email address for the sftpUser, the subscriptions re-created, and then replays made for each subscription to cover time between when the files stopped sending (roughly 8/25/2023 at 4:45 PM EST) to when each subscription was restarted.
Re-created subscriptions for In Progress (program selected) applications first, immediately ran a replay for each. This was necessary because if a record came over in a subsequent subscription data file before it came through the In Progress file, an application record would not exist in Slate and it would not update properly. The In Progress data subscription is what creates the application for the record.
DPT-SEA
| Expand |
|---|
| title | In Progress Subscription |
|---|
|
| Code Block |
|---|
{
"subscription": {
"id": 8014,
"notificationEmailAddress": "tts-slate-team@elist.tufts.edu",
"expirationDate": "2025-08-28",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"userLevel": "institution",
"disabled": false,
"createdDate": "2023-08-29 17:16:24",
"updatedDate": "2023-08-29 17:16:24",
"subscriptionDetails": [
{
"id": 48215,
"event": "application.program.selected",
"responseType": "fullResponse",
"responseLevel": "program",
"responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
"destinationType": "SFTP",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"apiVersion": "v2",
"disabled": false,
"createdDate": "2023-08-29 17:16:24",
"updatedDate": "2023-08-29 17:16:24",
"sftpDestination": {
"id": 12073,
"sftpHost": "ft.technolutions.net",
"sftpPort": 22,
"sftpBaseDirectory": "/incoming/liaison/PTCAS/data/",
"sftpPathTemplate": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
"sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
"sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"createdDate": "2023-08-29 17:16:24",
"updatedDate": "2023-08-29 17:16:24"
}
}
]
}
} |
|
| Expand |
|---|
|
| Code Block |
|---|
{
"replay": {
"id": 8232,
"status": "PENDING",
"fromDate": "2023-08-25 17:45:00",
"toDate": "2023-08-29 17:00:00",
"createdDate": "2023-08-29 17:17:11",
"updatedDate": "2023-08-29 17:17:11",
"subscription": {
"subscriptionId": 8014
}
}
} |
|
DPT-PHX
| Expand |
|---|
| title | In Progress Subscription |
|---|
|
| Code Block |
|---|
{
"subscription": {
"id": 8015,
"notificationEmailAddress": "tts-slate-team@elist.tufts.edu",
"expirationDate": "2025-08-28",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"userLevel": "institution",
"disabled": false,
"createdDate": "2023-08-29 17:38:24",
"updatedDate": "2023-08-29 17:38:24",
"subscriptionDetails": [
{
"id": 48216,
"event": "application.program.selected",
"responseType": "fullResponse",
"responseLevel": "program",
"responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
"destinationType": "SFTP",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"apiVersion": "v2",
"disabled": false,
"createdDate": "2023-08-29 17:38:24",
"updatedDate": "2023-08-29 17:38:24",
"sftpDestination": {
"id": 12074,
"sftpHost": "ft.technolutions.net",
"sftpPort": 22,
"sftpBaseDirectory": "/incoming/liaison/PTCAS/data/",
"sftpPathTemplate": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
"sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
"sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"createdDate": "2023-08-29 17:38:24",
"updatedDate": "2023-08-29 17:38:24"
}
}
]
}
} |
|
| Expand |
|---|
|
| Code Block |
|---|
{
"replay": {
"id": 8233,
"status": "PENDING",
"fromDate": "2023-08-25 17:45:00",
"toDate": "2023-08-29 17:00:00",
"createdDate": "2023-08-29 17:38:37",
"updatedDate": "2023-08-29 17:38:37",
"subscription": {
"subscriptionId": 8015
}
}
} |
|
DPT-BOS
| Expand |
|---|
| title | In Progress Subscription |
|---|
|
| Code Block |
|---|
{
"subscription": {
"id": 8016,
"notificationEmailAddress": "tts-slate-team@elist.tufts.edu",
"expirationDate": "2025-08-28",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"userLevel": "institution",
"disabled": false,
"createdDate": "2023-08-29 17:40:24",
"updatedDate": "2023-08-29 17:40:24",
"subscriptionDetails": [
{
"id": 48217,
"event": "application.program.selected",
"responseType": "fullResponse",
"responseLevel": "program",
"responseOptions": "expand=all,includeNulls=true,contentType=text/csv,columnSeparator=COMMA,csvHeaderTruncationSize=4,csvShortName=question",
"destinationType": "SFTP",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"apiVersion": "v2",
"disabled": false,
"createdDate": "2023-08-29 17:40:24",
"updatedDate": "2023-08-29 17:40:24",
"sftpDestination": {
"id": 12075,
"sftpHost": "ft.technolutions.net",
"sftpPort": 22,
"sftpBaseDirectory": "/incoming/liaison/PTCAS/data/",
"sftpPathTemplate": "PTCAS-app-started_<instanceId>_<organizationId>_<programId>_<applicationId>_<casApplicantId>.csv",
"sftpUser": "liaison_service@tusmgp.admissions.tufts.edu",
"sftpPassword": "2717fef375e24a1ab89a376a86cbe358",
"createdBy": "TuftsUni",
"updatedBy": "TuftsUni",
"createdDate": "2023-08-29 17:40:24",
"updatedDate": "2023-08-29 17:40:24"
}
}
]
}
} |
|
| Expand |
|---|
|
| Code Block |
|---|
{
"replay": {
"id": 8234,
"status": "PENDING",
"fromDate": "2023-08-25 17:45:00",
"toDate": "2023-08-29 17:00:00",
"createdDate": "2023-08-29 17:40:37",
"updatedDate": "2023-08-29 17:40:37",
"subscription": {
"subscriptionId": 8016
}
}
} |
|
Applications in SOPHAS but not in Slate:
...