Skip navigation
jenn
Currently Being Moderated

CFFILE - Accepting Office 2007 Mime Types

Dec 29, 2011 7:08 AM

Tags: #office #mime #types #2007

How can all mime types for Office 2007 be included in accepting file types. This is what I have:   

...accept="application/vnd.openxmlformats-officedocument.spreadsheetml .sheet, etc.".

 
Replies
  • Currently Being Moderated
    Dec 29, 2011 8:15 AM   in reply to jenn

    jenn wrote:

     

    How can all mime types for Office 2007 be included in accepting file types. This is what I have:   

    ...accept="application/vnd.openxmlformats-officedocument.spreadsheetml .sheet, etc.".

    I would do it as follows, the way El Dombo would. Get hold of all the Office 2007 MIME types. Then shove them all in the accept attribute.

     

    <cfset OFFICE2007MimeTypes = "application/vnd.openxmlformats-officedocument.wordprocessingml.docum ent,application/vnd.ms-word.document.macroEnabled.12,application/vnd.o penxmlformats-officedocument.wordprocessingml.template,application/vnd .ms-word.template.macroEnabled.12,application/vnd.openxmlformats-offic edocument.spreadsheetml.sheet,application/vnd.ms-excel.sheet.macroEnab led.12,application/vnd.openxmlformats-officedocument.spreadsheetml.tem plate,application/vnd.ms-excel.template.macroEnabled.12,application/vn d.ms-excel.sheet.binary.macroEnabled.12,application/vnd.ms-excel.addin .macroEnabled.12,application/vnd.openxmlformats-officedocument.present ationml.presentation,application/vnd.ms-powerpoint.presentation.macroE nabled.12,application/vnd.openxmlformats-officedocument.presentationml .slideshow,application/vnd.ms-powerpoint.slideshow.macroEnabled.12,app lication/vnd.openxmlformats-officedocument.presentationml.template,app lication/vnd.ms-powerpoint.template.macroEnabled.12,application/vnd.ms -powerpoint.addin.macroEnabled.12,application/vnd.openxmlformats-offic edocument.presentationml.slide,application/vnd.ms-powerpoint.slide.mac roEnabled.12,application/onenote,application/vnd.ms-officetheme">

     

    <cfif isdefined("form.sbmt")>
    <cffile action = "upload" 
            fileField = "myFile" 
            destination = "c:\test" 
            accept = "#OFFICE2007MimeTypes#" 
            nameConflict = "MakeUnique">
    </cfif>
    <cfform method="post" enctype="multipart/form-data">
    <cfinput name="myFile" type="file">
    <cfinput name="sbmt" type="submit" value="upload">
    </cfform>

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 30, 2011 7:43 AM   in reply to jenn

    What's the file extension of the spreadsheets?

     
    |
    Mark as:
  • Dave Watts
    747 posts
    Mar 11, 2003
    Currently Being Moderated
    Dec 30, 2011 7:51 AM   in reply to jenn

    What MIME type is your computer sending when you attempt to upload one of these files? You can view that using Firebug, or something similar.

     

    Dave Watts, CTO, Fig Leaf Software

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 30, 2011 8:14 AM   in reply to jenn

    jenn wrote:

     

    xls, and xlsx

    Xls? I suspected something like that. You said Office 2007!

     

    MIME type for XLS: application/vnd.ms-excel

    MIME type for XLS: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

     

    Oh, and watch out when you copy-and-paste. For example, you would have encountered a problem if you copied the list OFFICE2007MimeTypes that I used above. The software of this forum adds arbitrary spaces to the list.

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 30, 2011 8:52 AM   in reply to jenn

    jenn wrote:

     

    Yes, I thought it was having an issue with xlsx, so I tried using an older version of the same document in xls. Both failed to upload. It is only the spreadsheet format that does not get uploaded. Do you think it could be a server issue?

    

    There could be a problem with the binary content of that particular document. Repeat the procedure with a different XLSX file.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points