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_TYPE

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".

Here is a partial list of the RT_FILE_TYPE records that EQuIS uses. To upload this file to EQuIS, use the refvals Format.

See MIME types for Microsoft Office 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

APP_CODE

APP_CODE – A code to represent the application. This enables application-specific symbol codes and sets. It should be left as NULL unless otherwise specified.