Parchment Template
Overview#
Parchment is a tool to help students, institutions, and employers to request and receive documents. If you are wanting to bring the documents in from Parchment, this guide will help you get started building that process. Your institution must be on the Parchment Receive Premium level to receive documents with an index file via SFTP.
Data Connectors#
Parchment interface will let you add a SFTP connection. This is where you can add the SFTP Element451 hosts and provided you during the implementation phase. We recommend building a Parchment folder in your SFTP. You can generate a separate username and password with access to a specific folder within your Element451 instance.
Import#
There will be two assets, a data import task and a document import task. It is important to build a data import task in the event that a student has submitted documents but is not a record in your Element451 instance.
Step 1: Data Import Task
Create a new import task and select the folder in the SFTP where Parchment is dropping off the documents. If you are wanting to schedule this process, you can use dynamic names in the path with the date:now token. Typically Parchment is delivering every hour, pending on how your folder names are set up will determine your dynamic name. If the folder path name looks like Parchment/Parchment_College_Transcripts_0107c430_20261103_070007_0.zip , for example, then you can set up a dynamic path name to look like Parchment/Parchment_College_Transcripts_*_[date:now,format=Ymd_H,timezone=PST]*_*.zip and have the file name be index*.csv . Then the scheduled import would pick up the corresponding index file for that hour. NOTE: We have not been able to confirm the timezone of the zip folder, please check with your Parchment support to confirm what time the timestamp is and adjust the token accordingly.
Once setting up the import’s source, on the mapping screen you can apply the Parchment Index File template. This template is to help get you started. Feel free to map additional things like address, phone number, source information. Some schools have opted for the data import to only create new profiles with contact information mapped to prevent potentially overwriting existing contacts with up to date contact information.
Make sure you have the toggle on for “When no matching files are available, execute the next scheduled task run.” as Parchment will not deliver a folder if there are no documents that hour.
| Name | Element451 Slug | Notes | Row |
|---|---|---|---|
| State | 23 | ||
| DID# | 2 | ||
| Address 2 | 21 | ||
| Common App ID | 12 | ||
| Document Type | 3 | ||
| DOB | user-dob | Date Format of m/d/Y | 9 |
| Application # | 11 | ||
| Student Email | user-email-address | 19 | |
| Class Of | 14 | ||
| Filename | 1 | ||
| Zip | 24 | ||
| School Type | 16 | ||
| Years Attended | 15 | ||
| RH CEEB | 13 | ||
| School | 5 | ||
| Receiver Name | 18 | ||
| Receiver ID | 17 | ||
| Address 1 | 20 | ||
| First Name | user-first-name | 6 | |
| SSN | 10 | ||
| City | 22 | ||
| Last Name | user-last-name | 8 | |
| Country | 25 | ||
| Date Sent | 4 | ||
| Middle Name | user-middle-name | 7 |
Step 2: Document Import Task
Following the processes in the help article (opens in a new tab), after creating the data task, a document task will be the next step. When setting up the document task, it will be important to toggle the “Use Index File” to on. The index file settings and document types are found below. If you are wanting to schedule this process, you can use dynamic names in the path with the date:now token. Typically Parchment is delivering every hour, pending on how your folder names are set up will determine your dynamic name. If the folder path name looks like Parchment/Parchment_College_Transcripts_0107c430_20261103_070007_0.zip , for example, then you can set up a dynamic path name to look like Parchment/Parchment_College_Transcripts_*_[date:now,format=Ymd_H,timezone=PST]*_*.zip . Make sure the index file is using the wildcard version index*.csv . Then the scheduled import would pick up the corresponding index file for that hour. NOTE: We have not been able to confirm the timezone of the zip folder, please check with your Parchment support to confirm what time the timestamp is and adjust the token accordingly.
Make sure you have the toggle on for “When no matching files are available, execute the next scheduled task run.” as Parchment will not deliver a folder if there are no documents that hour.
| Name | Mode | Notes | Row |
|---|---|---|---|
| Filename | Filename | 1 | |
| DID# | Skip | 2 | |
| Document Type | Document Type | 3 | |
| Date Sent | Skip | 4 | |
| School | Skip | 5 | |
| First Name | Skip | 6 | |
| Middle Name | Skip | 7 | |
| Last Name | Skip | 8 | |
| DOB | Skip | 9 | |
| SSN | Skip | 10 | |
| Application # | Skip | 11 | |
| Common App ID | Skip | 12 | |
| RH CEEB | Skip | 13 | |
| Class Of | Skip | 14 | |
| Years Attended | Skip | 15 | |
| School Type | Skip | 16 | |
| Receiver ID | Skip | 17 | |
| Receiver Name | Skip | 18 | |
| Student Email | Person Matching | Matching on Email | 19 |
| Address 1 | Skip | 20 | |
| Address 2 | Skip | 21 | |
| City | Skip | 22 | |
| State | Skip | 23 | |
| Zip | Skip | 24 | |
| Country | Skip | 25 |
| Name |
|---|
| Apostille Certificate |
| Application |
| Counselor Recommendation - Final |
| Counselor Recommendation - Initial |
| Counselor Recommendation - Midyear |
| Degree Certificate |
| Diploma |
| Enrollment Certificate |
| eSSR |
| Final Report |
| Grade Report |
| Guidance Report |
| International Leaving Results |
| International School Supplement |
| International Student Report Supplement |
| Letter of Recommendation |
| Letter Of Recommendation |
| Letter of Recommendation - Counselor |
| Letter of Recommendation - Teacher |
| Midyear Report |
| Optional Report |
| Other |
| Professional Certificate |
| Resume |
| School Profile |
| School Report |
| Secondary School Report |
| Secondary School Report - Final |
| Secondary School Report - Initial |
| Secondary School Report - Midyear |
| Secondary School Report - Optional |
| Secondary School Report - OR Change Explanation |
| SRE Request |
| Standardized Transcript |
| Teacher Evaluation |
| Teacher Recommendation |
| Transcript |
| Transcript - Final |
| Transcript - Initial |
| Transcript - Midyear |
| Transcript - Optional |
| Transcript (Final) |
| Transcript (Initial) |
| Transcript (Midyear) |
| Transcript (Optional) |
| Transcript Image |
| Transfer Transcript |
| Transfer Transcript 1 |
| Transfer Transcript 2 |
| Transfer Transcript 3 |