topic Re: how Can we change the output format to CSV instead of HTML ? in Alfresco Archive

how Can we change the output format to CSV instead of HTML ?

raghu462 — Tue, 20 Apr 2010 09:54:15 GMT

how can we change the output of webscript to CSV file instead of html?following are corresponding ftl and webscript files——————————————————————————————————————————-<#macro recurse_macro node depth> <#if node.isContainer> <tr> <td> ${node.properties.name} </td

Re: how Can we change the output format to CSV instead of HTML ?

invictus9 — Tue, 20 Apr 2010 14:19:54 GMT

You need to indicate the response format in the web script description.

The FTL file should have the name: recursive.get.csv.ftl and the description file should have the name: recursive.get.desc.xml. The 'recursive' part can be set to anything you want. The '.get' indicates the protocol, the '.csv' part indicates the returned format, and the '.ftl' part indicates the format of the file itself.

Re: how Can we change the output format to CSV instead of HTML ?

raghu462 — Tue, 20 Apr 2010 14:50:59 GMT

I changed the FTL file name as recrsive.get.csv.ftl whenever executing the file it's showing following exception please suggest me.

The Web Script /alfresco/service/sample/recurse/{recurse} has responded with a status of 500 - Internal Error.

500 Description:   An error inside the HTTP server which prevented it from fulfilling the request.

Message:   IO Error during processing of the template 'org/alfresco/sample/recurse.get.html.ftl'. Please contact your system administrator.

Exception:   java.io.FileNotFoundException - Template org/alfresco/sample/recurse.get.html.ftl not found.

   freemarker.template.Configuration.getTemplate(Configuration.java:489)
   freemarker.template.Configuration.getTemplate(Configuration.java:452)
   org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:193)
   org.alfresco.web.scripts.AbstractWebScript.renderTemplate(AbstractWebScript.java:329)
   org.alfresco.web.scripts.DeclarativeWebScript.renderFormatTemplate(DeclarativeWebScript.java:232)
   org.alfresco.web.scripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:158)
   org.alfresco.web.scripts.WebScriptRuntime.wrappedExecute(WebScriptRuntime.java:342)
   org.alfresco.web.scripts.WebScriptRuntime.authenticatedExecute(WebScriptRuntime.java:308)
   org.alfresco.web.scripts.WebScriptRuntime$1.execute(WebScriptRuntime.java:163)
   org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
   org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
   org.alfresco.web.scripts.WebScriptRuntime.executeScript(WebScriptRuntime.java:174)
   org.alfresco.web.scripts.WebScriptServlet.service(WebScriptServlet.java:109)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
   org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
   org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
   org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
   org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
   org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
   java.lang.Thread.run(Thread.java:595)

Exception:   org.alfresco.service.cmr.repository.TemplateException - IO Error during processing of the template 'org/alfresco/sample/recurse.get.html.ftl'. Please contact your system administrator.

   org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:220)

Re: how Can we change the output format to CSV instead of HTML ?

raghu462 — Sun, 25 Apr 2010 13:33:20 GMT

please anybody give me reply.

Re: how Can we change the output format to CSV instead of HTML ?

invictus9 — Tue, 27 Apr 2010 19:04:08 GMT

In web scripts it is important that the files that go together have the same root name. In your example, you have a web script called "recurse" which cannot find the formatting file called recurse.get.csv.ftl – this is because you named the file recrsive.get.csv.ftl. It needs to be named recurse.get.csv.ftl

Re: how Can we change the output format to CSV instead of HTML ?

raghu462 — Thu, 10 Jun 2010 08:46:57 GMT

I resolve my Problem,There is no mime type for generate CSV file and we can't generate CSV file by using webscripts also
after generated the HTML file format using webscript then you can copy the output and paste in notepad after that copy the content in notepad and open MS Excel sheet and paste whatevere copied in notepad and save as the file with the extension as comma delimited(CSV) thats all.

Re: how Can we change the output format to CSV instead of HTML ?

invictus9 — Thu, 10 Jun 2010 15:28:43 GMT

I resolve my Problem,There is no mime type for generate CSV file and we can't generate CSV file by using webscripts also
after generated the HTML file format using webscript then you can copy the output and paste in notepad after that copy the content in notepad and open MS Excel sheet and paste whatevere copied in notepad and save as the file with the extension as comma delimited(CSV) thats all.

Whoops. I'm sorry for misleading you.

Another alternative would have been to use XML export, as Microsoft Excel is able to read XML files directly.