View Issue Details

IDProjectCategoryView StatusLast Update
15924Bug reports[All Projects] Survey participants (Tokens)public2020-02-27 11:18
Reporteracran Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version4.1.7 
Target VersionFixed in Version 
Summary15924: Can not send invitations to imported participants where emailstatus IS NULL
Description

After importing participants from CSV with an empty or omitted emailstatus trying to send invitation e-mails ends up with an error message although all listed criteria are actually fulfilled:

There were no eligible emails to send. This will be because none satisfied the criteria of:

  • having a valid email address
  • not having been sent an invitation already
  • not having already completed the survey
  • having an access code
  • having at least one use left
Steps To Reproduce
  1. create a new survey
  2. add a participants table
  3. import participants via a CSV without a "emailstatus" column (see attached example)
  4. generate access tokens
  5. go to "send email invitation"
  6. disable the "Bypass participants with failing email addresses:" checkbox (since the emailstatus is empty and not "OK")
  7. click "send invitations"
    => error message appears
Additional Information

I figured that after clicking edit on a affected particpant and saving it without doing any changes the invitations do work. Looking at the database contents I found that the problem is that after importing the "emailstatus" column is set to NULL. Manually editting and saving "wihtout changes" sets it to an empty string though and after this it works.

This issue is related to 15772 and 15823

TagsNo tags attached.
Complete LimeSurvey version number (& build)4.1.7 10454b9ffd90dd23c1673253199051a145dc97f9 (current GitHub master)
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionMySQL 5.7.29
Server OS (if known)
Webserver software & version (if known)
PHP Version7.2.24

Activities

acran

acran

2020-02-27 10:59

reporter  

participants.csv (49 bytes)
acran

acran

2020-02-27 11:18

reporter   ~56231

Submitted a Pull Request: https://github.com/LimeSurvey/LimeSurvey/pull/1395

Issue History

Date Modified Username Field Change
2020-02-27 10:59 acran New Issue
2020-02-27 10:59 acran File Added: participants.csv
2020-02-27 11:18 acran Note Added: 56231