DemandTools - Validity

Unable to login

Hello, I am having an issue with loggin into the tool. My teammate and I have been receiving this message when we attempt to login: Unable to find valid certification path: a valid trusted certificate is required to run Java for DemandTools, Import o...

Formula to Find "Bob And Mary Smith" and "Steve and Lisa Jones"

@Hydey_Validity I'm onto another Contact change where I want to find "Bob And Mary Smith". I find these using your % And %. I also find "Steve and Lisa Jones"(lower case "a"nd). When I later grab all the characters before the "And" and after the "...

Workaround for DTV Import Upsert Crash when adding another mapping for a field (version 5.24.1)

DTV Import Upsert is crashing on save scenario after selecting Add another mapping for a mapped field and then clicking Save scenario.To workaround this crash, add the additional field mapping and then select Scenario Save As. Once you do Save As, yo...

LOVE DemandTools! Will not work without it!

Hello,I am proud to say I have been using DemandTools for around 15 years now!I have been a Salesforce System Administrator since 2004 and cannot say enough on the difference DemandTools has made managing data in Salesforce. The tool has literally sa...

Resolved! Nested IF Formulas

Is it possible to use a Nested IF Formula to set a field value in the Modify module? And if so, is there a limit on the number of IFs you can nest? When I tried creating one and I clicked the button to "Check Formula" my screen turn entirely white ...

Export DTV Grid data with a common DedupKey

Hello,I'd like to import my grid data into SF to do some more refinement and exclusions based on child records and comparison of values between certain fields. I plan to use SF reports for this and so I'd like to group a common DedupKey in SF. The ...

Can't update my DemandTools V to 24.1

I use two different computers for work - my laptop and my desktop - both on windows. I was running DemandTools V v22 on both and when I opened it up I was notified there was an update to v24.1. I downloaded the update and tried to install it on bot...

Resolved! Old "Find IDs" module

Hey there! Was the old "Find IDs" module replaced with something that I have simply overlooked so far? I used to use the all the time on an older version, but have found myself doing mass VLookups too much lately and wondered if I was missing somethi...

UK deduping

Hi, does anybody have any suggestions for finding UK postcodes which are incorrectly formatted? Usually no space in the correct place. Also how to fix this. Thank you

Workaround for DTV Import when changing input file on existing scenario (applies to DTV 5.24.1.0)

If you load an existing DTV Import scenario, and change the input file, and then attempt to Save the Scenario, and get an error message Reqeust Processing Failed, or Something Unexpected Happened. There are two was to workaround this. You can either...

Validity Customer Community

Forum Posts

Unable to login

Formula to Find "Bob And Mary Smith" and "Steve and Lisa Jones"

Workaround for DTV Import Upsert Crash when adding another mapping for a field (version 5.24.1)

LOVE DemandTools! Will not work without it!

Resolved! Nested IF Formulas

Export DTV Grid data with a common DedupKey

Can't update my DemandTools V to 24.1

Resolved! Old "Find IDs" module

UK deduping

Workaround for DTV Import when changing input file on existing scenario (applies to DTV 5.24.1.0)

Dedupe Winner Rule When Records Exact Same

Opportunity Export - Amount (Converted)

Override/ignore to prevent Proper update of "IT" -...

How can I replicate FieldCopyUnique on Other Addre...

How to find duplicate email address across Leads a...

Get your blog on

Resolved! Nested IF Formulas

Resolved! Old "Find IDs" module

Ask Me Anything Series

DemandTools Newsletter

Get your blog on