Fastest way to set a Lighthouse property on all users
Hi,
I would like to set a property on all user objects, such as
accounts[Lighthouse].properties.registrationDate
I have about 30,000 users. What would be the fastest way to set tis property on all users? Two methods I can think of:
1) Export all users objects, edit them all with a perl/sed/awk script
and then re-import them.
2) Run a workflow to checkout all users in turn, and set the property
on each userview, then check them in.
Any suggestions?
Thanks,
John I
[534 byte] By [
johnia] at [2007-11-27 10:29:30]

# 1
Hi John,
I was in a similar situation, where I needed to push attribute changes en masse. The Bulk Action mechanism works very well.
Use the option to supply a CSV file, and on each line indicate the update command, the user to act on, and the path expression whose value you want to set.
So in the example you mentioned, you'd want a CSV file that looks like:
command,user,accounts[Lighthouse].properties.registrationDate
Update,John Doe,theDate
Update,Jane Smith,theDate
Update,Bill Jones,theDate
...
Hope that helps!
Adam Ohren
Professional Services
QoS Labs, LLC