topic Re: Word template fill-up in Alfresco Archive

Word template fill-up

ivo_costa — Tue, 10 Feb 2009 16:30:02 GMT

HII'm trying to have some word template filled with data that the users enters as metadata.I'm looked into POI that I think Alfresco uses but I can't find any documentation for thiswhat I need is something like this1) user selects create new content2) if possible user selects "information template"

Re: Word template fill-up

ivo_costa — Wed, 11 Feb 2009 11:36:54 GMT

Hi…

I've been trying to access the file's content using the ContentService, unfortunely I can't get the stream to the content…
I always get a failed to get stream to content

can any-one help?

here is some some source code


    public void onUpdateProperties(NodeRef nodeRef, Map<QName, Serializable> before, Map<QName, Serializable> after)
    {
       System.out.println("Update1");
      ContentService cs = serviceRegistry.getContentService();
      System.out.println("Update2");
      ContentReader cr = cs.getReader(nodeRef, ContentModel.PROP_CONTENT);
      System.out.println("Update3");
      System.out.println(cr.getContentString()); //debug de leitura
      System.out.println("Update4");
      
      //cr = FileContentReader.
      
      //.getSafeContentReader(cr,Application.getMessage(req.getSession(), MSG_ERROR_CONTENT_MISSING),   nodeRef, cr);
      try
      {
         InputStream is = cr.getContentInputStream();
      }
      catch(ContentIOException e)
      {
         System.out.println("error: " + e.getMessage());
         System.out.println("Stack trace: " + e.getStackTrace().toString());
      }
   }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Word template fill-up

ivo_costa — Fri, 27 Feb 2009 16:11:33 GMT

Found a way of doing something similar based on the Openoffice connection already existing in Alfresco
Only thing missing is adding the "Information Template" in the wizard's box of "Mime/type"

Re: Word template fill-up

sebpeanut — Thu, 30 Apr 2009 09:39:06 GMT

Hi ivo.costa,

I'm aiming to the same thing. Could you give me a tip of where to look to implement this ?

Thanks

Seb

Re: Word template fill-up

ivo_costa — Mon, 04 May 2009 11:35:14 GMT

Hi Seb

this solution I've found is some-what based on the Office data extracter existing code on the Alfresco project, right now I can recall what was the file's name but I'm sure that you can easely find it.

Take a look on the OpenOffice API Documentation

Here are some samples from my own code:

      tempFromFile = TempFileProvider.createTempFile(
            "OpenOfficeMetadataExtracter-", ".ott");

      reader.getContent(tempFromFile);

      String sourceUrl = toUrl(tempFromFile, connection);

      XComponentLoader desktop = connection.getDesktop();

      PropertyValue[] loadProps = new PropertyValue[2];
      loadProps[0] = new PropertyValue();
      loadProps[0].Name = "AsTemplate";
      loadProps[0].Value = new Boolean(true);
      loadProps[1] = new PropertyValue();
      loadProps[1].Name = "Hidden";
      loadProps[1].Value = new Boolean(true);

      // load
      return desktop.loadComponentFromURL(sourceUrl, "_blank", 0, loadProps);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

      System.out.println("Added Template needed Information");
      // load template with User fields
      XComponent xTemplateComponent = template;

      XTextFieldsSupplier xTextFieldsSupplier = (XTextFieldsSupplier) UnoRuntime
            .queryInterface(XTextFieldsSupplier.class, xTemplateComponent);

      // access the TextFields and the TextFieldMasters collections
      XNameAccess xNamedFieldMasters = xTextFieldsSupplier
            .getTextFieldMasters();
      XEnumerationAccess xEnumeratedFields = xTextFieldsSupplier
            .getTextFields();

      // iterate over hashtable and insert values into field masters
                // recipient is Hashtable with the data needed by the template
      java.util.Enumeration<String> keys = recipient.keys();
      while (keys.hasMoreElements()) {
         // get column name
         String key = (String) keys.nextElement();
         System.out.println("Adding " + key);

         // access corresponding field master
         Object fieldMaster = xNamedFieldMasters
               .getByName("com.sun.star.text.FieldMaster.User." + key);

         // query the XPropertySet interface, we need to set the Content
         // property
         XPropertySet xPropertySet = (XPropertySet) UnoRuntime
               .queryInterface(XPropertySet.class, fieldMaster);

         System.out.println("Before Add");
         // insert the column value into field master
         xPropertySet.setPropertyValue("Content", recipient.get(key));
         // System.out.println("After Add " + recipient.get(key).toString());
      }

      // afterwards we must refresh the textfields collection
      XRefreshable xRefreshable = (XRefreshable) UnoRuntime.queryInterface(
            XRefreshable.class, xEnumeratedFields);
      xRefreshable.refresh();
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Sorry but the code is a little messy right now

hope it helps, and if you have any questions just post them , and I'll try my best to help you

Regards…

Ivo Costa

Re: Word template fill-up

sebpeanut — Thu, 07 May 2009 08:32:59 GMT

That looks like a neat solution indeed !
I suppose/hope it's possible to save it (convert ?) as a .doc file .. !?

Thanks a lot,

Seb

Re: Word template fill-up

ivo_costa — Thu, 07 May 2009 11:16:58 GMT

Hi Seb

you can save in .doc, it took me some time to find out how to do it, but yesterday I found the export parameter needed
had to make a full print of the API response using some code I've found

it was actually easier than I've thought

here are the parameters

PropertyValue[] storeProps = new PropertyValue[1];
       storeProps[0] = new PropertyValue();
       storeProps[0].Name = "FilterName";
       storeProps[0].Value = "MS Word 97";       ‍‍‍‍

all you have to do is add these to the writer method

if you find a way of using a Word Template in place of the OpenOffice Template that I'm using right now, please do post here
I'm still missing that part

Thanks

Re: Word template fill-up

mviswam — Thu, 12 Apr 2012 10:59:57 GMT

HI ivo.costa / Seb,

I think I am also searching for a similar solution. We have decided to implement Alfresco for our Document Management. However we are currently using a set of MS-Word templates.

Will I be able to use the same templates in Alfresco also, if not what is a better alternative. we are implementing alfresco 4.0.

Please guide/help.

Mahesh