Updating the SUNY App Source Format
This article provides information on necessary changes to the pre-built Source Format used for importing SUNY Applications into Slate.
If you are ready to start importing SUNY Applications into your Slate instance, you will find a pre-built Source Format called “SUNY Application – 2018”. This was built when the Slate environment was cloned. Since then, changes have been made and the Source Format must be updated to accurately map the information contained in the application files.
Remove Custom SQL
Custom SQL was initially added to assist in mapping the Race field. As they have since been updated and can be mapped directly in Value Mappings, that SQL should be deleted. Navigate to the Database () > Import > Source Formats. Click on the “SUNY Application – 2018” Source Format, then click the Edit button.
Navigate to the Format Definition tab. Here, you will see that the second box is labeled “SQL”.
Highlight all of the custom SQL and delete it. Click Save.
Upload Test File
Before you can update the value mappings, you will need to upload a test file. If you do not yet have access to, or do not wish to start with an actual application file, you can use this test file: Test SUNY Application Data.txt
Fields & Value Mappings
Many basic fields will already be mapped. Please review the VisaTypeCode field and ensure it is properly mapped. Race fields were last added and will need to be mapped next. If you have already uploaded the majors prompt list provided by SysAdmin, you can map the CurriculumCode to the Major prompts. If you have not yet done so, please see the related articles below.
Lastly, review the unmapped fields and decide if and how you want to map them.
Once your Source Format is mapped to capture the information you want, you will need to ensure that you have set up Periods and Rounds before you being to upload the application files. You can find more information below. Once the applications are imported, you will need to begin setting up the Reader bins to enable your admissions officers to review the applications.