ADAM export

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Joe O'Toole
Veteran Member
Posts: 314
Veteran Member

    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
    Posts: 3353
      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
        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
        Posts: 3353
          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

            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
              Hi John,

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