Check data integrity/en - Revision history

FuzzyBot: Updating to match new version of source page

2024-02-16T11:05:12Z

Updating to match new version of source page

← Older revision		Revision as of 13:05, 16 February 2024
Line 19:		Line 19:
	=== Additional parameter for response table field checks ===		=== Additional parameter for response table field checks ===
	Starting with version 6.x you can set an additional parameter to the integrity check URL named checkResponseTableFields.		Starting 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.		Just add the following text to the end of the URL

			<code>?checkResponseTableFields=y</code>

			and press enter.
	If you set this parameter, 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.		If you set this parameter, 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.

FuzzyBot: Updating to match new version of source page

2024-02-16T10:35:26Z

Updating to match new version of source page

← Older revision		Revision as of 12:35, 16 February 2024
Line 5:		Line 5:
	==General==		==General==

	The '''~~Check data~~ integrity''' function checks the consistency and the redundancy of data. It can be accessed from the '''~~Configuration~~''' ~~dialog:~~		The '''Data integrity''' function checks the consistency and the redundancy of data. It can be accessed from the top menu, section '''Advanced''', menu item '''Data integrity'''. When opening this menu entry, it will immediately start checking your data for any faults.

	~~<center>[[File~~:~~Check data integrity configuration.png]]</center>~~
			In general two categories of checks will be executed:
			* Data consistency
			* Data redundancy

	==Data consistency check==		==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, ...		This check looks for possible errors that might exist between the response tables and survey tables or between the token list and the CPDB, etc. If it finds errors, most of them will be automatically fixed, for some you will be asked if they should be fixed.
			In general, we advise letting the integrity check fix these errors. After the fixes are done, please run the check again, until no more errors can be found.
	~~<center>[[File:Data consistency~~ check.~~png]]</center>~~

	~~All~~ the ~~values from~~ the ~~screenshot need to meet the consistency standards~~.

	=== Additional parameter for response table field checks ===		=== 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.		Starting 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.		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.		If you set this parameter, 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==		==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:		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>~~

	{{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 gone forever.}}		{{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 gone forever.}}

FuzzyBot: Updating to match new version of source page

2024-02-16T09:58:15Z

Updating to match new version of source page

← Older revision		Revision as of 11:58, 16 February 2024
Line 3:		Line 3:
	__TOC__		__TOC__

	=General=		==General==

	The '''Check data integrity''' function checks the consistency and the redundancy of data. It can be accessed from the '''Configuration''' dialog:		The '''Check data integrity''' function checks the consistency and the redundancy of data. It can be accessed from the '''Configuration''' dialog:
Line 9:		Line 9:
	<center>[[File:Check data integrity configuration.png]]</center>		<center>[[File:Check data integrity configuration.png]]</center>

	=Data consistency check=		==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, ...		It looks for possible errors that might exist between the response tables and survey tables or between the token list and the CPDB, ...
Line 17:		Line 17:
	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=		=== 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:		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:

FuzzyBot: Updating to match new version of source page

2021-05-31T11:34:20Z

Updating to match new version of source page

← Older revision		Revision as of 13:34, 31 May 2021
Line 11:		Line 11:
	=Data consistency check=		=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~~.		It looks for possible errors that might exist between the response tables and survey tables or between the token list and the CPDB, ...

	<center>[[File:Data consistency check.png]]</center>		<center>[[File:Data consistency check.png]]</center>

	~~For everything to be alright, 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=		=Data redundancy check=

FuzzyBot: Updating to match new version of source page

2018-06-12T10:30:02Z

Updating to match new version of source page

← Older revision		Revision as of 12:30, 12 June 2018
Line 5:		Line 5:
	=General=		=General=

	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 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 23:		Line 23:
	<center>[[File:Data redundancy check.png]]</center>		<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~~.}}		{{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 gone forever.}}

FuzzyBot: Updating to match new version of source page

2017-09-11T09:00:02Z

Updating to match new version of source page

New page

<languages />

__TOC__

=General=

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>

=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.

<center>[[File:Data consistency check.png]]</center>

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:

<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.}}