Write Exec Task

[pclark_braums]

Is there a way to create an Exel file that is not in Exel 2007 format. I have a user using an app on an i phone and it will not let me sort the spreedsheet. He can with other exec files.

Also, how does the Exel template work?

[Support_Duane]

GoAnywhere does not currently create Excel 2007 spreadsheets, only Excel 2003. We are working on that ability, but it does not currently exist.

As far as the Excel template goes, you create an Excel file that has the headings and columns the way you want them and then you reference that file in the template field in the Write Excel task.

[Support_Julie]

As of version 3.00 we now support Excel 2007.
(Older versions of GoAnywhere Director only support Excel 2003.)

[bjbstl]

I've tried creating an excel template (xlsx) to use in my Write Exec command but I'm getting a job log. The error is unclear. I see no instructions or examples in the manual for creating a Template File for the Write Exec Task.
INFO Finished task 'sql 1.0 (Connect to DB)'
4/11/11 11:50:31 AM INFO Executing task 'writeExcel 2.0 (Convert to Excel)'
4/11/11 11:50:31 AM INFO Finished task 'writeExcel 2.0 (Convert to Excel)'
4/11/11 11:50:31 AM ERROR org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
4/11/11 11:50:31 AM INFO Finished project 'BJB PARM120'
4/11/11 11:50:31 AM ERROR org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
com.linoma.dpa.runtime.JobFailedException: org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
at com.linoma.dpa.runtime.Job.run(Unknown Source)
at com.linoma.dpa.runtime.Runtime.executeProject(Unknown Source)
at com.linoma.dpa.j2ee.forms.ProjectListForm.runProject(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.apache.el.parser.AstValue.invoke(AstValue.java:172)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at org.apache.myfaces.el.convert.MethodExpressionToMethodBinding.invoke(MethodExpressionToMethodBinding.java:75)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:57)
at javax.faces.component.UICommand.broadcast(UICommand.java:143)
at javax.faces.component.UIData.broadcast(UIData.java:696)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466)
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103)
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:151)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.linoma.dpa.security.SecurityFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:811)
Caused by: com.linoma.dpa.ExecutionException: org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
at com.linoma.dpa.ErrorHandler.handleOnError(Unknown Source)
at com.linoma.dpa.Module.execute(Unknown Source)
at com.linoma.dpa.Project.execute(Unknown Source)
at com.linoma.dpa.runtime.Job.executeProject(Unknown Source)
... 45 more
Caused by: java.lang.NoSuchMethodError: org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
at org.apache.poi.util.PackageHelper.clone(PackageHelper.java:83)
at org.apache.poi.util.PackageHelper.clone(PackageHelper.java:44)
at org.apache.poi.POIXMLDocument.ensureWriteAccess(POIXMLDocument.java:185)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:172)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelDataWriter.initializeWorkBook(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelDataWriter.initialize(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelDataWriter.execute(Unknown Source)
at com.linoma.dpa.tasks.converters.DataWriterTask.execute(Unknown Source)
... 48 more
4/11/11 11:50:31 AM INFO End Date and Time: 4/11/11 11:50:31 AM