Hey All,
I am having trouble importing users using the excel spreadsheet that have any value in authentication_method_id. When I submit the sheet, I get back:
0 users were created successfully.
Row 2: Invalid authentication method. ("3")
Row 3: Invalid authentication method. ("3")
Row 4: Login is already taken. (dross)
Row 5: Invalid authentication method. ("3")
I have tried the following combinations and all of them give the same error: 3, "3", LDAP.
The import file was saved from Excel 2003 and I'm submitting into LAMS 2.0.3 running on a CentOS 5.0 host.
Is there any way to turn up the debugging further?
09:34:55,858 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.integration.security.SingleSignOn - Process request for '/lams/admin/importexcelsave.do'
09:34:55,858 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.integration.security.SingleSignOn - Checking for SSO cookie
09:34:55,859 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.integration.security.SingleSignOn - Checking for cached principal for ff808081136aa8ab01136aae7707004b
09:34:55,859 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.integration.security.SingleSignOn - Found cached principal 'sysadmin' with auth type 'FORM'
09:34:55,859 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.web.session.SessionManager - SessionManager: cookie is not null, currentSessionId=C8D0BD1CE16486108A2DA80CBF2CA4FD session=org.lamsfoundation.lams.web.session.SessionManager$SessionImpl@1799932
09:34:55,860 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.web.filter.LocaleFilter - Locale set from user lang/country is en,AU
09:34:55,860 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.util.CustomizedOpenSessionInViewFilter - Using SessionFactory 'coreSessionFactory' for OpenSessionInViewFilter
09:34:55,860 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.util.CustomizedOpenSessionInViewFilter - Opening single Hibernate Session in OpenSessionInViewFilter
09:34:55,932 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - sheet rows: 0..4
09:34:55,933 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - starting row: 1
09:34:56,006 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - hasError: true
09:34:56,007 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - starting row: 2
09:34:56,041 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - hasError: true
09:34:56,041 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - starting row: 3
09:34:56,055 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - hasError: true
09:34:56,055 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - starting row: 4
09:34:56,089 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - hasError: true
09:34:56,089 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.admin.service.ImportService - found 4 users in spreadsheet.
09:34:56,211 [http-0.0.0.0-8080-4:] DEBUG org.lamsfoundation.lams.util.CustomizedOpenSessionInViewFilter - Closing single Hibernate Session in OpenSessionInViewFilter
Also, is there a way of importing CSV files as opposed to an XLS sheet?
Posted by Darryl Ross
