topic Re: How to write metadata into document in Alfresco Archive

How to write metadata into document

giluka — Thu, 16 Jan 2014 14:44:01 GMT

Hi all,i want to copy all metadata i've added or updated into an alfresco node (related to a document) to document itself.In this manner when document will be downloaded it will contains all metadata like in alfresco.Is it possibile to do that ?Thanks.

Re: How to write metadata into document

rjohnson — Thu, 16 Jan 2014 15:37:04 GMT

What document types? How do you want to see it in the document. Will the document have content or just metadata?

Re: How to write metadata into document

giluka — Thu, 16 Jan 2014 15:41:24 GMT

The documents are .doc or .pdf with a content. The metadata i want to insert into them are all metadata i can see in Alfresco (in node object).

Thanks !

Re: How to write metadata into document

rjohnson — Thu, 16 Jan 2014 18:03:59 GMT

You can use Apache POI for .doc and PDFBox for PDF to update the documents own "properties". However that is not "out-of-the-box" so you will need to do some Java development and .doc and PDF only have a limited number of proeprties fields that you could populate.

Try this add-on. It may do what you need. http://addons.alfresco.com/addons/metadata-writer

Re: How to write metadata into document

pavo83 — Tue, 21 Jan 2014 16:29:05 GMT

Hi,

I used the metadata-writer add-on on my local alfresco and I changed original metadata of my document and, also, I created new ones (for doc and docx, but not for pdf).
However, I am looking for a way to insert new info in my .doc file content.
e.g.: I have a document where I need to insert an information from one property of my custom model, in a specific point of the content itself.

Is there a way to do so using the metadata-writer?

Re: How to write metadata into document

mrogers — Tue, 21 Jan 2014 17:13:57 GMT

Yes probably.

Could you add a macro to your docx before uploading to alfresco that reads the doc properties which will be injected by the metadata writer.

Or use the POI libraries directly to author a doc or docx file.

Re: How to write metadata into document

pavo83 — Wed, 22 Jan 2014 09:22:12 GMT

Thanks for the answer.

Is there some example on how to get the content of the doc, uploaded in Alfresco, with a java class, I suppose throught some filestream method, that will be used by the POI libraries to modify it?

Re: How to write metadata into document

scopio — Thu, 13 Feb 2014 08:44:39 GMT

Hi pavo83
I am trying to get metadatawriter working without any luck. Can you please post the solution. I am trying to map my metadate to word document properties.

Re: How to write metadata into document

pavo83 — Fri, 14 Feb 2014 13:51:46 GMT

Hi Scopio,

I modified the metadata-writer-service-context.xml (inside src->main->config->alfresco->extension->model) and created a bean to map my metadata to a word document properties.
I could not modify the content of the word document, but through word I can add standard word properties into the content of the document itself.

This is how I modified the xml:

   <bean id="metadata-writer.service"
      class="org.redpill.alfresco.module.metadatawriter.services.impl.MetadataServiceImpl"
      init-method="register" parent="metadata-writer.abstract.service">
      <property name="serviceName" value="metadata-writer.service" />
      <property name="converters">
         <list></list>
      </property>
      <property name="mappings">
         <props>
            <prop key="Description">cm:description</prop>
            <prop key="category">ne:aziendaDiAppartenenza</prop>
            <prop key="Author">cm:author</prop>
            <prop key="Title">cm:title</prop>

            <prop key="Subject">cm:modifier</prop>
            <prop key="Keywords">ne:mittenteMail</prop>
            <prop key="Producer">cm:creator</prop>
            
            <prop key="Fattura">ne:numFattura</prop>
            <prop key="Stato2">ne:ufficioCompetenza</prop>
         </props>
      </property>
   </bean>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

As you can see, I modified the property "mappings" adding some props throught key and the metadata form my model that I wanted to return to the document.
The Italian key value are custom properties added by me in the word document.

I hope this could help.

Re: How to write metadata into document

scopio — Mon, 17 Feb 2014 22:36:31 GMT

Hi Pavo83, Thank you very much for your reply.

I cannot find this folder structure(src->main->config->alfresco->extension->model). Please see below for how I installed it.

I downloaded metadatawriter-3.4.12.jar file from metadatawriter project website and dropped the file into /opt/alfresco-4.2.e/tomcat/webapps/share/WEB-INF/lib folder and restarted Alfresco share.

then I exposed 'Metadata Writer' aspect on alfresco share. That is all i've done. Now I cannot see metadata-writer-service-context.xml file nor above file structure.

Please instruct me how to do this.

Regards,
Scopio

Re: How to write metadata into document

scopio — Mon, 17 Feb 2014 22:45:14 GMT

Further more I am using Alfresco 4.2.e and I want this working on Alfresco share.