Prev
Next
Forums S3 Systems Administration

ADAM export

Sort:
You are not authorized to post a reply.
Author
Messages
Joe O'Toole
Veteran Member
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
    Senior Member
    Posts: 3348
    Senior Member
    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
      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
        Senior Member
        Posts: 3348
        Senior Member
        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
          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
            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.

              You are not authorized to post a reply.