Element451Integrations Guide

CBCA FAQ

Updated Article

How do I update my CBCA import task for the new cycle?

Find your task that is running in the import section of Imports + Exports in Element451. Stop the schedule so you can edit the mapping screen. Make sure any user-applications or user-milestones fields that reference old terms are updated to all new terms. Set the schedule back up.

Can I update the CBCA application import while it is live?

Yes! At any point, you can go into the import task in your Element451 instance, stop the schedule, make the edits, and restart the schedule.

What if CBCA uses different dropdown options from my institution?

We know how important it is to keep data clean, and imports are the easiest way to bring bad data in. During implementation, the Element451 team member working on your template will tediously ensure the data sources from CBCA line up with the data sources you use in Element451. Our team will either apply the transformations to the the import, taking the CBCA value and swapping in your recognized value, or create crosswalk tables in your Regular Data Sources and use those in a formula on the imports.

If you are adding a new field after the implementation phase of the integration, you can map the field and use the replace transformation or create a calculated field to take the incoming CBCA value and return your institution’s value.

How can I check that the import is running?

All of the tasks will be found under the Import + Export feature. You can search for CBCA and find the related tasks. Like other import tasks, you can open and view the run history where all previous runs and their outcomes are listed.

What do I do if a record was skipped?

When you view the run history and see that a record was skipped you have a few options. First, you should view the details of the skipped record to see if it was a invalid data value or a match error.

For Invalid Data Values:

You will need to download the file from CBCA and find the record that was skipped and clean up the data that was invalid. Once cleaned, in the Import + Export feature in Element451, make a copy of your CBCA import and select the cleaned file from your computer and manually run the task to bring the record in immediately.

For Match Errors:

You will need to download the file from CBCA and identify the record that was skipped. Search your Element451 instance for the duplicate records, the match error happens when there are multiple records in Element451 with identities of the incoming record and so the system doesn’t know which record to update. Correct the duplicate records in your Element451 instance. Once the merge has happened, you’ll need to head back to the Import + Export feature in Element451, make a copy of your CBCA import and drop the file from your computer and manually run the task to bring the record in immediately.