Element451's recent release of entity exports means that you can now easily export multiple rows for a student record. The field options for entity exports include User Profiles, Notes, Applications, and Sources. However, labels are not currently included in the entity exports. On this page we will provide instructions for how to create an export that includes all the labels associated with a user.

First, create an export template, select a segment, and then go to the Mapping tab. For an overall introduction to exporting from Element451, check out this article.

Once you are in the Mapping tab, you can choose which fields you would like to include in the export. In order to export all the labels for a user, click "Add Column" at the bottom of the page and then add six standard columns: search for "Label" once you have selected "Standard" and add the fields with IDS "user-labels-one" through "user-labels-six." It is not possible to add all of these columns in one action - you will need to add each of these columns separately.

You will now have an export that looks something like this:

However, when you navigate to the export preview, you will notice that the labels show up as a taxonomy (something like "abc.taxonomy.123456") if the mapping is left like this. That data format may not be very useful to you. Therefore, we recommend creating calculated columns to map the labels to their corresponding names (such as "Territory 2" or "Flutist").

To export your labels as names instead of taxonomies, select "Add Column" at the bottom of the Mapping tab and choose "Calculated" this time. Once the column is added, click on the blue gear at the far right of this new column and navigate to the "Formula" tab. Input the following formula: TAXONOMY_MAP([user-labels-x], "guid", "name", "NA"), where "x" is the written-out number ("one" through "six"). "NA" will be input for any label fields left blank for that user.

Note that when you enter the left bracket, field options will appear and you will select among them (the field should be highlighted orange when you are done!). The only piece of the formula that changes for the six calculated columns is the written-out number.

Now, when you preview your export, it will look something like this (calculated columns have only been created for Labels One and Two in this example). Note that Label One (Columns 3 and 9) now shows up as "Accepted" in the calculated column and Label Two (Columns 4 and 10) now shows up as "NA."

Once the calculated columns are set up for all the labels you would like to include, you are all set to set the destination for your task and run it!

Did this answer your question?