search

harvard-library / aspace-import-excel

Import resources, archival objects, etc. into ArchivesSpace using Excel spreadsheet files
Apache License 2.0
43 stars 10 forks source link

The file you have chosen is not an Excel Spreadsheet #41

Closed wjlevay closed 5 years ago

wjlevay commented 6 years ago

I'm testing this out on a local instance of ASpace (2.4.1 on Windows 10, using the embedded database), but cannot get past this error. This occurs with every xslx and xls I've thrown at it, and even when using an unedited copy of the provided Excel template.

bobbi-SMR commented 6 years ago

Hi,

I’m happy to work with you to trouble-shoot this, but I am not in a position to replicate your environment. Perhaps the answers to my questions below will help me trouble-shoot:

When you get the unedited copy of the Excel template, are you downloading it from GitHub?

If so, are you just downloading it, or first opening it up in Excel (I’m assuming your browser/Windows 10 interaction gives you the option of Open with or Save File). -- If you’re Opening With, then Saving: what version of Excel are you using? -- Are you then doing a “Save as…” (I believe you have to, since the template on GitHub is read-only), and, if so, what type do you select?

To get technical: you are getting this error because the javascript check on the file object created by the Add File process is looking for a file object type whose value is application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Cheers, Bobbi

From: Bill Levay [mailto:notifications@github.com] Sent: Tuesday, August 14, 2018 2:04 PM To: harvard-library/aspace-import-excel aspace-import-excel@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [harvard-library/aspace-import-excel] The file you have chosen is not an Excel Spreadsheet (#41)

I'm testing this out on a local instance of ASpace (2.4.1 on Windows 10, using the embedded database), but cannot get past this error. This occurs with every xslx and xls I've thrown at it, and even when using an unedited copy of the provided Excel template.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_harvard-2Dlibrary_aspace-2Dimport-2Dexcel_issues_41&d=DwMCaQ&c=WO-RGvefibhHBZq3fL85hQ&r=5xWUzLrZrVLeTqs3CDoeRpPtLv1fRM04CCu4TDULrSY&m=IkzP84DIlsnJEByQmJoNBUTqnCWR0hRVRrZtrqjgJpk&s=qNMzT-njPmHGKY4PHIScuoeIrVwYa5AjkAJIFNC_WxM&e=, or mute the threadhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_ADrXYyuvqnJXr4aCSTD-5FKutdqSapLUbqks5uQxEEgaJpZM4V86Hv&d=DwMCaQ&c=WO-RGvefibhHBZq3fL85hQ&r=5xWUzLrZrVLeTqs3CDoeRpPtLv1fRM04CCu4TDULrSY&m=IkzP84DIlsnJEByQmJoNBUTqnCWR0hRVRrZtrqjgJpk&s=E9zWQ1d7rjqEJNkxJ8A5Zb2MTfNVTMt_dL43lWNsVU8&e=.

wjlevay commented 6 years ago

Thanks. I checked the mime-type of the spreadsheets I've been trying to import and indeed they are all application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

I'm thinking I must have something misconfigured in my environment. I'll keep troubleshooting.

bobbi-SMR commented 6 years ago

Hi, Bill,

It occurred to me that if you have Web Developer tools in your browser (I use FireFox), you could set breakpoints in assets/tree_extensions.js (around line 97 and/or 99), and see what you get as the fileObj.type.

Let me know if that’s helpful.

Cheers, Bobbi

From: Bill Levay [mailto:notifications@github.com] Sent: Tuesday, August 21, 2018 1:16 PM To: harvard-library/aspace-import-excel aspace-import-excel@noreply.github.com Cc: Fox, Bobbi bobbi_fox@harvard.edu; Comment comment@noreply.github.com Subject: Re: [harvard-library/aspace-import-excel] The file you have chosen is not an Excel Spreadsheet (#41)

Thanks. I checked the mime-type of the spreadsheets I've been trying to import and indeed they are all application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

I'm thinking I must have something misconfigured in my environment. I'll keep troubleshooting.

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_harvard-2Dlibrary_aspace-2Dimport-2Dexcel_issues_41-23issuecomment-2D414752046&d=DwMFaQ&c=WO-RGvefibhHBZq3fL85hQ&r=5xWUzLrZrVLeTqs3CDoeRpPtLv1fRM04CCu4TDULrSY&m=IEzOwlGu2nFoYRTqjmJxmnGku7N8C-Eg4tnfnxsPzGs&s=xAc4zZdmOjwavITRML7lfKqSqAUnAx6ZOih-0rJAhhg&e=, or mute the threadhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_ADrXY58y-5F8s-5FbV7xsKV9bkD7es5yuDXNks5uTEBZgaJpZM4V86Hv&d=DwMFaQ&c=WO-RGvefibhHBZq3fL85hQ&r=5xWUzLrZrVLeTqs3CDoeRpPtLv1fRM04CCu4TDULrSY&m=IEzOwlGu2nFoYRTqjmJxmnGku7N8C-Eg4tnfnxsPzGs&s=goJhhfhONpbtGli994ypyClBV9djau4t4pZ97NRoWas&e=.