topic transform excell file to webpage in Alfresco Archive

transform excell file to webpage

tomw — Tue, 11 Sep 2007 08:46:38 GMT

I'm new to alfresco and i'm not sure what alfresco can do for my company.I would like to import excell files and let them automatically be shown as web pages. Is that possible? How do i do that?I found a content rule to transform an excell file to html but i also want i to publisch automatically.Tha

Re: transform excell file to webpage

kevinr — Mon, 17 Sep 2007 11:46:47 GMT

Yes as you have found Alfresco can convert Excel to HTML no problem. It depends what you mean by "publish" - Alfresco WebContentManagement can deploy data to either a static site location or another dedicated Alfresco instance. Also you could expose a folder in Alfresco to Guest users and give out direct URLs to content. You could also build a Freemarker template that displayed the data within a folder to generate links for you users. You can also create a cron job to FTP out data from Alfresco (Alfresco has a built in FTP server). You have lots of options!

Thanks,

Kevin

Re: transform excell file to webpage

schneika — Fri, 21 Sep 2007 13:10:23 GMT

You can use the following Freemarker-Templates to display your webcontent (html and jpeg) in a Custom-View of your smartspace

<#——————————————————————>
<#– Shows JPG and HTML-Files in a Smartspace                         –>
<#——————————————————————>
<H4> Prozess ${space.properties.title} </H4>
<#list space.children as child>
    <#if child.isDocument && (child.mimetype = "image/png" || child.mimetype = "image/gif" || child.mimetype= "image/jpeg")>
        <img src="/alfresco${child.url}">
    </#if>
</#list>
<#list space.children as child>
    <#if child.isDocument && (child.mimetype = "text/html")>
             ${child.content}
     </#if>
</#list>‍‍‍‍‍‍‍‍‍‍‍‍‍‍

With this template you can present your flash-files:

<#——————————————————————>
<#– Shows SWF-Flash-Files in a Smartspaces                    –>
<#——————————————————————>
<H4> Directory ${space.properties.title} </H4>
<H6> Click your Presentation </H6>

<#list space.children as child>
   <#if child.isDocument && (child.mimetype = "application/x-shockwave-flash")>
      <object>
         <embed src="/alfresco${child.url}" type="application/x-shockwave-flash" height="600" width="800"/>
      </object>
   </#if>
</#list>‍‍‍‍‍‍‍‍‍‍‍‍‍

Or you can combine them to a template which will display all your web-content and so on.
This Combination of Action-Rules and Custom-View-Templates is a very flexible and dynamic Way to publish the regular webcontent of a smartspace…

Re: transform excell file to webpage

schneika — Fri, 21 Sep 2007 13:31:05 GMT

But by the way i have a question to the community about the "Transform Object an copy to another place"-Action.
How can i modify this Action to "tranform Object" but do not copy to another place, instead it should copy the transformed object always to the same place where the original resists. Which XML-Files must i modify for this Action :?: