Employee Import - Keep Qualtrics Language? | XM Community
Skip to main content

Hi community,

I am trying to find a solution to the problem I have. In EX’s Employee Directory, I have a monthly import job to get the employee data from the external system:

The data includes the user language the simplified example is attached.

 

The problem is that some of the employees are also Qualtrics users, and when they change their language in Qualtrics, it’s overwritten monthly by this import. Changing it in the leading system is not wanted, as there are reasons why the languages between it and Qualtrics would differ.

 

I tried using the existing data manipulation tasks, but with no success at all. Is there a way how I could enforce keeping the existing language in Qualtrics in case it differs to the one being imported? Or to use the current one unless it is empty/new employee?

An update - I followed this topic with Qualtrics Technical Support and there doesn’t seem to be an easy way how to do this, as it is not currently possible to add a condition to the workflow for what I tried to do, at least not during an import.

A follow up in case someone faces a similar issue.

Considering we have a limited list of employees who are affected, I solved this by combination of an “Imported Data” project and a dedicated workflow.

The Imported Data is a list of affected employees, using:

  • sequential ID
  • qualtrics user ID (“user”)
  • target language, as requested by the user (“lang”)
  • comment field to help myself recognize the individual users while not keeping any sensitive user data

Then there is this scheduled workflow, starting after the user import one:

It extracts the list of users to have their language changed, and then uses the update user API (../API/v3/users/${datasource://Extract data from data project/user}) in its most minimalist form to just change the language:

{"language": "${datasource://Extract data from data project/lang}"}

It’s not perfect, not what I originally had in mind, but it does exactly what was needed, even in a better way - not only it ensures the qualtrics user language is the target one, but it also keeps the employee language matching the original from the source system, enabling that user to use the default language while participating in the surveys of others.

Terms & ConditionsAccessibility statement