Site
Home / Forum / General Discussion / League creation (Biathlon World Cup)
Home / Forum / General Discussion / League creation (Biathlon World Cup)
League creation (Biathlon World Cup) |
| Posted: 10 Jan 2023 15:51 | |||
 zag  Posts: 3,511 Joined: 2020 | Great teamwork all! Ptikrazy | ||
 | |||
| Posted: 23 Jan 2023 18:34 | |||
 Posts: 22 Joined: 2022 | Hello there ! I'm reviving this because I'm trying to work on a PSD with variables as you suggested curswine, to have posters generated automatically. I watched some videos about it, as I understand you need a PSD file + a text file with all the variables. My idea is simple: getting the country's flag in background + city name & year in text in front. I assume I'll have to give you both files, but I wonder is there a way to dynamically retrieve the city + year from the event before the poster is generated ? I could provide a file with all the countries and cities from the beginning of the world cup until now, but if there's a new city next year I don't know how to handle that automatically. I'm totally new to this so I'm probably missing something obvious, if you have any advice  | ||
| |||
| Posted: 23 Jan 2023 19:10 | |||
Posts: 935 Joined: 2020 | I'm reviving this because I'm trying to work on a PSD with variables as you suggested curswine, to have posters generated automatically. I watched some videos about it, as I understand you need a PSD file + a text file with all the variables. My idea is simple: getting the country's flag in background + city name & year in text in front. I assume I'll have to give you both files, but I wonder is there a way to dynamically retrieve the city + year from the event before the poster is generated ? I could provide a file with all the countries and cities from the beginning of the world cup until now, but if there's a new city next year I don't know how to handle that automatically. I'm totally new to this so I'm probably missing something obvious, if you have any advice That sounds very possible. The more experienced you are with Photoshop and using spreadsheets like Excel or Google Sheets the better results you can achieve. You can write a script that will pull the data from the API, but that shouldn't be necessary since that data is already in a spreadsheet. Post a draft image of what you're trying to create and I'll see how possible it is to do it for all events. | ||
| |||
| Posted: 23 Jan 2023 20:04 | |||
Posts: 22 Joined: 2022 | That sounds very possible. The more experienced you are with Photoshop and using spreadsheets like Excel or Google Sheets the better results you can achieve. You can write a script that will pull the data from the API, but that shouldn't be necessary since that data is already in a spreadsheet. Post a draft image of what you're trying to create and I'll see how possible it is to do it for all events. Alright ! Here it is, very basic stuff: https://drive.google.com/file/d/1j1KqkocMLgxqvKMn5m1bbtA6kc6op8vf/view?usp=share_link As I understand it I created 2 layers that should dynamically change with what I put in the Excel file. Could you tell me what it lacks to be usable please ? I'll try my best to complete it | ||
| |||
| Posted: 24 Jan 2023 07:03 | |||
Posts: 935 Joined: 2020 | You're not wrong that is as basic as it gets. You should add a text layer at the bottom which would be the filename, this is the easiest way to control what files are called when you export the data sets. | ||
| |||
| Posted: 24 Jan 2023 16:08 | |||
Posts: 22 Joined: 2022 | Alright, I'll look into it but it seems a bit too complicated for me | ||
| |||
| Posted: 24 Jan 2023 17:15 | |||
Posts: 935 Joined: 2020 | If you design the psd I'm happy to deal with the spreadsheet and variables in Photoshop. | ||
| |||
| Posted: 25 Jan 2023 00:10 | |||
Posts: 22 Joined: 2022 | I absolutely suck at these kind of artistic things, as you witnessed I'll see if I can motivate a friend to help me, otherwise no poster is ok. I'm also gonna start to fill the previous doc I linked here with past years in the coming days, I'll follow your examples and let you know when you can import. First edition was 1978, would you prefer to import everything at once or like 10 years by 10 years ? | ||
| |||
| Posted: 25 Jan 2023 08:19 | |||
Posts: 935 Joined: 2020 | I absolutely suck at these kind of artistic things, as you witnessed I'll see if I can motivate a friend to help me, otherwise no poster is ok. I'm also gonna start to fill the previous doc I linked here with past years in the coming days, I'll follow your examples and let you know when you can import. First edition was 1978, would you prefer to import everything at once or like 10 years by 10 years ? Alright, if you come up with anything just post it here and I'll do my best to batch process it. Lets go with 10 years at a time, make sure the data is as detailed as possible. | ||
| |||
| Posted: 27 Jan 2023 17:42 | |||
Posts: 22 Joined: 2022 | Lets go with 10 years at a time, make sure the data is as detailed as possible. I'll do my best yeah, I'll follow you examples and that should be fine  | ||
| |||
| Posted: 23 Oct 2024 23:42 | |||
Posts: 22 Joined: 2022 | Hey guys, I'm really sorry it took me SO long to finally have the patience to work on this, I know you created the league based on my assurance I would fill it quickly... But that's it, I want to make things square now I managed to create a to scrap the website https://biathlonresults.com/, the official results of the Biathlon events. The result is the following for the season 2023-2024: https://gofile.io/d/fk7u8v Is this formatting good for you guys ? The only thing that changes compared to what has already been added is the name of the events (eg. "4x6km Mixed Relay" becomes "4x6km Mixed Relay (W+M)"), and some city names (Östersund becomes Oestersund). It would be a lot easier to go back from scratch, since the scraping takes approximatively 30s for a season, but I would understand if you don't want to erase the seasons that's already been added and in that case I would work on converting the name of the races to what's already in here. One more time, sorry for the almost 2 years delay, I've been discouraged by the task for months until I really put my head in. If you need me to adapt some things, let me know ! But if it's good for you, I can provide a file with all seasons tomorrow. Thanks ! zag | ||
| |||
| Posted: 24 Oct 2024 13:51 | |||
Posts: 935 Joined: 2020 | All have been added. I tweaked a few event names to keep some uniformity with previously added ones. https://www.thesportsdb.com/season/5342-Biathlon-World-Cup/2023-2024 | ||
| |||
| Posted: 24 Oct 2024 16:42 | |||
Posts: 22 Joined: 2022 | Thanks curswine ! Could you tell me the ones you modified please ? I'll provide a spreadsheet with all seasons later today with the correct naming. Thanks Edit: I just realized there's an issue with the UTC and local date. I'll fix it tomorrow and give you the spreadsheet. | ||
| |||
| Posted: 25 Oct 2024 08:08 | |||
Posts: 935 Joined: 2020 | Thanks curswine ! Could you tell me the ones you modified please ? I'll provide a spreadsheet with all seasons later today with the correct naming. Thanks Edit: I just realized there's an issue with the UTC and local date. I'll fix it tomorrow and give you the spreadsheet. I actually changed all the names in one way or another. I added an 'S' to all the Men and Women events. I removed the (W+M) from the Mixed events. I think there are a few other things, but those are what I remember. | ||
| |||
| Posted: 26 Oct 2024 12:22 | |||
Posts: 22 Joined: 2022 | Alright, here's the file: https://gofile.io/d/0yFqWM Sadly for some races the time is probably false (no race starts at 1 in the morning), but I don't have any other source. I didn't add the first few seasons because some events were missing, I'll add them by hand later. Let me know if you need me to format things differently ! My apologies again for the delay, but it should be (almost) complete 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 |