What are Integration Codes

Integration codes allow you to create additional mappings for your data sources.

These integration codes can be used when working with suspect/prospect lead import tasks, applicant import tasks or anytime an additional mapping is required for majors, terms, and degrees.

Let's explore when and how to use them.

When to use Integration Codes

We recommend importing and exporting data between Element451 and your Student Information System (SIS). Your SIS codes will be stored in the "Code" column of each item.

However, you may need to integrate with other systems (such as an Ad platform or LMS). If those systems uses separate codes for your SIS, you'll save those additional code as Integration Codes.

Element451 provides 5 "custom" integration code slots, as well as slots for the following systems:

ACT
CIP
Coalition Application
College Board
Common Application
Hobsons
Naviance
NRCCUA
SIS

Adding Integration Codes

Add Integration Codes to your data in the Data Sources module. Under the Data + Automations menu, select "Data Sources".

Manually Adding an Integration Code

In this example, we'll add an integration code for a Major.

Edit the Major. Click on the pencil icon to edit a Major in the list.

Select the "Integration Code" tab on the pop-up window. Select "Add Code" and choose an option from the "With" menu. In this example, we'll add a "CIP" code. See all available "With" options.

Lastly, input the code value into the "Code" field. Add additional codes as needed.

Click "Done". This will return you back to the Majors data source list.

At this point, you can add additional codes manually by editing each field, or by uploading them.

Uploading Integration Codes

After one integration code has been manually added, you can use the export feature to provide upload the rest.

Click the Download icon. This will download a .csv file of your Data Sources to your computer.

Open the file in Excel (or a software of your choice). Locate the Integration Code column. In our manual example, we selected a "CIP" code. This will correlate to a "CIP" column in the file. Add the rest of the codes to the column.

Save the file as a .csv. When all codes are added, ensure the final file is saved as a .csv. Excel files cannot be uploaded to Element451.

Import the .csv file to the Data Source. Find the Upload icon (next to the download icon). Select the "Upload file" card and select the file from your local computer. Select to either import only new data, update existing data, or update existing and import new data. Click "Upload" to begin the upload.

Referencing Integration Codes in the Import and Export Modules.

With Integration Codes added to your Data Sources, you can now use them when importing and exporting data from the Import and Export Modules. This his how you will interpret or send codes between systems.

Before continuing here, make sure you're familiar with the Import and Export Modules.

Importing Integration Codes

Importing an integration code will require you to use a Calculated column. Once a calculated column is created, use the DB_MAP() formula to target the data source and field you wish to export.

In this example, we'll import the CIP code to the user's Intended Major. Let's assume we're importing a file of 20 columns. The 10th column has the CIP major code for each student.

DB_MAP("major" , [C10],  "cip", "guid", "")

Each parameter of DB_MAP() is separated by a comma. The parameters are:

The Type. In this case, we're using "Major". "Term" & "Taxonomy" are also available.
The Input. In this case, we're using the 10th column of the file, which the formula will identify as [C10]. To select a column, type "[" into the formula field. This will show all columns that can be selected.
The Match. This is the type of data that is stored in the column of the import file. In this case, the column at [C10] stores the CIP of the major. By inputting "cip" in the match parameter, we're telling the formula to anticipate that type of value.
The Output. This is the attribute of the major we want to appear in the export. No matter the case, we always want import calculated columns to output the GUID of a data source field. The GUID is the only valid data type that data source fields can store. If the CIP code were to be output, the system would not understand how to display or use the data.
The Default. This will be inserted into the field by default no value exists in the column, or if the Match fails and produces no Output. In this case, the Default is "", which will input no value into the field.

Once the formula is entered, the Preview tab will show the GUID in the output for the calculated column.

Read more about DP_MAP() and see all formulas here.

Exporting Integration Codes

Exporting an integration code will require you to use a Calculated column. Once a calculated column is created, use the DB_MAP() formula to target the data source and field you wish to export.

In this example, we'll export the CIP code of the user's Intended Major.

DB_MAP("major" , [user-education-prefered-major],  "guid", "cip", "")

Each parameter of DB_MAP() is separated by a comma. The parameters are:

The Type. In this case, we're using "Major". "Term" & "Taxonomy" are also available.
The Input. In this case, we're using [user-education-prefered-major]. To select a Field to input, type "[" into the formula field. This will show all slugs that can be selected.
The Match. This is the attribute of the major that is stored in the field. In this case, the [user-education-prefered-major] field stores the GUID of the major. By inputting "guid" in the Match parameter, we're telling the formula to anticipate that type of value.
The Output. This is the attribute of the major we want to appear in the export. In this case, we want the CIP code, so we insert "cip" into the parameter.
The Default. This will be inserted into the column by default no value exists in the Field, or if the Match fails and produces no Output. In this case, the Default is "", which will produce an empty cell.

Once the formula is entered, the Preview tab will show the integration code in the output for the calculated column.

Read more about DP_MAP() and see all formulas here.