...
Note that retrieving an unsubmitted application will be quite unsatisfying--the available fields are quite restricted.
Postlaunch
There are several different options for testing the data mapping and confirming that data is being imported correctly once the feeds have been turned on. The immediate check is the test file from the CAS; if that arrives in Slate, that is a good sign. It will not actually be imported, but will show an Error. Once real application files start flowing, it is good to check occasionally that everything is flowing as expected.
...
The options for exporting data from WebAdmit about In Progress Applicants is limited.
...
Pulling this list gets a list of everyone who is currently In Progress; this means that anyone who has submitted is not included. There is no control over what fields are exported, so for vet Vet at least this means there is a great deal of address information that has not been imported yet.
The number of individuals in the “In Progress” pile in WebAdmit fluctuates as individuals submit their applications, and as they change their mind about applying to Tufts and ‘undesignate’ the school. When students previously designated Tufts, the In Progress file was sent; there is no way to pull back that data, so over the course of the cycle there will be several hundred people who ‘disappear’ from WebAdmit, but exist as prospects in Slate.
(1) Confirm there is no one in WebAdmit who does not have a record in Slate
XLOOKUP syntax: =XLOOKUP(lookup,lookup_array,return_array,[not_found],[match_mode],[search_mode]) https://exceljet.net/functions/xlookup-function
(2) Spot check- data is matching appropriately. (~10 records).