The file you have chosen is not an Excel Spreadsheet

[wjlevay]

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]

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 GitHub<https://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 thread<https://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]

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]

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 GitHub<https://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 thread<https://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=>.