• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

ADAM export

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Joe O'Toole
Veteran Member Send Private Message
Posts: 314
Veteran Member
9/18/2008 9:33 PM

Has anyone found a utility that can dump selected data from Lawson ADAM to a flat file? Specifically, I need to export a record with userid, last name, first name and empno to do an integrity comparison to what we have sitting in AD. Thanks.

John Henley
Send Private Message
Posts: 3351
9/18/2008 10:53 PM
Well, there's a product called "ProcessFlow Integrator" that will do it in a heartbeat
You can also use Windows Scripting Host (WSH) combined with LDIFDE or CSVDE to parse their output.
Thanks for using the LawsonGuru.com forums!
John
Joe O'Toole
Veteran Member Send Private Message
Posts: 314
Veteran Member
9/19/2008 2:10 PM
Unfortunately, I'm not at liberty to buy Integrator for this one purpose. Am I correct in assuming that user id and empno are in different keys or does one exist that has both pieces of info?
John Henley
Send Private Message
Posts: 3351
9/19/2008 3:49 PM
Oh, I'm sure you'll find other applications for it... I'd look at CSVDE and the VB scripting approach to parse the CSV file. I've seen some examples and it looks pretty simple. You should be able to get the employee from dn: cn=_EMPLOYEE, ou=svcxref, o=lwsnSecData, CN=
Thanks for using the LawsonGuru.com forums!
John
Joe O'Toole
Veteran Member Send Private Message
Posts: 314
Veteran Member
9/19/2008 4:01 PM

Thanks John, we've got some VB wiz'es in house. I also just learned from a friend that SSOCONFIG can be used to dump the LDAP Employee key to an XML file.

RickyY
Veteran Member Send Private Message
Posts: 50
Veteran Member
6/2/2011 5:42 PM
Hi John,

We are in the same situation. Do you have a example of doing it ProcessFlowIntegrator? Thanks.