Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

How to tell whether response is complete in exported results .CSV file

  • minerj
  • minerj's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 8 months ago #142038 by minerj
When you export results from a Limesurvey ( Version 2.05+ Build 140915 ) project, you have the option of selecting All Responses, Completed Responses Only or Incomplete Responses Only. However, in the exported CSV file I see no column indicating whether a response is Completed or Incomplete. Is there any way to export results with an indicator of the completion status?
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 8 months ago #142041 by tpartner
There should be a column with the completed date that will be empty if the response set is incomplete. I can't check the column name right now from my phone but it will be one of the first 4 or 5 columns.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: minerj
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
8 years 8 months ago #142042 by tpartner
...the column name (unsurprisingly) is 'submitdate'.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: minerj
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose