You need to sign in to do that
Don't have an account?
pintoo rajput
Need to insert records using dataloader..
I need to upload 100 contacts using dataloader, we have some validation rule on contact object, now my requirement is the validation rule should impose for 1 to 50 records and should not impose for 51 to 100 records, how to achieve this?
Thanks in Advance
Thanks in Advance
Override_Validation_Rules__c = FALSE
Then add a column to your CSV file for this field and mark TRUE for the 50 records that you don't want to apply the Validation rule to, and FALSE for the other 50 records.
All Answers
2. Process first excel sheet using the Data Loader
3. Before processing second excel sheet make sure to Deactivate the Validation rule.
4.Once process done, activate the Data Loader
Override_Validation_Rules__c = FALSE
Then add a column to your CSV file for this field and mark TRUE for the 50 records that you don't want to apply the Validation rule to, and FALSE for the other 50 records.
True that you shouldn't create a new field to process just 50 records.
The good part is that you can reuse this going forward. And if you add it to all -or most- Validations you create, next time you need to override a couple of rules you don't need to go around deactivating and activating a bunch of them.