How to I import or update panellists in bulk

How to I import or update panellists in bulk

In EyeQuestion you have the possibility to import or update information about your panellists. 
The steps to be taken for this are described below:

Step 1: Go to Panel Management and click on ''Import Panellists'' (The option can be used to create new panellists, but also to update existing panellist.)





Step 2: After clicking on import panellists you will land on following page (below). Please download the example file. 






Step 3: Fill the import panellist file 

Open the downloaded template file in Excel and please pay attention to the following important things while entering the data:

1. All required fields should be filled in for each panellist (one panellist per row)
2. Login, password and email fields should always be filled in (these fields are mandatory, all other fields are optional)
3. In the import file, you can add a column called “forcePasswordChange” and choose the option “TRUE” or “FALSE”. The choice would either enable or disable the option “force password change” in the panellist profile.
4. Make sure to always save the file.



Step 4: Browse for the newly created or updated panellist

Import the Excel file you just created by clicking on the ''Browse'' button (image below) . 


Step 5: Click on the "Import" button 


Step 6: After you import the panellist, you will get a message explaining if the import was successful. 

Step 7: That's it! You have successfully imported or updated panellists in bulk using the EyeQuestion software.



Enabling the function Force Password Change

Please note: By following the steps below you will be able to enable  the function: ''ForcePWchange'' (force password change)


Step 1: Please go to User Management and click on Manage Users.




Step 2: Go to ''Edit user'' 





Step 3: In the option ''Edit User'' please ensure that option Force PW change is set to ON.



Step 4: That's it!

How to import categories from the import file?

Please click ''here'' to learn how to import categories from the import file. 

    • Related Articles

    • How to Modify Panellist Answers

      Sometimes, you might find it necessary to modify or update the answers provided by your panellists for a particular session. This article will guide you through the process of changing the answers of your panelists in EyeQuestion while keeping in ...

    • How can I import a panel in EyeQuestion project?

      You can add panelists in EyeQuestion by transferring them from the Panel Database to the panel access list or using excel import. Open a project and click the panel tab. Panelists can be added to the panel by adding them to the access list from the ...

    • Categories and Dynamic Panels

      Categories can be used to store the characteristics of your panellists. It can contain information about for example allergies, shopping behaviour and food consumption behaviour. Using categories, and other information available in the panelist ...

    • Calculate Panellists Questionnaire Response Time

      Introduction By tracking the time it takes for respondents to complete surveys, we can gather valuable insights that can help us improve our processes. Firstly, response times reveal user engagement levels and identify potential issues with question ...

    • How to add panellists in panel database

      The Panel Database in EyeQuestion is where you can access a comprehensive list of all panelists, complete with their information stored within the system. Access to this page is restricted to users with a Panelist Manager profile. Adding Panellists ...