Actions

Check data integrity: Difference between revisions

From LimeSurvey Manual

mNo edit summary
No edit summary
Line 7: Line 7:
=General=
=General=


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:


<center>[[File:Check data integrity configuration.png]]</center>
<center>[[File:Check data integrity configuration.png]]</center>
Line 13: Line 13:
=Data consistency check=<!--T:2-->
=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.
It 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.


<center>[[File:Data consistency check.png]]</center>
<center>[[File:Data consistency check.png]]</center>
Line 21: Line 21:
=Data redundancy check=<!--T:3-->
=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.
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:


<center>[[File:Data redundancy check.png]]</center>
<center>[[File:Data redundancy check.png]]</center>
Line 27: Line 27:
<!--T:4-->
<!--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.}}
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 10:55, 11 September 2017

General

The Check data integrity function checks the consistency and the redundancy of the 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, and so on.

For everything to be alright, 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:

  Warning : Please note that you cannot undo the deletion. Once you click on the Delete checked items! button, the data will be forever gone.