Overview
Importing People records is key to using Element451. This feature allows you to bring in important data points to use in all other features in Element451, like segment building, workflow conditions, and email personalization.
Import Permissions
Access Import/Export: The user has basic access to the import, export, and templates sections.
Administer Data Templates: The user has access to create, edit, and delete import/export templates.
Administer Import/Export: The user has access to create, edit, and delete import/export tasks.
What Can Imports Do?
The Import feature is your tool to easily bring in large amounts of data on records without having to create each record manually.
Create Parent, Student, and Influencer Records
Bring in Test Scores
Create Applications
Update Records with Student IDs, Student Emails, Deposit and Enrollment information
Upload Hold Information
Features
Sources: Identify and select the data file you want to import.
Update Preference: Decide whether to create only new records, update existing ones, or both.
Matching: Check incoming records against already existing records on a chosen identifier to prevent duplicate records in your instance.
Segments: Import records directly into a segment.
Preview: View the input/outputs of the first few records to ensure data quality.
Test Import: Run the import without creating any records to review how many records would be updated, created, and skipped.
Accessing Imports
To access Import + Export, navigate to Data + Automations > Import + Export > Import + Export.
Import Management
The Import + Export screen is the main area for navigating between the import and export features and where you can see the comprehensive import + export tasks you and your team have created and run. On the import screen specifically, you can:
View all imports you and your team create
Manage your import tasks (edit, delete, duplicate)
Apply quick filters to your import tasks
Search for import tasks
Assign import tasks to folders
Creating Imports
Imports can be spun up quickly using pre-existing templates or can manually be set up.
Column Setting Options
When creating imports and mapping the incoming data to fields in Element451, additional cleaning or transformations need to occur. Donβt worry about making names titlecase in your spreadsheet tool, Element451 can get it done.
Data Quality Guide
Use this reference guide as you are building your imports to double-check that your data comes in clean the first time.
Creating Document Imports
Along with data, you can also bring in documents and relate them to records.
Decision Tree: Regular or System Data Source?
Below is a decision tree graphic designed to guide you on how to bring data into Element451. While it focuses on import tasks, the same steps can be applied to API use. This resource will help clarify the best practices for setting up custom fields and integrating your data sources efficiently.
Click the image to enlarge:
FAQ + Troubleshooting
Can I import a student's secondary email address?
Secondary email is not an available field for imports. Instead, the secondary email is added to a profile during the merge process if the emails are different. To import a secondary email, we recommend creating a custom field. You can then use an email token to send it to that email address. Ensure that the field has email validation enabled.