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.