Forum LAMS for Tech-Heads - General Forum: Import of users and roles


 
You may request notification for Import of users and roles.
Search: 

1: Import of users and roles
04/16/07 08:15 AM
[ Reply | Forward ]
Hi.

To import users, I clicked on XLS file link, edited it (in IE), saved, and clicked on back button OK. Did this again for the roles and got the following error. I then when back 3 or 4 history steps and all worked well.

Also where is the documentation for what some of those fields mean?

Best,

-ken

Sorry, there as been an error.
There is a problem processing this request. Close the browser window and try again. If the problem persists please contact your system administrator or the technical forums on http://lamscommunity.org/.

java.io.IOException: Unable to read entire header; -1 bytes read; expected 512 bytes Hide detail
java.io.IOException: Unable to read entire header; -1 bytes read; expected 512 bytes at org.apache.poi.poifs.storage.HeaderBlockReader.(HeaderBlockReader.java:78) at org.apache.poi.poifs.filesystem.POIFSFileSystem.(POIFSFileSystem.java:83) at org.lamsfoundation.lams.admin.service.SpreadsheetService.getSheet(SpreadsheetService.java:128) at org.lamsfoundation.lams.admin.service.SpreadsheetService.isUserSpreadsheet(SpreadsheetService.java:134) at org.lamsfoundation.lams.admin.service.SpreadsheetService.parseSpreadsheet(SpreadsheetService.java:148) at org.lamsfoundation.lams.admin.web.ImportExcelSaveAction.execute(ImportExcelSaveAction.java:70) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.lamsfoundation.lams.web.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:151) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.lamsfoundation.lams.web.session.SystemSessionFilter.doFilter(SystemSessionFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.lamsfoundation.lams.integration.security.SingleSignOn.invoke(SingleSignOn.java:121) at org.lamsfoundation.lams.integration.security.LoginRequestValve.invoke(LoginRequestValve.java:67) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:619)

Posted by Ken Kahn

2: Re: Import of users and roles
In response to 1 04/16/07 06:00 PM
[ Reply | Forward ]
Thanks for pointing this out. When you pressed back in your browser, you reached the point where LAMS expected a spreadsheet to be submitted, but there wasn't any. You'll get the same error if you click 'Import' straight away without browsing for a file first. It's a bug, I'll add a jira issue for it. What it should properly do is say something to the effect that it's expecting a spreadsheet to be submitted.

Documentation for the import spreadsheets should be at - http://wiki.lamsfoundation.org/display/lamsdocs/Import+Users (the blue help icon in the LAMS Import Users page links to there) - but you're right, it doesn't describe all of the columns, only the essential ones. Check the link soon for an update...

Posted by Jun-Dir Liew

3: Re: Re: Import of users and roles
In response to 2 04/17/07 04:08 AM
[ Reply | Forward ]
Thanks. Perhaps a link to http://wiki.lamsfoundation.org/display/lamsdocs/Import+Users should be on the import dialog page.

Best,

-ken

Posted by Ken Kahn

4: Re: Re: Re: Import of users and roles
In response to 3 04/17/07 06:05 PM
[ Reply | Forward ]
From 2.0 onwards that page has a link to the wiki page (via the blue help icon with the question mark on it). If you're using RC2 or earlier, you won't have the link.

Posted by Jun-Dir Liew

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum