Re: [eGroupWare-users] Bug in tracker attachment ? - SOLVED

[cbahiana <car...@gm...>]

Folks,

This is what I did and that worked for me. 

Test before trying. Backup before trying.

First of all check to see your version of EgroupWare. If you downloaded from
trunk recently you might have version 1.7.003. This one already have the
DOCX entry. Mine is 1.6.003.

I edited /usr/share/egroupware/phpgwapi/inc/class.mime_magic.inc.php to
include:

'docm'  =>  'application/vnd.ms-word.document.macroEnabled.12',
'docx'  =>
'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
'dotx'  =>
'application/vnd.openxmlformats-officedocument.wordprocessingml.',
'potm'  => 'application/vnd.ms-powerpoint.template.macroEnabled.',
'potx'  =>
'application/vnd.openxmlformats-officedocument.presentationml.template',
'ppam'  => 'application/vnd.ms-powerpoint.addin.macroEnabled.12',
'ppsm'  => 'application/vnd.ms-powerpoint.slideshow.macroEnabled.12',
'ppsx'  =>
'application/vnd.openxmlformats-officedocument.presentationml.slideshow',
'pptm'  => 'application/vnd.ms-powerpoint.presentation.macroEnabled.12',
'pptx'  =>
'application/vnd.openxmlformats-officedocument.presentationml.presentation',
'xlam'  => 'application/vnd.ms-excel.addin.macroEnabled.12',
'xlsb'  => 'application/vnd.ms-excel.sheet.binary.macroEnabled.12',
'xlsm'  => 'application/vnd.ms-excel.sheet.macroEnabled.12',
'xlsx'  =>
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'xltm'  => 'application/vnd.ms-excel.template.macroEnabled.12',
'xltx'  =>
'application/vnd.openxmlformats-officedocument.spreadsheetml.template',

This will take care os new files, inserted through File Manager from this
moment on.

To extend this update to existing files, you'll need to access the database.
I did it using phpmyadmin.

Having logged on phpmyadmin, I chose egroupware database, then selected
egw_sqlfs table.

Using the SQL tab, I ran:

update `egw_sqlfs` SET fs_mime =
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" WHERE
`fs_name` LIKE '%xlsx';
update `egw_sqlfs` SET fs_mime =
"application/vnd.openxmlformats-officedocument.presentationml.presentation"
WHERE `fs_name` LIKE '%pptx';
update `egw_sqlfs` SET fs_mime =
"application/vnd.openxmlformats-officedocument.wordprocessingml.document"
WHERE `fs_name` LIKE '%docx';

This will change of the fs_mime field from octet/stream to each of the main
Office file types (Excell, PowerPoint and Word).

Now my existing Office 2007 files are correctly downloaded with IE8 and the
new files get correctly identified.
-- 
View this message in context: http://egroupware.219119.n3.nabble.com/Bug-in-tracker-attachment-tp263667p997244.html
Sent from the egroupware-users mailing list archive at Nabble.com.