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?
Write Exec Task
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
- Support_Duane Offline
- Support Specialist
- Posts: 66
- Joined: Thu Mar 05, 2009 3:49 pm
Re: Write Exec Task
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.
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 Offline
- Support Specialist
- Posts: 91
- Joined: Thu Mar 05, 2009 3:49 pm
- Location: Ashland, NE USA
- Contact:
Re: Write Exec Task
As of version 3.00 we now support Excel 2007.
(Older versions of GoAnywhere Director only support Excel 2003.)
(Older versions of GoAnywhere Director only support Excel 2003.)
Re: Write Exec Task
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
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