Site
Home / Forum / General Discussion / [REQUESTS] Team & player updates / Duplicates

[REQUESTS] Team & player updates / Duplicates


Posted: 05 Aug 2024 09:56
smudgie

Posts: 363
Joined: 2020

Recently been updating Scottish Premiership Teams, noticed that after teams have been updated player duplicates are being added, eg, https://www.thesportsdb.com/team/133646-Hibernian, ?

Posted: 05 Aug 2024 10:04
curswine


Posts: 935
Joined: 2020

I imagine the ID has not been input and then they've had their lineups synced the players have shown as not being in the database and been auto-imported.

Please try and add IDs when manually adding players. I'll try and clean up the Hibs team.

Posted: 05 Aug 2024 10:30

Ovokx

Posts: 1,768
Joined: 2020

Duplicate teams:
https://www.thesportsdb.com/team/147251-Ju-Vi-Cremona https://www.thesportsdb.com/team/148281-JuVi-Cremona


only @zag can do so


Posted: 05 Aug 2024 14:23
HubFlyer

Posts: 25
Joined: 2024

Please consider adding "Practice Squad" as a status for American football NFL players. This is a real status for players under contract to a team but not on the playing roster. Teams can "poach" a player from another team's practice squad but the player must then be guaranteed a roster spot and salary for at least three weeks for the new team.

Posted: 05 Aug 2024 14:54
smudgie

Posts: 363
Joined: 2020

cheers curswine,
Please try and add IDs when manually adding players. I'll try and clean up the Hibs team.
Assume you mean ,API Football ID: , if so the option seems to be blanked out.

Posted: 05 Aug 2024 14:58

zag


Posts: 3,511
Joined: 2020

cheers curswine,
Please try and add IDs when manually adding players. I'll try and clean up the Hibs team.
Assume you mean ,API Football ID: , if so the option seems to be blanked out.


Yeh any new players should have an API football ID. You can get it by syncing any lineup, timeline or team.

I regularly add ID's if people are adding players manually. But sometimes there are dupes.

Posted: 06 Aug 2024 19:19
bANAAN


Posts: 26
Joined: 2024

Doubles players

34175883
34223814

34222041
34245699

curswine
Posted: 07 Aug 2024 17:17
bANAAN


Posts: 26
Joined: 2024

Doubles players

34177336
34218536

and delete this one: 34245807

34225308
34223065

34217027
34218382

curswine
Posted: 08 Aug 2024 21:29
bANAAN


Posts: 26
Joined: 2024

Some teams in the dutch league has multiple duplicates now because i synced some line ups.

Can someone tell me how to prevent this next time and how I can clean up my own mess?

Posted: 09 Aug 2024 05:29
curswine


Posts: 935
Joined: 2020

Some teams in the dutch league has multiple duplicates now because i synced some line ups.

Can someone tell me how to prevent this next time and how I can clean up my own mess?


Try and make sure each player has a value in the API Football ID: field, these are the numbers that display when you sync a team.


Posted: 09 Aug 2024 07:07

zag


Posts: 3,511
Joined: 2020

Some teams in the dutch league has multiple duplicates now because i synced some line ups.

Can someone tell me how to prevent this next time and how I can clean up my own mess?


Best thing to do is sync the lineup or timeline and find those player ID's in brackets. Copy them into each player "API Football ID" that you have added manually. This will then sycn in fututure

Moderators can auto add these players as well, but I don't think normal users can.

Assuming you stick around, I could make you a moderator in the future

Posted: 09 Aug 2024 07:08

zag


Posts: 3,511
Joined: 2020

Some teams in the dutch league has multiple duplicates now because i synced some line ups.

Can someone tell me how to prevent this next time and how I can clean up my own mess?


Best thing to do is sync the lineup or timeline and find those player ID's in brackets. Copy them into each player "API Football ID" that you have added manually. This will then sync in future

Moderators can auto add these players as well, but I don't think normal users can.

Assuming you stick around, I could make you a moderator in the future

Posted: 09 Aug 2024 07:55
bANAAN


Posts: 26
Joined: 2024

Tnx for your reply! I dont think I can manually add the ID's per player? In the section 'edit player details' is not giving me possible to add or change. Or do I need to do it somewhere else?

Posted: 09 Aug 2024 08:30
curswine


Posts: 935
Joined: 2020

Tnx for your reply! I dont think I can manually add the ID's per player? In the section 'edit player details' is not giving me possible to add or change. Or do I need to do it somewhere else?

I didn't know this wasn't an option for every user.

@zag, could this maybe be a right which can be allowed to certain users like bANAAN and Smudgie, who I think also reported not having access to editing this field?

Posted: 09 Aug 2024 21:56
bANAAN


Posts: 26
Joined: 2024

List of duplicate players of the first 8 teams in the dutch eredivisie to be deleted:

AZ
34246157

FC UTRECHT
34245980

FEYENOORD
34246148
34246152
34246147
34246121
34246138
34246145
34246133
34246127
34246130
34222034
34246149
34246126
34246141
34246150
34246122
34246146
34246132
34246134
34246143
34246104
34246137
34246119
34246151
34246131
34246135

FORTUNA SITTARD
34246066
34246067
34246062
34246060
34246063
34246058
34246068
34236369
34246059
34246054
34246064
34225235
34246050
34246057
34246053
34246055





curswine
Posted: 09 Aug 2024 22:30
curswine


Posts: 935
Joined: 2020

List of duplicate players of the first 8 teams in the dutch eredivisie to be deleted:

Thanks for being so thorough. I think I have got them all.

I have no idea how so many of those could have happened.

If you find more teams like Feyenoord where there are a lot of players, just post the team name and I should be able to work out which the duplicates are.

bANAAN
Posted: 10 Aug 2024 20:35
bANAAN


Posts: 26
Joined: 2024

Feyenoord - > player Milambo
Fortuna Sittard -> player Robberechts
Go Ahead Eagles -> All players without full body render
(some players are not double anymore because i moved the most complete player to the right club)

Nac Breda -> player Mahmutovic, player Omgba
NEC Nijmegen -> player Larsen



Posted: 10 Aug 2024 20:37
bANAAN


Posts: 26
Joined: 2024

PEC Zwolle has also a lot of duplicates.. but didnt sort that team out yet.

Posted: 10 Aug 2024 20:56
curswine


Posts: 935
Joined: 2020

Thanks, hopefully all done.

Pretty embarrassing how many duplicates there are.

Posted: 11 Aug 2024 15:39
bANAAN


Posts: 26
Joined: 2024

Almere city FC -> Balboa
Feyenoord -> Kasanwirjo
Feyenoord -> Lanfranco & Lopez are the same players

curswine
Posted: 12 Aug 2024 20:06
bANAAN


Posts: 26
Joined: 2024

RKC waalwijk -> Lutonda... already playing in team PEC Zwolle

curswine
Posted: 20 Aug 2024 08:22

Ovokx

Posts: 1,768
Joined: 2020

dupe to be deleted, please:

https://www.thesportsdb.com/team/146412-Pachuca-Women

Posted: 08 Sep 2024 13:02
HubFlyer

Posts: 25
Joined: 2024

NE Patriots duplicates:

Valid records, KEEP
https://www.thesportsdb.com/player/34243779-Joe-Milton
https://www.thesportsdb.com/player/34249455-Zachary-Thomas

Duplicate records, DELETE
https://www.thesportsdb.com/player/34249213-Joe-Milton-III
https://www.thesportsdb.com/player/34249215-Zach-Thomas


Ovokx
Posted: 08 Sep 2024 16:53

Ovokx

Posts: 1,768
Joined: 2020

Could the Teams for UFC be expanded to cover weight classes?
Currently Teams is just divided by sex and pretty useless. Weight classes would be more appropriate.


done! also moved all existing fighters to their weight class!


zag
Posted: 08 Sep 2024 16:55

Ovokx

Posts: 1,768
Joined: 2020

NE Patriots duplicates:

Valid records, KEEP
https://www.thesportsdb.com/player/34243779-Joe-Milton
https://www.thesportsdb.com/player/34249455-Zachary-Thomas

Duplicate records, DELETE
https://www.thesportsdb.com/player/34249213-Joe-Milton-III
https://www.thesportsdb.com/player/34249215-Zach-Thomas


done!

HubFlyer, zag

Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm

About Us

Discussion forum for TheSportsDB.com site and related topics

Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 575 to 600 (Total: 627)