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.

Write Exec Task

Postby 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?
pclark_braums
Verified User
 
Posts: 1
Joined: Mon Sep 28, 2009 9:52 am

Re: Write Exec Task

Postby 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_Duane
Support Specialist
 
Posts: 65
Joined: Thu Mar 05, 2009 3:49 pm

Re: Write Exec Task

Postby 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
Software Support
Linoma Software
Support_Julie
Support Specialist
 
Posts: 75
Joined: Thu Mar 05, 2009 3:49 pm
Location: Ashland, NE USA

Re: Write Exec Task

Postby 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
bjbstl
 
Posts: 1
Joined: Fri Apr 08, 2011 4:58 pm


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 1 guest