[13:22:27 CDT(-0500)] <b-sure> Hello uPortal Devs. is there a place in the database where I can reset a users layout to the default layout? I would need to do this on a mass scale for all of the users. Maybe this could happen by updating a field in the db?
[13:24:20 CDT(-0500)] <EricDalquist> hrm ...
[13:25:00 CDT(-0500)] <EricDalquist> one thing to try if you are on the latest uPortal 4 release
[13:25:09 CDT(-0500)] <b-sure> I'm only looking at this as an option becuase its the last step holding us back from upgrading. and I've been spinning my wheels lately getting the imports to work
[13:25:13 CDT(-0500)] <EricDalquist> create a big .groovy script with one line of:
[13:25:13 CDT(-0500)] <EricDalquist> portalShellBuildHelper.deleteUser("deluser", '$ ');
[13:25:13 CDT(-0500)] <EricDalquist> per user
[13:25:21 CDT(-0500)] <EricDalquist> replace $ with their username
[13:25:40 CDT(-0500)] <EricDalquist> then do "ant up-shell -Dscript=path/to/script"
[13:25:49 CDT(-0500)] <EricDalquist> that should run that groovy script and delete all those users
[13:26:04 CDT(-0500)] <EricDalquist> and if layouts are the only bit of interesting data that should work
[13:26:14 CDT(-0500)] <b-sure> oh. so if the user doesn't exist in the db, then they will get recreated and default layout setup?
[13:26:34 CDT(-0500)] <EricDalquist> yup
[13:27:03 CDT(-0500)] <b-sure> is there a reason to not do a "delete from up_user" sql query?
[13:27:12 CDT(-0500)] <b-sure> maybe foreign keys
[13:28:02 CDT(-0500)] <EricDalquist> yeah
[13:28:09 CDT(-0500)] <EricDalquist> that leaves A LOT of crud in other tables
[13:28:51 CDT(-0500)] <b-sure> ok that makes sense. so for the portalSHellBuildHelper.deleteUser("deluser", '$ ') ; do I need a list of users to feed to the script?
[13:29:56 CDT(-0500)] <b-sure> it would be nice since some of the successful imports work, but then break on the logged in display, to figure out which ones don't work and just delete those.
[13:31:46 CDT(-0500)] <b-sure> thanks for the tip EricDalquist.
[14:58:26 CDT(-0500)] <b-sure> hi EricDalquist. I've tried your suggestion above but am running into some kind of size threshold http://pastebin.com/raw.php?i=t8VPiqtt. I'm gonna try to split up the file. into chunks and retry to run it. it currently has 22971 users
[14:58:58 CDT(-0500)] <b-sure> unless there is some what to increase the constant pool.
[14:58:59 CDT(-0500)] <EricDalquist> huh
[14:59:07 CDT(-0500)] <EricDalquist> it works with a smaller list?
[14:59:16 CDT(-0500)] <b-sure> I'm gonna try that now...
[14:59:32 CDT(-0500)] <EricDalquist> http://groovy.codehaus.org/Input+Output
[14:59:35 CDT(-0500)] <EricDalquist> that is another options
[14:59:37 CDT(-0500)] <EricDalquist> option
[14:59:42 CDT(-0500)] <EricDalquist> since it is a groovy script
[14:59:58 CDT(-0500)] <EricDalquist> use that withReader example
[15:00:04 CDT(-0500)] <EricDalquist> put one username per line in a text file
[15:00:12 CDT(-0500)] <EricDalquist> and have it call that delete user method once per line
[15:02:31 CDT(-0500)] <b-sure> ok I'll give that a try as well.
[15:16:11 CDT(-0500)] <b-sure> ok EricDalquist. do you think maybe this user isn't in the 4.0 db? they were a user exported from the 3.2.x build http://pastebin.com/raw.php?i=ZiN7bV7S ?
[15:16:38 CDT(-0500)] <EricDalquist> ah that could very much be the case
[15:16:56 CDT(-0500)] <EricDalquist> that should be filed as a bug against uPortal
[15:17:02 CDT(-0500)] <b-sure> dough it probably makes sense to get my userlist directly from the new db
[15:17:04 CDT(-0500)] <EricDalquist> since it shouldn't fail with a stack in that case
[15:17:33 CDT(-0500)] <b-sure> ok. I"ll create a jira for this.
[15:24:57 CDT(-0500)] <b-sure> ok created https://issues.jasig.org/browse/UP-3462. not sure if you need me to add more to i.
[15:28:34 CDT(-0500)] <EricDalquist> that's good