Export - mime type

[vdancik]

The correct row name for mime types is "mime_type" instead of "mime_types".

The mime_type for images should be "image/jpg" or "image/png", depending on the file extension. The mime_type for stories should be "text/html", depending on the file extension.

[zhouji2013]

references

• https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types
• https://technet.microsoft.com/en-us/library/ee309278(office.12).aspx
• https://blogs.msdn.microsoft.com/vsofficedeveloper/2008/05/08/office-2007-file-format-mime-types-for-http-content-streaming-2/

[zhouji2013]

For each evidence column, there is only one mime type. However, we do allow multiple observations of file type. That implies that we should enforce the constraint that all the files within that same column (column in the spreadsheet, row on the web UI) should have the same mime type. I need Ken's confirmation concerning this.

[zhouji2013]

Row name is corrected and the actual mime type is populated; in case of more than one observation, the last evidence file's mime type is recorded (in fact overwriting the earlier ones).

[kcs3]

The following is observed on testing: A file of type .png receives mime_type image/png. A file of type .jpg receives mime type image/jpeg. A file of type .siff receives no mime type. A file of type .txt is rejected by the submission builder, with message that text files are not allowed to be uploaded. A file of type .html is rejected by the submission builder, with message that text files are not allowed to be uploaded.