Page 1 of 1

Importing Spreadsheet not recognizing players

Posted: Tue Oct 20, 2020 7:34 pm
by mellis193
Hi,

I just want to start off by thanking the amazing contributions to keep this game alive.

My issue I'm having is when I import a spreadsheet the players are not being recognized. All I've changed is the data in the current ability/potential ability columns. I can put "a" in the mode column and they will be added to my database, but then I'm just duplicating players. Using "e" for edit or "d" for delete I get an error. It looks like this may have something to do with player histories? I can't understand why this happening otherwise.

Anyone that can help?

Much appreciated.

Importing Spreadsheet not recognizing players

Posted: Tue Oct 20, 2020 10:09 pm
by archibalduk
What error message do you get in the _errors.csv/xlsx spreadsheet?

Importing Spreadsheet not recognizing players

Posted: Tue Oct 20, 2020 10:20 pm
by mellis193
Under Column A I get TRUE for every row.

Columns B C and D are for Club Contracted, Club Playing For, and Errors and all these cells are empty.

If you want, I can try to post a screenshot, however not quite sure how to do that unfortunately.

P.S. In my original spreadsheet I'm trying to import I keep Mode(e) empty as your spreadsheet guide says to do.

Thanks for your help!!

Importing Spreadsheet not recognizing players

Posted: Tue Oct 20, 2020 10:47 pm
by mellis193
archibalduk wrote: Tue Oct 20, 2020 10:09 pm What error message do you get in the _errors.csv/xlsx spreadsheet?
Under Column A I get TRUE for every row.

Columns B C and D are for Club Contracted, Club Playing For, and Errors and all these cells are empty.

If you want, I can try to post a screenshot, however not quite sure how to do that unfortunately.

P.S. In my original spreadsheet I'm trying to import I keep Mode(e) empty as your spreadsheet guide says to do.

Thanks for your help!!

Importing Spreadsheet not recognizing players

Posted: Wed Oct 21, 2020 8:08 am
by archibalduk
That means the Editor cannot find a person matching the selected name and DOB in the database. If you have double-checked these details are correct then upload the DB and spreadsheet and I'll take a quick look.

Importing Spreadsheet not recognizing players

Posted: Wed Oct 21, 2020 4:20 pm
by mellis193
archibalduk wrote: Wed Oct 21, 2020 8:08 am That means the Editor cannot find a person matching the selected name and DOB in the database. If you have double-checked these details are correct then upload the DB and spreadsheet and I'll take a quick look.
https://www.dropbox.com/s/m6egjl5wwkrvz ... 4.csv?dl=0

https://www.dropbox.com/s/0g8vdzn2ye1v8 ... s.csv?dl=0

First link is my file and the second is the errors.

Now, when I just try to quickly export and import the database that was just released I'm getting a similar message.

Thanks for looking into this! Please let me know what you find. Much appreciated!

Importing Spreadsheet not recognizing players

Posted: Thu Oct 22, 2020 9:39 pm
by archibalduk
mellis193 wrote: Wed Oct 21, 2020 4:20 pm
archibalduk wrote: Wed Oct 21, 2020 8:08 am That means the Editor cannot find a person matching the selected name and DOB in the database. If you have double-checked these details are correct then upload the DB and spreadsheet and I'll take a quick look.
https://www.dropbox.com/s/m6egjl5wwkrvz ... 4.csv?dl=0

https://www.dropbox.com/s/0g8vdzn2ye1v8 ... s.csv?dl=0

First link is my file and the second is the errors.

Now, when I just try to quickly export and import the database that was just released I'm getting a similar message.

Thanks for looking into this! Please let me know what you find. Much appreciated!
Can you upload the DB you're trying to import into?

I tried your spreadsheet on the v5 Pivot Rosters and it works fine (other than two errors but they're obvious typos).

Importing Spreadsheet not recognizing players

Posted: Sun Nov 05, 2023 8:09 pm
by Zemalli
How this issue ended? I am currently facing same issue.