How to Import or Update Panellists in Bulk

How to Import or Update Panellists in Bulk

Import in Bulk Panellists

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.)




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






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.



5. Browse for the newly created or updated panellist

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

5. Click on the "Import" button 


6. After you import the panellist, you will get a message explaining if the import was successful. 
7. That's it! You have successfully imported or updated panellists in bulk using the EyeQuestion software.


Enabling the Function "Force Password Change"

NOTE: By following the steps below you will be able to enable  the function: ''ForcePWchange'' (force password change)
1. Please go to User Management and click on Manage Users.



2. Go to ''Edit User'' 



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



4. That's it!



    • Related Articles

    • How to Load, Create, and Update EyeQuestion Panel

      EyeQuestion Panel The panel manager can add a panel to a project to allow specific panelists to answer that questionnaire. The used panel can be found under the access list (on the right side of the page). (In this case it is still empty) Load a ...

    • Panel Scheduling in EyeQuestion 5

      Introduction One of the more challenging tasks in conducting sensory and consumer research is the process of manually checking the availability of your panellists participation by calling or emailing them. This traditional approach is not ideal as it ...

    • 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 ...

    • 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 ...

    • How to Manage Panellists Unsubscription

      Introduction In this article we will explain more about how you can manage panellist unsubscriptions. Manage Unsubscribes Under the panel management tab you can see various options, including "Manage Unsubscribes". Under the manage unsubscribes tab ...