| | Posted: 24 Sep 2019 22:33 | |
zag
Posts: 3,515
Joined: 2020
| | Anyone know when this might appear? Games start next week.
| |
 |
| | Posted: 25 Sep 2019 09:08 | |
zag
Posts: 3,515
Joined: 2020
| | I'll see what I can do to get it imported, its a lot of games!
In the mean time, anyone can add events...
| |
|
| | Posted: 25 Sep 2019 10:07 | |
zag
Posts: 3,515
Joined: 2020
| | OK looks like our importer works for the new seasons.... hurray!!
1300+ events added including the pre-season events and scores.
It may not be perfect but it is importing as much as possible each day. I suspect people may need to help with adding some scores as a few are already missing for some reason (Maybe UTC date times is the issue).
| |
|
| | Posted: 04 Oct 2019 16:26 | |
zag
Posts: 3,515
Joined: 2020
| | Thanks for getting those in there! One big problem is that the UTC dates / times are all off--for instance, the _true_ UTC day for an upcoming game is actually a day ahead of the posted one. Which means if you use moment or something to convert from UTC to another timezone you'll often be a whole day off.
Is there any way just to import a timestamp rather than the confusing split between strTime and dateEvent? They should really just be one field.
Thanks!
Adam
| |
|
| | Posted: 04 Oct 2019 16:49 | |
zag
Posts: 3,515
Joined: 2020
| | Since the season started, I'm updating this info manually while I add the TV info. The issue here is that unfortunately, all the events are not "local date +1"
| |
|
| | Posted: 04 Oct 2019 19:50 | |
zag
Posts: 3,515
Joined: 2020
| | Since the season started, I'm updating this info manually while I add the TV info. The issue here is that unfortunately, all the events are not "local date +1"
Damn
I will see what I can do to fix.
EDIT: I just checked. Can you give an example of what it should be just so I can understand?
https://www.thesportsdb.com/event/619535
| |
|
| | Posted: 04 Oct 2019 23:13 | |
zag
Posts: 3,515
Joined: 2020
| |
Damn
I will see what I can do to fix.
EDIT: I just checked. Can you give an example of what it should be just so I can understand?
https://www.thesportsdb.com/event/619535
UTC date is incorrect, as it should be 4th October as UTC time is 12:00am which is correct
Local date is correct, but local time is wrong as it should be 8:00pm ET
But also we have some events that are played earlier in time and then, UTC & Local dates are correct like on this example: https://www.thesportsdb.com/event/617567
So there's no easy fix in adding automatically a +1 on date for all the events imported as depence also on the time to make that "jump"
| |
|
| | Posted: 05 Oct 2019 11:59 | |
zag
Posts: 3,515
Joined: 2020
| | OK thanks, that's actually reasonably easy to fix programatically. I will take a look.
I want to get UTC and local time working for all the main sports and leagues.
| |
|
| | Posted: 07 Oct 2019 22:57 | |
zag
Posts: 3,515
Joined: 2020
| | Great, thanks! You can delete this one as it is a duplicate:
https://www.thesportsdb.com/event/619586
Adam
| |
|
| | Posted: 08 Oct 2019 08:32 | |
zag
Posts: 3,515
Joined: 2020
| | Great, thanks! You can delete this one as it is a duplicate:
https://www.thesportsdb.com/event/619586
Adam
Thanks done
| |
|
| | Posted: 10 Oct 2019 21:06 | |
zag
Posts: 3,515
Joined: 2020
| | NHL games are still coming in with the wrong dates (ie non UTC, no times). Additionally, it seems like there are duplicate games created? For instance, there is a 'correct' entry for the October 9th (PDT) Kings-Canucks game and a non-correct game posted for the game also.
| |
|
| | Posted: 10 Oct 2019 21:16 | |
zag
Posts: 3,515
Joined: 2020
| | Also this game is a duplicate with wrong time info and can be deleted:
https://www.thesportsdb.com/event/619729
Cheers,
Adam
| |
|
| | Posted: 11 Oct 2019 15:30 | |
zag
Posts: 3,515
Joined: 2020
| | Also this game is a duplicate with wrong time info and can be deleted:
https://www.thesportsdb.com/event/619729
Cheers,
Adam
Sure, done! Thanks for the advise!
| |
|
| | Posted: 12 Oct 2019 10:41 | |
zag
Posts: 3,515
Joined: 2020
| | I think their might be more, I will check it all out.
| |
|
| | Posted: 13 Oct 2019 21:34 | |
zag
Posts: 3,515
Joined: 2020
| | Hopefully fixed now for UTC times, I made a few mistakes on this one but got there in the end.
It needed a full re-import. Hopefully the auto score updater works better in the future also...
| |
|