![\"\"](\"http:\/\/blog.felineflock.com\/wp-content\/uploads\/2011\/05\/appsetupcustomsettings.jpg\" "\\"AppSetupCustomSettings\\"")
<\/p>\nWhile working on a recruiting application, I found a solution for being able to load data into a SalesForce application without being blocked by validation rules.<\/p>\n
Validation rules are usually intended to be applied only when a user creates a record and not when data is being imported from an external database. In this recruiting application, candidate records go several stages in a sequence (1-lead, 2-phone, 3-applicant, 4-interview, 5-contract negotiation, etc.) and this validation rule prevented the import process from loading candidate records in a stage higher than lead.<\/p>\n
<\/p>\n
So the solution was to create a Custom Setting of type Hierarchy with a flag\/checkbox in it that disables validation rules for a given user or profile. That is, all the validation rules will include this flag and only\u00a0apply\u00a0when\u00a0the value of this flag is enabled.<\/p>\n
To implement it:<\/p>\n
1) click Setup, then on the left side, click App Setup\/Develop\/Custom Settings.<\/p>\n
2) click New and create your settings as hierarchy\/public<\/p>\n
3) now create a custom field of type Checkbox: \u00a0click New, select Checkbox, click Next, type the name of the field as “Disable Validation Rules”, default to Unchecked, click Next, then click Save.<\/p>\n 4) in the Custom Setting Definition\/Your App Settings screen, click Manage to start configuring the setting you just created.<\/p>\n 5) click the New button above “Default Organization Level Value”, leave the checkbox “Disable Validation Rules” unchecked and then click Save.<\/p>\n 6) click “Back to List”, click the New button at the bottom, select Profile or User then choose the user id or profile that will perform the data loading, then click “Disable Validation Rules” and click Save.<\/p>\n 7) now edit the validation rule appending the expression (highlighted below) 9) now the validation rule will only apply if the setting checkbox 10) you can now load data freely and then, later, re-enable all 11) you can use this way of implementing Custom Settings on Pertinent Articles: While working on a recruiting application, I found a solution for being able to load data into a SalesForce application without being blocked by validation rules. Validation rules are usually intended to be applied only when a user creates a record and not when data is being imported from an external database. In this recruiting […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[8,18],"tags":[],"class_list":["post-56","post","type-post","status-publish","format-standard","hentry","category-data-load","category-validation"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/posts\/56","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/comments?post=56"}],"version-history":[{"count":0,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/posts\/56\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/media?parent=56"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/categories?post=56"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.felineflock.com\/index.php\/wp-json\/wp\/v2\/tags?post=56"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"http:\/\/blog.felineflock.com\/wp-content\/uploads\/2011\/05\/appsetupcustomsettings2.jpg\" "\\"AppSetupCustomSettings2\\"")
<\/a><\/p>\n
\n&& NOT( $Setup.Your_App_Settings__c.Disable_Validation_Rules__c )<\/strong><\/p>\n<\/a>\u00a0 8 ) click Save<\/p>\n
\nDisable Validation Rules is unchecked for your profile\/user<\/p>\n
\nvalidation rules for your profile\/user by changing the custom
\nsetting.<\/p>\n
\ntriggers too, just use the syntax below:<\/p>\n Your_App_Settings__c s =\u00a0\n Your_App_Settings__c.getInstance( UserInfo.GetUserID() ); \/\/or Profile<\/var><\/span>\n if( s.Disable_Validation_Rules__c ) return; \/\/ skip trigger...<\/em><\/span><\/pre>\n
\n–\u00a0Accessing Custom Settings<\/a>
\n– Let’s make some magic…<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"