Exforsys
+ Reply to Thread
Results 1 to 4 of 4

How to delete duplicates from Merged Outlook contacts?

This is a discussion on How to delete duplicates from Merged Outlook contacts? within the Data Warehousing forums, part of the ERP category; Hello, We just bought a CRM software and until today, each salesman had his own contact list in Outlook. I ...

  1. #1
    trusty is offline Junior Member Array
    Join Date
    Aug 2008
    Answers
    9

    How to delete duplicates from Merged Outlook contacts?

    Hello,

    We just bought a CRM software and until today, each salesman had his own contact list in Outlook. I retrieved, for each of them, XLS files from Outlook and I copy-pasted it in one file. Thing is, now I have hundreds and hundreds of duplicate records .

    I would like to get rid of all the duplicates, how can I handle this easily?


  2. #2
    Talgru is offline Junior Member Array
    Join Date
    Aug 2008
    Answers
    6
    Hello!

    I'd recommend you have a look at an ETL tool. It allows, among other things, to "clean up data" including deleting duplicate records. Also I know there are open source ETL tools, making it pretty easy to download.


  3. #3
    trusty is offline Junior Member Array
    Join Date
    Aug 2008
    Answers
    9
    I've been looking at those etl tools you talk about and would like to know which, among the open source etl tools, is the easiest to use? I'm asking because now I've seen what I can do with these tools, I'll use them on a regular basis (data integration?).

    Once I've chosen the one I'm going to use, I will come back with more technical questions.

    Thanks for your answers.


  4. #4
    conED is offline Junior Member Array
    Join Date
    Mar 2011
    Location
    New York, United States
    Answers
    1
    Quote Originally Posted by trusty View Post
    I've been looking at those etl tools you talk about and would like to know which, among the open source etl tools, is the easiest to use? I'm asking because now I've seen what I can do with these tools, I'll use them on a regular basis (data integration?).

    Once I've chosen the one I'm going to use, I will come back with more technical questions.

    Thanks for your answers.
    yeah!!! and it's giving the hard time.


    •    Sponsored Ads



Latest Article

Network Security Risk Assessment and Measurement

Read More...