[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
[15:44:53 CDT(-0500)] <athena> EricDalquist: what needs to happen to get the new SCSS build into master?
[15:45:02 CDT(-0500)] <EricDalquist> I need about 4 hours of time
[15:45:04 CDT(-0500)] <athena> are you waiting on testing or anything like that?
[15:45:06 CDT(-0500)] <athena> ah ok
[15:45:17 CDT(-0500)] <EricDalquist> so hopefully some evening this week
[15:46:47 CDT(-0500)] <athena> cool 
[15:46:58 CDT(-0500)] <athena> just wanted to make sure you weren't waiting on us for anything
[15:47:08 CDT(-0500)] <EricDalquist> this will also be the point where we create a 4.0 branch
[15:47:19 CDT(-0500)] <EricDalquist> and in the 4.0 branch I'll setup the plugin for manual execution
[15:47:25 CDT(-0500)] <EricDalquist> so it will regenerate the .css files in place
[15:47:42 CDT(-0500)] <EricDalquist> and in master (4.1) I'll rm the .css files and switch to build-time generation
[15:53:23 CDT(-0500)] <athena> gotcha
[15:53:32 CDT(-0500)] <athena> that seems reasonable
[15:54:10 CDT(-0500)] <athena> by the way, do you have examples of some more complex fragment mappings?
[15:54:10 CDT(-0500)] <EricDalquist> since deleting the .css files mid 4.0 release stream seems bad
[15:54:29 CDT(-0500)] <athena> peterjhart is working on a UI fragment mapping administration, and he could use some real-world examples
[15:54:40 CDT(-0500)] <athena> particularly around use of nested and/or/not blocks
[15:54:50 CDT(-0500)] <athena> yeah that's probably nicer to wait
[15:55:01 CDT(-0500)] <EricDalquist> https://gist.github.com/2639189
[15:55:08 CDT(-0500)] <EricDalquist> that is our prod PAGS/DLM config
[15:55:36 CDT(-0500)] <athena> thanks!
[15:55:37 CDT(-0500)] <athena> much appreciated
[15:55:53 CDT(-0500)] <athena> will be cool to have a UI for that
[15:56:08 CDT(-0500)] <athena> peter also had a suggestion that i think would make a nice improvement to the import/export portlet
[15:56:21 CDT(-0500)] <athena> basically the ability to input XML via copy/paste/entry rather than just file upload
[15:56:24 CDT(-0500)] <EricDalquist> yes
[15:56:26 CDT(-0500)] <EricDalquist> that would be nice
[15:56:31 CDT(-0500)] <athena> could probably also display XML on the screen and let you edit and save
[15:56:32 CDT(-0500)] <EricDalquist> that portlet is on my todo list
[15:56:32 CDT(-0500)] <athena> yeah
[15:56:39 CDT(-0500)] <athena> that modification?
[15:56:46 CDT(-0500)] <EricDalquist> since the import/expoert API now supports listing available data per type
[15:56:47 CDT(-0500)] <athena> or just the portlet in general
[15:56:51 CDT(-0500)] <athena> that one could use UI help as well
[15:56:51 CDT(-0500)] <EricDalquist> in general
[15:56:53 CDT(-0500)] <athena> yeah
[15:56:57 CDT(-0500)] <athena> and it needs a facelift
[15:57:09 CDT(-0500)] <EricDalquist> we could in theory have a data type drop down and a fluid pager
[15:57:11 CDT(-0500)] <EricDalquist> pick your data type
[15:57:16 CDT(-0500)] <EricDalquist> then page through the entities of that type
[15:57:21 CDT(-0500)] <EricDalquist> pick what you want to export/delete
[15:57:33 CDT(-0500)] <EricDalquist> also it would be nice to be able to upload a .zip or .tar.gz
[15:57:36 CDT(-0500)] <EricDalquist> for import
[15:57:37 CDT(-0500)] <athena> yeah that'd be cool too
[15:57:38 CDT(-0500)] <athena> yes
[15:57:45 CDT(-0500)] <athena> those all sound like nice new features
[15:57:48 CDT(-0500)] <EricDalquist> yes
[15:57:56 CDT(-0500)] <EricDalquist> just you know ... no time
[15:57:58 CDT(-0500)] <athena> maybe we should create a ticket for a general overhaul of that one
[15:57:59 CDT(-0500)] <athena> yes :/
[15:58:08 CDT(-0500)] <athena> and that layout stuff . . . no idea when we're going to really do that
[15:58:15 CDT(-0500)] <EricDalquist> well
[15:58:21 CDT(-0500)] <EricDalquist> that will be on my todo list post conference
[15:58:23 CDT(-0500)] <EricDalquist> yeah
[15:58:37 CDT(-0500)] <EricDalquist> what ticket is peter working off of right now for it?
[15:58:50 CDT(-0500)] <EricDalquist> I really need to get the diagraming done for the conference bof
[15:59:12 CDT(-0500)] <athena> that came up in discussion for https://issues.jasig.org/browse/UP-3367
[15:59:19 CDT(-0500)] <athena> so not actively working on import/export right now
[15:59:48 CDT(-0500)] <EricDalquist> ah
[15:59:48 CDT(-0500)] <EricDalquist> ok
[16:04:30 CDT(-0500)] <EricDalquist> https://issues.jasig.org/browse/UP-3463
[16:10:02 CDT(-0500)] <EricDalquist> ok athena documented all those ideas
[16:10:12 CDT(-0500)] <EricDalquist> all subtasks of 3436
[16:11:42 CDT(-0500)] <athena> awesome!
[16:14:23 CDT(-0500)] <EricDalquist> so it looks like I have to figure out how to apply read-only transactions to reading portlet entities and definitions only when the DB is postgres
[16:14:29 CDT(-0500)] <EricDalquist> since it requires that for clobs
[16:14:43 CDT(-0500)] <EricDalquist> and postgres actually has a read-only tx concept
[16:14:51 CDT(-0500)] <EricDalquist> the rest of the dbs result in lots of table locking
[16:14:54 CDT(-0500)] <EricDalquist> 