Site
Home / Forum / General Discussion / Multi entries for leagues
Home / Forum / General Discussion / Multi entries for leagues
Multi entries for leagues |
| Posted: 12 Feb 2023 12:29 | |||
Posts: 32 Joined: 2020-06-25 | Hi, I they a way to enter multi games in a easier way other then entering it manually? https://www.thesportsdb.com/league/5344-FIVB-Volleyball-Mens-World-Championship August 26, 2022-11:00 Brazil,3,2,Cuba Japan,3,0,Qatar United States,3,0,Mexico France,3,0,Germany Slovenia,3,0,Cameroon Poland,3,0,Bulgaria August 27, 2022-11:00 Türkiye,3,0,China Netherlands,3,0,Egypt Tunisia,3,0,Puerto Rico Argentina,2,3,Iran Ukraine,0,3,Serbia Italy,3,0,Canada August 28, 2022-11:00 Cuba,3,1,Qatar Brazil,3,0,Japan United States,3,0,Bulgaria Germany,3,0,Cameroon France,3,2,Slovenia Poland,3,0,Mexico August 29, 2022-11:00 Canada,3,0,China Argentina,2,3,Netherlands Serbia,3,0,Puerto Rico Iran,3,1,Egypt Ukraine,3,0,Tunisia Italy,3,0,Türkiye August 30, 2022-11:00 Brazil,3,0,Qatar Japan,3,1,Cuba Mexico,3,2,Bulgaria France,3,0,Cameroon Slovenia,3,0,Germany Poland,3,1,United States August 31, 2022-11:00 Argentina,3,2,Egypt Canada,0,3,Türkiye Serbia,3,0,Tunisia Iran,1,3,Netherlands Ukraine,3,1,Puerto Rico Italy,3,0,China September 03, 2022 Round of 16 - Final Round - Men-17:30 Slovenia,3,1,Germany Italy,3,1,Cuba September 04, 2022 Round of 16 - Final Round - Men-17:30 United States,3,2,Türkiye Poland,3,0,Tunisia September 05, 2022 Round of 16 - Final Round - Men-17:30 Netherlands,0,3,Ukraine Round of 16 - Final Round - Men-21:00 France,3,2,Japan September 06, 2022 Round of 16 - Final Round - Men-17:30 Serbia,0,3,Argentina Brazil,3,0,Iran September 07, 2022 Quarter Finals - Final Round - Men-17:30 Italy,3,2,France Slovenia,3,1,Ukraine September 08, 2022 Quarter Finals - Final Round - Men-17:30 Argentina,1,3,Brazil Poland,3,2,United States September 10, 2022 Semifinals - Final Round - Men-18:00 Poland,3,2,Brazil Italy,3,0,Slovenia September 11, 2022 Final 3-4 - Final Round - Men-18:00 Brazil,3,1,Slovenia Final 1-2 - Final Round - Men-21:00 Poland,1,3,Italy | ||
 | |||
| Posted: 12 Feb 2023 12:37 | |||
Posts: 32 Joined: 2020-06-25 | the format is as follows Home team,Home score,Away Score,Away Team | ||
| |||
| Posted: 12 Feb 2023 13:08 | |||
Posts: 32 Joined: 2020-06-25 | FIVB Volleyball Womens World Championship https://www.thesportsdb.com/league/5345-FIVB-Volleyball-Womens-World-Championship September 24, 2022-13:00 Türkiye,2,3,Thailand Belgium,3,0,Puerto Rico Italy,3,0,Cameroon Dominican Republic,3,0,Korea United States,3,0,Kazakhstan Brazil,3,1,Czech Republic September 25, 2022-13:00 Belgium,3,0,Kenya China,3,0,Argentina Japan,3,0,Colombia Netherlands,3,0,Cameroon Germany,3,1,Bulgaria Serbia,3,0,Canada September 26, 2022-14:15 Japan,3,0,Czech Republic Germany,3,0,Kazakhstan Serbia,3,2,Bulgaria Italy,3,0,Puerto Rico Brazil,3,0,Argentina United States,3,0,Canada September 27, 2022-14:00 Türkiye,3,0,Korea China,3,0,Colombia Dominican Republic,3,0,Croatia Italy,3,1,Belgium Cameroon,0,3,Kenya Poland,3,0,Thailand September 28, 2022-14:00 Thailand,3,0,Croatia China,3,0,Japan Brazil,3,0,Colombia Türkiye,3,2,Dominican Republic Argentina,3,1,Czech Republic Netherlands,3,1,Puerto Rico Poland,3,0,Korea September 29, 2022-13:00 Canada,3,0,Kazakhstan Korea,0,3,Thailand Serbia,3,0,Germany Türkiye,3,0,Croatia Italy,3,0,Kenya United States,3,1,Bulgaria Poland,1,3,Dominican Republic Puerto Rico,3,0,Cameroon September 30, 2022-13:00 Serbia,3,0,Kazakhstan China,3,0,Czech Republic Brazil,1,3,Japan Bulgaria,1,3,Canada Colombia,2,3,Argentina United States,3,0,Germany Netherlands,1,3,Belgium October 01, 2022-13:00 Bulgaria,3,0,Kazakhstan Brazil,3,1,China Dominican Republic,2,3,Thailand Germany,2,3,Canada Puerto Rico,3,1,Kenya Korea,3,1,Croatia Colombia,1,3,Czech Republic United States,0,3,Serbia Poland,2,3,Türkiye October 02, 2022-13:00 Belgium,3,0,Cameroon Japan,3,0,Argentina Netherlands,1,3,Italy October 04, 2022-14:15 Japan,3,1,Belgium Thailand,1,3,Canada Italy,2,3,Brazil United States,3,1,Dominican Republic Türkiye,3,0,Germany Netherlands,3,1,Argentina Serbia,3,0,Poland October 05, 2022-14:15 Italy,3,1,Japan Thailand,1,3,Germany China,3,0,Puerto Rico Türkiye,3,0,Canada Serbia,3,0,Dominican Republic Belgium,3,0,Argentina United States,0,3,Poland October 06, 2022-16:00 Brazil,3,0,Puerto Rico China,3,2,Netherlands October 07, 2022-14:15 Japan,3,0,Puerto Rico Serbia,3,0,Thailand Italy,3,0,Argentina United States,3,1,Türkiye Dominican Republic,3,1,Germany Brazil,3,0,Netherlands Poland,3,2,Canada October 08, 2022-13:30 Italy,3,0,China United States,3,2,Thailand Brazil,3,1,Belgium Serbia,3,0,Türkiye Dominican Republic,2,3,Canada Poland,3,2,Germany October 09, 2022-12:30 China,3,0,Belgium Japan,3,0,Netherlands Puerto Rico,3,1,Argentina October 11, 2022-Quarter Finals - Final Round - Women-17:00 Italy,3,1,China Quarter Finals - Final Round - Women-17:30 United States,3,0,Türkiye Quarter Finals - Final Round - Women-20:00 Brazil,3,2,Japan Quarter Finals - Final Round - Women-20:30 Serbia,3,2,Poland October 12, 2022-Semifinals - Final Round - Women-20:30 Serbia,3,1,United States October 13, 2022-Semifinals - Final Round - Women-20:00 Italy,1,3,Brazil October 15, 2022-Final 3-4 - Final Round - Women-16:00 Italy,3,0,United States Final 1-2 - Final Round - Women-20:00 Brazil,0,3,Serbia | ||
| |||
| Posted: 13 Feb 2023 22:54 | |||
 zag Posts: 3,329 Joined: 2020-03-23 | Sadly not I'm afraid. Unless someone wants to write an importer or can find an API feed. Sometimes I will write an importer if there is a lot of historical data, but its not worth it for smaller imports. Manually is the only way. | ||
| |||
| Posted: 14 Feb 2023 08:49 | |||
Posts: 868 Joined: 2020-06-17 | I could upload them if you produce a properly formatted CSV file. The data you've posted is not suitable to be used in its current format. https://docs.google.com/spreadsheets/d/1MeyyTBNzUllOmEhlxwxjkx2RFlZBAkmU2WBcA55-eWs/edit?usp=sharing is the format I use to bulk add events, the row headers have notes to explain what to add. | ||
| |||
| Posted: 02 Mar 2023 09:44 | |||
Posts: 32 Joined: 2020-06-25 | If this is how you want it please let me know then Ill start looking to fill the gaps. https://www.dropbox.com/s/dmq34rshhqrx4zi/TSDB_Volley-ball-Mens.xlsx?dl=1 | ||
| |||
| Posted: 02 Mar 2023 13:30 | |||
Posts: 868 Joined: 2020-06-17 | Yes that is much better. Couple of things I'd like to point out for the future ... - The UTC times are wrong if the local times are correct. 26/08/2022 14:00 in Ljubljana would be 26/08/2022 12:00 UTC. - Poland vs Mexico, UTC and local time are the same. - Brazil vs Cuba has an 11.5 difference in UTC and local time. - Team names need to be exactly as they appear on the site. For example 'Brazil' should be 'Brazil Volleyball' (https://www.thesportsdb.com/team/141819) most team names should be the same with the suffix Volleyball. If a team doesn't exist then it needs to be added to the DB first. - Rounds should also be as they appear on the website. 'QF' - 'Quarter-Final', 'SF' - 'Semi-Final', 'F' - 'Final'. - Don't change the header names. All of these are easy for me to update myself, so I'll look to add these later today unless there is more details you wish to add yourself? | ||
| |||
| Posted: 02 Mar 2023 15:10 | |||
Posts: 868 Joined: 2020-06-17 | All added. https://www.thesportsdb.com/season.php?l=5344&s=2022 Here is how the data looks that I used to add the events. https://docs.google.com/spreadsheets/d/1iDWdPkrH-UE1Avipf9KvYwanswuJUuVlJdwDHARWBb4/edit?usp=sharing | ||
| |||
| Posted: 03 Mar 2023 08:08 | |||
Posts: 32 Joined: 2020-06-25 | Here is how the data looks that I used to add the events. https://docs.google.com/spreadsheets/d/1iDWdPkrH-UE1Avipf9KvYwanswuJUuVlJdwDHARWBb4/edit?usp=sharing Ok got it will use that in the future for adding stuff. The utc i did manually so might have missed 1 or 2 here or there. curswine | ||
|
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 |