Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »

[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", '$

Unknown macro: {user}

');

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

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

<EricDalquist> replace $

Unknown macro: {user}

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", '$

Unknown macro: {user}

') ; 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 (smile)

[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

  • No labels