Symptoms

Can not open attached MS Office 2007 documents in versaSRS HelpDesk.

Cause

The current version (v4.0.0) has not been configured to support MS Office 2007 documents. This will be corrected in a future software release.

Resolution

To correct this problem locate the versaSRS database table 'tbl_FileTypes' using SQL Server Enterprise Manager or SQL Server Management Studio Express or equivalent.

You will the need to add a new record for .DOCX &/or .XLSX files as follows:

FileExtension: DOCX
MimeType: application/vnd.openxmlformats-officedocument.wordprocessingml.document
SendAsAttachment: True (MS SQL 2005 / 2008) or 1 (MS SQL 200)

You can also add an entry for XLSX files (MS Excel 2007) as follows:

FileExtension: XLSX
MimeType: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
SendAsAttachment: True (MS SQL 2005 / 2008) or 1 (MS SQL 200)

Note: if you upgraded from an earlier version of versaSRS you may need to increase the character length of the field MimeType.

As of versaSRS 4.0, the MimeType field should be set to a Data Type of nvarchar(250).

                                             

Did the information in this article help answer your question?

Yes
No
Did not apply