Check data integrity

From LimeSurvey Manual

Revision as of 10:57, 11 September 2017 by Cdorin (talk | contribs) (Marked this version for translation)
Other languages:
Deutsch • ‎English • ‎日本語 • ‎Nederlands


The Check data integrity function checks the consistency and the redundancy of the data. It can be accessed from the Configuration dialog:

Check data integrity configuration.png

Data consistency check

It looks for possible errors that might exist between the response tables and survey tables or between the token list and the CPDB, and so on.

Data consistency check.png

For everything to be alright, all the values from the screenshot need to meet the consistency standards.

Data redundancy check

If you deactivate a survey, the token tables, the response tables etc., will not be automatically deleted. They will get stored in archived tables. If you do not need them anymore, use the Check data integrity function and select the "leftovers" you wish to delete:

Data redundancy check.png
Warning : Please note that you cannot undo the deletion. Once you click on the Delete checked items! button, the data will be forever gone.