Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: pablitobs on September 11, 2008, 05:35:42 AM

Title: Solution to handle office 2007 docs on SME 7.x
Post by: pablitobs on September 11, 2008, 05:35:42 AM

Hello everyone, recently I cross with the issue of handling office 2007 documents on my SME 7.x, every time my users tried o access a office 2007 document using any web access (mail program, web application etc.), the current zip client took over the operation, opening a bunch of folders with xml documents

so after digging on this forum I create this how to... based on chris burnat post http://forums.contribs.org/index.php?topic=38947.0

1. mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf

2. cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf

3. vi 75AddType05.docx

4.[and add the following:]
#add mime support for asx files
AddType application/vnd.ms-word.document.macroEnabled.12 .docm
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document docx
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.template dotx
AddType application/vnd.ms-powerpoint.template.macroEnabled.12 potm
AddType application/vnd.openxmlformats-officedocument.presentationml.template potx
AddType application/vnd.ms-powerpoint.addin.macroEnabled.12 ppam
AddType application/vnd.ms-powerpoint.slideshow.macroEnabled.12 ppsm
AddType application/vnd.openxmlformats-officedocument.presentationml.slideshow ppsx
AddType application/vnd.ms-powerpoint.presentation.macroEnabled.12 pptm
AddType application/vnd.openxmlformats-officedocument.presentationml.presentation pptx
AddType application/vnd.ms-excel.addin.macroEnabled.12 xlam
AddType application/vnd.ms-excel.sheet.binary.macroEnabled.12 xlsb
AddType application/vnd.ms-excel.sheet.macroEnabled.12 xlsm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx
AddType application/vnd.ms-excel.template.macroEnabled.12 xltm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.template xltx

5. expand-template /etc/httpd/conf/httpd.conf
6. /etc/rc7.d/S86httpd-e-smith restart

After that you will see this on your screen:

Restarting httpd-e-smith                                   [  OK  ]

If so you are ready. now go to your mail program, web application etc, and you should be able to open your documents.

Hope this helps!!!

Title: Re: Solution to handle office 2007 docs on SME 7.x
Post by: cactus on September 11, 2008, 11:02:45 AM

Quote from: pablitobs on September 11, 2008, 05:35:42 AM

Hello everyone, recently I cross with the issue of handling office 2007 documents on my SME 7.x, every time my users tried o access a office 2007 document using any web access (mail program, web application etc.), the current zip client took over the operation, opening a bunch of folders with xml documents

so after digging on this forum I create this how to... based on chris burnat post http://forums.contribs.org/index.php?topic=38947.0

1. mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf

2. cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf

3. vi 75AddType05.docx

4.[and add the following:]
#add mime support for asx files
AddType application/vnd.ms-word.document.macroEnabled.12 .docm
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document docx
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.template dotx
AddType application/vnd.ms-powerpoint.template.macroEnabled.12 potm
AddType application/vnd.openxmlformats-officedocument.presentationml.template potx
AddType application/vnd.ms-powerpoint.addin.macroEnabled.12 ppam
AddType application/vnd.ms-powerpoint.slideshow.macroEnabled.12 ppsm
AddType application/vnd.openxmlformats-officedocument.presentationml.slideshow ppsx
AddType application/vnd.ms-powerpoint.presentation.macroEnabled.12 pptm
AddType application/vnd.openxmlformats-officedocument.presentationml.presentation pptx
AddType application/vnd.ms-excel.addin.macroEnabled.12 xlam
AddType application/vnd.ms-excel.sheet.binary.macroEnabled.12 xlsb
AddType application/vnd.ms-excel.sheet.macroEnabled.12 xlsm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx
AddType application/vnd.ms-excel.template.macroEnabled.12 xltm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.template xltx

5. expand-template /etc/httpd/conf/httpd.conf
6. /etc/rc7.d/S86httpd-e-smith restart

After that you will see this on your screen:

Restarting httpd-e-smith                                   [  OK  ]

If so you are ready. now go to your mail program, web application etc, and you should be able to open your documents.

Hope this helps!!!

Please raise a bug for this so it can be implemented in future releases by default.

Title: Re: Solution to handle office 2007 docs on SME 7.x
Post by: shawnbishop on September 11, 2008, 11:59:05 AM

Hi

Also add to WIKI under Windows Integration??, awesome How to and very clear

Cheers

Title: Re: Solution to handle office 2007 docs on SME 7.x
Post by: mdo on September 11, 2008, 07:33:58 PM

Quote from: pablitobs on September 11, 2008, 05:35:42 AM

AddType application/vnd.ms-word.document.macroEnabled.12 .docm

Is that really ".docm" (all following lines do NOT use the dot)  or could this be a typo and the line should just end with "..ed.12 docm"?

Title: Re: Solution to handle office 2007 docs on SME 7.x
Post by: holck on September 11, 2008, 10:12:27 PM

According to this link http://blogs.msdn.com/vsofficedeveloper/pages/Office-2007-Open-XML-MIME-Types.aspx
 (http://blogs.msdn.com/vsofficedeveloper/pages/Office-2007-Open-XML-MIME-Types.aspx), there is one suffix missing:

Code: [Select]

AddType application/vnd.ms-word.template.macroEnabled.12 dotm