This article assumes you are familiar with creating and editing data sources, editing fields in the field management section, and importing/exporting data.

On This Page:

When you first implemented Element451, you learned all about creating and editing data sources and using them in either the system fields or custom fields you built. As time goes by, there may be some changes that occur where the original data source used on the field is no longer applicable and a new data source needs to be used.

This article will walk you through the steps you need to take to update the field for future usage and clean up the old values on student profiles to align with your new data source.

At this point, you have your new data source built and you are ready to change the field to use the new data source.

Navigate to Field Management and find the field you are updating, the first two tabs are system delivered fields and the last tab is the custom fields your institution has created.

Click the pencil icon next to your field and either navigate to the field options sections or toggle the "Use Default Data Source" to off to select the new data source.

Changing the data source at the Field Management level will impact any future forms, applications, and events built that use that field, but any current forms, applications, and events need to updated as well.

On each form, application, and event that uses the field needs to be updated to the new data source by clicking the pencil icon on the field and selecting the new data source.

Now it is time to clean up all the records that already have data (using the old data source) in that field. This step will involve the import/export modules.

Create and save a segment for profiles that have data in the field you updated by using the "exists" operator.

Create an export task using that segment and on the mapping tab at minimum add the "Element ID" and the field that needs to be cleaned up.

Once the export task is ran, you can open the file in your preferred spreadsheet tool and swap out the old values from the old data source to the new values from your new data source.

Note: It does not matter if you insert the names or the codes of the new data source as long as it is consistent through out your whole spreadsheet.

Save your file and head back to your Element451 instance to create an import task.

For your import task, after dropping in your cleaned up file, we recommend setting the import to "Update Existing" profiles on the mapping tab to prevent records from getting created in the event they were deleted/merged during the time you were cleaning the file. Map the Element ID and the field you are updating. For that field, click on the blue gear and identify if you are bringing in the names or the codes and check the "Enabled" box. On the matching tab, match on Element ID. From there, your import task is ready to be ran!

To confirm that all possible records have updated, create a segment that looks for data in that field that "exists" and is "not in" all the new values. The first part of this article can guide you in building it.