Check data integrity: Difference between revisions
From LimeSurvey Manual
No edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
<translate> | <translate> | ||
<!--T:1--> | |||
__TOC__ | |||
The Check data integrity function checks the consistency and the redundancy of the data. It can be accessed from the Configuration dialog box: | The Check data integrity function checks the consistency and the redundancy of the data. It can be accessed from the Configuration dialog box: | ||
| Line 8: | Line 9: | ||
<center>[[File:Check data integrity configuration.png]]</center> | <center>[[File:Check data integrity configuration.png]]</center> | ||
=Data consistency check= | =Data consistency check=<!--T:2--> | ||
This check 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. | This check 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. | ||
| Line 16: | Line 17: | ||
For everything to be alright, all the values from the screenshot need to meet the consistency standards. | For everything to be alright, all the values from the screenshot need to meet the consistency standards. | ||
=Data redundancy check= | =Data redundancy check=<!--T:3--> | ||
This check looks for tables leftovers, which are created when a user deactivates a survey. For example, if you deactivate a survey, the token tables, the response tables etc., will not be automatically deleted. If you do not need the respective data anymore, use the '''Check data integrity''' function and select the items you wish to be deleted. | This check looks for tables leftovers, which are created when a user deactivates a survey. For example, if you deactivate a survey, the token tables, the response tables etc., will not be automatically deleted. If you do not need the respective data anymore, use the '''Check data integrity''' function and select the items you wish to be deleted. | ||
| Line 22: | Line 23: | ||
<center>[[File:Data redundancy check.png]]</center> | <center>[[File:Data redundancy check.png]]</center> | ||
<!--T:4--> | |||
{{Alert|title=Warning|text=Please note that you cannot undo the deletion. Once you click on the '''Delete checked items!''' button, the data will be forever gone.}} | {{Alert|title=Warning|text=Please note that you cannot undo the deletion. Once you click on the '''Delete checked items!''' button, the data will be forever gone.}} | ||
Revision as of 16:53, 5 September 2017
The Check data integrity function checks the consistency and the redundancy of the data. It can be accessed from the Configuration dialog box:
Data consistency check
This check 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.
For everything to be alright, all the values from the screenshot need to meet the consistency standards.
Data redundancy check
This check looks for tables leftovers, which are created when a user deactivates a survey. For example, if you deactivate a survey, the token tables, the response tables etc., will not be automatically deleted. If you do not need the respective data anymore, use the Check data integrity function and select the items you wish to be deleted.
Warning : Please note that you cannot undo the deletion. Once you click on the Delete checked items! button, the data will be forever gone.
It checks old database tables to see if they may be deleted, LimeSurvey really doesn't delete old responses, but saves them away in an archive table