topic Office 2007 (docx...) Extract Common Metadata in Alfresco Archive

Office 2007 (docx...) Extract Common Metadata

kenneth_thorman — Thu, 02 Apr 2009 09:53:16 GMT

HiIs there support for in the current version of Alfresco 3.0 Stable through the use of the POI version installed to extract docx document properties (custom ones?)I have been strugelling with this for a while and it seems to work for doc files but not docx.AnyoneRegardsKenneth Thorman

Re: Office 2007 (docx...) Extract Common Metadata

kenneth_thorman — Thu, 02 Apr 2009 11:00:33 GMT

In the current release 3.0 Stable of Alfresco the POI library versino 3.1 is used.

If this is changed to 3.5 (beta) we're getting detailed exception and it says "The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)"

So I guess a bit of the code will have to be changed.

Any pointers, anyone?

Regards
Kenneth Thorman

Re: Office 2007 (docx...) Extract Common Metadata

jpfi — Thu, 02 Apr 2009 12:07:35 GMT

Hi,
yub, .doc is a binary file format, .docx is a special xml format.
You'll have to write your own metadata extrator, map it to docx file extension and use the XSSF part of jakarta POI.
I'm not sure if the old extractors are still working with a 3.5 POI jar…
Cheers, Jan

Re: Office 2007 (docx...) Extract Common Metadata

kenneth_thorman — Tue, 01 Dec 2009 14:46:50 GMT

We have been waiting for this feature, not wanting to implement this if alfresco was going to come out with this functionality.

I have been searching high and low now since POI 3.5 have come out.

Is it correct that this feature (office 2007 file format metadata awareness) is still not available?

Regards
Kenneth Thorman