uPortal IRC Logs-2012-05-08

[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)]

[13:25:13 CDT(-0500)] <EricDalquist> per user

[13:25:21 CDT(-0500)]

[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)]

[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>

[17:04:49 CDT(-0500)] <peterjhart1> dlm.xml is only for uP3, right?