search

archibalduk / TransferTool

An open source program to add and edit players using spreadsheets
2 stars 2 forks source link

expand the Clubs import option to include, Stadiums, Cities and Referees #13

Open MScientistCM opened 3 years ago

Dermotron commented 3 years ago

Wow Gian, thanks for looking into this

Dermotron commented 2 years ago

Hi Gain,

I know a lot has happened in the past couple of years but did you ever look into this? I see someone has posted their version of the Turkish leagues but based on our 2022 April Data. Going forward, this will probably happen more as the pool of people playing shrinks and the people with different languages try to collaborate (I've tried talking to the guy that posted the Turkish data before but he had to converse via Google Translate).

Cities and Stadiums are a pains taking task since you generally have to do both at once. Find stadium name, find city, create city, find co-ordinates, create stadium, add city, add club.

Clubs imported with Stadiums is probably going to be messy but even importing cities, then stadiums, then manually adding to them clubs probably compresses 4hrs work to 1hr.

regards Dermot

MScientistCM commented 2 years ago

Hi Gain,

I know a lot has happened in the past couple of years but did you ever look into this? I see someone has posted their version of the Turkish leagues but based on our 2022 April Data. Going forward, this will probably happen more as the pool of people playing shrinks and the people with different languages try to collaborate (I've tried talking to the guy that posted the Turkish data before but he had to converse via Google Translate).

Cities and Stadiums are a pains taking task since you generally have to do both at once. Find stadium name, find city, create city, find co-ordinates, create stadium, add city, add club.

Clubs imported with Stadiums is probably going to be messy but even importing cities, then stadiums, then manually adding to them clubs probably compresses 4hrs work to 1hr.

regards Dermot

no time for such big task right now

Dermotron commented 2 years ago

Thanks Gian. I have no idea how much work is involved but it's best to ask. Adding 60 Sweden/Georgia/Belarus clubs recently took about 15 hours in terms of database sessions (not purely just adding those clubs though). I'll see if I can get JohnLockes version to work for cities at least