Data Integrity

Data Integrity

General

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


Data consistency check

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 the Delete checked items! button, the data will be permanently deleted.

    • Related Articles

    • Introduction

      General Advanced is the first menu under Configuration located in the top navigation bar of the home page. The functionality here can be used to change survey themes, add/edit label sets, check for data consistency, and do a backup of your database. ...
    • Overview - Configuration Tab

      General The Configuration tab contains three menus: Advanced, Users, and Settings. Advanced menu The functionality here can be used to change survey themes, add/edit label sets, check for data consistency, and do a backup of your database. It also ...
    • Backup Entire Database

      General If you would like to upgrade your LimeSurvey installation or transfer it to another location/server, we highly recommend that you back up all your data (questions, participants, responses, etc.). You can use the Backup entire database ...
    • Manage Users

      User management The user management tool allows you to add additional administration users to LimeSurvey. We refer to them as 'users'.  Do not confuse them with survey participants. Add users To add a new user, under Configuration (located on the ...
    • ComfortUpdate

      General ComfortUpdate is a professional service from LimeSurvey GmbH to update LimeSurvey easily from your web browser with just a few mouse clicks (instead of having to perform a manual update). To use and test ComfortUpdate, you have to sign up on ...