RT_FILE_TYPE – MIME Types

<< Click to Display Table of Contents >>

Navigation:  Professional > Tables & Views > Reference Value (RT) Tables >

RT_FILE_TYPE – MIME Types

The RT_FILE_TYPE reference table holds file types extensions for use in DT_FILE and other file-storing tables. This includes a MIME_TYPE column.

 

MIME stands for Multiple-purpose Internet Mail Extensions. MIME types classify file types on the Internet. Each web program uses a specific list of MIME types for consistent transfer of individual types of files.

 

EQuIS uses MIME types when downloading a file. Without a MIME type, the program cannot open the file automatically, just saving the file instead. When attaching a file to an email notification, EQuIS must include the MIME type in the message data. To accomplish this, RT_FILE_TYPE maintains associations between file name extensions (File Type) with their respective MIME types. Add to this list as necessary to support the organization's EQuIS database.

 

To populate the MIME_TYPE field for unknown MIME types, use "application/octet-stream".

 

Download a partial list of the RT_FILE_TYPE records that EQuIS uses here. To upload this file to EQuIS, use the RefVals format.

 

See MIME types for Microsoft Office 2007 and up in the following table.

 

File Type

MIME Type

.doc

application/msword

.dot

application/msword

.docx

application/vnd.openxmlformats-officedocument.wordprocessingml.document

.dotx

application/vnd.openxmlformats-officedocument.wordprocessingml.template

.docm

application/vnd.ms-word.document.macroEnabled.12

.dotm

application/vnd.ms-word.template.macroEnabled.12

.xls

application/vnd.ms-excel

.xlt

application/vnd.ms-excel

.xla

application/vnd.ms-excel

.xlsx

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

.xltx

application/vnd.openxmlformats.officedocument.spreadsheetml.template

.xlsm

application/vnd.ms-excel.sheet.macroEnabled.12

.xltm

application/vnd.ms-excel.template.macroEnabled.12

.xlam

application/vnd.ms-excel.addin.macroEnabled.12

.xlsb

application/vnd.ms-excel.sheet.binary.macroEnabled.12

.ppt

application/vnd.ms-powerpoint

.pot

application/vnd.ms-powerpoint

.pps

application/vnd.ms-powerpoint

.ppa

application/vnd.ms-powerpoint

.pptx

application/vnd.openxmlformats-officedocument.presentationml.presentation

.potx

application/vnd.openxmlformats-officedocument.presentationml.template

.ppsx

application/vnd.openxmlformats-officedocument.presentationml.slideshow

.ppam

application/vnd.ms-powerpoint.addin.macroEnabled.12

.pptm

application/vnd.ms-powerpoint.presentation.macroEnabled.12

.potm

application/vnd.ms-powerpoint.presentation.macroEnabled.12

.ppsm

application/vnd.ms-powerpoint.slideshow.macroEnabled.12