Site
Home / Forum / General Discussion / Timeline Auto-Update

Timeline Auto-Update


Posted: 01 Dec 2020 10:55
cydalby


Posts: 346
Joined: 2020

Any update on getting the event timelines to sync from the apiFootball endpoint yet? Any chance we could turn this on for Premier League at least?

Posted: 01 Dec 2020 20:09

zag


Posts: 3,511
Joined: 2020

Any update on getting the event timelines to sync from the apiFootball endpoint yet? Any chance we could turn this on for Premier League at least?

English Premier league, Spanish La Liga and German Bundasliga are all now pretty much ready to go, but I cant just filter by those leagues without doing a load of temporary hacks. It will need to be at the very least MLS, French and Italian leagues complete with player ID's before I turn this on.

Just for the logic behind this, If we miss just a single players ID and they have a timeline event then the sync will miss it out and cause all kinds of issues with top goal scores(coming soon) etc. So I want to get the backend data right before adding the feature I've run scripts in the background matching player names to the ID's, as well as personally checking and updating the the top 3 leagues player id's, so I am working on this a lot, others can help speed up the process though, it will be a cool feature once its done allowing many more features as well.

cydalby
Posted: 07 Dec 2020 11:51

zag


Posts: 3,511
Joined: 2020

Just to update the progress on this.

Player Matching Complete
Bundesliga
Premier League
La Liga

In progress
Serie A (Nearly complete)
English Championship (in progress)

Still to do
MLS
English Div 1
English Div2
French Ligue 1

cydalby
Posted: 10 Dec 2020 09:01

zag


Posts: 3,511
Joined: 2020

I've moved on to the French league, if anyone can help out with cutout images that would be really useful

https://www.thesportsdb.com/league/4334-French-Ligue-1

I'm itching to get this timeline feature done now

Posted: 10 Dec 2020 10:30
cydalby


Posts: 346
Joined: 2020

I've moved on to the French league, if anyone can help out with cutout images that would be really useful

https://www.thesportsdb.com/league/4334-French-Ligue-1

I'm itching to get this timeline feature done now


Sure, will get some done today

Posted: 11 Dec 2020 17:15
smudgie

Posts: 364
Joined: 2020

Added missing thumbs and cutouts for Angers, French Ligue 1. Also moved the out on loan players
Will look at more teams later


zag
Posted: 11 Dec 2020 20:21

zag


Posts: 3,511
Joined: 2020

Thanks I wrote a squad sync tool to add missing players automatically to a team. Should help a lot but still need artwork and descriptions.

EDIT1: OK french squads synced automatically with ID's
EDIT2: If anyone is interested in an easy way to do the French cutouts:

1) Go to the official website https://www.ligue1.com/
2) Search for the player
3) Click on the player result to show their full profile page
3) Right click on the players image >> save image as
4) You should now get a nice 700x700 size profile image
5) upload image to https://www.remove.bg/ and it should auto resize to 500x500
6) Upload cutout to player page

Posted: 11 Dec 2020 20:44
smudgie

Posts: 364
Joined: 2020

Yes that's what i did, similar to the premier league site , except jpgs
https://www.remove.bg/ resizes to 500 by 500 as well , happy days

zag
Posted: 11 Dec 2020 20:56
smudgie

Posts: 364
Joined: 2020

Seems to be adding players already in the team but with a different spelling of their name
ex Angers Mathias Pereira Lage already in as Mathias Pereira-Lage

Posted: 11 Dec 2020 22:57

zag


Posts: 3,511
Joined: 2020

Yes there will be a few dupes, I will try to clean up

Posted: 15 Dec 2020 10:25
cydalby


Posts: 346
Joined: 2020

Sorry been rammed at work, where are we at currently? Still needing players for Ligue 1?

Posted: 15 Dec 2020 11:31

zag


Posts: 3,511
Joined: 2020

Sorry been rammed at work, where are we at currently? Still needing players for Ligue 1?

Yep Ligue 1 and MLS are outstanding currently.

Serie A also but it is progressing well.

I'm also working on the English Championship in the background as thats the league my home team plays in

Posted: 15 Dec 2020 13:57

zag


Posts: 3,511
Joined: 2020

Similar for MLS you can find a nice high resolution profile face by going to this site
https://www.foxsports.com/soccer/luis-diaz-7-player

Right click on the image and open in new tab
https://b.fssta.com/uploads/application/soccer/headshots/69082.vresize.350.350.medium.22.png

Then remove the scaling "vresize" text from the URL like this:
https://b.fssta.com/uploads/application/soccer/headshots/69082.png

It needs re cropping and increasing colour depth to 16 million colours but its a nice high quality image to use.

Posted: 02 Jan 2021 22:37

zag


Posts: 3,511
Joined: 2020

Ok timeline sync is now active, its experimental for now as you will probably see lots of missing players. Especially the substitutes.

All manual just like the other features until we build up the player database.

Example: https://www.thesportsdb.com/event/1034699

cydalby
Posted: 03 Jan 2021 09:46
cydalby


Posts: 346
Joined: 2020

Amazing cheers

Posted: 03 Jan 2021 10:40

zag


Posts: 3,511
Joined: 2020

I improved it a little, so that the yellow cards show on the player lineup as well next to the players name.

Wondering if I should remove them and the substitutes from the timeline to make it cleaner?

Posted: 03 Jan 2021 11:03
cydalby


Posts: 346
Joined: 2020

I personally use the yellow cards from the timeline api so it’d be great if they stayed. Can’t hurt to have it in both though!

Posted: 03 Jan 2021 16:46

zag


Posts: 3,511
Joined: 2020

I personally use the yellow cards from the timeline api so it’d be great if they stayed. Can’t hurt to have it in both though!

Yeh the data would stay, just looking for better ways to display it...

Posted: 07 Jan 2021 17:11

Ovokx

Posts: 1,768
Joined: 2020

I manually synced all spanish LaLiga events till today with:

- Timeline
- Lineups
- Event stats
- Highlights
- Created, linked & added cutouts for missing players



Posted: 07 Jan 2021 19:58

zag


Posts: 3,511
Joined: 2020

I manually synced all spanish LaLiga events till today with:

- Timeline
- Lineups
- Event stats
- Highlights
- Created, linked & added cutouts for missing players



Ahh amazing thanks, I've had a good look at the English premiership and championship but meant to do it for some other leagues as well but my clicking fingers hurt too much

It will be automated next season I hope but for now it will remain manual until next summer.

EDIT: I've also been playing with the display of timeline events. I hope it pleases all, I tried to simplify the data while keeping the nice look. Still trying to work out how to show assists and red cards.

Ovokx, MaximeGo31
Posted: 08 Jan 2021 19:44

zag


Posts: 3,511
Joined: 2020

Italian, German and French Soccer leagues updated with timelines and any missing players.

Still lots of missing cutout player images but the data looks good now.


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 21 (Total: 21)