topic Re: configure openoffice-document-formats.xml file for .docx in Alfresco Archive

configure openoffice-document-formats.xml file for .docx

javauser007 — Mon, 12 Jan 2009 09:34:54 GMT

Hi i want to configure the file named openoffice-document-formats.xml for reading the content of ms-word 2007 files. Because i'm using alfresco 2.9 which does not support the searching the content of ms-word 2007 files.any help is appriciated….thanks

Re: configure openoffice-document-formats.xml file for .docx

zaizi — Mon, 26 Jan 2009 10:41:35 GMT

Add the following lines;


  <document-format><name>Microsoft Word 2007</name>
    <family>Text</family>
    <mime-type>application/vnd.openxmlformats-officedocument.wordprocessingml.document</mime-type>
    <file-extension>docx</file-extension>
    <export-filters>
      <entry><family>Text</family><string>MS Word 97</string></entry>
    </export-filters>
  </document-format>

  <document-format><name>Microsoft Excel 2007</name>
    <family>Spreadsheet</family>
    <mime-type>application/vnd.openxmlformats-officedocument.spreadsheetml.sheet</mime-type>
    <file-extension>xlsx</file-extension>
    <export-filters>
      <entry><family>Spreadsheet</family><string>MS Excel 97</string></entry>
    </export-filters>
  </document-format>

  <document-format><name>Microsoft Powerpoint 2007</name>
    <family>Presentation</family>
    <mime-type>application/vnd.openxmlformats-officedocument.presentationml.presentation</mime-type>
    <file-extension>pptx</file-extension>
    <export-filters>
      <entry><family>Presentation</family><string>MS PowerPoint 97</string></entry>
    </export-filters>
  </document-format>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You can of course include templates and other mime types. Full Office 2007 mimetypes are;


.docm,application/vnd.ms-word.document.macroEnabled.12
.docx,application/vnd.openxmlformats-officedocument.wordprocessingml.document
.dotm,application/vnd.ms-word.template.macroEnabled.12
.dotx,application/vnd.openxmlformats-officedocument.wordprocessingml.template
.potm,application/vnd.ms-powerpoint.template.macroEnabled.12
.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
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: configure openoffice-document-formats.xml file for .docx

ganesh_boil — Mon, 27 Apr 2009 12:12:30 GMT

Hi zaizi, i'm also facing the same kind of problem.
in my case i'm using alfresco labs stable version (you know it comes with open office 3.0).
I configured openoffice-document-formats.xml file for .docx according to ypur suggession. But still no luck.
And it is not able to display the content of docx/doc in custom dashlet. it is showing some "?" which are not there in the content.
Any help is appriciated.

Re: configure openoffice-document-formats.xml file for .docx

dwinfield — Wed, 01 Jul 2009 20:39:18 GMT

I have a svn checkout of alfresco, and those suggestions were already implemented.

However, I too could not get indexing of the contents of the docx file to work. When I view the document through share the preview works, and my server's installation of open office can open up the file.

Was anyone able to get this to work?

Re: configure openoffice-document-formats.xml file for .docx

ganesh_boil — Fri, 03 Jul 2009 11:51:17 GMT

it is working fine with labs 3.0..
Just follow the steps specified by zaizi.

It is not working for 2.9 or earlier versions (at least for me)… even if we configures the docx formats.
But with 3.0 labs stable version working like a champ.

Thanks zaizi.

Re: configure openoffice-document-formats.xml file for .docx

rliu — Fri, 24 Jul 2009 19:37:59 GMT

This is merely a comment and not a solution to your problem. The "?" you are referring to is a character set issue. Based on whatever library you use to read the content, the character "in question" is returned with a "?". Locate that character and see if there's a workaround to it.

Re: configure openoffice-document-formats.xml file for .docx

itbeb — Tue, 08 Sep 2009 14:14:28 GMT

For which version of openoffice does this apply? We currently have version 2.3 and I believe this only works from 3.0 onwards?

Re: configure openoffice-document-formats.xml file for .docx

ganesh_boil — Thu, 29 Oct 2009 09:15:56 GMT

Yes itbeb,
It works from openoffice 3.0 and alfresco 3.0 onwords…

Re: configure openoffice-document-formats.xml file for .docx

inspiron82 — Fri, 27 Nov 2009 18:47:34 GMT

Add the following lines;


  <document-format><name>Microsoft Word 2007</name>
    <family>Text</family>
    <mime-type>application/vnd.openxmlformats-officedocument.wordprocessingml.document</mime-type>
    <file-extension>docx</file-extension>
    <export-filters>
      <entry><family>Text</family><string>MS Word 97</string></entry>
    </export-filters>
  </document-format>

  <document-format><name>Microsoft Excel 2007</name>
    <family>Spreadsheet</family>
    <mime-type>application/vnd.openxmlformats-officedocument.spreadsheetml.sheet</mime-type>
    <file-extension>xlsx</file-extension>
    <export-filters>
      <entry><family>Spreadsheet</family><string>MS Excel 97</string></entry>
    </export-filters>
  </document-format>

  <document-format><name>Microsoft Powerpoint 2007</name>
    <family>Presentation</family>
    <mime-type>application/vnd.openxmlformats-officedocument.presentationml.presentation</mime-type>
    <file-extension>pptx</file-extension>
    <export-filters>
      <entry><family>Presentation</family><string>MS PowerPoint 97</string></entry>
    </export-filters>
  </document-format>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You can of course include templates and other mime types. Full Office 2007 mimetypes are;


.docm,application/vnd.ms-word.document.macroEnabled.12
.docx,application/vnd.openxmlformats-officedocument.wordprocessingml.document
.dotm,application/vnd.ms-word.template.macroEnabled.12
.dotx,application/vnd.openxmlformats-officedocument.wordprocessingml.template
.potm,application/vnd.ms-powerpoint.template.macroEnabled.12
.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
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hi guys,
i understand that the rows in the first box must be written in openoffice-document-formats.xml, but where do i have to write lines of the second box?

Is this procedure needed only to make Alfresco search in content of files with those extensions or for something else?

thanks a lot

Re: configure openoffice-document-formats.xml file for .docx

javauser007 — Thu, 03 Dec 2009 11:33:00 GMT

Hi inspron,

you need to put the second box's code in mimetype-map.xml by follwoing the below syntax.

 
<mimetype mimetype="application/vnd.openxmlformats-officedocument.presentationml.presentation" display="Microsoft PowerPoint 2007">
            <extension>pptx</extension>
</mimetype>
‍‍‍‍‍

NOTE: Already some mimetypes were mapped. You need to map/write which were not there in the above file.