[10:28:30 CDT(-0500)] <athena> EricDalquist: do we have any documented SQL to determine how many users have customized their layout?
[10:28:39 CDT(-0500)] <EricDalquist> nope
[10:28:47 CDT(-0500)] <EricDalquist> and its more complex than that
[10:28:57 CDT(-0500)] <EricDalquist> you also need to account for any user that has portlet entity preferences as well
[10:29:13 CDT(-0500)] <EricDalquist> if you are considering exported layout #s
[10:29:32 CDT(-0500)] <EricDalquist> in theory select distinct user_id from up_layout_struct might work
[10:29:46 CDT(-0500)] <EricDalquist> but I'm guessing that in most installs users have layout data even if they haven't customized
[10:32:05 CDT(-0500)] <athena> yeah
[10:32:20 CDT(-0500)] <athena> i'm worried that it would - especially since this is a 3.0 install
[10:32:40 CDT(-0500)] <athena> think they're just trying to get a general idea of how much customization has been done, so ignoring portlet prefs is probably fine
[10:33:08 CDT(-0500)] <EricDalquist> you could probably do something like:
[10:33:28 CDT(-0500)] <EricDalquist> select user_id, count
as node_count from up_user_layout group by user_id
[10:33:39 CDT(-0500)] <EricDalquist> that would give you the # of layout nodes per user
[10:34:06 CDT(-0500)] <athena> makes sense - layout nodes in that case are essentially overrides, right?
[10:34:14 CDT(-0500)] <EricDalquist> and you might be able to simply say any user with X or fewer nodes haven't customized
[10:34:15 CDT(-0500)] <EricDalquist> right
[10:34:31 CDT(-0500)] <EricDalquist> like users without customization might just have 5-6 nodes
[10:34:51 CDT(-0500)] <EricDalquist> actually I think they would have the same node count as the defaultTemplateUser
[10:35:10 CDT(-0500)] <EricDalquist> but yeah, each node would be an override of some sort
[10:35:17 CDT(-0500)] <EricDalquist> with a few extra nodes for container nodes
[10:35:19 CDT(-0500)] <athena> thanks
[10:35:23 CDT(-0500)] <athena> i'll play around w/ some options
[11:45:08 CDT(-0500)] <EricDalquist> grr
[11:45:18 CDT(-0500)] <EricDalquist> this layout code is so inefficient
[11:45:29 CDT(-0500)] <EricDalquist> how can it be using more connections than there are threads in the jvm to export user layouts?
[11:47:09 CDT(-0500)] <athena> eep
[11:47:18 CDT(-0500)] <EricDalquist> I mean
[11:47:21 CDT(-0500)] <EricDalquist> I've seen the code
[11:47:25 CDT(-0500)] <EricDalquist> I know how it is managing to do this
[11:47:29 CDT(-0500)] <EricDalquist> its just sad that it is 
[11:47:48 CDT(-0500)] <EricDalquist> I'm looking forward to doing a review of the new user/profile/layout data model at the conference
[11:47:57 CDT(-0500)] <EricDalquist> and post-conf I'll likely start working on it
[15:57:37 CDT(-0500)] <athena> EricDalquist: do you know what version of ant uportal 3.0.8 should be built with?
[15:57:52 CDT(-0500)] <athena> it seems to want 1.7.1, but the quickstart contains 1.6.5
[15:59:11 CDT(-0500)] <athena> actually more maybe an issue w/ the build not even knowing how to use the antversion element
[16:00:13 CDT(-0500)] <EricDalquist> hrm
[16:00:19 CDT(-0500)] <EricDalquist> I thought all of 3.x used 1.7
[16:00:22 CDT(-0500)] <EricDalquist> er 1.7.1
[16:00:42 CDT(-0500)] <athena> manual says 1.6
[16:00:45 CDT(-0500)] <athena> https://wiki.jasig.org/display/UPM30/Apache+Ant
[16:00:53 CDT(-0500)] <EricDalquist> huh
[16:01:12 CDT(-0500)] <EricDalquist> might have been an over-eager commit somewhere that added the check for 1.7.1
[16:01:18 CDT(-0500)] <athena> ok
[16:01:23 CDT(-0500)] <athena> i'll take a look at the history