| | Posted: 07 Jan 2020 16:22 | |
![]()
curswine
Posts: 143
Joined: Jan 2017
| | English League 2 is a duplicate of English League 1
Could we also use this opportunity of editing whole leagues to add in Wikipedia and social media information when they're blank?
| |
 |
| | Posted: 07 Jan 2020 19:50 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Scotland 1
[quote:2q0hriz4] Aberdeen (252)
Heart OF Midlothian (254)
Celtic (247)
ST Johnstone (258)
Hibernian (249)
ST Mirren (251)
Livingston (255)
Motherwell (256)
Ross County (902)
Hamilton Academical (248)
Kilmarnock (250)
Rangers (257)[/quote:2q0hriz4]
Scotland 2
[quote:2q0hriz4] Alloa Athletic (1391)
Partick (901)
Arbroath (4249)
Queen of the South (1384)
Ayr Utd (1387)
Morton (1383)
Dundee Utd (1386)
Inverness CT (903)
Dunfermline (1388)
Dundee (253)[/quote:2q0hriz4]
Greece 1
[quote:2q0hriz4] AEK Athens FC (575)
Xanthi FC (959)
Aris Thessalonikis (1123)
OFI (1124)
Atromitos Athinon (952)
Larisa (953)
Olympiakos Piraeus (553)
Asteras Tripolis (955)
Panionios (622)
Volos NFC (2110)
PAOK (619)
Panetolikos (949)
Lamia (956)
Panathinaikos (617)[/quote:2q0hriz4]
Dutch 1
[quote:2q0hriz4] PEC Zwolle (193)
Willem II (195)
Vitesse (200)
Ajax (194)
Emmen (208)
Groningen (202)
VVV Venlo (204)
Waalwijk (417)
Twente (415)
PSV Eindhoven (197)
Heracles (206)
Heerenveen (210)
ADO Den Haag (198)
Utrecht (207)
Feyenoord (209)
Sparta Rotterdam (426)
AZ Alkmaar (201)
Fortuna Sittard (205)
GO Ahead Eagles (410)
De Graafschap (199)
Den Bosch (421)
Excelsior (196)
FC OSS (423)
Cambuur (420)
NEC Nijmegen (413)
Almere City FC (419)[/quote:2q0hriz4]
| |
|
| | Posted: 07 Jan 2020 19:55 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Belgium
[quote:bo7zvwpr]Genk (742)
Kortrijk (734)
Cercle Brugge (741)
Standard Liege (733)
St. Truiden (735)
Royal Excel Mouscron (743)
Zulte Waregem (600)
KV Mechelen (266)
Waasland-beveren (738)
Club Brugge KV (569)
Anderlecht (554)
Oostende (624)
Charleroi (736)
Gent (631)
AS Eupen (739)
Antwerp (740)[/quote:bo7zvwpr]
Turkey 1
[quote:bo7zvwpr] Sivasspor (1002)
Besiktas (549)
Fenerbahce (611)
Gazişehir Gaziantep (3573)
Yeni Malatyaspor (999)
Istanbul Basaksehir (564)
Genclerbirligi (997)
Rizespor (1007)
Kasimpasa (1004)
Trabzonspor (998)
Kayserispor (1001)
Alanyaspor (996)
Konyaspor (607)
Ankaragucu (1010)
Denizlispor (3570)
Galatasaray (645)
Goztepe (994)
Antalyaspor (1005)[/quote:bo7zvwpr]
Denmark 1
[quote:bo7zvwpr] Sonderjyske (396)
Randers FC (401)
FC Midtjylland (397)
Esbjerg (403)
Brondby (407)
Silkeborg (2073)
Odense (405)
FC Copenhagen (400)
AC Horsens (404)
FC Nordsjaelland (398)
Hobro (408)
Aarhus (406)
Lyngby (625)
Aalborg (402)[/quote:bo7zvwpr]
Portugal 1
[quote:bo7zvwpr] GIL Vicente (762)
FC Porto (212)
SC Braga (217)
Moreirense (215)
Maritimo (214)
Sporting CP (228)
Vitoria Setubal (219)
Tondela (218)
Santa Clara (227)
Famalicao (242)
Benfica (211)
Pacos Ferreira (234)
Boavista (222)
Aves (220)
Portimonense (216)
Belenenses (221)
Rio Ave (226)
Guimaraes (224)[/quote:bo7zvwpr]
USA 1
[quote:bo7zvwpr] Philadelphia Union (1599)
Toronto FC (1601)
Orlando City SC (1598)
New York City FC (1604)
FC Dallas (1597)
New England Revolution (1609)
Columbus Crew (1613)
New York Red Bulls (1602)
Vancouver Whitecaps (1603)
Minnesota Stars FC (1612)
Colorado Rapids (1610)
Portland Timbers (1617)
Houston Dynamo (1600)
Real Salt Lake (1606)
Los Angeles Galaxy (1605)
Chicago Fire (1607)
San Jose Earthquakes (1596)
Montreal Impact (1614)
Seattle Sounders (1595)
FC Cincinnati (2242)
DC United (1615)
Atlanta United FC (1608)
Los Angeles FC (1616)
Sporting Kansas City (1611)[/quote:bo7zvwpr]
USA Women
[quote:bo7zvwpr] Washington Spirit W (3005)
Sky Blue W (3003)
North Carolina Courage W (2999)
Chicago Red Stars W (2997)
Orlando Pride W (3000)
Portland Thorns W (3001)
Houston Dash W (2998)
Reign W (3002)
Utah Royals W (3004)[/quote:bo7zvwpr]
Sweden supertanten
[quote:bo7zvwpr] IF Brommapojkarna (371)
Vasteras SK FK (2241)
Mjallby AIF (2240)
Varbergs BoIS FC (2171)
Orgryte IS (2166)
Norrby IF (2173)
trelleborgs FF (369)
Gais (2170)
Osters IF (2174)
dalkurd FF (368)
Syrianska FC (2167)
Degerfors IF (2172)
IK brage (2175)
IK Frej (2164)
Jonkopings Sodra (764)
Halmstad (766)[/quote:bo7zvwpr]
Sweden Allsvenskan
[quote:bo7zvwpr] AIK stockholm (377)
Ostersunds FK (376)
falkenbergs FF (812)
Orebro SK (365)
kalmar FF (374)
Sirius (370)
Helsingborg (811)
IFK Norrkoping (378)
Vasby United (765)
IFK Goteborg (366)
Djurgardens IF (364)
GIF Sundsvall (373)
IF elfsborg (372)
Hammarby FF (363)
Malmo FF (375)
BK Hacken (367)
IK brage (2175)[/quote:bo7zvwpr]
Mexico
[quote:bo7zvwpr] Puebla (2291)
Club Tijuana (2280)
Atlas (2283)
FC Juarez (2298)
Atletico San Luis (2314)
U.N.A.M. - Pumas (2286)
Pachuca (2292)
Leon (2289)
Tigres UANL (2279)
Monarcas (2284)
Club America (2287)
Monterrey (2282)
Necaxa (2288)
Cruz Azul (2295)
Toluca (2281)
Club Queretaro (2290)
Santos Laguna (2285)
Guadalajara Chivas (2278)
Veracruz (2294)[/quote:bo7zvwpr]
| |
|
| | Posted: 07 Jan 2020 19:58 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Brazil 1
[quote:3f56d6zb] Atletico Paranaense (134)
Vasco DA Gama (133)
Atletico-MG (1062)
Avai (145)
Bahia (118)
Corinthians (131)
Ceara (129)
CSA (150)
Chapecoense-sc (132)
Internacional (119)
Flamengo (127)
Cruzeiro (135)
Fluminense (124)
Goias (151)
Gremio (130)
Santos (128)
Palmeiras (121)
Fortaleza EC (154)
Sao Paulo (126)
Botafogo (120)[/quote:3f56d6zb]
Brazil 2
[quote:3f56d6zb] Botafogo SP (2618)
Vitoria (136)
Brasil DE Pelotas (141)
Bragantino (794)
Coritiba (147)
Ponte Preta (139)
CRB (146)
Londrina (148)
Criciuma (140)
Cuiaba (1193)
Guarani Campinas (138)
Figueirense (137)
Operario-PR (1223)
America Mineiro (125)
Sao Bento (156)
Atletico Goianiense (144)
Sport Recife (123)
Oeste (143)
Vila Nova (142)
Parana (122)[/quote:3f56d6zb]
Ukraine
[quote:3f56d6zb] Desna (3616)
Lviv (3618)
Vorskla Poltava (1121)
Zorya Luhansk (599)
Dnipro-1 (3623)
Olimpik Donetsk (639)
Kolos Kovalivka (3627)
FC Mariupol (2252)
Oleksandria (3619)
Shakhtar Donetsk (550)
Karpaty (3617)
Dynamo Kyiv (572)[/quote:3f56d6zb]
Russia
[quote:3f56d6zb] Zenit Saint Petersburg (596)
Tambov (2008)
Spartak Moscow (558)
PFC Sochi (2012)
FC Rostov (779)
Orenburg (1080)
Lokomotiv Moscow (597)
Rubin (1083)
Akhmat Grozny (1085)
Krasnodar (621)
Arsenal Tula (1077)
Dinamo Moscow (1088)
Krylya Sovetov (1079)
CSKA Moscow (555)
Ural (1084)
FC UFA (1078)[/quote:3f56d6zb]
Australia 1
[quote:3f56d6zb] Adelaide United (948)
Sydney (943)
Western Sydney Wanderers (939)
Central Coast Mariners (941)
Melbourne Victory (944)
Melbourne City (945)
Wellington Phoenix (942)
Western United (7573)
Perth Glory (940)
Brisbane Roar (947)
Newcastle Jets (946)[/quote:3f56d6zb]
China 1
[quote:3f56d6zb] Shandong Luneng (844)
Beijing Renhe (835)
Guangzhou Evergrande FC (832)
Tianjin Songjiang (843)
Shanghai Shenhua (833)
SHANGHAI SIPG (836)
Wuhan Zall (1434)
Beijing Guoan (830)
Chongqing Lifan (845)
Guangzhou R&F (838)
Shenzhen Ruby FC (1433)
Hebei Zhongji (839)
Henan Jianye (840)
Dalian Aerbin (831)
Jiangsu Suning (842)
Tianjin Teda (837)[/quote:3f56d6zb]
England 2
[quote:3f56d6zb] Salford City (1844)
Stevenage (1368)
Bradford (1343)
Cambridge United (1370)
Carlisle (1371)
Crawley Town (1362)
Colchester (1361)
Port Vale (1351)
Crewe (1363)
Plymouth (1357)
Exeter City (1364)
Macclesfield (1380)
Forest Green (1378)
Oldham (1349)
Leyton Orient (1373)
Cheltenham (1372)
Morecambe (1375)
Grimsby (1365)
Newport County (1367)
Mansfield Town (1374)
Northampton (1337)
Walsall (1342)
Scunthorpe (1340)
Swindon Town (1353)[/quote:3f56d6zb]
| |
|
| | Posted: 07 Jan 2020 21:13 | |
![]()
curswine
Posts: 143
Joined: Jan 2017
| | Scotland 1
Greece 1
Dutch 1
Belgium 1
Turkey 1
Denmark 1
Portugal 1
All done.
| |
|
| | Posted: 08 Jan 2020 11:18 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | USA Major League
USA Women
Brazil 1
All complete.
| |
|
| | Posted: 08 Jan 2020 11:42 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Remaining teams here:
https://www.thesportsdb.com/apifootball.php
| |
|
| | Posted: 08 Jan 2020 18:56 | |
![]()
ovokx
Posts: 830
Joined: Jan 2017
| | Australia 1
Brazil 2
Sweden supertanten
Scotland 2
Done!
| |
|
| | Posted: 08 Jan 2020 19:03 | |
![]()
curswine
Posts: 143
Joined: Jan 2017
| | Sweden 1
Mexico 1
Ukraine 1
Russia 1
China 1
England (League) 2
All done.
| |
|
| | Posted: 08 Jan 2020 19:45 | |
![]()
ovokx
Posts: 830
Joined: Jan 2017
| | Yeah! We're pretty close to end with the existing leagues!
| |
|
| | Posted: 08 Jan 2020 19:54 | |
![]()
cydalby
Posts: 188
Joined: Mar 2019
| | How often does a check against api-football take place? Be nice to know how long it might take until we can verify the Alternate name has worked
| |
|
| | Posted: 08 Jan 2020 20:20 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | How often does a check against api-football take place? Be nice to know how long it might take until we can verify the Alternate name has worked
Not implemented any importers yet, I need to do a lot of basework. I'm aiming for very quick updates though.
One of the biggest issues is API-Football has no IdLeague, only an ID for the league AND season. Which makes things quite difficult, but not impossible
I'll probably start with a the Japanese J-League as a test. API-Football has a huge number of leagues so its going to take some time to match up all the "_No League" teams here.
| |
|
| | Posted: 09 Jan 2020 15:55 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | I wrote a nicer browser for the team ID's as posting them here was tiring:
https://www.thesportsdb.com/sync_apifoo ... eagues.php
Basically just click on the flag for the country you are looking for and then click on the league name to see all the team ID's. then update as appropriate on TheSportsDB.
Any help for teams is appreciated
| |
|
| | Posted: 09 Jan 2020 21:08 | |
![]()
ovokx
Posts: 830
Joined: Jan 2017
| | Argentina Primera Division (780)
Poland Ekstraklasa (517)
Norway OBOS-ligaen (288)
Done!
| |
|
| | Posted: 09 Jan 2020 21:11 | |
![]()
cydalby
Posts: 188
Joined: Mar 2019
| | Whats the plan with women's teams/u21's?
Also the United States section doesn't seem to contain the MLS
| |
|
| | Posted: 09 Jan 2020 21:21 | |
![]()
ovokx
Posts: 830
Joined: Jan 2017
| | Also the United States section doesn't seem to contain the MLS
MLS is supported I guess as teams are already linked. The only ones which aren't linked are the new ones that will start on next season
| |
|
| | Posted: 09 Jan 2020 22:02 | |
![]()
cydalby
Posts: 188
Joined: Mar 2019
| | Matched up as many id's as I could!
| |
|
| | Posted: 09 Jan 2020 22:24 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Awesome thanks all, the United states probably needs the URL changing to ?c=USA I think. There may be a few other countries like that as well.
All the fun of the matching process!
| |
|
| | Posted: 09 Jan 2020 22:38 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Whats the plan with women's teams/u21's?
Also the United States section doesn't seem to contain the MLS
We can add them later on, i'm most interested in the leagues we already have and linking their team ID's for now.
| |
|
| | Posted: 10 Jan 2020 09:05 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Few useful links.
https://www.thesportsdb.com/sync_apifoo ... hp?c=world
https://www.thesportsdb.com/sync_apifoo ... .php?c=USA
https://www.thesportsdb.com/apifootball.php
| |
|
| | Posted: 10 Jan 2020 09:20 | |
![]()
cydalby
Posts: 188
Joined: Mar 2019
| | Very useful! Cheers
| |
|
| | Posted: 10 Jan 2020 10:22 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Just Completed:
Wales 1
International Women
USA 2
| |
|
| | Posted: 10 Jan 2020 15:49 | |
![]()
ovokx
Posts: 830
Joined: Jan 2017
| | the United states probably needs the URL changing to ?c=USA I think. There may be a few other countries like that as well.
Same issue with Netherlands
| |
|
| | Posted: 10 Jan 2020 15:55 | |
![]()
cydalby
Posts: 188
Joined: Mar 2019
| | Have matched up as many id's as possible. Missing some European Internationals and the u21 teams
| |
|
| | Posted: 10 Jan 2020 20:46 | |
![]()
zag
Posts: 1,558
Joined: Oct 2016
| | Brilliant, thats pretty much it for our existing leagues. I will spend the weekend getting it all synced up with an events importer.
Then its onto introducing some more leagues and teams
Thanks all for your help!
| |
|