Check data integrity: Difference between revisions
From LimeSurvey Manual
mNo edit summary |
(Updated title headers - add information on new parameter) |
||
| Line 5: | Line 5: | ||
__TOC__ | __TOC__ | ||
=General= <!--T:5--> | ==General== <!--T:5--> | ||
<!--T:6--> | <!--T:6--> | ||
| Line 13: | Line 13: | ||
<center>[[File:Check data integrity configuration.png]]</center> | <center>[[File:Check data integrity configuration.png]]</center> | ||
=Data consistency check= <!--T:2--> | ==Data consistency check== <!--T:2--> | ||
<!--T:8--> | <!--T:8--> | ||
| Line 24: | Line 24: | ||
All the values from the screenshot need to meet the consistency standards. | All the values from the screenshot need to meet the consistency standards. | ||
=Data redundancy check= <!--T:3--> | === Additional parameter for response table field checks === | ||
Start with version 6.x you can set an additional parameter to the integrity check URL named checkResponseTableFields. | |||
Just add the following text to the URL: ?checkResponseTableFields=y and press enter. | |||
If you set this parameter this an additional check will be executed, which checks if all fields in all response tables have correct names, which can take a long time to complete. | |||
==Data redundancy check== <!--T:3--> | |||
<!--T:11--> | <!--T:11--> | ||
Revision as of 11:57, 16 February 2024
General
The Check data integrity function checks the consistency and the redundancy of data. It can be accessed from the Configuration dialog:
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, ...
All the values from the screenshot need to meet the consistency standards.
Additional parameter for response table field checks
Start with version 6.x you can set an additional parameter to the integrity check URL named checkResponseTableFields. Just add the following text to the URL: ?checkResponseTableFields=y and press enter. If you set this parameter this an additional check will be executed, which checks if all fields in all response tables have correct names, which can take a long time to complete.
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:
Warning : Please note that you cannot undo the deletion. Once you click on the Delete checked items! button, the data will be gone forever.