XLSX and DOCX files being downloaded as ZIP files

  • Profile Image
    rvannatta
    Asked on May 15, 2011 at 09:53 AM

    Is there a time frame on when this problem will be resolved.  Several other posts and your technical staff have acknowledged that the problem is related to the MIME type being communicated to the brower. 

    The work arounds are painful.

    Help?

    UPDATE: Have you looked at my latest post?

  • Profile Image
    NeilVicente
    Answered on May 15, 2011 at 12:46 PM

    Hi,

    So far, after using the three major browsers today (IE, Firefox, Chrome), I'm still not able to replicate your situation.

     

     

    Upon further research, it looks like older versions of IE has this recurring problem. Are you, by any chance, using IE 7? If yes, I guess it might be time to retire that old browser and use a more current one, such as Firefox.

    Hope this information was of help to you. Let me know if there's anything else you need assistance with.


    Neil

  • Profile Image
    rvannatta
    Answered on May 15, 2011 at 12:53 PM

    I am using IE 9 which is the latest and greatest, although I had the problem on IE 8 as well. Your screen shots show you downloading an .XLS file.  Not an .XLSX file.

    XLSX is an XML based format introduced in Office 2007.

    Can you try it again with an XLSX document?  I have one uploaded on 2011-05-15 09:32:25 called Test.xlsx.

  • Profile Image
    rvannatta
    Answered on May 15, 2011 at 12:54 PM

    I am using IE 9 which is the latest and greatest, although I had the problem
    on IE 8 as well. Your screen shots show you downloading an .XLS file. Not an
    .XLSX file.

    XLSX is an XML based format introduced in Office 2007.

    Can you try it again with an XLSX document? I have one uploaded on
    2011-05-15 09:32:25 called Test.xlsx.


  • Profile Image
    rvannatta
    Answered on May 15, 2011 at 01:00 PM

    I tried it with Chrome and it worked fine.  This is an issue with how the server is telling IE what the MIME type is....  and it occurs with the latest version of IE, version 9.

  • Profile Image
    NeilVicente
    Answered on May 15, 2011 at 01:04 PM

    Hi,

    As per your request:

     

     

    Using IE 8

     

    I have read somewhere that this issue might have something to do with Microsoft Office's settings. I cannot be sure though. I think it's safer to use a non-MS browser such as Firefox or Chrome on the premise that Office cannot have control over these browsers.

    Try using either of the two browsers I mentioned, then get back to us if the problem still persists.

    EDIT: I missed your post by a heartbeat. Glad to know that you were able to sort things out.


    Neil

  • Profile Image
    rvannatta
    Answered on May 15, 2011 at 02:19 PM

    Ok, so here's what I found out.  

    IE does something called MIME Sniffing, that is, it reads the first 200 bytes of data from a downladed file, to determine what app it's associated with only IF certain conditions exist on the local machine.  So it won't always happen on every PC running IE.  That explains why you can't replicate the problem but many others continue to experience it.

    While I like Chrome and use it every day, it seems like you'd want to make your service compatible with all browers.  Especially since one of the HUGE selling points of JotForm is the large storage available with paid accounts along with it's integration with DropBox.

    I should point out that when I turn on Compatability View in IE9, the problem seems to go away.

    But I'd suggest that you take a look at this post.  I still beleive that you can fix this for everyone by making changes on the server side so that IE never needs to MIME sniff.

    http://www.webdeveloper.com/forum/showthread.php?t=162526

    It turns out that Office 2007/2010 documents are ZIP'ed XML documents.  They're zip files.  So IE gets to a point where it's not sure what is being downloaded and it takes matters into it's own hands to figure out what app it should associate the file with.  It reads the first 200 bytes and finds a match in the registry and assumes it should treat it as a compressed file. -- http://msdn.microsoft.com/en-us/library/ms775148.aspx

    So I'm faced with having folks save their documents in an old 2003 format before uploading, or having the consumers of the uploaded documents use a different browser or jump through hoops to Save As and change the file type.  If they have IE8 or IE9 I can suggest they turn on Compatibility View, which may, or may not, work.

  • Profile Image
    rvannatta
    Answered on May 15, 2011 at 02:31 PM

    One more thing!

    The trigger for MIME Sniffing has to do with the "Content-Disposition" specificed in HTML on the server.

    A content-disposition type of "inline" tells the browser to display the file immediately, inline, on the page.  This works great for image files that you want to automatically display when someone views a submission.  However, this creates a problem when the file is say, an XLSX file.  

    http://en.wikipedia.org/wiki/MIME#Content-Disposition

    If the content-disposition type were "attachment" instead, I believe this would avoid the problem altogether.  Some other posts confirm this conclusion (including Microsoft).

    So this is another option.  You could make the content-disposition type conditional based upon the file type knowing that you're not going to display or render DOCX and XLSX files on the subissions view page.  Of course that'd take a wee bit of coding....

  • Profile Image
    richardcsu
    Answered on February 12, 2012 at 03:11 PM

    Any update on this issue?  I experience this problem also, and considering I have people from an entire campus all using different browsers and all using different versions of Office, this is an issue.

    I can't tell other departments "Use Firefox or Chrome" when I don't control their IT people!

    Thanks!

    Richard

  • Profile Image
    fxr
    Answered on February 13, 2012 at 03:41 AM

    Hello Richard,

    This issue is currently being worked on by a developer and has been marked as important. 

    I will update this thread when it does get resolved. 

  • Profile Image
    richardcsu
    Answered on February 24, 2012 at 02:51 PM

    JotForm Support - Thank you for your response.  I see that this was brought up over 7 months ago.  Any timeline on when it might work?  I have alot of forms I would like to use this with but I can't expect everyone on campus to use outdated software to upload their files (xls, etc.)  Reeeeaaaaalllly need this feature and apparently so do others.  Just curious if I should find a different form provider that would support such features or if it's going to be relatively soon for this to get fixed. 

    Thanks!

  • Profile Image
    fxr
    Answered on February 24, 2012 at 03:05 PM

    Hello Richard,

    The problem is related to a known issue on IE7 & IE8. 

    I will bring your concerns to the developer responsible for trying to find a resolution for this.

     

    Thanks.

  • Profile Image
    Richard
    Answered on April 03, 2012 at 02:44 PM

    Hi Guys,

    Any update on this? 

    Thanks!

    Richard

  • Profile Image
    jonathan
    Answered on April 03, 2012 at 03:47 PM

    Hello Richard,

    This question was addressed on another thread with similar subject here Can you configure mime type of your server to handle Microsoft Word 2007/2010 fomat .docx? 

    Can you confirm if you are currently still experiencing the same issue on your ms office document files?

    Thanks.

  • Profile Image
    jonathan
    Answered on April 03, 2012 at 03:48 PM

    Sorry, the link was wrong initially, I updated it. Thanks.

  • Profile Image
    richardcsu
    Answered on April 03, 2012 at 05:13 PM

    Hi Jonathan,

    It still isn't working.  I just uploaded a .docx file and when you click on the link in the notification e-mail it is trying to open it as a .zip file. 

    Richard

  • Profile Image
    jonathan
    Answered on April 03, 2012 at 05:31 PM

    Richard,

    I could not duplicate the issue. I test the jotform upload and check my notification email, click on the .docx link, and I was able to download the file as ms word 2007 (.docx)

    Can you please try uploading your test .docx file on my test form here http://jotform.me/form/20922686208456 , I will check it on my email. 

    Thanks.

     

  • Profile Image
    richardcsu
    Answered on April 03, 2012 at 05:35 PM

    Ok...done...and please keep in mind this is IE8, seems to work in Firefox though. 

  • Profile Image
    jonathan
    Answered on April 03, 2012 at 05:58 PM

    Richard,

    You are correct, it does seem to fail when using IE 8 version. But not on IE 9(I have this ver) and Chrome, or Firefox.

    I will assign this to our developer team to check further into it.
    For the meantime, I think it will be appropriate to use for now temporarily other browser option to continue using your form and services.

    Thank you for finding this. We will update you once it get fixed. 

  • Profile Image
    jonathan
    Answered on April 03, 2012 at 06:09 PM

    Btw Richard, you may also try checking it on another time if the issue will resolve itself. If you check the link to the discussion thread I provided, it was mentioned there that the issue was supposedly not on JotForm service side but on another provider, and issue does happen ocassionally only.

    Thanks.

  • Profile Image
    eee
    Answered on April 05, 2012 at 07:19 AM

    Hi,

    The problem is related with our file provider (Amazon Networks), and it will be fixed for new files,

    Kindest Regards,

    Ertugrul. 

  • Profile Image
    richardcsu
    Answered on April 05, 2012 at 10:34 AM

    Hi Ertugrul,

    "and it will be fixed for new files,"   The question is when?  Looking at the forums, this has been an identified problem for quite some time and we keep hearing that it will be fixed but it has yet to be done.  Any timeline on when this might be completed?

    Thanks!

    Richard

  • Profile Image
    eee
    Answered on April 05, 2012 at 11:23 AM

    Hi Richard,

    The problem is related with IE and Amazon, we're trying to find a solution but it doesn't affect any other major browsers except IE. That's the reason it's priority is low when we compare with other problems.

    We have released a fix today (a few hours ago), it will be applied to new files only,

    Thank you for your understanding,

    Kindest Regards,

    Ertugrul.

  • Profile Image
    richardcsu
    Answered on April 05, 2012 at 11:27 AM

    I understand.  Can you specify what you mean by new files only?  Are you talking only files uploaded after today? 

    Thanks!

  • Profile Image
    liyam
    Answered on April 05, 2012 at 12:25 PM

    Hello richardcsu.  Yes, those files that are uploaded only after the fix has been put up.  So for those uploaded prior to the fix, it would be best to use other browsers aside from IE.

  • Profile Image
    richardcsu
    Answered on April 05, 2012 at 01:21 PM

    Thank you!

  • Profile Image
    eee
    Answered on April 06, 2012 at 03:39 AM

    Hi Richard,

    I have found a problem with the yesterday's fix and I solved it completely,

    If you may give a try and inform us, I would be very glad to hear it,

    Kindest Regards,

    Ertugrul.

  • Profile Image
    richardcsu
    Answered on April 06, 2012 at 11:03 AM

    It appears to be working now!  Thank you!

    Richard

  • Profile Image
    Stephen
    Answered on March 26, 2013 at 05:10 PM

    Curious, what was the issue here?  I'm having this issue on Chrome and IE9 at the moment...

  • Profile Image
    Mike_T
    Answered on March 26, 2013 at 05:32 PM

    @Stephen,

    It is probably that there was some MIME Type misconfiguration. If you are having these download issues with our service, please create a new thread. We will be happy to help.