Check data integrity

From LimeSurvey Manual

Revision as of 13:20, 26 May 2021 by Vharris (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Other languages:
Deutsch • ‎English • ‎Nederlands • ‎español • ‎français • ‎italiano • ‎magyar • ‎polski • ‎română • ‎slovenščina • ‎български • ‎日本語


The Check data integrity function checks the consistency and the redundancy of 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, ...

Data consistency check.png

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
Important.png  Warning : Please note that you cannot undo the deletion. Once you click on the Delete checked items! button, the data will be gone forever.