Index: lams_admin/src/java/org/lamsfoundation/lams/admin/service/ImportService.java =================================================================== RCS file: /usr/local/cvsroot/lams_admin/src/java/org/lamsfoundation/lams/admin/service/ImportService.java,v diff -u -r1.14 -r1.15 --- lams_admin/src/java/org/lamsfoundation/lams/admin/service/ImportService.java 20 Aug 2009 04:37:46 -0000 1.14 +++ lams_admin/src/java/org/lamsfoundation/lams/admin/service/ImportService.java 2 Sep 2009 05:33:04 -0000 1.15 @@ -699,6 +699,7 @@ user.setFax(parseStringCell(row.getCell(FAX))); user.setDisabledFlag(false); user.setCreateDate(new Date()); + user.setTimeZone(user.getTimeZone()); user.setTutorialsDisabled(false); user.setFirstLogin(true); Index: lams_common/db/sql/insert_lams_users.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_lams_users.sql,v diff -u -r1.4 -r1.5 --- lams_common/db/sql/insert_lams_users.sql 21 Aug 2009 03:25:40 -0000 1.4 +++ lams_common/db/sql/insert_lams_users.sql 2 Sep 2009 05:33:04 -0000 1.5 @@ -97,84 +97,84 @@ INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone,fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id, flash_theme_id, html_theme_id) +locale_id, flash_theme_id, html_theme_id, timezone) VALUES(1, 'sysadmin',SHA1('sysadmin'),'The','System','Administrator',null,null,null, 'Sydney','NSW','Australia',null,null,null,null,'sysadmin@x.x', 0,NOW(),1,51, -1,1,2); +1,1,2,28); INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone,fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id, flash_theme_id, html_theme_id) +locale_id, flash_theme_id, html_theme_id, timezone) VALUES(2, 'test',SHA1('test'),'Dr','Testing','LDAP',null,null,null, 'Sydney','NSW','Australia',null,null,null,null,'test@xx.xx.xx', 0,NOW(),3,null, -3,1,2); +3,1,2,28); INSERT INTO lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone,fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id, flash_theme_id, html_theme_id) +locale_id, flash_theme_id, html_theme_id, timezone) VALUES(3, 'lamskh01',SHA1('dummy'),'Mr','Jacky','Fang',null,null,null, 'Sydney','NSW','Australia',null,null,null,null,'jfang@melcoe.mq.edu.au', 0,NOW(),2,null, -1,1,2); +1,1,2,28); insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone, fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id, flash_theme_id, html_theme_id) +locale_id, flash_theme_id, html_theme_id, timezone) values (4,'mmm',SHA1('mmm'),'Ms','Mary','Morgan','99','First Ave',null, 'Parramatta','NSW','Australia','0295099999','0298939999','0499999999', '0299999999','mmmmmmm@xx.os', -0,'20041223',1,4,1,1,2); +0,'20041223',1,4,1,1,2,28); insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone, fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id,flash_theme_id, html_theme_id) +locale_id,flash_theme_id, html_theme_id, timezone) values (5,'test1',SHA1('test1'),'Dr','One','Test','1','Test Ave',null, 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', '0211111113','test1@xx.os', -0,'20041223',1,5,1,1,2); +0,'20041223',1,5,1,1,2,28); insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone, fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id,flash_theme_id, html_theme_id) +locale_id,flash_theme_id, html_theme_id, timezone) values (6,'test2',SHA1('test2'),'Dr','Two','Test','2','Test Ave',null, 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', '0211111113','test2@xx.os', -0,'20041223',1,6,1,1,2); +0,'20041223',1,6,1,1,2,28); insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone, fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id,flash_theme_id, html_theme_id) +locale_id,flash_theme_id, html_theme_id, timezone) values (7,'test3',SHA1('test3'),'Dr','Three','Test','3','Test Ave',null, 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', '0211111113','test3@xx.os', -0,'20041223',1,7,1,1,2); +0,'20041223',1,7,1,1,2,28); insert into lams_user (user_id,login,password,title,first_name,last_name,address_line_1,address_line_2,address_line_3, city,state,country,day_phone,evening_phone,mobile_phone, fax,email, disabled_flag,create_date,authentication_method_id,workspace_id, -locale_id,flash_theme_id, html_theme_id) +locale_id,flash_theme_id, html_theme_id, timezone) values (8,'test4',SHA1('test4'),'Dr','Four','Test','4','Test Ave',null, 'Nowhere','NSW','Australia','0211111111','0211111112','0411111111', '0211111113','test4@xx.os', -0,'20041223',1,8,1,1,2); +0,'20041223',1,8,1,1,2,28); --- sysadmin only belongs to root and public INSERT INTO lams_user_organisation (user_organisation_id, organisation_id, user_id) VALUES (1, 1, 1); Index: lams_common/src/java/org/lamsfoundation/lams/usermanagement/service/LdapService.java =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/usermanagement/service/LdapService.java,v diff -u -r1.17 -r1.18 --- lams_common/src/java/org/lamsfoundation/lams/usermanagement/service/LdapService.java 10 Apr 2009 17:24:02 -0000 1.17 +++ lams_common/src/java/org/lamsfoundation/lams/usermanagement/service/LdapService.java 2 Sep 2009 05:33:04 -0000 1.18 @@ -156,6 +156,9 @@ user.setDisabledFlag(getDisabledBoolean(attrs)); user.setCreateDate(new Date()); user.setLocale(getLocale(map.get("locale"))); + user.setTimeZone(user.getTimeZone()); + user.setTutorialsDisabled(false); + user.setFirstLogin(true); service.save(user); service.auditUserCreated(user, "common"); return true;