[Building Sakai] Samigo export

Jaco Gillman jaco at opencollab.co.za
Wed Aug 20 04:34:25 PDT 2014


Hi Stephen

Thanks for your reply. Was just wondering because this is standard Sakai
Samigo source.

I have used for org.apache.poi.xssf other Sakai Projects myself, and would
also prefer using xlsx here.


Regards,

*Jaco Gillman*

Java Developer

opencollab

*Tel*: +27 21 970 4017  |  *Fax*: +27 21 914 3098

*Email*: jaco at opencollab.co.za  |  *Skype*: gillmanjc

*Web*: www.opencollab.co.za



On 20 August 2014 13:08, Stephen Marquard <stephen.marquard at uct.ac.za>
wrote:

>  You may want to try the xlsx format here, org.apache.poi.xssf rather
> than hssf.
>
>
>
> Regards
>
> Stephen
>
>
>
> ---
> Stephen Marquard, Learning Technologies Co-ordinator,
> Centre for Innovation in Learning and Teaching (CILT)
> University of Cape Town
> http://www.cilt.uct.ac.za
> stephen.marquard at uct.ac.za
> Phone: +27-21-650-5037 Cell: +27-83-500-5290
>
>
>
> *From:* sakai-dev-bounces at collab.sakaiproject.org [mailto:
> sakai-dev-bounces at collab.sakaiproject.org] *On Behalf Of *Jaco Gillman
> *Sent:* 20 August 2014 11:49 AM
> *To:* Sakai Dev Mail List
> *Subject:* [Building Sakai] Samigo export
>
>
>
> Hi All
>
>
>
> Has anyone came across this issue when trying to do a Samigo Export? Sakai
> 2.9.3 used...
>
>
>
>
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException:
> java.lang.IllegalArgumentException: Themaximum length of cell contents (
> text) is 32,767 characters
>     at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:73)
> caused by: org.sakaiproject.tool.api.ToolException:
> javax.servlet.ServletException: java.lang.IllegalArgumentException: The
> maximum length of cell contents (text) is 32,767 characters
>     at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1483)
> caused by: javax.servlet.ServletException:
> java.lang.IllegalArgumentException: The maximum length of cell contents (
> text) is 32,767 characters
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> caused by: javax.faces.el.EvaluationException:
> java.lang.IllegalArgumentException: The maximum length of cell contents (
> text) is 32,767 characters
>     at javax.faces.component.UICommand.broadcast(UICommand.java:325)
> caused by: java.lang.IllegalArgumentException: The maximum length of cell
> contents (text) is 32,767 characters
>     at
> org.apache.poi.hssf.usermodel.HSSFCell.setCellValue(HSSFCell.java:559)
>     at
> org.apache.poi.hssf.usermodel.HSSFCell.setCellValue(HSSFCell.java:533)
>     at
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.getAsWorkbook(ExportResponsesBean.java:430)
>     at
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.writeDataToResponse(ExportResponsesBean.java:314)
>     at
> org.sakaiproject.tool.assessment.ui.bean.evaluation.ExportResponsesBean.exportExcel(ExportResponsesBean.java:180)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>     at java.lang.reflect.Method.invoke(Method.java:597)
>     at
> com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:146)
>     at javax.faces.component.UICommand.broadcast(UICommand.java:325)
>     at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:287)
>     at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:401)
>     at
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:95)
>     at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245)
>     at
> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:110)
>     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:213)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:634)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
>     at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
>     at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
>     at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
>     at
> org.sakaiproject.jsf.util.SamigoJsfTool.dispatch(SamigoJsfTool.java:301)
>     at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
>     at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
>     at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378)
>     at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
>     at
> org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:511)
>     at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1483)
>     at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:213)
>     at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:96)
>     at
> org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:73)
>     at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1273)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:695)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
>     at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
>     at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
>     at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
>     at org.apache.tomcat.util.net
> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
>     at java.lang.Thread.run(Thread.java:662)
>
>
>  Regards,
>
> *Jaco **Gillman*
>
> Java Developer
>
> opencollab
>
> *Tel*: +27 21 970 4017  |  *Fax*: +27 21 914 3098
>
> *Email*: jaco at opencollab.co.za  |  *Skype*: gillmanjc
>
> *Web*: www.opencollab.co.za
>
>
>
>
>  ------------------------------
>
> See OpenCollab email disclaimer at
> http://www.opencollab.co.za/email-disclaimer
>  ------------------------------
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27
> 21 650 9111. This e-mail is intended only for the person(s) to whom it is
> addressed. If the e-mail has reached you in error, please notify the
> author. If you are not the intended recipient of the e-mail you may not
> use, disclose, copy, redirect or print the content. If this e-mail is not
> related to the business of UCT it is sent by the sender in the sender's
> individual capacity.
>

-- 

------------------------------
See OpenCollab email disclaimer at 
http://www.opencollab.co.za/email-disclaimer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140820/c5f36a8a/attachment.html 


More information about the sakai-dev mailing list