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 primary menus: Advanced, Users, and Settings. Advanced Menu This section lets you change survey themes, edit label sets, check data consistency, and back up the database. The available options are: Themes ...

    • Manage Users

      User Management The user management tool allows you to add additional administration users to LimeSurvey. These are referred to as 'users' and should not be confused with survey participants. Add Users To add a new user, navigate to Configuration on ...

    • Backup Entire Database

      Overview The "Backup Entire Database" function in LimeSurvey enables users to export all application data, including surveys, participant information, and responses, as a .sql file that the browser prompts you to save. This feature is accessible ...

    • Global Settings

      Overview Global Settings in LimeSurvey can be accessed via Configuration → Settings → Global settings, where the options are grouped across several screens. Only administrators with the "Settings and Plugin permission" may modify these ...