Importing Spreadsheet not recognizing players

mellis193 · Post by **mellis193** » Tue Oct 20, 2020 7:34 pm

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.

Post by **archibalduk** » Tue Oct 20, 2020 10:09 pm

What error message do you get in the _errors.csv/xlsx spreadsheet?

mellis193 · Post by **mellis193** » Tue Oct 20, 2020 10:20 pm

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!!

mellis193 · Post by **mellis193** » Tue Oct 20, 2020 10:47 pm

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!!

Post by **archibalduk** » 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.

mellis193 · Post by **mellis193** » 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!

Post by **archibalduk** » Thu Oct 22, 2020 9:39 pm

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).

Zemalli · Post by **Zemalli** » Sun Nov 05, 2023 8:09 pm

How this issue ended? I am currently facing same issue.