topic Re: Demand Tools Mass Effect Question in DemandTools

Demand Tools Mass Effect Question

LeonaBelkMSSU — Mon, 13 Feb 2023 17:48:53 GMT

Hello Validity Community! I have used Demand Tools for several years now, recently upgrading to Demand Tools V. One thing I cannot seem to do with the new platform is Mass Effect using a .csv file. I tend to use this feature a lot for updating one field on a small group of records, versus updating every record. Is this something I am completely missing in Demand Tools V? Or perhaps something that will be coming soon? For now I have been going back to the old version but I would prefer to not go that route. I looked under the Modify option but do not see where we can upload a file.

Re: Demand Tools Mass Effect Question

AnthonyValidity — Wed, 15 Feb 2023 13:37:31 GMT

Hi @LeonaBelkMSSU ,

Thank you for reaching out - happy to see you here! This is a good quesiton.

DemandTools V (DTV)'s Import module is what you're looking for. It allows you to update, insert, or upsert in one scenario. You can use either key fields or use match criteria if you do not have the Salesforce IDs.

The Modify module would be used for conditional batches where the value is the same across all the records, and the Import module would be best to use when you have a file and the values for each record are different.

Common use cases for the Import module:

Import and Match a list of Leads from a trade show
Import new target accounts
Migrate data from legacy systems
Insert records into newly created custom objects
Insert Products and Pricebooks
Add or reassign account teams
Update records using email address (or other external ids) as the key
Populate newly created custom fields
Schedule regular imports, updates, or upserts
Transform data on insert or update using standardization formulas

You can find training videos in the DemandTools V (DTV) Videos section of our Help Center.

Hope this helps!

Regards,

Anthony
Customer Success Manager

Re: Demand Tools Mass Effect Question

LeonaBelkMSSU — Mon, 13 Feb 2023 22:22:15 GMT

Thank you @AnthonyValidity . I saw the training videos but had not found the time to watch any of them. I appreciate your thourough explanation. That is definitely good information to have. I look forward to using this module.

Re: Demand Tools Mass Effect Question

AnthonyValidity — Tue, 14 Feb 2023 00:26:37 GMT

My pleasure, @LeonaBelkMSSU !

If you ever have functionality or use case questions feel free to join our Expert Office Hours. We have fun and love helping out!

Best,

Anthony
Customer Success Manager

Re: Demand Tools Mass Effect Question

James_D — Wed, 09 Aug 2023 15:56:49 GMT

Thanks so asking this question as I was also struggling.

Re: Demand Tools Mass Effect Question

ken_shaw — Tue, 05 Mar 2024 19:23:42 GMT

Thanks for the question and the answer. "Import" is not an intuitive name for "modify from file", and every time I come back to Demand Tools V I struggle with this question (and go back to the old version).