Eduphoria supports various importers for districts that use Secure File Transfer Protocol (SFTP), such as imports for updating users, tests, student supports, and built-in roles. Here, you can review the available imports and their file requirements. Refer to the Access Keys article to learn how to create access keys and set up SFTP connections for specific imports.
Importing User Updates
Districts can use SFTP to update existing user accounts and delete no longer needed user accounts.
Note: The only way to deactivate/delete a user is to include the Action column and provide the corresponding value on the user record.
User File Import Fields and Requirements
The importer processes the following file header values within a user-built CSV file. Review which fields are required and under which circumstances. Adding values to headers that aren’t required still updates the relevant user information. For instance, adding or changing the Employee ID value updates the Employee ID for that user record once the import is complete.
If a column doesn’t exist or if the value is blank, the import does not change the value for the user account at all, with the exception of the User/CustomRole column.
Exact Header Value | Required? | More Information |
|---|---|---|
Email Address | Always required | Every record requires a user’s email address to identify unique user accounts. If it is missing, the importer won’t process the file. |
First Name | Not required | |
Last Name | Not required | |
Middle Name | Not required | |
Suffix | Not required | |
School(s) | Not required | |
Employee ID | Not required | |
User/CustomRole | Not required |
|
Unique/State ID | Not required | |
Certification ID | Not required | |
Certification Type | Not required | |
Certification Expiration | Not required | |
National Board Certification Expiration | Not required | |
Employee Position | Not required | |
Date of Birth | Not required | |
Gender | Not required | |
Race/Ethnicity | Not required | |
Other Unique Identifier | Not required | |
Action | Not required | The Action column can either be left blank or contain one of these values:
If no Action column is provided in the file, all records are treated as if there is no set value. |
Importing Test Files
Test file imports with SFTP should be in the same file format as you obtain them from assessment vendors such as the TEA, College Board, and more. To see which vendors and file types we accept, visit Supported File Types.
Note: Importing test files via SFTP is only supported with built-in test types. Custom test types are not supported at this time.
You can automate SFTP test imports and see their uploads in your import history within Aware > Analysis Settings () > Upload Test Files > History tab. Visit Access Keys to learn how to connect your SFTP client to run test file imports.
Importing Student Supports
You can import student supports with SFTP by uploading a CSV of either a TestHound file or a file in a custom format, which you can download below:
Be sure to maintain the file headers so the file imports successfully and adds the requested student supports to the correct students. You can see the file’s import history by checking the box for Show jobs imported via SFTP in Aware > Students Settings () > Upload Student Supports. Visit Access Keys to learn how to connect your SFTP client to run student supports imports.