Jump to content

QA/Bugzilla/Attachments

From The Document Foundation Wiki
(Redirected from QA/Bugzilla-Attachments)


This page is about Attachments in Bugzilla.

Filesize Limit

  • Currently 30MB

Temporarily, we're putting files too large for Bugzilla here on the wiki or on Nextcloud:


MIME Type Problems

UPDATE: Based on pre- and post-migration testing, we believe that the new TDF Bugzilla does not suffer from the mimetype problems seen on FDO Bugzilla. However, there are browser bugs that still cause problems. Currently we are aware of a mimetype bug in Firefox that was reported in 2007.


We sometimes have problems getting the right MIME type set on Bugzilla attachments. For a period of time, auto-detection for MIME types was disabled in FDO Bugzilla. Tollef re-enabled auto-detection for the LibreOffice product (thank goodness!).

Currently,

  • Many attachments have incorrect MIME type
  • Many binary documents are marked as text/plain

Nuances

Michael Stahl points out that there are some special cases to consider when cleaning up MIME types:

Automation

It makes sense for us to have some type of automation (or at least automatic notification) to help us clean up improperly-annotated attachments.

External References

Current Manual Fixing

What we do now:

  1. Look up attachments of a particular MIME type - "set a 'Custom Search' on 'Attachment mime type' 'is equal to' <mime type you would like to kill>"
  2. Look at file extension and confirm that it matches the MIME type in Bugzilla
  3. If the extension does not match the MIME type, update the MIME type (Note: See MStahl's cautionary note about believing file extensions, above)

Shortlist of extensions and MIME types

File Extension MIME type
Image Formats
JPEG Image jpg, jpeg image/jpeg
PNG Image png image/png
SVG Image svg image/svg+xml
OpenDocument Formats
OpenDocument Text ODT application/vnd.oasis.opendocument.text
OpenDocument Graphics ODG application/vnd.oasis.opendocument.graphics
OpenDocument Presentation ODP application/vnd.oasis.opendocument.presentation
OpenDocument Spreadsheet ODS application/vnd.oasis.opendocument.spreadsheet
OpenDocument Formula ODF

(yes, really!)

application/vnd.oasis.opendocument.formula
OpenDocument Database ODB application/vnd.oasis.opendocument.database
Flat ODF stuff many Unclear...perhaps text/xml ?
MS OOXML Formats
OOXML Spreadsheet XLSX application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
OOXML Spreadsheet + Macros XLSM application/vnd.ms-excel.sheet.macroEnabled.12
OOXML Spreadsheet Binary + Macros XLSB application/vnd.ms-excel.sheet.binary.macroEnabled.12
OOXML Spreadsheet Template XLTX application/vnd.openxmlformats-officedocument.spreadsheetml.template
OOXML Presentation PPTX application/vnd.openxmlformats-officedocument.presentationml.presentation
OOXML Slideshow PPSX application/vnd.openxmlformats-officedocument.presentationml.slideshow
OOXML Presentation Template POTX application/vnd.openxmlformats-officedocument.presentationml.template
OOXML Wordprocessing DOCX application/vnd.openxmlformats-officedocument.wordprocessingml.document
OOXML Wordprocessing Template DOTX application/vnd.openxmlformats-officedocument.wordprocessingml.template
MS Binary Formats
MS PowerPoint (binary) PPT application/vnd.ms-powerpoint
MS PowerPoint Show (binary) PPS application/vnd.ms-powerpoint
MS PowerPoint Template (binary) POT application/vnd.ms-powerpoint
MS Word (binary) DOC application/msword
MS Word Template (binary) DOT application/msword
MS Excel (binary) XLS application/vnd.ms-excel
MS Excel Template (binary) XLT application/vnd.ms-excel
Everything Else
RTF rtf application/rtf
PDF pdf application/pdf
MS Visio (XML) vsdx application/vnd.ms-visio.drawing
MS Visio (binary) vsd application/vnd.visio
MS Publisher pub application/x-mspublisher
Apple Pages (iWork) pages application/vnd.apple.pages
Apple Numbers (iWork) numbers application/vnd.apple.numbers
Apple Keynote (iWork) key application/vnd.apple.keynote
Apple Works / Claris Works cwk application/clarisworks
Mac Writer mw application/macwriteii
Hangul hwp application/x-hwp
pdb application/x-aportisdoc
pdb_plucker application/prs.plucker
pdb_palm application/vnd.palm
lrf application/x-sony-bbeb
psw application/x-pocket-word
602 application/x-t602
fb2 application/x-fictionbook+xml
fh image/x-freehand
cmx image/x-cmx
wpg image/x-wpg

Scripting

The general idea

  1. Create user 'MIMEtype Fixer'
  2. Use XML-RPC/etc.. API
  3. Get list of all attachments (id, filename, MIMEtype)
  4. Foreach attachment, compare (embedded) file MIMEtype w/Bugzilla MIMEtype
    • If they don't match, fix (or possibly review before fix)