Using POI transformer to transform excel documents

darkstar1 — Mon, 18 Jan 2016 09:48:15 GMT

So I am trying to use the POI transformer to transform EXCEL => HTML.So I have the following: In <Project-home>/src/main/amp/config/alfresco/extension/subsystems/Transformers/default/default/transformers.properties content.transformer.Poi.priority=70 content.transformer.Poi.extensions

Re: Using POI transformer to transform excel documents

darkstar1 — Fri, 22 Jan 2016 09:19:00 GMT

I decided to create the following complex pipeline (Excel => PDF => HTML) instead and then replace the out of the box transformer for PDF to html (which seems to be <a href="https://github.com/Alfresco/community-edition/blob/dcbe8a0d5219614fbe8bc11c166d638152b9367c/projects/repository/config/alfresco/subsystems/Transformers/default/transformers.properties#L311">PdfBox</a>) with pdf2htmlex for the pdf=>html transformation.
<strong>My transformer spring bean</strong>:


    <bean id="transformer.worker.pdf2htmlex" class="org.alfresco.repo.content.transform.RuntimeExecutableContentTransformerWorker">
        <property name="mimetypeService">
            <ref bean="mimetypeService" />
        </property>
        <property name="checkCommand">
            <bean class="org.alfresco.util.exec.RuntimeExec">
                <property name="commandsAndArguments">
                    <map>
                        <entry key=".*">
                            <list>
                                <value>pdf2htmlex</value>
                                <value>-v</value>
                            </list>
                        </entry>
                    </map>
                </property>
                <!–<property name="errorCodes">
                    <value>1</value>
                </property>–>
            </bean>
        </property>
        <property name="transformCommand">
            <bean class="org.alfresco.util.exec.RuntimeExec">
                <property name="commandsAndArguments">
                    <map>
                        <entry key=".*" value="pdf2htmlEX –embed CFIJO ${source} ${target}"/>
                    </map>
                </property>
                <property name="processDirectory"
                          value="/"/>
            </bean>
        </property>
        <property name="explicitTransformations">
            <list>
                <bean class="org.alfresco.repo.content.transform.ExplictTransformationDetails" >
                    <constructor-arg><value>application/pdf</value></constructor-arg>
                    <constructor-arg><value>text/html</value></constructor-arg>
                </bean>
            </list>
        </property>
    </bean>

    <bean id="transformer.pdf2htmlex" class="org.alfresco.repo.content.transform.ProxyContentTransformer" parent="baseContentTransformer">
        <property name="worker">
            <ref bean="transformer.worker.pdf2htmlex" />
        </property>
    </bean>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

<strong>The transformer properties file </strong>:


#disable ootb pdf->html and xlsx->html transformation path
content.transformer.OpenOffice.extensions.xlsx.html.supported=false
#content.transformer.complex.OpenOffice.PdfBox.avilable=false
content.transformer.complex.OpenOffice.PdfBox.extensions.*.html.supported=false

#PDF to html transformer
content.transformer.pdf2htmlex.available=true
content.transformer.pdf2htmlex.priority=50
content.transformer.pdf2htmlex.extensions.pdf.html.supported=true
content.transformer.pdf2htmlex.extensions.pdf.html.priority=50


#   XLSX to HTML pipeline
content.transformer.complex.Xlsx.Html.pipeline=*|pdf|pdf2htmlex
content.transformer.complex.Xlsx.Html.available=true
content.transformer.complex.Xlsx.Html.extensions.xlsx.html.priority=30
content.transformer.complex.Xlsx.Html.extensions.xlsx.html.supported=true
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

One thing I notice, is that when I startup my repository, this shows up in the logs:


2016-01-21 14:18:37,962  TRACE [util.exec.RuntimeExec] [localhost-startStop-1] Execution result: 
   os:         Mac OS X
   command:    pdf2htmlex -v
   succeeded:  true
   exit code:  0
   out:        
   err:        pdf2htmlEX version 0.13.6
Copyright 2012-2014 Lu Wang <coolwanglu@gmail.com> and other contributors
Libraries: 
  poppler 0.40.0
  libfontforge 20160113
  cairo 1.14.6
Default data-dir: /usr/local/Cellar/pdf2htmlex/0.13.6_7/share/pdf2htmlEX
Supported
   existing environment: 
        JAVA_MAIN_CLASS_7289=com.intellij.rt.execution.application.AppMain
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I'm wondering why, if the check command has an exit code of 0, is the output to the command an error; but the main thing is that the transform command results in an error and a zero byte target file.
Copying that exact command and executing it in terminal always succeeds.

Re: Using POI transformer to transform excel documents

darkstar1 — Mon, 25 Jan 2016 10:44:00 GMT

So it turns out that the reason for the failing argument is down to the way that you specify arguments for the transformCommand


<property name="transformCommand">
            <bean class="org.alfresco.util.exec.RuntimeExec">
                <property name="commandsAndArguments">
                    <map>
                        <entry key=".*">
                            <list>
                                <value>pdf2htmlEX</value>
                                <value>–embed</value>
                                <value>CFIJO</value>
                                <value>${source}</value>
                                <value>${target}</value>
                            </list>
                        </entry>
                    </map>
                </property>
                <property name="processDirectory" value="/"/>
            </bean>
        </property>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

as opposed to:


<property name="transformCommand">
<bean class="org.alfresco.util.exec.RuntimeExec">
      <property name="commandsAndArguments">
              <map>
                  <entry key=".*" value="pdf2htmlEX –embed CFIJO ${source} ${target}"/>
              </map>
          </property>
      <property name="processDirectory" value="/"/>
</bean>
</property>
‍‍‍‍‍‍‍‍‍‍‍‍

I had found the clue in the comments written on org/alfresco/util/exec/RuntimeExec.java class that's responsible for executing the commands

Re: Using POI transformer to transform excel documents

darkstar1 — Tue, 26 Jan 2016 12:28:30 GMT

Also, like Jeff Potts <a href="https://forums.alfresco.com/comment/160957#comment-160957">in his post</a>, I came across the exact same issue and was resolved in exactly the same way. The reason, I think for this is that I believe that the complex pipeline needs to be registered with the TransformerRegistry on startup other wise it is unable to recognise and declare the transformer as available for the pipeline.

topic Re: Using POI transformer to transform excel documents in Alfresco Archive

Using POI transformer to transform excel documents

Re: Using POI transformer to transform excel documents

Re: Using POI transformer to transform excel documents

Re: Using POI transformer to transform excel documents