Results 1 to 1 of 1

Thread: CMDuplicatesFinder - A tool to find duplicate entries in a cm0102 database

  1. #1

    Join Date
    26-09-18
    Location
    Brazil
    Posts
    738
    vCash
    968

    CMDuplicatesFinder - A tool to find duplicate entries in a cm0102 database

    WHAT? This tool outputs a list of possible duplicate players (staff) from a cm0102 database, like this:

    Code:
    DUPLICATES LIST - PARTIAL RESULT (PROGRESS COMPLETED SO FAR: 2.47% : 81 DUPLICATE GROUPS FOUND SO FAR):
    Legend: (FN = First name; LN = Last name; CN = Common name; DOB = Date of birth)
    
    
    ************************* DUPLICATE TYPE EEE: STAFFS WITH EQUAL NAMES, EQUAL DATES OF BIRTH AND EQUAL CLUBS (16 DUPLICATE GROUPS FOUND SO FAR):
        DUPLICATE GROUP ID EEE-0:
            FN: Lubomír; LN: Michalík; CN: [None]; DOB: 13.08.1966; CLUB: SKF Sered; LOAN: [None]; STAFF ID: 51
            FN: Lubomir; LN: Michalik; CN: [None]; DOB: 13.08.1966; CLUB: SKF Sered; LOAN: [None]; STAFF ID: 62546
        DUPLICATE GROUP ID EEE-1:
            FN: Matej; LN: Slavik; CN: [None]; DOB: 05.08.1977; CLUB: DAC Dunajska Streda; LOAN: [None]; STAFF ID: 77
            FN: Matej; LN: Slávik; CN: [None]; DOB: 05.08.1977; CLUB: DAC Dunajska Streda; LOAN: [None]; STAFF ID: 114725
        DUPLICATE GROUP ID EEE-2:
            FN: Dzenan; LN: Catic; CN: [None]; DOB: 25.05.1975; CLUB: Rio Grande Valley FC Toros; LOAN: [None]; STAFF ID: 375
            FN: Dženan; LN: Catic; CN: [None]; DOB: 25.05.1975; CLUB: Rio Grande Valley FC Toros; LOAN: [None]; STAFF ID: 132223
        DUPLICATE GROUP ID EEE-3:
            FN: Lajos; LN: Hegedüs; CN: [None]; DOB: 19.12.1970; CLUB: Puskás Akadémia FC; LOAN: [None]; STAFF ID: 424
            FN: Lajos; LN: Hegedus; CN: [None]; DOB: 19.12.1970; CLUB: Puskás Akadémia FC; LOAN: [None]; STAFF ID: 14199
        DUPLICATE GROUP ID EEE-4:
            FN: Joăo Francisco; LN: Favaro Amaral; CN: Joăo Francisco; DOB: 23.04.1975; CLUB: Săo Bernardo Futebol Clube; LOAN: [None]; STAFF ID: 443
            FN: Joao; LN: Francisco; CN: [None]; DOB: 23.04.1975; CLUB: Săo Bernardo Futebol Clube; LOAN: [None]; STAFF ID: 132045
        DUPLICATE GROUP ID EEE-5:
            FN: Abdullah; LN: Cetin; CN: [None]; DOB: 18.03.1967; CLUB: Diyarbekirspor; LOAN: [None]; STAFF ID: 720
            FN: Abdullah; LN: Cetin; CN: [None]; DOB: 18.03.1967; CLUB: Diyarbekirspor; LOAN: [None]; STAFF ID: 8536
        DUPLICATE GROUP ID EEE-6:
            FN: Dilaver; LN: Güçlü; CN: [None]; DOB: 20.02.1969; CLUB: Sakaryaspor; LOAN: [None]; STAFF ID: 59112
            FN: Dilaver; LN: Güclü; CN: [None]; DOB: 20.02.1969; CLUB: Sakaryaspor; LOAN: [None]; STAFF ID: 883
        DUPLICATE GROUP ID EEE-7:
            FN: Alex; LN: Martinez; CN: [None]; DOB: 25.08.1974; CLUB: Charlotte Independence; LOAN: [None]; STAFF ID: 151808
            FN: Alex; LN: Martínez; CN: [None]; DOB: 25.08.1974; CLUB: Charlotte Independence; LOAN: [None]; STAFF ID: 980
        DUPLICATE GROUP ID EEE-8:
            FN: Denílson; LN: Ramírez; CN: [None]; DOB: 25.08.1981; CLUB: Academia Deportiva Cantolao; LOAN: [None]; STAFF ID: 1727
            FN: Denilson; LN: Ramírez; CN: [None]; DOB: 25.08.1981; CLUB: Academia Deportiva Cantolao; LOAN: [None]; STAFF ID: 150345
        DUPLICATE GROUP ID EEE-9:
            FN: Benoît; LN: Bryand; CN: [None]; DOB: 10.01.1975; CLUB: FC Stade Nyonnais; LOAN: [None]; STAFF ID: 2585
            FN: Benoit; LN: Bryand; CN: [None]; DOB: 10.01.1975; CLUB: FC Stade Nyonnais; LOAN: [None]; STAFF ID: 4977
        DUPLICATE GROUP ID EEE-10:
            FN: Leandro Carrijo; LN: Silva; CN: Leandro Carrijo; DOB: 03.09.1968; CLUB: FC Juárez; LOAN: [None]; STAFF ID: 2649
            FN: Leandro; LN: Carrijó; CN: [None]; DOB: 03.09.1968; CLUB: FC Juárez; LOAN: [None]; STAFF ID: 45300
        DUPLICATE GROUP ID EEE-11:
            FN: Cihat; LN: Celik; CN: [None]; DOB: 02.01.1979; CLUB: Gazisehir Gaziantep Futbol Kulübü; LOAN: [None]; STAFF ID: 2840
            FN: Cihat; LN: Çelik; CN: [None]; DOB: 02.01.1979; CLUB: Gazisehir Gaziantep Futbol Kulübü; LOAN: [None]; STAFF ID: 88720
        DUPLICATE GROUP ID EEE-12:
            FN: Sven; LN: Goldschimdt; CN: [None]; DOB: 08.10.1982; CLUB: SV Meppen; LOAN: [None]; STAFF ID: 3068
            FN: Sven; LN: Goldschmidt; CN: [None]; DOB: 08.10.1982; CLUB: SV Meppen; LOAN: [None]; STAFF ID: 22350
        DUPLICATE GROUP ID EEE-13:
            FN: Matias; LN: García; CN: [None]; DOB: 22.10.1974; CLUB: San Martín de Tucumán; LOAN: [None]; STAFF ID: 3164
            FN: Matías; LN: García; CN: [None]; DOB: 22.10.1974; CLUB: San Martín de Tucumán; LOAN: [None]; STAFF ID: 45803
        DUPLICATE GROUP ID EEE-14:
            FN: Marc; LN: Amoakon; CN: [None]; DOB: 03.05.1977; CLUB: Union Sportive Esch-Alzette; LOAN: [None]; STAFF ID: 3386
            FN: Marck; LN: Amoakon; CN: [None]; DOB: 03.05.1977; CLUB: Union Sportive Esch-Alzette; LOAN: [None]; STAFF ID: 111617
        DUPLICATE GROUP ID EEE-15:
            FN: Laszlo; LN: Tóth; CN: [None]; DOB: 09.07.1978; CLUB: Kazincbarcikai SC; LOAN: [None]; STAFF ID: 3429
            FN: László; LN: Tóth; CN: [None]; DOB: 09.07.1978; CLUB: Kazincbarcikai SC; LOAN: [None]; STAFF ID: 85767
    
    
    ************************* DUPLICATE TYPE EED: STAFFS WITH EQUAL NAMES, EQUAL DATES OF BIRTH AND DIFFERENT CLUBS (13 DUPLICATE GROUPS FOUND SO FAR):
        DUPLICATE GROUP ID EED-0:
            FN: Pedro; LN: Ribeiro; CN: [None]; DOB: 13.06.1973; CLUB: [None]; LOAN: [None]; STAFF ID: 190
            FN: Pedro Nezio; LN: de Araújo Lopes Ribeiro; CN: Pedro Ribeiro; DOB: 13.06.1973; CLUB: Fresno FC; LOAN: [None]; STAFF ID: 107007
        DUPLICATE GROUP ID EED-1:
            FN: Sergei; LN: Terehhov; CN: [None]; DOB: 18.04.1958; CLUB: Nomme Kalju FC; LOAN: [None]; STAFF ID: 659
            FN: Sergei; LN: Terehhov; CN: [None]; DOB: 18.04.1958; CLUB: Nomme Kalju FC U21; LOAN: [None]; STAFF ID: 4741
        DUPLICATE GROUP ID EED-2:
            FN: Dmytro; LN: Bilonoh; CN: [None]; DOB: 26.05.1978; CLUB: Zirka Kropyvnytsky; LOAN: [None]; STAFF ID: 706
            FN: Dmytro; LN: Bilonog; CN: [None]; DOB: 26.05.1978; CLUB: [None]; LOAN: [None]; STAFF ID: 49444
        DUPLICATE GROUP ID EED-3:
            FN: Onur Behic; LN: Özalgan; CN: [None]; DOB: 27.08.1977; CLUB: Körfez Spor Kulübü; LOAN: [None]; STAFF ID: 876
            FN: Onur Behic; LN: Özalgan; CN: [None]; DOB: 27.08.1977; CLUB: Nevsehir Belediyespor; LOAN: [None]; STAFF ID: 142428
        DUPLICATE GROUP ID EED-4:
            FN: Rubén; LN: de la Barrera; CN: [None]; DOB: 18.01.1968; CLUB: Real Sociedad C.F.; LOAN: [None]; STAFF ID: 957
            FN: Rubén; LN: de la Barrera; CN: [None]; DOB: 18.01.1968; CLUB: Cultural Leonesa; LOAN: [None]; STAFF ID: 93167
        DUPLICATE GROUP ID EED-5:
            FN: Tony; LN: Tsabedze; CN: [None]; DOB: 29.10.1967; CLUB: Mbabane Swallows; LOAN: [None]; STAFF ID: 1542
            FN: Tony; LN: Tabedze; CN: [None]; DOB: 29.10.1967; CLUB: Engen Santos (RSA); LOAN: [None]; STAFF ID: 58270
        DUPLICATE GROUP ID EED-6:
            FN: Paulo Carlos; LN: Lima Pereira dos Santos; CN: Carlos Pereira; DOB: 01.07.1947; CLUB: [None]; LOAN: [None]; STAFF ID: 1690
            FN: Carlos; LN: Pereira; CN: [None]; DOB: 01.07.1947; CLUB: Atlético Clube de Portugal; LOAN: [None]; STAFF ID: 48023
        DUPLICATE GROUP ID EED-7:
            FN: Sameh Abdel; LN: Fadil; CN: [None]; DOB: 22.03.1971; CLUB: Pharco FC; LOAN: [None]; STAFF ID: 2243
            FN: Sameh; LN: Abdel-Fadil; CN: [None]; DOB: 22.03.1971; CLUB: Petrojet; LOAN: [None]; STAFF ID: 124391
        DUPLICATE GROUP ID EED-8:
            FN: Kun-Hoan; LN: Kim; CN: Kim Kun-Hoan; DOB: 12.08.1969; CLUB: [None]; LOAN: [None]; STAFF ID: 2557
            FN: Keun-hwan; LN: Kim; CN: Kim Keun-hwan; DOB: 12.08.1969; CLUB: Gyeongnam FC; LOAN: [None]; STAFF ID: 140681
        DUPLICATE GROUP ID EED-9:
            FN: Adem; LN: Gökce; CN: [None]; DOB: 10.09.1965; CLUB: Yomraspor; LOAN: [None]; STAFF ID: 2986
            FN: Adem; LN: Gökçe; CN: [None]; DOB: 10.09.1965; CLUB: Bayburt Grup Özel Idare Genclik Ve Spor; LOAN: [None]; STAFF ID: 15366
        DUPLICATE GROUP ID EED-10:
            FN: Gabor; LN: Horvath; CN: [None]; DOB: 24.08.1973; CLUB: Aqvital FC Csákvár; LOAN: [None]; STAFF ID: 3237
            FN: Gábor; LN: Horváth; CN: [None]; DOB: 24.08.1973; CLUB: Dorogi FC; LOAN: [None]; STAFF ID: 105302
        DUPLICATE GROUP ID EED-11:
            FN: Liridon; LN: Kukaj; CN: [None]; DOB: 22.06.1966; CLUB: KF Ballkani; LOAN: [None]; STAFF ID: 3377
            FN: Liridon; LN: Kukaj; CN: [None]; DOB: 22.06.1966; CLUB: KF KEK-u Kastriot; LOAN: [None]; STAFF ID: 60963
        DUPLICATE GROUP ID EED-12:
            FN: Rui Pedro; LN: Sa Castro; CN: [None]; DOB: 10.10.1954; CLUB: Olympiacos Piraeus; LOAN: [None]; STAFF ID: 140523
            FN: Rui Pedro; LN: Sá Castro; CN: Rui Pedro; DOB: 10.10.1954; CLUB: Vitória Guimarăes SC; LOAN: [None]; STAFF ID: 3623
    
    
    ************************* DUPLICATE TYPE EDE: STAFFS WITH EQUAL NAMES, DIFFERENT DATES OF BIRTH AND EQUAL CLUBS (12 DUPLICATE GROUPS FOUND SO FAR):
        DUPLICATE GROUP ID EDE-0:
            FN: Gastón; LN: Guruceaga; CN: [None]; DOB: 06.04.1978; CLUB: Los Andes; LOAN: [None]; STAFF ID: 53
            FN: Gastón; LN: Guruceaga; CN: [None]; DOB: 06.04.1973; CLUB: Los Andes; LOAN: [None]; STAFF ID: 33763
        DUPLICATE GROUP ID EDE-1:
            FN: Sofian; LN: Chahed; CN: [None]; DOB: 18.04.1966; CLUB: VfV Borussia 06 Hildesheim; LOAN: [None]; STAFF ID: 82
            FN: Sofien; LN: Chahed; CN: [None]; DOB: 21.11.1972; CLUB: VfV Borussia 06 Hildesheim; LOAN: [None]; STAFF ID: 42879
        DUPLICATE GROUP ID EDE-2:
            FN: Mickael; LN: Leoni; CN: [None]; DOB: 21.04.1972; CLUB: FC Jeunesse Canach; LOAN: [None]; STAFF ID: 681
            FN: Mickaël; LN: Leoni; CN: [None]; DOB: 22.04.1972; CLUB: FC Jeunesse Canach; LOAN: [None]; STAFF ID: 22582
        DUPLICATE GROUP ID EDE-3:
            FN: Tuan Anh; LN: Nguyen; CN: [None]; DOB: 16.05.1978; CLUB: Hoang Anh Gia Lai; LOAN: [None]; STAFF ID: 766
            FN: Nguyen; LN: Tuan Anh; CN: [None]; DOB: 00.00.0000; CLUB: Hoang Anh Gia Lai; LOAN: [None]; STAFF ID: 33586
        DUPLICATE GROUP ID EDE-4:
            FN: Andre; LN: Hainault; CN: [None]; DOB: 17.06.1969; CLUB: 1.FC Kaiserslautern; LOAN: [None]; STAFF ID: 150163
            FN: André; LN: Hainault; CN: [None]; DOB: 15.06.1969; CLUB: 1.FC Kaiserslautern; LOAN: [None]; STAFF ID: 890
        DUPLICATE GROUP ID EDE-5:
            FN: Craig; LN: Williams; CN: [None]; DOB: 28.01.1966; CLUB: Newtown AFC; LOAN: [None]; STAFF ID: 913
            FN: Craig T.; LN: Williams; CN: [None]; DOB: 21.12.1970; CLUB: Newtown AFC; LOAN: [None]; STAFF ID: 128783
        DUPLICATE GROUP ID EDE-6:
            FN: Tino; LN: Lagator; CN: [None]; DOB: 15.09.1971; CLUB: SC Hessen Dreieich; LOAN: [None]; STAFF ID: 1521
            FN: Tino; LN: Lagator; CN: [None]; DOB: 14.09.1970; CLUB: SC Hessen Dreieich; LOAN: [None]; STAFF ID: 54722
        DUPLICATE GROUP ID EDE-7:
            FN: Vítor; LN: Coelho; CN: [None]; DOB: 00.00.0000; CLUB: Sport Uniăo Sintrense; LOAN: [None]; STAFF ID: 2613
            FN: Vitor; LN: Coelho; CN: [None]; DOB: 00.00.0000; CLUB: Sport Uniăo Sintrense; LOAN: [None]; STAFF ID: 22629
        DUPLICATE GROUP ID EDE-8:
            FN: Slim; LN: Jedaied; CN: [None]; DOB: 20.09.1972; CLUB: Stade Tunisien; LOAN: [None]; STAFF ID: 2697
            FN: Slim; LN: Jedaďed; CN: [None]; DOB: 19.09.1972; CLUB: Stade Tunisien; LOAN: [None]; STAFF ID: 57656
        DUPLICATE GROUP ID EDE-9:
            FN: Anh Duc; LN: Nguyen; CN: [None]; DOB: 25.01.1968; CLUB: Becamex Binh Duong FC; LOAN: [None]; STAFF ID: 55189
            FN: Nguyen; LN: Anh Duc; CN: [None]; DOB: 00.00.0000; CLUB: Becamex Binh Duong FC; LOAN: [None]; STAFF ID: 2833
        DUPLICATE GROUP ID EDE-10:
            FN: Que; LN: Ngoc Hai; CN: [None]; DOB: 00.00.0000; CLUB: Song Lam Nghe An FC; LOAN: [None]; STAFF ID: 2910
            FN: Ngoc Hai; LN: Que; CN: [None]; DOB: 14.05.1976; CLUB: Song Lam Nghe An FC; LOAN: [None]; STAFF ID: 48325
        DUPLICATE GROUP ID EDE-11:
            FN: András; LN: Vági; CN: [None]; DOB: 25.12.1971; CLUB: Paksi FC; LOAN: [None]; STAFF ID: 3033
            FN: Andras; LN: Vagi; CN: [None]; DOB: 26.12.1971; CLUB: Paksi FC; LOAN: [None]; STAFF ID: 66614
    
    
    ************************* DUPLICATE TYPE SEE: STAFFS WITH SIMILAR NAMES, EQUAL DATES OF BIRTH AND EQUAL CLUBS (13 DUPLICATE GROUPS FOUND SO FAR):
        DUPLICATE GROUP ID SEE-0:
            FN: Ross; LN: McCrorie; CN: [None]; DOB: 18.03.1981; CLUB: Glasgow Rangers; LOAN: [None]; STAFF ID: 343
            FN: Robbie; LN: McCrorie; CN: [None]; DOB: 18.03.1981; CLUB: Glasgow Rangers; LOAN: [None]; STAFF ID: 99615
        DUPLICATE GROUP ID SEE-1:
            FN: Luiz; LN: Fernando; CN: [None]; DOB: 23.06.1980; CLUB: Richmond Kickers; LOAN: [None]; STAFF ID: 408
            FN: Luiz Fernando; LN: Nascimento; CN: [None]; DOB: 23.06.1980; CLUB: Richmond Kickers; LOAN: [None]; STAFF ID: 132168
        DUPLICATE GROUP ID SEE-2:
            FN: Kosuke; LN: Matsuda; CN: [None]; DOB: 23.04.1974; CLUB: MIO Biwako Shiga; LOAN: [None]; STAFF ID: 1125
            FN: Yusuke; LN: Matsuda; CN: [None]; DOB: 23.04.1974; CLUB: MIO Biwako Shiga; LOAN: [None]; STAFF ID: 101120
        DUPLICATE GROUP ID SEE-3:
            FN: Shahrazen; LN: Said; CN: [None]; DOB: 14.12.1968; CLUB: Brunei DPMM FC; LOAN: [None]; STAFF ID: 1586
            FN: Mohammad; LN: Said; CN: [None]; DOB: 14.12.1968; CLUB: Brunei DPMM FC; LOAN: [None]; STAFF ID: 93903
        DUPLICATE GROUP ID SEE-4:
            FN: José; LN: Torcato; CN: [None]; DOB: 05.05.1951; CLUB: AC Alcanenense; LOAN: [None]; STAFF ID: 1795
            FN: José António; LN: Torcato; CN: [None]; DOB: 05.05.1951; CLUB: AC Alcanenense; LOAN: [None]; STAFF ID: 2686
        DUPLICATE GROUP ID SEE-5:
            FN: Sime; LN: Pesic; CN: [None]; DOB: 13.07.1982; CLUB: NK Lucko; LOAN: [None]; STAFF ID: 98419
            FN: Duje; LN: Pesic; CN: [None]; DOB: 13.07.1982; CLUB: NK Lucko; LOAN: [None]; STAFF ID: 2290
        DUPLICATE GROUP ID SEE-6:
            FN: Yuki; LN: Nishiya; CN: [None]; DOB: 04.10.1976; CLUB: Tochigi SC; LOAN: [None]; STAFF ID: 2333
            FN: Kazuki; LN: Nishiya; CN: [None]; DOB: 04.10.1976; CLUB: Tochigi SC; LOAN: [None]; STAFF ID: 9714
        DUPLICATE GROUP ID SEE-7:
            FN: Liridon; LN: Simoni; CN: [None]; DOB: 25.10.1977; CLUB: SC Goldau; LOAN: [None]; STAFF ID: 2813
            FN: Jozef; LN: Simoni; CN: [None]; DOB: 25.10.1977; CLUB: SC Goldau; LOAN: [None]; STAFF ID: 92428
        DUPLICATE GROUP ID SEE-8:
            FN: Baggio; LN: Rakotonomenjanahary; CN: [None]; DOB: 19.12.1974; CLUB: Sukhothai FC; LOAN: [None]; STAFF ID: 2909
            FN: John Baggio; LN: Rakotonomenjanahary; CN: John Baggio; DOB: 19.12.1974; CLUB: Sukhothai FC; LOAN: [None]; STAFF ID: 135149
        DUPLICATE GROUP ID SEE-9:
            FN: Matias; LN: García; CN: [None]; DOB: 22.10.1974; CLUB: San Martín de Tucumán; LOAN: [None]; STAFF ID: 3164
            FN: Ariel; LN: García; CN: [None]; DOB: 22.10.1974; CLUB: San Martín de Tucumán; LOAN: [None]; STAFF ID: 113764
        DUPLICATE GROUP ID SEE-10:
            FN: Matt; LN: Penney; CN: [None]; DOB: 11.02.1981; CLUB: Sheffield Wednesday; LOAN: [None]; STAFF ID: 3395
            FN: Matthew; LN: Penney; CN: [None]; DOB: 11.02.1981; CLUB: Sheffield Wednesday; LOAN: [None]; STAFF ID: 143832
        DUPLICATE GROUP ID SEE-11:
            FN: Malick; LN: Seck; CN: [None]; DOB: 09.02.1973; CLUB: Stade Bordelais; LOAN: [None]; STAFF ID: 3743
            FN: El Hadji Malick; LN: Seck; CN: [None]; DOB: 09.02.1973; CLUB: Stade Bordelais; LOAN: [None]; STAFF ID: 74272
        DUPLICATE GROUP ID SEE-12:
            FN: Javi; LN: Castellano; CN: [None]; DOB: 02.11.1970; CLUB: U.D. Las Palmas; LOAN: [None]; STAFF ID: 3746
            FN: Dani; LN: Castellano; CN: [None]; DOB: 02.11.1970; CLUB: U.D. Las Palmas; LOAN: [None]; STAFF ID: 63310
    
    
    ************************* DUPLICATE TYPE SSE: STAFFS WITH SIMILAR NAMES, SIMILAR DATES OF BIRTH AND EQUAL CLUBS (12 DUPLICATE GROUPS FOUND SO FAR):
        DUPLICATE GROUP ID SSE-0:
            FN: Stefan; LN: Mikic; CN: [None]; DOB: 19.06.1980; CLUB: FK Rudar Prijedor; LOAN: [None]; STAFF ID: 45
            FN: Stefan; LN: Gavranovic; CN: [None]; DOB: 13.06.1980; CLUB: FK Rudar Prijedor; LOAN: [None]; STAFF ID: 120938
        DUPLICATE GROUP ID SSE-1:
            FN: Hamza; LN: Uzman; CN: [None]; DOB: 01.01.1979; CLUB: Yomraspor; LOAN: [None]; STAFF ID: 73
            FN: Osman; LN: Mertoglu; CN: [None]; DOB: 01.01.1973; CLUB: Yomraspor; LOAN: [None]; STAFF ID: 36121
        DUPLICATE GROUP ID SSE-2:
            FN: José Francisco; LN: Torres; CN: [None]; DOB: 30.10.1970; CLUB: Puebla FC; LOAN: [None]; STAFF ID: 339
            FN: Francisco; LN: Torres; CN: [None]; DOB: 29.10.1970; CLUB: Puebla FC; LOAN: [None]; STAFF ID: 144239
        DUPLICATE GROUP ID SSE-3:
            FN: Mahmoud; LN: El Sayed; CN: [None]; DOB: 09.05.1968; CLUB: Masry Port Said; LOAN: [None]; STAFF ID: 578
            FN: Elsayed; LN: Abdelaal; CN: [None]; DOB: 09.05.1969; CLUB: Masry Port Said; LOAN: [None]; STAFF ID: 127182
        DUPLICATE GROUP ID SSE-4:
            FN: Mostafa; LN: Gamal; CN: [None]; DOB: 25.07.1973; CLUB: Harras El Hodoud; LOAN: [None]; STAFF ID: 149030
            FN: Belal; LN: Gamal; CN: [None]; DOB: 25.11.1973; CLUB: Harras El Hodoud; LOAN: [None]; STAFF ID: 760
        DUPLICATE GROUP ID SSE-5:
            FN: Shun; LN: Nagasawa; CN: [None]; DOB: 26.08.1971; CLUB: Gamba Osaka; LOAN: [None]; STAFF ID: 804
            FN: Shu; LN: Kurata; CN: [None]; DOB: 26.11.1971; CLUB: Gamba Osaka; LOAN: [None]; STAFF ID: 14001
        DUPLICATE GROUP ID SSE-6:
            FN: Yuto; LN: Misao; CN: [None]; DOB: 16.04.1974; CLUB: Kashima Antlers; LOAN: [None]; STAFF ID: 836
            FN: Kento; LN: Misao; CN: [None]; DOB: 16.04.1979; CLUB: Kashima Antlers; LOAN: [None]; STAFF ID: 55697
        DUPLICATE GROUP ID SSE-7:
            FN: Remi; LN: Jakobsen; CN: [None]; DOB: 26.01.1971; CLUB: Mo IL; LOAN: [None]; STAFF ID: 966
            FN: Jonas; LN: Jacobsen; CN: [None]; DOB: 26.09.1971; CLUB: Mo IL; LOAN: [None]; STAFF ID: 6198
        DUPLICATE GROUP ID SSE-8:
            FN: Lucas; LN: Cano; CN: [None]; DOB: 09.05.1978; CLUB: Argentinos Juniors; LOAN: [None]; STAFF ID: 1567
            FN: Lucas; LN: Chaves; CN: [None]; DOB: 09.08.1978; CLUB: Argentinos Juniors; LOAN: [None]; STAFF ID: 145436
        DUPLICATE GROUP ID SSE-9:
            FN: Jorge Martin; LN: Salinas; CN: [None]; DOB: 06.05.1975; CLUB: JEF United Chiba; LOAN: [None]; STAFF ID: 1710
            FN: Jorge; LN: Salinas; CN: [None]; DOB: 07.05.1975; CLUB: JEF United Chiba; LOAN: [None]; STAFF ID: 87115
        DUPLICATE GROUP ID SSE-10:
            FN: Bartosz; LN: Krawczynski; CN: [None]; DOB: 08.07.1982; CLUB: Warta Gorzow; LOAN: [None]; STAFF ID: 1920
            FN: Bartosz; LN: Zurawski; CN: [None]; DOB: 27.07.1982; CLUB: Warta Gorzow; LOAN: [None]; STAFF ID: 136129
        DUPLICATE GROUP ID SSE-11:
            FN: Darley Ramon; LN: Torres; CN: Darley; DOB: 14.12.1972; CLUB: Tombense Futebol Clube (MG); LOAN: [None]; STAFF ID: 2884
            FN: Darley; LN: Torres; CN: [None]; DOB: 15.12.1972; CLUB: Tombense Futebol Clube (MG); LOAN: [None]; STAFF ID: 151351
    
    
    ************************* DUPLICATE TYPE ESD: STAFFS WITH EQUAL NAMES, SIMILAR DATES OF BIRTH AND DIFFERENT CLUBS (15 DUPLICATE GROUPS FOUND SO FAR):
        DUPLICATE GROUP ID ESD-0:
            FN: Cédric; LN: Mensah; CN: [None]; DOB: 06.03.1972; CLUB: Stade Laval; LOAN: [None]; STAFF ID: 724
            FN: Cedric; LN: Mensah; CN: [None]; DOB: 05.03.1972; CLUB: FC Le Mans; LOAN: [None]; STAFF ID: 51673
        DUPLICATE GROUP ID ESD-1:
            FN: Álvaro; LN: Giménez; CN: [None]; DOB: 19.05.1974; CLUB: UD Almería; LOAN: [None]; STAFF ID: 762
            FN: Álvaro; LN: Jiménez; CN: [None]; DOB: 19.05.1978; CLUB: Getafe CF; LOAN: [None]; STAFF ID: 97087
        DUPLICATE GROUP ID ESD-2:
            FN: Carlos; LN: Fernández; CN: [None]; DOB: 01.09.1973; CLUB: Titanes FC; LOAN: [None]; STAFF ID: 993
            FN: Carlos; LN: Hernández; CN: [None]; DOB: 16.09.1973; CLUB: Real Oviedo C.F.; LOAN: [None]; STAFF ID: 82773
        DUPLICATE GROUP ID ESD-3:
            FN: Fahd; LN: Al-Juhani; CN: [None]; DOB: 27.10.1974; CLUB: Al-Nadha; LOAN: [None]; STAFF ID: 1109
            FN: Fahad; LN: Al-Johani; CN: [None]; DOB: 26.10.1974; CLUB: Al Qadisiyah FC; LOAN: [None]; STAFF ID: 108521
        DUPLICATE GROUP ID ESD-4:
            FN: Nicolás; LN: Martínez; CN: [None]; DOB: 15.02.1972; CLUB: Club Sol de América; LOAN: [None]; STAFF ID: 1111
            FN: Nikolas; LN: Martidis; CN: [None]; DOB: 15.02.1964; CLUB: [None]; LOAN: [None]; STAFF ID: 106440
        DUPLICATE GROUP ID ESD-5:
            FN: El Aid; LN: Madouni; CN: [None]; DOB: 26.06.1969; CLUB: MC Saďda; LOAN: [None]; STAFF ID: 1374
            FN: Laďd; LN: Madouni; CN: [None]; DOB: 23.06.1969; CLUB: [None]; LOAN: [None]; STAFF ID: 27226
        DUPLICATE GROUP ID ESD-6:
            FN: Goran; LN: Stevanovic; CN: [None]; DOB: 27.11.1949; CLUB: Qingdao Jonoon; LOAN: [None]; STAFF ID: 1847
            FN: Goran; LN: Stefanovic; CN: [None]; DOB: 27.11.1947; CLUB: [None]; LOAN: [None]; STAFF ID: 57500
        DUPLICATE GROUP ID ESD-7:
            FN: Albi; LN: Alla; CN: [None]; DOB: 01.02.1976; CLUB: FC Flamurtari; LOAN: [None]; STAFF ID: 1910
            FN: Ali; LN: Akla; CN: [None]; DOB: 09.02.1976; CLUB: VV IJsselmeervogels; LOAN: [None]; STAFF ID: 39908
        DUPLICATE GROUP ID ESD-8:
            FN: Paulo; LN: Ferreira; CN: [None]; DOB: 11.02.1970; CLUB: Sporting Clube de Bustelo; LOAN: [None]; STAFF ID: 2347
            FN: Pablo; LN: Herrera; CN: [None]; DOB: 14.02.1970; CLUB: Universidad de Costa Rica; LOAN: [None]; STAFF ID: 17427
        DUPLICATE GROUP ID ESD-9:
            FN: Diego; LN: Alonso; CN: [None]; DOB: 16.04.1959; CLUB: CF Monterrey; LOAN: [None]; STAFF ID: 2379
            FN: Diego; LN: Alonso; CN: Diego Alonso; DOB: 16.04.1958; CLUB: [None]; LOAN: [None]; STAFF ID: 35012
        DUPLICATE GROUP ID ESD-10:
            FN: Manel; LN: Royo; CN: [None]; DOB: 28.02.1978; CLUB: [None]; LOAN: [None]; STAFF ID: 2654
            FN: Manel; LN: Royo; CN: [None]; DOB: 28.02.1977; CLUB: R.C.D. Espanyol B; LOAN: [None]; STAFF ID: 79839
        DUPLICATE GROUP ID ESD-11:
            FN: Suppiah; LN: Chanturu; CN: [None]; DOB: 14.12.1970; CLUB: [None]; LOAN: [None]; STAFF ID: 2815
            FN: Chanturu; LN: Suppiah; CN: [None]; DOB: 14.12.1971; CLUB: Sarawak FA; LOAN: [None]; STAFF ID: 28314
        DUPLICATE GROUP ID ESD-12:
            FN: Dani; LN: Hernández; CN: [None]; DOB: 26.03.1979; CLUB: CD El Ejido 2012; LOAN: [None]; STAFF ID: 3094
            FN: Dani; LN: Hernández; CN: [None]; DOB: 26.03.1969; CLUB: [None]; LOAN: [None]; STAFF ID: 99061
        DUPLICATE GROUP ID ESD-13:
            FN: Aleksandar; LN: Susnjar; CN: [None]; DOB: 19.08.1977; CLUB: FK Teplice; LOAN: [None]; STAFF ID: 3649
            FN: Aleksandar; LN: Susnjar; CN: [None]; DOB: 19.08.1978; CLUB: FK Mladá Boleslav; LOAN: [None]; STAFF ID: 139982
        DUPLICATE GROUP ID ESD-14:
            FN: Jozef; LN: Urblík; CN: [None]; DOB: 23.08.1979; CLUB: FC Vysocina Jihlava; LOAN: [None]; STAFF ID: 3758
            FN: Jozef; LN: Urblik; CN: [None]; DOB: 22.08.1979; CLUB: Puskás Akadémia FC; LOAN: [None]; STAFF ID: 53848
    WHY? To help finding and removing duplicate staff for data updates.

    HOW TO INSTALL? No installation required, simply download the CMDuplicatesFinder.zip file, extract the zip file into anywhere in your computer (except into admin protected folders like 'Program Files' folder) and run the CMDuplicatesFinder.exe. To uninstall simply delete the extrated folder.
    Note: If you get an error message while using the CMDuplicatesFinder tool, then you probably need to install Visual C++ redistributable and/or .NET framework (I think they usually come installed with windows but not sure). Let me know if that happens so I can update the install instructions.

    HOW TO USE? The UI is self explanatory. But first you need to have exported a .csv file of your desired CM database using the TransferTool with the option "Transfer Import Format". If something is consfusing, please let me know and I can write a better guide.
    Note: Some of the duplicates listed will be false positives. The tool just lists the duplicates, it doesn't remove them from the database and it doesnt change the database in any way. So the duplicates need to be removed manually from the database.



    In a database of 150k staff, it takes 2-3 hours to complete (because it does a very deep duplicate finding, trying to have few false positives), but you get a partial list of duplicates every second or so, and you can pause and resume from where you paused another day. If you just want a quick shot of all the most obvious duplicates without going too deep, then please use this other tool instead: https://champman0102.co.uk/showthread.php?t=11885

    Thanks to Andrea71, Dermotron and archibalduk for great feedback while I was developing this tool.

    If you are a programmer, you are welcome to submit code changes to this tool. The code project is here.

  2. The Following 6 Users Say Thank You to MadScientist For This Useful Post:


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •