Series of error upon import

Question

Series of error upon import

bennetse opened this issue 5 years ago · 7 comments

Hi, when I try to import the sheet it pops up a dialog box "ERROR: error; Error detected," and then another: "Processing stopped at row 200 [Error(s) parsing Excel File No processible data rows found!]" Each row that I've tried to import shows an error message like this "Row 6 will not be processed due to errors: This form's Resource is missing an EAD ID."

I've followed the suggestion to make sure that the EAD ID is formatted at text and also tried formatting all the rows differently or not at all. Any suggestions?

Answer 1 · 2019-09-16T14:43:43.000Z

The AS resource record needs to have the identifier in the EAD ID field, which is found in the Finding Aid Data section.

…

On Mon, Sep 16, 2019 at 10:30 AM bennetse ***@***.***> wrote: Hi, when I try to import the sheet it pops up a dialog box "ERROR: error; Error detected," and then another: "Processing stopped at row 200 [Error(s) parsing Excel File No processible data rows found!]" Each row that I've tried to import shows an error message like this "Row 6 will not be processed due to errors: This form's Resource is missing an EAD ID." I've followed the suggestion to make sure that the EAD ID is formatted at text and also tried formatting all the rows differently or not at all. Any suggestions? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#58?email_source=notifications&email_token=AJJ7MVPCKDKE5TGKCLM52RLQJ6J77A5CNFSM4IXDDBGKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HLTF34A>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AJJ7MVIK3CE4LJUKPM4VME3QJ6J77ANCNFSM4IXDDBGA> .

Answer 2 · 2019-09-16T14:55:34.000Z

Thanks, @kschlottmann for answering the question more quickly than I got to it! 💯

Also, make sure that the EAD ID on the spreadsheet matches exactly the entry in Finding Aid EAD ID (e.g.: if you have MAD003 in the Finding Aid EAD ID field, don't use mad003 in your spreadsheet).

Answer 3 · 2019-09-16T15:02:54.000Z

Alas it does match exactly, to this human eye anyway @kschlottmann @bobbi-SMR There isn't anything else it could be?

Answer 4 · 2019-09-16T15:12:53.000Z

hmm. I've never seen this problem before where the EADID in the Finding Aid and the EADID in the spreadsheet match to the eye, but don't match, computationally. Can you upload your spreadsheet, or send it to me (bobbi-SMR AT bobbifox.net)? And also download the EAD of your resource, then upload/send so I can take a look?

Answer 5 · 2019-09-16T15:57:30.000Z

Good news @bobbi-SMR , operator error - turns out that I had the collection id under the Basic Information section but not in the Finding Aid Data section. If anyone else encounters this error, check under FAD! Thanks for everyone's help!

Answer 6 · 2019-09-16T17:17:57.000Z

I love it when users solve their own problems! 😄

Answer 7 · 2019-09-16T17:29:45.000Z

Thanks for asking for the EAD, it prompted me to look at it before I sent it and the issue was much more obvious there!