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.
4 posts Page 1 of 1

pclark_braums

Verified User
Posts: 1
Joined: Mon Sep 28, 2009 9:52 am

Post by pclark_braums » Mon Sep 28, 2009 10:00 am
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

Support Specialist
Posts: 66
Joined: Thu Mar 05, 2009 3:49 pm

Post by Support_Duane » Mon Sep 28, 2009 4:53 pm
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

User avatar
Support Specialist
Posts: 91
Joined: Thu Mar 05, 2009 3:49 pm
Location: Ashland, NE USA

Post by Support_Julie » Tue Dec 29, 2009 3:01 pm
As of version 3.00 we now support Excel 2007.
(Older versions of GoAnywhere Director only support Excel 2003.)
Julie Rosenbaum
Sr Support Analyst
e. goanywhere.support@helpsystems.com
p. 1.800.949.4696
w. HelpSystems.com

bjbstl

Posts: 1
Joined: Fri Apr 08, 2011 4:58 pm

Post by bjbstl » Mon Apr 11, 2011 12:17 pm
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
4 posts Page 1 of 1