Update And Change Participant Data

1 Updating Participant Data
- 1.1 Update template
2 Changing Participant Data
- 2.1 Bulk Editing Participant Data

English | Deutsch

In the Participant administration menu you can update participant data using an update template. In the List of participants you can also change the data of one or more participants at the same time.

Updating Participant Data

If you wish to update participant data, download the update template in the Participant administration menu. To do so, click on the Update participant data button and then on Download update template.

Update template

In order to assign the data that should be updated, you must fill in the u_id field of the template. To make sure you don't accidentally overwrite participant data, simply delete the columns you don't need for the update process. The existing data will also be overwritten, if the column is not filled out.

After filling in the template, you must select the corresponding file under the "Source" option and click the Send file button. After the successful transfer, the data will be updated.

To retrieve the User ID do the following: In the participant administration, click the View button. Activate the checkbox for User ID. In order to display the User ID, you need the export-with_lfdn right. If you would like to obtain this right, please contact our support team. Next, click the Excel export button. The Excel export will contain your participants, including the User ID.

Changing Participant Data

If you wish to subsequently change or correct the data of a participant, you must first select the participant from the list of participants. With a large number of participants, this requires using the Search participant function. In the list of participants, the participant’s name will be displayed as a link you can click on to open the same entry form. Now you can change all required data and then transfer them to participant
administration by clicking on Save.

Bulk Editing Participant Data

It is often the case that already uploaded participant data records need to be subsequently modified or extended. For example, titles used to personalize e-mails and questionnaires need to be changed (“Dr.” → “PhD” it turns out during evaluation that a variable necessary for a particular split has not been created and filled in in the participant administration (e.g. “customer type”). The “Bulk edit” feature allows to realize such changes with reduced effort. If you limit the list of participants to the relevant data records (or at least to a subset) using appropriate search criteria, you can modify all these in a single step.

Please proceed as follows:

To do so, switch to the Participant administration.
Use Search participants to restrict the list of participants as far as possible to those participants affected by the change.
Mark the participants to be changed.
Select the “Bulk edit” action from the drop-down list.
Confirm by clicking on Execute.
The form where you can specify the desired change will be displayed. Select the variable to be changed and the value you want this variable to have after the change. In the given example, the value of the variable “u_group” is to be changed within the selected data records from 1 = Development to 5 = System administration as the employees have been transferred.
Click on Preview to check the result.
Check whether the change appears as you had planned it. If so, confirm by clicking on Save