Question

Push user attribute changes to a group of users

Laserfiche Version 10

Updated August 25, 2020

asked on October 15, 2018

I am in a deployment phase where I need to change user profile attributes and massively push them to over 250 accounts.

Out of these 250 accounts, there are 4 groups of changes and I have applied attribute changes to 4 tests users (for testing purpose).

I have exported key attributes onto an XML file (for each test users) so I now have 4 XML files ready to push out.

We don't want to go through manually opening up all these 250 accounts one by one and import the XML for everyone of them. Also, we will have multiple deployment phases always requiring attribute changes so we will need to do it again a few more times.

Is there a SQL update command I can use to push these attribute changes directly to these users?

0 0

Replies

replied on August 25, 2020

I am finding this need more and more as we have customers with hundreds/thousands of users that they want to push new attributes out to. I understand there are custom ways to apply attributes (SDK script, SQL update) but there needs to be a way that an admin who does not have programming experience can update these in mass.

1 0

replied on October 15, 2018

the only group you can assign attribute is the "everyone" group

0 0

replied on October 15, 2018 • Show version history

The trustee_attr table is where the attributes for each trustee are stored. However, you would have to extract the attributes from your XML files and insert them individually. You just need to make sure that you have the right SID for each user. Also, make a backup and preferably try it out in a test environment.

The safer method is probably to use the SDK. However, the same warnings apply.

0 0

replied on October 15, 2018

Thanks for your answers Rene and Devin,

I know Rene that only attributes on the everyone group will be pushed to users but I need to automate something here.

I've asked this many times over the years to Laserfiche but seems like the Profile/Attribute advanced management tool has not yet come to life. Not enough peoples have asked for this yet, I guess.

I'm mainly looking at some examples that some other advanced Users or VARs may have developed for this.

Users I'll need to update were created within LFDS and on the repository side, we have added these LFDS users to the repository and assigned them to Laserfiche groups. I would like to use the LF groups and get a list of Users's SID so I can push my attributes.

Wondering if someone has ever gone through this before.

Or if Laserfiche can give some hints and SQL examples

0 0

replied on October 22, 2018 • Show version history

LOL Daniel, I have not looked at the user who post the question when I added my comment.

I Wonder if there is a way using Script in workflow to modify the attribute for Laserfiche Windows account or repository account based on which group they are?

It sure if it is for only one shot, it is a lot of effor to create this script but if it can be used for several time, it could be interesting to create it and maybe use it for other Customer if needed.

0 0

replied on October 22, 2018

Sure. You can use Workflow to run SDK Scripts, and that would give you access to whatever you need.

IMO, it's well worth the effort to write a detailed script for a one-time operation. It ensures that everything gets done consistently and safely. Even if you never run it again, it's better to have confidence that it was done right.

1 0

You are not allowed to follow up in this post.

Question

Question

Push user attribute changes to a group of users

Replies

Sign in to reply to this post.