[ARCHIVED] We need our own unique identifiers returned in export data

[douglas_blatt]

We load our data into Canvas with SIS Imports.  The user.csv file includes 2 different fields that are unique for the individuals being loaded.  In the CanvasCLI exports, we get a user_dim table, containing the same people (I assume) but we don't get back our unique identifiers in that table.  How are we supposed to match up student records when the system doesn't pass back our own unique identifiers?

[a1222252]

Hi Douglas,

The pseudonym_dim table is the likely answer here. For us the SIS_USER_ID and UNIQUE_NAME columns are populated with values from our student system, (PeopleSoft Campus Solutions), and this can be joined to the user_dim.

I expect this depends on how the interface to your student system has been configured.

Regards,

Stuart.