topic Re: Getting metadata from the content of a document in Alfresco Archive

Getting metadata from the content of a document

jlabuelo — Tue, 29 Jan 2008 20:45:31 GMT

Hi thereI am trying to assgin a customized type to a document droped in an Space using a business rule, but then would also like to fulfill the properties of the type automatically obtaining the metadata from the "content" of the document.Let me explain what I pretend to get a) Move a Word, Excel, P

Re: Getting metadata from the content of a document

vicsaego — Thu, 07 Aug 2008 07:18:03 GMT

Hi,

I'm interesting in doing the same but I can´t find information about how to do it.
Did you find any solution?
Is is possible to do it?

Thanks very much in advance

Re: Getting metadata from the content of a document

jlabuelo — Thu, 07 Aug 2008 07:31:06 GMT

Hi there

Seems that is possible, however you would need to design a process your self, nobody from Alfresco Community has replied to this post and we are investigating how to create a script-interface in java to upload a file to alfresco and change the metadata of the file once uploaded with the information of the file.

At this moment we have this project stopped but it is one of our aims for the near future. We have discovered that this is quite difficult to implement if the document you want to scan or upload is not a form with a static structure so you make the code to always review the same "positions" of the docuement.

For your information there is actually an interface that allows you to upload an scanned document with OCR directly from the scanner to Alfresco, but you need to buy it (KOFAX is the company that has designed this script) and it is quite expensive. If you look in google Alfresco-Kofax you will get the link needed.

Sorry can not help you more at this time. If you find any information will appreciate if you can share it with me

Regards

Re: Getting metadata from the content of a document

loftux — Thu, 07 Aug 2008 07:38:11 GMT

I think you will have to write some custom extractor to do that.
The challenge is not only to dissect ms word format, but know where to look in the document. You can try to force them to put it in a certain table or field, but user have a tendency to move/remove things

Maybe you are better of if you write some vba code, a dialog that asks for the value and puts it in the right place in the document AND writes it to properties of the file. Then you can use Alfresco metadata extractor to transfer the values, only configuration needed.

//Peter Löfgren

Re: Getting metadata from the content of a document

jlabuelo — Fri, 08 Aug 2008 07:37:56 GMT

Hi Peter

Sounds quite interesting what you are suggesting, did you already get to implement something like this?, sorry but dont understand exactly what you mean by Wrtting in the "Properties of the document before uploading it to Alfresco".

Also could you point me where we can find some documentation to configure a metadata extractor for our Alfresco configuration?

Thanks a lot!!

Re: Getting metadata from the content of a document

loftux — Fri, 08 Aug 2008 07:54:12 GMT

I've not done it yet in Alfresco, although in my previous proprietary consultancy life i've done things like this.

Do a search on http://www.google.com/search?q=word+custom+properties and you will get some links, this one looks promising http://msdn.microsoft.com/en-us/library/aa537163.aspx. Either write to custom properties or the built in ms office properties, and then let Alfresco extract and overwrite on each save by setting overwrite policy to eager.

I do not know how to do it for PDFs, but the above method will work for Office documents

Here you have some links
http://wiki.alfresco.com/wiki/Metadata_Extraction
http://forums.alfresco.com/en/viewtopic.php?=&p=22670 (on the topic of how to configure extraction of custom properties, not resolved)

Re: Getting metadata from the content of a document

jlabuelo — Fri, 08 Aug 2008 12:28:16 GMT

Thanks a lot Peter

Will take a look to these links next week and will let you know what I found 😄

Regards