View Full Version: Copy Lsf9 Users From Prod To Dev / Test

LawsonTalk > LSF 9.0 (NEW!!) > Copy Lsf9 Users From Prod To Dev / Test



Title: Copy Lsf9 Users From Prod To Dev / Test
Description: Anyone able to copy users across env?


Keith_G_Thompson - October 23, 2007 05:22 PM (GMT)
I have just LIS'd with Lawson and I must say, they've fallen a bit short on this whole User ID thing with LSF9. My challenge is this:

I have more than 5000 self-service users loaded in PROD and need a way to migrate them to a TEST (and DEV) environment. LAWSON OFFERS NO WAY TO DO THIS. :wwf:

So, before I reinvent the wheel, I thought I'd ask: Has anyone else has attempted and/or been successful with this?

My thoughts on the approach is this:
  • I still need to define the DEV_EMPLOYEE identity definition.
  • I have a utility to export various user-related LDAP records from ADAM, so I will use this as a starting point.
  • Once dumped, I can do an 'awk' or equiv to search and replace PROD with DEV
  • Then I can load the .ldif files into ADAM and all should be well
So, how crazy am I? I know the dump / load concept works as I have automated the user creation process in LSF9 for our self-service users. Thoughts?

Keith_G_Thompson - November 12, 2007 06:24 PM (GMT)
Success! I put this on the back burner for a while, but here are the basics.

I have scripted an export of the direct LDAP data to text files. These text files are then searched and replaced for PROD and DEV / TEST. You can then use more LDAP scripts to load the entries into the target LDAP instance. (We have separate LDAP installs for each environment. If you share one I think you might be on your own).

YMMV, but here's the jist:

Export the entries for tree(s) for PROD_EMPLOYEE, IDXREF, resources and SSOP. (We also make heavy use of Groups, so we exported those too). If you have self-service procurement you'd also need PROD_PURCHASE (or whatever it is).

Search and Replace the resulting .ldif files for PROD to DEV (e.g. update the user's product line, self-service entries, etc). **trick** you also need to eliminate the entry for "objectCategory" before the load as Lawson does not want to load this - it is created for you upon each entry.

We are now able to successfully able to migrate about 4000 users in 15 minutes.

We still do have an issue with synchronizing the user's NT IDs, but we're working on an automate solution there too.

Good luck to you!

theking75 - April 15, 2008 07:31 PM (GMT)
Do you mind sharing the scripts you used? I'm trying to do the same kind of thing. I am on a Windows Server running ADAM. I'm trying to use the ldfide command to export and import the information. On the import, I either get:

"Unwilling to Perform"

or

"Constraint Violation"

depending on how the data was exported. Any ideas what I'm doing wrong? Thanks.




Hosted for free by InvisionFree