Koozali.org: home of the SME Server

Solution to handle office 2007 docs on SME 7.x

Offline pablitobs

  • **
  • 35
  • +0/-0
Solution to handle office 2007 docs on SME 7.x
« 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!!!

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Solution to handle office 2007 docs on SME 7.x
« Reply #1 on: September 11, 2008, 11:02:45 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.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline shawnbishop

  • *****
  • 298
  • +0/-0
Re: Solution to handle office 2007 docs on SME 7.x
« Reply #2 on: September 11, 2008, 11:59:05 AM »
Hi

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

Cheers

Offline mdo

  • *
  • 355
  • +0/-0
Re: Solution to handle office 2007 docs on SME 7.x
« Reply #3 on: September 11, 2008, 07:33:58 PM »
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"?
...

Offline holck

  • *
  • 322
  • +1/-0
Re: Solution to handle office 2007 docs on SME 7.x
« Reply #4 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
, there is one suffix missing:

Code: [Select]
AddType application/vnd.ms-word.template.macroEnabled.12 dotm
......