MRSware Sales and Commissions
  • New MRSware.com
  • About EYOND
  • Free Trial / Download
  • New Blogs / Docs / Training
  • Blog
  • Support
    • Training >
      • Sales Training
      • Data Entry Training
      • Training Classes - MRSweb
      • Training Classes - MRSware >
        • Lesson 1 - MRSware Home Page
        • Lesson 2 - CRM - Companies/Contacts
        • Lesson 3 - CRM - Calendar
        • Lesson 4 - CRM - Journals
        • Lesson 5 - CRM - Tasks
        • Lesson 6 - CRM - Projects
        • Lesson 7 - MREPS - Customers
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Web Login
  • Sales Tracking Software for Manufacturers Reps
  • Commission Tracking Software
  • Manufacturers Sales Rep Commission Rates
  • Commission Management Software for Manufacturers Reps

Creating one company-wide, "master" database of contact and companies

6/16/2008

0 Comments

 
One of the typical challenges/projects we see when a new customer comes on board with MRSware is the creation of one company-wide company and contact list that everyone can use. The challenge part is that the source of this new "master list" is found in multiple, previously individually kept contact lists from various programs that the inside staff, outside field, accounting department, etc. kept. This makes many sources of the information, all of which will have different information, whether it is just names of contacts and companies spelled differently, or entirely different (or missing) address, phone numbers, e-mails, et. al.

So what do we do about all these sources and differing information? We work at it. It is going to be an iterative process of working through the lists to bring them together. Some of the tools you will use along the way include those built into your existing contact program (the source of the list), Excel, and tools we have built into MRSware.

Following is a short list of a couple of the tools and features to use, and when to use them:

Excel
​

Spreadsheets are just meant for certain things, and working with a lot of data in rows and columns is the primary one. Sort by column headers, like Company Name, to group all of your contacts together. Make sure the Company Names are all spelled the same where appropriate -- it is very common to have normal abbreviations used in differently throughout a list. For example, make sure all those "Co.", "Company", "Inc.", and "Incorporated"'s are used consistently. This will help in reducing duplication of the Companies when the list is imported. Repeat this process, sorting by Last Name this time, making sure that common first names are spelled the same for multiple contacts.

The examples work even better when you can first bring the multiple lists from different sources together into one Excel spreadsheet first. However, in some cases you may not be able to do this easily (particularly when the contacts are coming from entirely different programs). In those cases, you can import the various lists into MRSware and work with the tools there to clean them up.
​
​MRSware

Contact Import

The contact import wizard allows you to take any contact file in csv (the common spreadsheet format) and import it into MRSware. When contacts are listed with company names, those companies will be created in the system for you -- if the Company already exists, the Contact will be associated with that Company. If a company name is in a row without a first or last name with it, it will be imported as the Company entry. What you get when you are done are the two lists of 1) Companies and 2) Contacts (individuals who work for those Companies).

  • Data Item Conflicts
    When you are importing it is quite common to have duplication in the contacts or companies. A duplicate entry is one that has almost the same information. Because of this "almost" part -- which could be a PO box vs. a street address, or a variation in the spelling of the name -- the system is unable to determine if it was suppose to be the same entry or not. This is when a Data Item Conflict is generated. The conflict resolution wizard, which you run after the import, helps the user match up to existing or create as new these conflicts entries. Conflicted items of this type are being held up from import until resolutions -- since the system doesn't know how to resolve the items, it is not imported until the user chooses how to resolve it.

  • Pending Data Updates
    A pending data update indicates that a match between two items was made, but some piece of data is different between what was already in the system and what is being imported. This is typically an extension is different on a contact or perhaps a job title. The user chooses which pieces of information to keep (the existing data from the system, or the newly imported data) to resolve the conflict.

Duplicate Contact Removal, Remove Duplicates

These are two methods -- one as a wizard, the other directly from the contact listing -- of merging multiple contacts into one entry. This is a very efficient way to mere multiple company entries that are suppose to be the same, but were spelled differently. Users can merge many entries at once into one entry. This is typically the easiest and preferred way to eliminate duplicates as it doesn't require the user to cut and paste any information between the contacts being merged, and it will also move associated items in the system over to the kept entry. For example, if two companies are being merged into one, all associated contacts will be reassigned to the company that is kept. In this way no information is lost, or left "floating" without correct association in the system. 
​
For more on how to use the remove duplicates features, refer to the Notes section.

What are some of the tools you use, and what successes have you had in merging your various contact lists to create your master list? Post back a reply and tell us about it.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Documentation

    ​You will find technical documentation, MRSware instructions, release notes, and general content to help MRSware users through their day on this page.

    Please use the Categories below to find documentation for each area in MRSware.

    ​You may also use the Search field above to look for specific topics. To get a more precise list of articles for a particular menu option, for example, use quotation marks around the text in the Search box, e.g. "bulk assign sales rep".

    Categories

    All
    1
    Android
    Appointments
    Auto-Complete
    Batch Edit/Bulk Update
    Categories
    Contacts
    Customers
    Data Analysis
    Duplicate Removal
    Education Module
    Email
    Email/Spam
    Email Templates
    File Share
    Google
    Hidden
    IMAP
    Installation
    Journals
    Master List
    Microsoft Office
    Mobile
    (MREPS)
    MRSweb
    New MRSware Users
    Outlook
    Payments
    Projects
    Reports/data Analysis
    RSS Reader
    Sales Force Automation (SFA)
    Search / Filter / Sort
    Sync
    Tables / Listings
    Troubleshooting
    Types
    User Manuals
    Video

    Archives

    November 2022
    September 2022
    June 2022
    March 2022
    February 2022
    January 2022
    December 2021
    May 2021
    October 2020
    September 2020
    July 2020
    June 2020
    May 2020
    September 2019
    April 2019
    September 2018
    January 2018
    August 2017
    February 2017
    January 2017
    December 2016
    September 2016
    July 2016
    June 2016
    May 2016
    February 2016
    January 2016
    December 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    July 2014
    June 2014
    February 2014
    October 2013
    September 2013
    July 2013
    May 2013
    April 2013
    March 2013
    February 2013
    November 2012
    September 2012
    July 2012
    June 2012
    May 2012
    April 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    May 2011
    April 2011
    March 2011
    December 2010
    September 2010
    July 2010
    May 2010
    April 2010
    February 2010
    January 2010
    December 2009
    November 2009
    October 2009
    July 2009
    June 2009
    May 2009
    April 2009
    March 2009
    February 2009
    January 2009
    October 2008
    September 2008
    August 2008
    July 2008
    June 2008
    May 2008
    April 2007
    September 2006
    August 2006
    July 2006
    June 2006
    May 2006

    RSS Feed

Home | Sales and Commissions | CRM | Blog |​ Pricing | Training | Support | Log In | Free Trial 
[email protected]    
​(866)795-8386
Copyright (c) 2004 -2025 EYOND
Picture
Live Services Status

​MRSware is an EYOND Integrated Solution
made in Austin, TX  USA