This article provides comprehensive guidance on adding participants to a project in EFS. It covers the manual creation of new participants, importing participants from a file, and importing participant codes.
New Participant
To manually create a new participant, please proceed as follows:
- Click the New participant split button to open the entry dialog.
- Enter the participant data. The following rules apply:
- The “E-mail” field must always be completed. Use of the other fields is optional.
- In the “Password” field, the “Generate new password” checkbox is ticked by default. If you enter a password yourself, this will be used, and no automatic password will be generated.
- If you want to have the questionnaire checked by test persons with specific tester status prior to the field phase, then tick the checkbox “yes” in the field “Tester” for these test persons. For further information on the use of testers.
- If variable characteristics are missing, use the Edit variable icon to open the dialog and add the new characteristics as required.
- After entering all required information, click on the Save button to save the data.
The new participant will appear in the list of participants.
Importing participants
Usually, you will not create the individual participants of your project manually but rather import the list of participants. In the following, the sequence of the import operation is first explained. After that, the structure of the import file is explained in detail.
Downloading the import template to import participants
- Switch to the Projects → {Selected project} → Participant administration menu.
- The dialog where the import takes place is opened by clicking on the New participant split button and selecting the Import participants option.
- EFS provides a preformatted import template already containing all necessary columns. It can be downloaded by clicking on Download import template.
Filling the import template with participant data
- Open the template in a suitable program
- Enter the data
- Save the file in Excel or CSV
Matching the fields of the import file with the database fields
- Again, open the import dialog by clicking on the Import participants button.
- Select the appropriate character set.
- Use Browse to select the import file on your computer.
- Verify that the checkbox in the field “First row includes column labels” is set appropriately. Normally, it should be activated.
- Verify that the checkbox in the field “Allow duplicate e-mail addresses” is set appropriately. Normally, it should be deactivated.
- Click on the Send file button to start the import operation.
- In the next step, all columns of the import file must be matched with the appropriate database fields. If you have used the template without changing the column labels, as recommended, the software will carry out the allocations automatically.
- After checking the allocations confirm by clicking on Proceed to preview.
Checking import data in the preview
- In the import preview all the data records are displayed as they will be imported into the project. The traffic-light icon in the “Status” column indicates whether the data record is complete and logically coherent. If the icon is red, i.e. if an error occurred, the reason for this will be indicated when hovering the cursor over the icon.
- If necessary, use the Edit and Delete icons to open and subsequently edit resp. delete specific data records. Afterwards, use the Back link to return to the overview.
Executing import and downloading results
- If you are satisfied with the data in the preview, click on Import to trigger the actual import.
- After completion of the import operation, you will be shown how many data records have been created and how many have not been created due to problems.
- By clicking on the Download results button you can retrieve an Excel file containing the following information:
- all data contained in the import file
- the “result” column contains the import result, i.e. a message “Data record import successful” or “Data record not imported”
- in case of problems, the reason will be indicated in the “messages” column
- If necessary, you can correct the data records that were not successfully created directly within this file, delete the data records created successfully, and use this file for a new import attempt.
Please note:
- Do not start preparing the import until you have created all the required participant variables.
- When using Excel, consider the following restrictions imposed by manufacturer specifications:
- Only the first sheet of the file will be processed. You should not exceed the maximum of 256 columns and 65,000 rows. Should you require more columns or rows, select a different program and save your import file in CSV format.
- Excel import is only possible for files created or saved using Excel 97+. Excel files that were created or saved using Excel for Mac”, “Neo Office” or “Numbers”, for example, cannot be imported.
- The file format XLSX, newly introduced by Microsoft with Office 2007, is not supported by EFS.
Formatting of the import file in detail
When filling in the import template or creating your own import file you have to consider various formatting rules.
File format
The import file can be created in Excel or CSV. Data columns may be separated by tab, comma, or semicolon. When using Excel, consider the following restrictions imposed by manufacturer specifications:
- Only the first sheet of the file will be processed. You should not exceed the maximum of 256 columns and 65,000 rows.
- Excel import is only possible for files created or saved using Excel 97+. Excel files that were created or saved using “Excel for Mac”, “Neo Office” or “Numbers”, for example, cannot be imported.
- The file format XLSX is supported by EFS.
File structure
An individual column is created for each participant variable to be imported.
- We recommend entering the respective column labels in the first row.
- Where possible use the name of the respective variable as the label: The software will automatically identify the columns and assign them to the appropriate database fields. If you choose this option, make sure to tick the checkbox “First row includes column labels” in the import dialog.
- Should you deviate from these recommendations, make sure that the first row does not contain any blank spaces or special characters such as dots or umlauts. Otherwise, these will be uniformly replaced with “_”.
- Optionally, you can dispense with using the column labels in the file. In this case, untick the checkbox labeled “First row includes column labels” in the import dialog.
The values of the individual data records are entered in the rows of the file.
- The code of the desired characteristic must be specified for data imported into “radio buttons”, “selectbox” or “checkbox” fields. You will find it in the Codebook. (Tick the checkbox labeled “Show participant variables” in order to display the respective section.) Empty cells are automatically set to the default value “0” upon import. How codes that do not yet exist or entries that cannot be interpreted as code are treated depends on the display type and fine-tune settings.
- Optionally, you can create new characteristics for an existing variable during import. To do this, the relevant option must be activated for the respective variable.
Special features of certain standard variables
Some variables require special consideration:
- In principle, an e-mail address should only be registered once, unless you wish to permit duplicate participation and explicitly select the “Allow duplicate e-mail addresses” field.
- Sometimes it is necessary to create dummy accounts. In such cases, you can use e-mail addresses on the @3uu.eu domain: these addresses are owned by TIVIAN, mails sent to them are deleted automatically.
- The access code must not be longer than the number of characters defined for option “Type of codes which will be generated” under the ‘project properties’ menu of your project.
- The mobile phone numbers of participants in u_mobile must be formatted according to international formatting rules:
- A total of seventy digits
- Two zeros at the start
- Country prefix, e.g. 49 for Germany
- The number itself.
- Example: 0049223379336.
- The special status of tester accounts can be set via the “tester” column of the import file. The values in this column are coded as follows:
- 0 and blank field: normal participant
- 1: tester
If you use passwords that contain non-ASCII characters, pay attention that characters and character set of the project are compatible with each other. Otherwise registration will not function, because the entries made by respondents will not correspond correctly with the contents of the database due to transfer problems. It is not possible for example to register for an ISO-88599-1 coded survey with a Japanese password. These kinds of problems can be avoided through the use of the international character set UTF-8, because UTF-8 can display all languages.
When exporting and importing participant data, mind that the “u_mobile” column of the Excel file should be formatted as “Text”. Otherwise the two leading zeros are removed.
Allowing Duplicate Participation
It is possible to use duplicate e-mail addresses in personalized projects, i.e. a participant can appear more than once. This function makes it possible, for example, to perform projects in several waves with the same participants. It is also useful for trade fair servers. In this case, the participant data records are not uniquely identified by the email address alone, but by the unique combination of e-mail address and password. If you wish to use duplicate e-mail addresses, your import file should therefore contain at least the names of the participants, e-mail addresses, passwords, and usually additional information on wave membership. For a participant to receive a duplicate invitation, you must create two rows that contain the same e-mail address, but different passwords. The waves to which the duplicate participants belong are usually defined via the content of the u_group field.
For this, the checkbox in the “Allow duplicate e-mail addresses” field must be ticked.
Import Codes
The Import codes option of the split button allows you to import participant codes from a file into participant administration. Each row of the file is interpreted as one code. Therefore, the file should not contain a header. A participant is created for each code. The remaining participant data (e.g. name, password) are set automatically.
For each imported code, a dummy account will be created. E-mail addresses on the @3uu.eu domain are used for these accounts. These addresses are owned by Tivian, mails sent to them are deleted automatically.
Please insert import codes into the text field below, each line one code. Per code one account will be created if code doesn’t already exist.
FAQ
What should I consider when using Excel for imports?
When using Excel, be aware of these limitations: – Only the first sheet is processed. – Maximum 256 columns and 65,000 rows. – Use Excel 97+ format (not Excel for Mac, Neo Office, or Numbers). – XLSX format is supported by EFS.
How should I format mobile phone numbers for import?
Format mobile numbers according to international rules: – Up to 70 digits – Start with two zeros – Include country prefix (e.g., 49 for Germany) – Example: 0049223379336
What should I do if I need to create dummy accounts?
Use email addresses on the @3uu.eu domain for dummy accounts. These are owned by TIVIAN, and emails sent to them are automatically deleted.