SPS Photos (Slate+Advising)
- Bryon Vaughn
Owned by Bryon Vaughn
Overview
The data that feeds from Lenel (Identity Access Management) into Slate needs to conform to specific standards for proper processing. This document will cover the synchronization feed that has been configured, including the detailed file specifications, use cases, and development cycles.
Technical Details
Current Release Version: 2022.1.0
Release Date:
Stakeholders
SPS Advising, CUIT/IAM
Special Considerations
Feed Processing
- Slate has been configured to watch for an updated file in the "incoming/sis" SFTP folder and then process the records using the appropriate source format.
- ZIP files are generated nightly through a scheduled process managed by the CUIT/IAM team.
- All files are saved on the H: drive in the following location: H:\Systems and Data Analysis\DATA_EXPORTS\Slate+Advising\photos.
- All files are transferred nightly to the Slate SFTP folder using a script on the AIS terminal server.
- SPS_Photos.zip
- Includes all SPS students that have a new or updated photo in the IAM system (Lenel)
- Includes a csv file that maps CUID to each included image file name (JPG)
- E.g., C012345678,ab1234.jpg
- SPS_Photos.zip
- ZIP files are generated nightly through a scheduled process managed by the CUIT/IAM team.
Support
- Automated emails are sent when files fail to be sent or uploaded.
- Should there be a problem with the feed on the IAM side, the following steps should be taken:
- Send an email to askcuit@coiumbia.edu with a note to assign it to Steve Cramer detailing the problem. Include iamfunc@columbia.edu on copy to ensure the IAM team gets the message as well.
- A ticket will be opened and the issue addressed by the support team.
- Send an email to askcuit@coiumbia.edu with a note to assign it to Steve Cramer detailing the problem. Include iamfunc@columbia.edu on copy to ensure the IAM team gets the message as well.
Requested Features/Issues
Current Cycle
Release 2023.1.0 [January 2023]
Features to Complete
- Not started
Features to Consider
- Not started
Features Ready for Release
- Not started
Previous Cycles
Release 2022.1.0 [December 2022]
- IAM Team
- Create a manifest file with comma-separated values of CUID and file name
- Zip the manifest and all included JPG files into a single archive
- Copy the file to the SPS H: drive location nightly at approximately 7pm
- SPS Team
- Copy the file from the H: drive location to the Slate SFTP server daily at approximately 7am
- Slate automatically imports any file that is copied