| | Posted: 07 Jan 2020 16:22 | |
zag
Posts: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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 | |
zag
Posts: 3,511
Joined: 2020
| | Scotland 1
Greece 1
Dutch 1
Belgium 1
Turkey 1
Denmark 1
Portugal 1
All done.
| |
|
| | Posted: 08 Jan 2020 11:18 | |
zag
Posts: 3,511
Joined: 2020
| | USA Major League
USA Women
Brazil 1
All complete.
| |
|
| | Posted: 08 Jan 2020 11:42 | |
zag
Posts: 3,511
Joined: 2020
| | Remaining teams here:
https://www.thesportsdb.com/apifootball.php
| |
|
| | Posted: 08 Jan 2020 18:56 | |
zag
Posts: 3,511
Joined: 2020
| | Australia 1
Brazil 2
Sweden supertanten
Scotland 2
Done!
| |
|
| | Posted: 08 Jan 2020 19:03 | |
zag
Posts: 3,511
Joined: 2020
| | Sweden 1
Mexico 1
Ukraine 1
Russia 1
China 1
England (League) 2
All done.
| |
|
| | Posted: 08 Jan 2020 19:45 | |
zag
Posts: 3,511
Joined: 2020
| | Yeah! We're pretty close to end with the existing leagues!
| |
|
| | Posted: 08 Jan 2020 19:54 | |
zag
Posts: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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 | |
zag
Posts: 3,511
Joined: 2020
| | Argentina Primera Division (780)
Poland Ekstraklasa (517)
Norway OBOS-ligaen (288)
Done!
| |
|
| | Posted: 09 Jan 2020 21:11 | |
zag
Posts: 3,511
Joined: 2020
| | 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 | |
zag
Posts: 3,511
Joined: 2020
| | 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 | |
zag
Posts: 3,511
Joined: 2020
| | Matched up as many id's as I could!
| |
|
| | Posted: 09 Jan 2020 22:24 | |
zag
Posts: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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 | |
zag
Posts: 3,511
Joined: 2020
| | Very useful! Cheers
| |
|
| | Posted: 10 Jan 2020 10:22 | |
zag
Posts: 3,511
Joined: 2020
| | Just Completed:
Wales 1
International Women
USA 2
| |
|
| | Posted: 10 Jan 2020 15:49 | |
zag
Posts: 3,511
Joined: 2020
| | 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 | |
zag
Posts: 3,511
Joined: 2020
| | 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: 3,511
Joined: 2020
| | 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!
| |
|