Search and Display Functions and Export

Simple Search

The search functions of the participant list allow you to limit the list to individual participants or participant groups. Then, in the next step, you can apply actions as e.g. “Invite”, “Generate code”, “Delete” etc. to these subgroups. Usually, the simple search function is displayed.

The following rules apply:

• Upper- and lowercase spelling will be ignored.

• When searching for a specific term, all entries containing the term will be shown in the results list.

• Instead of one single search criterion, you can also enter a combination of criteria.

• The criteria will be joined by an AND, i.e. the results must fulfill all criteria.

• You can perform several search operations in succession to progressively further restrict a set of results.

Extended Search

The search function of the participant list has been revised, so that now large amounts of participants can be searched with a minimum of time. The search is divided into two sections: "Fields with index" and "Fields without index".

Open

In the section "Fields with Index" you can, for example, search for participants according to the disposition code. A special new feature in this section is the search using the creation date. You can now search for the period in which participants were created. But  if you want to search for a specific date/day, the same date must be selected in both fields. A further possibility of the precise and fast participant search is the search for e-mail addresses. To do this, you can use the search for certain elements of an e-mail address in the upper left corner. For example, if you select Ends with, you can search for all e-mail addresses that end on a particular domain. The second search for e-mail addresses is located at the bottom right and allows you to search for several e-mail addresses at the same time by entering these addresses one below the other in the free text field. In the extended search of Personalized Surveys you can also use the free text field Code to search for several codes at the same time.

Open

In the "Fields without index" area, you can search for participant variables that do not have an index in the database. A search in the "Fields without index" area therefore takes much longer than a search in the upper area. But if you have a participant variable from the lower area searched particularly frequently, this variable field can be provided with an index in the database. For this purpose, please contact our support team.

Search Multiple E-mail Addresses

Using the “Search multiple e-mail addresses” function in the extended search, you can simultaneously select a large number of participants via their e-mail addresses. This is useful if, for example, you wish to set a large number of participants whose invitation mails have been bounced back to disposition code 15 (not available).

Just copy the e-mail addresses of the participants you are searching for into the entry field. In doing so, limit each line to just one e-mail-address. After that, confirm by clicking on Search. The participants will then be located.

Display Functions

As the participant administration usually contains a large number of extensive participant data records, only selected data are normally displayed in the overview list. However, there are several functions that enable you to specify which participant data and how many participants per page will be displayed.

• The links labeled > (Next page) and < (Previous page) allow you to scroll forward and back through the list of participants.

• Clicking on a column title allows you to sort all participant data by the content of the respective column. For example, clicking on “Participant” will sort all participants alphabetically by their names.

The View Button

By clicking on the View button you can display a dialog that allows you to specify whether the various table columns are to be shown or hidden. You can also change the number of rows per page. After you have confirmed by clicking on Submit the table will be expanded accordingly.

Additional Information

The following additional information and functions are available for each data record:

• All participant data. The participants’ names are active links. Clicking on a participant will open the entry form, where you can change the participant’s data.

• Password and code: depending on whether the login option set for the project is “Password” or “Code”, the corresponding column will contain an activated link which can be copied and passed on (e.g. to a tester who wants to check the questionnaire under real conditions).

• The “Direct link” column displays an icon which can be used to open and view the questionnaire intended for the respective participant in a pop-up window.

• If you have read rights to “show_dispcode”, you can see the disposition code of the participants.

• Question mark icons indicate values for which there is as yet no corresponding characteristic for “radio button” or “checkbox” type variables. This may occur if you use values in the imported dataset for which you have not yet created any characteristic and for which, at the same time, the function for automatic creation of new characteristics on import is disabled.

• Via the checkbox in the “Actions” column you can select participants to whom you wish to apply the actions.

Excel- and CSV-Export

The entire content of the list of participants can be downloaded as one CSV or Excel file. If you wish, for example, to invite project participants to take part in a follow-up project, this feature allows you to easily export all necessary data into this follow-up project.

If you have the read right show_dispcode necessary for viewing the disposition codes, the export file also contains the dispositon codes of the participants.

To trigger the export, click on either of the Excel export or CVS export buttons.

Please note:

• The Excel export may take some time, depending on the number of data records and variables contained in the list of participants. For large projects we therefore recommend the CVS export.

• If an Excel file is opened, depending on the circumstances, a message may be displayed which notifies you that the file is corrupted. This problem is caused by an extension provided by a third-party supplier. Until further notice, please proceed as follows:

  • Save the file locally.

  • Then, open the saved file, allowing Excel to repair it.

  • Finally, save the file again.