{"id":8981,"date":"2023-09-20T14:56:24","date_gmt":"2023-09-20T13:56:24","guid":{"rendered":"https:\/\/www.threesl.com\/blog\/?p=8981"},"modified":"2023-10-05T09:06:53","modified_gmt":"2023-10-05T08:06:53","slug":"project-administration-integrity-checks-item-integrity-checker","status":"publish","type":"post","link":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/","title":{"rendered":"Project Administration Integrity Checks &#8211; Item Integrity Checker"},"content":{"rendered":"<p>There are situations, as with any database, where integrity issues may occur with the data not matching what is defined in the schema. This could be due to a number of reasons such as:<\/p>\n<ul>\n<li>Items of data that have not yet been populated<\/li>\n<li>Mandatory categories or frames that have not been populated<\/li>\n<\/ul>\n<p>With Cradle also providing the facility for data to be imported and captured in a number of different ways, it is inevitable that the integrity of this data may be questionable. <a href=\"https:\/\/www.threesl.com\/cradle\/help\/7.7\/#documentloader\/other\/ch1_overview.htm\">Document Loader<\/a>, <a href=\"https:\/\/www.threesl.com\/cradle\/help\/7.7\/#headingpages\/cradle_capture_utilities.htm\">capture add-ins<\/a> and <a href=\"https:\/\/www.threesl.com\/cradle\/help\/7.7\/#importexport\/other\/importinfo.htm\">import<\/a> are some of these mechanisms and, despite some protective settings in these tools, it is still possible to bring in data that does not match the current schema.<\/p>\n<p>In addition to this, it is possible to import a project schema itself or modify the project setup which would impact the data that already exists in the database:<\/p>\n<ul>\n<li>Changing item attributes, categories and frames<\/li>\n<li>Changing link rules<\/li>\n<\/ul>\n<p>For these reasons, Cradle provides two utilities in WorkBench that check the data in comparison to Project Setup:<\/p>\n<ul>\n<li>Item Integrity Check<\/li>\n<li>Cross Reference Integrity Check<\/li>\n<\/ul>\n<p>For both of these utilities, the user <em><strong>MUST<\/strong><\/em> have <strong>ACCESS_BYPASS<\/strong> privilege to instigate any changes to the data. It is highly recommended that there are no other active users in the database when the checkers are ran. One way to ensure this is to lock the project using <a href=\"https:\/\/www.threesl.com\/cradle\/help\/7.7\/#projectmanager\/tasks\/lock_unlock_project.htm\">Project Manager<\/a>.<\/p>\n<p>We also recommend that you take a backup of your database and\/or create a <a href=\"https:\/\/www.threesl.com\/cradle\/help\/7.7\/#workbench\/other\/snapshots.htm\">snapshot<\/a> prior to making any changes with these utilities.<\/p>\n<p>In this blog we will focus on the <a href=\"https:\/\/www.threesl.com\/cradle\/help\/7.7\/#workbench\/other\/item_integrity_checker.htm\"><strong>Item Integrity Checker<\/strong><\/a>.<\/p>\n<h2>Item Integrity Checker<\/h2>\n<p>The <strong>Item Integrity Checker<\/strong> is split into two parts:<\/p>\n<ul>\n<li><strong>Frame version checks<\/strong><\/li>\n<li><strong>Item checks<\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_8983\" aria-describedby=\"caption-attachment-8983\" style=\"width: 585px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8983\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png\" alt=\"Item Integrity Checker\" width=\"585\" height=\"492\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png 585w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker-300x252.png 300w\" sizes=\"auto, (max-width: 585px) 100vw, 585px\" \/><figcaption id=\"caption-attachment-8983\" class=\"wp-caption-text\">Item Integrity Checker<\/figcaption><\/figure>\n<h3>Frame Version Checks<\/h3>\n<p>Cradle item types contain a type of attribute called a frame. Each frame can store or manage up to 1 TByte of any kind of data. An item can contain any number of frame attributes.<\/p>\n<p>In practice, most frames store a small amount of text.<\/p>\n<p>These item types also have a mechanism called <em>edit history<\/em> that records any changes that are made to an item. Each edit contains:<\/p>\n<ol>\n<li>The date and time the edit occurred<\/li>\n<li>The Cradle username of the person who performed the edit<\/li>\n<li>The reason the edit was performed, this description is optional<\/li>\n<li>A list of all the attributes (predefined, category values and frames) that were changed in the edit and their old and new values<\/li>\n<\/ol>\n<p>For frames, it records the frame version numbers before and after the edit. All the frames versions are held within the item&#8217;s frame.<\/p>\n<p>These frame version checks detect:<\/p>\n<ul>\n<li>Missing version of any frames<\/li>\n<li>Missing records in any version of any frame<\/li>\n<\/ul>\n<p>To run this utility, select the item type(s) you want to check or <strong>All<\/strong> to check all item types. Then press the left-most <strong>Check<\/strong> button.<\/p>\n<figure id=\"attachment_8984\" aria-describedby=\"caption-attachment-8984\" style=\"width: 251px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8984\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image1.png\" alt=\"Frame Version Checks\" width=\"251\" height=\"230\" \/><figcaption id=\"caption-attachment-8984\" class=\"wp-caption-text\">Frame Version Checks<\/figcaption><\/figure>\n<p>This will check all of the items in each item type selected to ensure each frame has a version of <strong>0<\/strong> and that all history for that frame, occurs in an accumulative sequence of <strong>0<\/strong>, <strong>1<\/strong>, <strong>2<\/strong>, <strong>3<\/strong> etc and produce both a report and a summary in the dialog.<\/p>\n<figure id=\"attachment_8985\" aria-describedby=\"caption-attachment-8985\" style=\"width: 557px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8985\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image2.png\" alt=\"Frame Integrity Check report\" width=\"557\" height=\"478\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image2.png 557w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image2-300x257.png 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><figcaption id=\"caption-attachment-8985\" class=\"wp-caption-text\">Frame Integrity Check report<\/figcaption><\/figure>\n<p>Notice in the dialog, that the <strong>Fix<\/strong> button becomes activated.<\/p>\n<figure id=\"attachment_8986\" aria-describedby=\"caption-attachment-8986\" style=\"width: 220px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8986\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image3.png\" alt=\"Fix button in frame version checks\" width=\"220\" height=\"207\" \/><figcaption id=\"caption-attachment-8986\" class=\"wp-caption-text\">Fix button in frame version checks<\/figcaption><\/figure>\n<p>Pressing this button will repair the history records and can be checked by repeating the process:<\/p>\n<figure id=\"attachment_8987\" aria-describedby=\"caption-attachment-8987\" style=\"width: 216px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8987\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image4.png\" alt=\"Recheck frame versions\" width=\"216\" height=\"201\" \/><figcaption id=\"caption-attachment-8987\" class=\"wp-caption-text\">Recheck frame versions<\/figcaption><\/figure>\n<figure id=\"attachment_8988\" aria-describedby=\"caption-attachment-8988\" style=\"width: 366px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8988\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image5.png\" alt=\"Frame Integrity Check Report - No issues\" width=\"366\" height=\"282\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image5.png 366w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image5-300x231.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><figcaption id=\"caption-attachment-8988\" class=\"wp-caption-text\">Frame Integrity Check Report &#8211; No issues<\/figcaption><\/figure>\n<h3>Item Checks<\/h3>\n<p>On the right-hand side of the <strong>Item Integrity Check<\/strong> dialog, you will see a list of item checks that can be selected, or press All to select and run all checks.<\/p>\n<p>These item checks compare the data that is held in the database with the currently defined settings in <a href=\"https:\/\/www.threesl.com\/cradle\/help\/7.7\/#projectsetup\/other\/project_setup.htm\">Project Setup<\/a> to ensure they are consistent. If they are not, the utility will list any possible issues.<\/p>\n<figure id=\"attachment_8989\" aria-describedby=\"caption-attachment-8989\" style=\"width: 431px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8989\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image6.png\" alt=\"Item Checks\" width=\"431\" height=\"680\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image6.png 431w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image6-190x300.png 190w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><figcaption id=\"caption-attachment-8989\" class=\"wp-caption-text\">Item Checks<\/figcaption><\/figure>\n<p>Once you have pressed the <strong>Check<\/strong> button, a report is produced and a summary appears in the dialog:<\/p>\n<figure id=\"attachment_8990\" aria-describedby=\"caption-attachment-8990\" style=\"width: 448px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8990\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image7.png\" alt=\"Item check results\" width=\"448\" height=\"221\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image7.png 448w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image7-300x148.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><figcaption id=\"caption-attachment-8990\" class=\"wp-caption-text\">Item check results<\/figcaption><\/figure>\n<figure id=\"attachment_8991\" aria-describedby=\"caption-attachment-8991\" style=\"width: 535px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8991\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image8.png\" alt=\"Database Item Integrity Check report\" width=\"535\" height=\"326\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image8.png 535w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image8-300x183.png 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><figcaption id=\"caption-attachment-8991\" class=\"wp-caption-text\">Database Item Integrity Check report<\/figcaption><\/figure>\n<p>As with the frame integrity check, there is a <strong>Fix<\/strong> button but this can only apply to a number of checks. The ones that cannot be automatically fixed will appear on the report and will require some user intervention to correct the issue.<\/p>\n<p>Below is a list of the issues that can be automatically fixed:<\/p>\n<figure id=\"attachment_8992\" aria-describedby=\"caption-attachment-8992\" style=\"width: 715px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8992\" src=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image9.png\" alt=\"Issues that can be fixed\" width=\"715\" height=\"453\" srcset=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image9.png 715w, https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/Image9-300x190.png 300w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><figcaption id=\"caption-attachment-8992\" class=\"wp-caption-text\">Issues that can be fixed<\/figcaption><\/figure>\n<h2>Summary<\/h2>\n<p>In this post we have addressed some of the checks that can be run on items in the database to confirm their data integrity using the <strong>Item Integrity Checker<\/strong>.<\/p>\n<p>Please remember that the user <em><strong>MUST<\/strong><\/em> have <strong>ACCESS_BYPASS<\/strong> privilege to instigate any changes to the data and it is highly recommended that there are no other active users in the database.<\/p>\n<p>Next we will discuss the <strong>Cross Reference Integrity Checker<\/strong>.<\/p>\n<aside class=\"mashsb-container mashsb-main mashsb-stretched\"><div class=\"mashsb-box\"><div class=\"mashsb-buttons\"><a class=\"mashicon-twitter mash-small mash-center mashsb-noshadow\" href=\"https:\/\/twitter.com\/intent\/tweet?text=&amp;url=https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/&amp;via=threesl\" target=\"_top\" rel=\"nofollow\"><span class=\"icon\"><\/span><span class=\"text\">Tweet<\/span><\/a><a class=\"mashicon-facebook mash-small mash-center mashsb-noshadow\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.threesl.com%2Fblog%2Fproject-administration-integrity-checks-item-integrity-checker%2F\" target=\"_top\" rel=\"nofollow\"><span class=\"icon\"><\/span><span class=\"text\">Share<\/span><\/a><a class=\"mashicon-subscribe mash-small mash-center mashsb-noshadow\" href=\"#\" target=\"_top\" rel=\"nofollow\"><span class=\"icon\"><\/span><span class=\"text\">Newsletter<\/span><\/a><div class=\"onoffswitch2 mash-small mashsb-noshadow\" style=\"display:none\"><\/div><\/div>\n            <\/div>\n                <div style=\"clear:both\"><\/div><\/aside>\n            <!-- Share buttons by mashshare.net - Version: 4.0.47-->","protected":false},"excerpt":{"rendered":"<p>There are situations, as with any database, where integrity issues may occur with the data not matching what is defined in the schema. This could be due to a number of reasons such as: Items of data that have not yet been populated Mandatory categories or frames that have not been populated With Cradle also &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Project Administration Integrity Checks &#8211; Item Integrity Checker&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"no","footnotes":""},"categories":[6],"tags":[542,330],"class_list":["post-8981","post","type-post","status-publish","format-standard","hentry","category-tips","tag-frames","tag-items"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Item Integrity Checker<\/title>\n<meta name=\"description\" content=\"This post details the Item Integrity Checker which allows you to perform integrity checks on your Cradle project database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Item Integrity Checker\" \/>\n<meta property=\"og:description\" content=\"This post details the Item Integrity Checker which allows you to perform integrity checks on your Cradle project database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/\" \/>\n<meta property=\"og:site_name\" content=\"3SL Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/3SLCradle\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-20T13:56:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-05T08:06:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png\" \/>\n<meta name=\"author\" content=\"Jan Lamb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@threesl\" \/>\n<meta name=\"twitter:site\" content=\"@threesl\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jan Lamb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/\"},\"author\":{\"name\":\"Jan Lamb\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/person\\\/4be1c5043a6af6683cc5592c94a0872f\"},\"headline\":\"Project Administration Integrity Checks &#8211; Item Integrity Checker\",\"datePublished\":\"2023-09-20T13:56:24+00:00\",\"dateModified\":\"2023-10-05T08:06:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/\"},\"wordCount\":873,\"publisher\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/integrity_checker.png\",\"keywords\":[\"frames\",\"items\"],\"articleSection\":[\"Hints &amp; Tips\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/\",\"name\":\"Item Integrity Checker\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/integrity_checker.png\",\"datePublished\":\"2023-09-20T13:56:24+00:00\",\"dateModified\":\"2023-10-05T08:06:53+00:00\",\"description\":\"This post details the Item Integrity Checker which allows you to perform integrity checks on your Cradle project database\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/integrity_checker.png\",\"contentUrl\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/integrity_checker.png\",\"width\":585,\"height\":492,\"caption\":\"Item Integrity Checker\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/project-administration-integrity-checks-item-integrity-checker\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Project Administration Integrity Checks &#8211; Item Integrity Checker\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/\",\"name\":\"3SL Blog\",\"description\":\"From concept to creation\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#organization\",\"name\":\"3SL\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/3SL_Logo_Medium.png\",\"contentUrl\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/3SL_Logo_Medium.png\",\"width\":152,\"height\":80,\"caption\":\"3SL\"},\"image\":{\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/facebook.com\\\/3SLCradle\",\"https:\\\/\\\/x.com\\\/threesl\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.threesl.com\\\/blog\\\/#\\\/schema\\\/person\\\/4be1c5043a6af6683cc5592c94a0872f\",\"name\":\"Jan Lamb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3139f592e413f881ae5026cd037aec5b2c5bb8dd3aed56c53b140b09e81c4b1c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3139f592e413f881ae5026cd037aec5b2c5bb8dd3aed56c53b140b09e81c4b1c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3139f592e413f881ae5026cd037aec5b2c5bb8dd3aed56c53b140b09e81c4b1c?s=96&d=mm&r=g\",\"caption\":\"Jan Lamb\"},\"sameAs\":[\"https:\\\/\\\/www.threesl.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Item Integrity Checker","description":"This post details the Item Integrity Checker which allows you to perform integrity checks on your Cradle project database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/","og_locale":"en_GB","og_type":"article","og_title":"Item Integrity Checker","og_description":"This post details the Item Integrity Checker which allows you to perform integrity checks on your Cradle project database","og_url":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/","og_site_name":"3SL Blog","article_publisher":"http:\/\/facebook.com\/3SLCradle","article_published_time":"2023-09-20T13:56:24+00:00","article_modified_time":"2023-10-05T08:06:53+00:00","og_image":[{"url":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png","type":"","width":"","height":""}],"author":"Jan Lamb","twitter_card":"summary_large_image","twitter_creator":"@threesl","twitter_site":"@threesl","twitter_misc":{"Written by":"Jan Lamb","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/#article","isPartOf":{"@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/"},"author":{"name":"Jan Lamb","@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/person\/4be1c5043a6af6683cc5592c94a0872f"},"headline":"Project Administration Integrity Checks &#8211; Item Integrity Checker","datePublished":"2023-09-20T13:56:24+00:00","dateModified":"2023-10-05T08:06:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/"},"wordCount":873,"publisher":{"@id":"https:\/\/www.threesl.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/#primaryimage"},"thumbnailUrl":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png","keywords":["frames","items"],"articleSection":["Hints &amp; Tips"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/","url":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/","name":"Item Integrity Checker","isPartOf":{"@id":"https:\/\/www.threesl.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/#primaryimage"},"image":{"@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/#primaryimage"},"thumbnailUrl":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png","datePublished":"2023-09-20T13:56:24+00:00","dateModified":"2023-10-05T08:06:53+00:00","description":"This post details the Item Integrity Checker which allows you to perform integrity checks on your Cradle project database","breadcrumb":{"@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/#primaryimage","url":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png","contentUrl":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2023\/09\/integrity_checker.png","width":585,"height":492,"caption":"Item Integrity Checker"},{"@type":"BreadcrumbList","@id":"https:\/\/www.threesl.com\/blog\/project-administration-integrity-checks-item-integrity-checker\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.threesl.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Project Administration Integrity Checks &#8211; Item Integrity Checker"}]},{"@type":"WebSite","@id":"https:\/\/www.threesl.com\/blog\/#website","url":"https:\/\/www.threesl.com\/blog\/","name":"3SL Blog","description":"From concept to creation","publisher":{"@id":"https:\/\/www.threesl.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.threesl.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.threesl.com\/blog\/#organization","name":"3SL","url":"https:\/\/www.threesl.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2017\/02\/3SL_Logo_Medium.png","contentUrl":"https:\/\/www.threesl.com\/blog\/wp-content\/uploads\/2017\/02\/3SL_Logo_Medium.png","width":152,"height":80,"caption":"3SL"},"image":{"@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/3SLCradle","https:\/\/x.com\/threesl"]},{"@type":"Person","@id":"https:\/\/www.threesl.com\/blog\/#\/schema\/person\/4be1c5043a6af6683cc5592c94a0872f","name":"Jan Lamb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/3139f592e413f881ae5026cd037aec5b2c5bb8dd3aed56c53b140b09e81c4b1c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3139f592e413f881ae5026cd037aec5b2c5bb8dd3aed56c53b140b09e81c4b1c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3139f592e413f881ae5026cd037aec5b2c5bb8dd3aed56c53b140b09e81c4b1c?s=96&d=mm&r=g","caption":"Jan Lamb"},"sameAs":["https:\/\/www.threesl.com\/"]}]}},"modified_by":"Jan Lamb","_links":{"self":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts\/8981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/comments?post=8981"}],"version-history":[{"count":5,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts\/8981\/revisions"}],"predecessor-version":[{"id":8998,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/posts\/8981\/revisions\/8998"}],"wp:attachment":[{"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/media?parent=8981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/categories?post=8981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.threesl.com\/blog\/wp-json\/wp\/v2\/tags?post=8981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}