Check data integrity: Difference between revisions
From LimeSurvey Manual
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<languages /> | <languages /> | ||
<translate> | <translate> | ||
_TOC_ | |||
The Check data integrity function checks the consistency and the redundancy of the data. It can be accessed from the Configuration dialog box: | |||
<center>[[File:Check data integrity configuration.png]]</center> | |||
=Data consistency check= | =Data consistency check= | ||
| Line 6: | Line 12: | ||
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. | ||
[[File:Data consistency check.png]] | <center>[[File:Data consistency check.png]]</center> | ||
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. | ||
| Line 14: | Line 20: | ||
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. | ||
[[File:Data redundancy check.png]] | <center>[[File:Data redundancy check.png]]</center> | ||
{{ | {{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.}} | ||
It | 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 | ||
</translate> | </translate> | ||
Revision as of 16:24, 5 September 2017
_TOC_
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