Data Retriever

[obtim]

Hello, I would like to conduct an experiment. Upload to the program the data from the bookmaker 1xBet, on virtual soccer(FIFA) - https://x-1xbet-02480.world/ru/cyber/FIFA/.
I have it in CSV format. Results by times and ODDs.
For this I create a new league - Soccer - Italian Championship(for example).
Now I have to load the data from XLS format with the "update from file" mechanism.
Where do I find the order of the columns with the headers that should be in xls format?

[Alex]

Sample XLS file is attached. Required fields: date, time, home, away, G1, G2. HT is desired but not necessary. Custom league must have all the teams and games for at least 3 past seasons + all the games in adjacent leagues with involved past games.

[obtim]

Sample XLS file is attached. Required fields: date, time, home, away, G1, G2. HT is desired but not necessary. Custom league must have all the teams and games for at least 3 past seasons + all the games in adjacent leagues with involved past games.

In the example, the sheet tab is named Tennis, for football named Other
Do I need to remove unused sheets(Tennis sheet)?

[Alex]

Only first worksheet will be imported. So it doesn't matter.

[obtim]

I created(I've uploaded it here: http://sendfile.su/1592266 because it too big 4 attach ) XLS file. Then I Created new League file and updated it from my xls file. There are 16046 entries in the file. I only see data for 01/19/2021 and can't see G1/G2 data. Why?
P.S. I set the format of the cells as in the example.

[Alex]

Your file from http://s4.sendfile.su/download/1592266/ could not be downloaded. Use other download hosting as SU is blocked in many areas.

[obtim]

Your file from http://s4.sendfile.su/download/1592266/ could not be downloaded. Use other download hosting as SU is blocked in many areas.

https://anonfiles.com/xc22C5A1p4/Template_Fifa_xls
I've forgot to say: Odds Wizard shows Teams:20 and Games:42 in the left down corner, after upload this file

[Alex]

Not acceptable as it requires installation of third party application.

[obtim]

Not acceptable as it requires installation of third party application.

https://drive.google.com/uc?id=1VqPHNRB ... t=download

[Alex]

Downloaded ok. Reason that the data was not imported is that columns G1, G2 contained not numbers but strings. Corrected ok. Imported into OW 13534 games. Almost all games are of 2020. Sorry, but your data is not correct: how can Atalanta play 6 (six!) games during one day December 25, 2020 ?!
My advice: better use Tools > Data retriever.

[obtim]

Downloaded ok. Reason that the data was not imported is that columns G1, G2 contained not numbers but strings. Corrected ok. Imported into OW 13534 games. Almost all games are of 2020. Sorry, but your data is not correct: how can Atalanta play 6 (six!) games during one day December 25, 2020 ?!
My advice: better use Tools > Data retriever.

Thanks! This is VIRTUAL games NOT REAL. I'm testing that https://1xbet.co.nz/ru/cyber/FIFA/21030 ... mpionship/

[obtim]

Downloaded ok. Reason that the data was not imported is that columns G1, G2 contained not numbers but strings. Corrected ok. Imported into OW 13534 games. Almost all games are of 2020. Sorry, but your data is not correct: how can Atalanta play 6 (six!) games during one day December 25, 2020 ?!
My advice: better use Tools > Data retriever.

Another question:During download, the program changed Timezone to +1 Where in the settings to prevent changing the time?

[Alex]

The program has no such an option yet, so use your computer time-zone adjustments.

[obtim]

Another question. Made a template for VFL(Virtual Football league) from Betradar(SportRadar). Uploaded it here https://drive.google.com/uc?id=1eDa-zRB ... t=download
But got another mistake during import process - import only 240 records. Why?

[Alex]

Usually the same teams cannot play several games during the same day (except of baseball). Setting "Round date tolerance" prevents from adding such games if its value >= 0. Set it to -1, and try to import again.