web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Uploading Contacts - B...
Microsoft Dynamics CRM (Archived)
Active Discussion

Uploading Contacts - Best Practice

(0) ShareShare
ReportReport
Posted on by sushicat_san

Hi All, 

I have about 300 reps in the field and we are going to have them start uploading their contact information into Dynamics CRM 2016 (on-prem) for the first time. Does anyone have any best practices for such a large group?

My initial thought is to create an upload template to try and minimize the clean up that my team will have to do, but I've got no illusions to the fact that their will be clean up. 

Any stories, best practices, add-ons that will help would be much appreciated! Thanks! 

*This post is locked for comments

  • sandeepstw Profile Picture
    sandeepstw 4,601 on at

    Hi,

    You can make a file and upload using data management in Dynamics crm. For more details you can see this link

    [View:https://docs.microsoft.com/en-us/dynamics365/customer-engagement/basics/import-contacts:750:50]

    You can download template file as per given in this image

    2018_2D00_06_2D00_12_5F00_0015.png

  • Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    Hi David Edwards,

    The approach I would take is to import the contact information using SQL Server Integration Services (SSIS) and KingswaySoft. Are you extracting the contact information from another system?

  • Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at

    HI David,

    Main questions is what format are those contacts in right now?

    If you have them in Excel, it might be easiest to use the Excel Template and use that for uploading the contacts.

    If you have them in other formats, maybe create a staging database, and import them using SSIS or SCRIBE.

    Hope this helps.

  • sushicat_san Profile Picture
    sushicat_san on at

    Thank you Sandeep. I'm am planning on using the upload template for contacts.

  • sushicat_san Profile Picture
    sushicat_san on at

    Thanks Adrian. We are not extracting from a different system. We're having the reps enter the information into the CRM from their contact in outlook or on their phone.

  • sushicat_san Profile Picture
    sushicat_san on at

    Thanks Aric. Right now the data is with the reps in either their outlook contacts or on their phones. Any ideas? I have a feeling my team is going to have a lot of data validation to do...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans