Site
Home / Forum / General Discussion / NFL 2017 Season fixtures not updated

NFL 2017 Season fixtures not updated


Posted: 12 Sep 2017 12:49

zag


Posts: 3,511
Joined: 2020

Hi, first time user.

I can see that the primera league is updated with all the known coming fixtures for 2017/18. For the NFL the only one fixture is shown for the 2017: Kansas City Chiefs - New England Patriots (https://www.thesportsdb.com/season.php?s ... =4391&r=01)

If i understand the data structure correct the following should should provide a full list of 2017 fixtures (https://www.thesportsdb.com/season.php?l=4391&s=2017)

If I can update the league for my teams i'm okay with that, however I can see that there is an "Automatic Importer" for american football, so I don't wan't to screw up the db by making duplicates.

What is the best cause of action here?

Posted: 13 Sep 2017 09:51

zag


Posts: 3,511
Joined: 2020

Ahh had the season started yet?

I will take a look, last time I checked it was during the season break.

EDIT: Does anyone know of any NFL team name changes for the new season?

Posted: 13 Sep 2017 11:01

zag


Posts: 3,511
Joined: 2020

i tried updating our NFL python script but it failed unfortunately.

Maybe hjone72 knows how to fix as he wrote it originally?

Posted: 14 Sep 2017 19:47

zag


Posts: 3,511
Joined: 2020

So the NFL-page says it should update by itself. But it hasen't for the whole first week. Anyone knows why?

Posted: 15 Sep 2017 08:25

zag


Posts: 3,511
Joined: 2020

Yep it broken for the new season. I just need the original developer to look at the python script we use, as its a bit beyond me.

viewtopic.php?f=4&t=4045

The module still seems to be working so it should be an easy fix.

Just need to work out why changing the year to 2017 in the code doesn't work

Can you help out and check all the teams are current in the database? Any name changes?

Posted: 15 Sep 2017 15:25

zag


Posts: 3,511
Joined: 2020

The San Diego Chargers have changed city to Los Angeles, other than that, everything seems fine

Posted: 16 Sep 2017 10:55

zag


Posts: 3,511
Joined: 2020

Thanks! I've changed the name now.

Any idea what their short code might be? At the moment its "SD".

Posted: 16 Sep 2017 11:19

zag


Posts: 3,511
Joined: 2020

Worked it out. For my own info later:

teams = [
['ARI', 'Arizona', 'Cardinals', 'Arizona Cardinals'],
['ATL', 'Atlanta', 'Falcons', 'Atlanta Falcons'],
['BAL', 'Baltimore', 'Ravens', 'Baltimore Ravens'],
['BUF', 'Buffalo', 'Bills', 'Buffalo Bills'],
['CAR', 'Carolina', 'Panthers', 'Carolina Panthers'],
['CHI', 'Chicago', 'Bears', 'Chicago Bears'],
['CIN', 'Cincinnati', 'Bengals', 'Cincinnati Bengals'],
['CLE', 'Cleveland', 'Browns', 'Cleveland Browns'],
['DAL', 'Dallas', 'Cowboys', 'Dallas Cowboys'],
['DEN', 'Denver', 'Broncos', 'Denver Broncos'],
['DET', 'Detroit', 'Lions', 'Detroit Lions'],
['GB', 'Green Bay', 'Packers', 'Green Bay Packers', 'G.B.', 'GNB'],
['HOU', 'Houston', 'Texans', 'Houston Texans'],
['IND', 'Indianapolis', 'Colts', 'Indianapolis Colts'],
['JAC', 'Jacksonville', 'Jaguars', 'Jacksonville Jaguars', 'JAX'],
['KC', 'Kansas City', 'Chiefs', 'Kansas City Chiefs', 'K.C.', 'KAN'],
['LA', 'Los Angeles', 'Rams', 'Los Angeles Rams', 'L.A.'],
['MIA', 'Miami', 'Dolphins', 'Miami Dolphins'],
['MIN', 'Minnesota', 'Vikings', 'Minnesota Vikings'],
['NE', 'New England', 'Patriots', 'New England Patriots', 'N.E.', 'NWE'],
['NO', 'New Orleans', 'Saints', 'New Orleans Saints', 'N.O.', 'NOR'],
['NYG', 'Giants', 'New York Giants', 'N.Y.G.'],
['NYJ', 'Jets', 'New York Jets', 'N.Y.J.'],
['OAK', 'Oakland', 'Raiders', 'Oakland Raiders'],
['PHI', 'Philadelphia', 'Eagles', 'Philadelphia Eagles'],
['PIT', 'Pittsburgh', 'Steelers', 'Pittsburgh Steelers'],
['SD', 'San Diego', 'Chargers', 'San Diego Chargers', 'S.D.', 'SDG'],
['SEA', 'Seattle', 'Seahawks', 'Seattle Seahawks'],
['SF', 'San Francisco', '49ers', 'San Francisco 49ers', 'S.F.', 'SFO'],
['STL', 'St. Louis', 'Rams', 'St. Louis Rams', 'S.T.L.'],
['TB', 'Tampa Bay', 'Buccaneers', 'Tampa Bay Buccaneers', 'T.B.', 'TAM'],
['TEN', 'Tennessee', 'Titans', 'Tennessee Titans'],
['WAS', 'Washington', 'Redskins', 'Washington Redskins', 'WSH'],
]


Posted: 16 Sep 2017 11:40

zag


Posts: 3,511
Joined: 2020

After much investigation it seems the opensource project 'nflgame' is not working for 2017 yet:

https://github.com/BurntSushi/nflgame/issues/331

Our importer is based on this, so we just have to wait for them to fix it.

Posted: 16 Sep 2017 20:37

zag


Posts: 3,511
Joined: 2020

Okey, thanks for looking into it

Posted: 16 Sep 2017 21:25

zag


Posts: 3,511
Joined: 2020

A fair few NFL teams still need their details filled out while we wait...

Posted: 18 Sep 2017 08:37

zag


Posts: 3,511
Joined: 2020

OK seems I just needed to sync the new year in python.

We are live updating results again for NFL!

https://www.thesportsdb.com/season.php?l=4391&s=2017

Posted: 18 Sep 2017 17:22

zag


Posts: 3,511
Joined: 2020

Upcoming games are not displayed. Is there any chance to add full calendar and then update the scores? I'm requesting this in order to be able to add the TV listing for these events.

Same behaviour will be great also NBA games which are added always once they're played, instead of full schedule

Thank you!

Posted: 18 Sep 2017 19:55

zag


Posts: 3,511
Joined: 2020

Unfortunately not as the API doesn't have future games. I will keep look out though. Its the same for NHL and NBA.

The only thing we really have is Soccer, Rugby and Motorsports in advance at the moment which is a big shame.

Posted: 22 Sep 2017 20:05

zag


Posts: 3,511
Joined: 2020

EDIT: Does anyone know of any NFL team name changes for the new season?

Posted: 23 Sep 2017 10:39

zag


Posts: 3,511
Joined: 2020

Thanks, just a reminder that anyone can update that info. just click the "edit team" button on the appropriate team.

I've done it this time.

EDIT: Wow that's a beautiful stadium!!




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 0 to 16 (Total: 16)