Page 1 of 1

Importing Draft History

Posted: Thu Apr 29, 2021 5:08 pm
by bl981
Hey Guys,

I am editing a database to be ready for 2021-22 season. I want to import draft history into the database to have the 2021 NHL Entry Draft already completed with filled draft picks from online mock drafts.

I created a template using the editor, filled in all the prospects and drafts picks and clubs etc. When I try to import into the database I get an error saying that all rows cannot be imported and on the error spreadsheet that it creates every row shows the error is "Club" but i have no idea why? I have every club name entered correctly.

Is what im trying to do not possible? Or do i need to do it a different way?

Thanks,

BL

Importing Draft History

Posted: Thu Apr 29, 2021 5:57 pm
by archibalduk
Can you post a screenshot of part of your import spreadsheet and part of your errors spreadsheet?

Importing Draft History

Posted: Thu Apr 29, 2021 6:22 pm
by bl981
Thanks Arch,

here are the following screenshots

Error message:
https://imgur.com/LsoMaa9

Spreadsheet errors:
https://imgur.com/qnDnod7

draft history spreadsheet:
https://imgur.com/yRBOrnu

Importing Draft History

Posted: Fri Apr 30, 2021 6:11 pm
by bl981
I didnt have the "use club long names" box checked off in the editor. Thanks

Importing Draft History

Posted: Sat May 01, 2021 6:53 am
by archibalduk
Good to hear :thup: