Actions

Difference between revisions of "Check data integrity"

From LimeSurvey Manual

(Marked this version for translation)
Line 5: Line 5:
 
__TOC__
 
__TOC__
  
=General=
+
=General= <!--T:5-->
  
 +
<!--T:6-->
 
The '''Check data integrity''' function checks the consistency and the redundancy of the data. It can be accessed from the '''Configuration''' dialog:
 
The '''Check data integrity''' function checks the consistency and the redundancy of the data. It can be accessed from the '''Configuration''' dialog:
  
 +
<!--T:7-->
 
<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-->
 
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.
 
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.
  
 +
<!--T:9-->
 
<center>[[File:Data consistency check.png]]</center>
 
<center>[[File:Data consistency check.png]]</center>
  
 +
<!--T:10-->
 
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=<!--T:3-->
+
=Data redundancy check= <!--T:3-->
  
 +
<!--T:11-->
 
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:
 
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:
  
 +
<!--T:12-->
 
<center>[[File:Data redundancy check.png]]</center>
 
<center>[[File:Data redundancy check.png]]</center>
  

Revision as of 10:57, 11 September 2017

Other languages:
Deutsch • ‎English • ‎日本語 • ‎Nederlands

General

The Check data integrity function checks the consistency and the redundancy of the data. It can be accessed from the Configuration dialog:

Check data integrity configuration.png

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.

Data consistency check.png

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:

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