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
Forum Posts
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...
Scenario Example to replicate PeopleImport with DTV Import Upsert
Revised 3/23/2023 with appendix notes at the end on how to update after adding campaign members.If you're looking to replicate PeopleImport with the new DTV, here's an outline of how I've made this work using Import / Upsert.In the steps outlined bel...
Formula Limit
Is there a limit to the number of relationships/lookups you can include in a formula in Modify? I'm trying to switch the Contact in a custom Primary Contact field on an Account to another contact on the Contact's new Account to facilitate a merger. I...
Resolved! International Phone Fix Formula Syntax Issues
I am trying to fix international mobile phone numbers using Modify and I am having trouble with the formula.The formula is: IntlPhoneFix(phone, country)So adding my field name and country I get: IntlPhoneFix(${MobilePhone},Germany)Has anyone had any ...
Resolved! How to count how many records we deduped?
HI All,I am a Salesforce Admin at a non profit. We use Demand Tools mainly to dedupe and merge accounts and contacts. Is there a way to see how many contacts we merged in a specific period? I can estimate how many records I reviewed (I download those...
Resolved! Remove a non-alpha character from the Title field
Hi everyone - easy question here for someone. We have an external tool that adds '^' to a Contact's title. For instance, the contact's title would be '^Accountant^'. I'm looking to run a cleanup job every night that would remove the Caret Notation ma...
Deduping strategies (loose criteria)
Hi everyone! I've gone through a few passes now to clean up out individual Lead record duplicates. Now I get into the realm of duplicates occurring because names are misspelled...first and/or last. Sometimes you can tell just by looking what it sh...
Resolved! Dedupe Module - Blank Value
Hello everyone, I am having confusion on using the "Blank Values" option in Step 2 of the Dedupe Module. It seems like when I set up my conditions, and then turn on "Blank Values" for my MailingStreet field condition, it looks like I'm not getting an...
The Trainings Are Great! Keep 'em coming!!!
I love the monthly training sessions on the various Demand Tools modules. They have propelled my skills from beginner to super user. Thanks!!!
Ask Me Anything Series
DemandTools Newsletter
Read the DemandTools 5.43.0 Release notes (September, 2024)
