PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/12/2015 2:36 PM by  xxxxxttysfh
ldusers.pl - script to convert .csv file into .xml file for loadusers
 17 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Anya
Private
Private
New Member
(5 points)
New Member
Posts:3


Send Message:

--
12/18/2008 7:44 AM
    Hello! We've been given (by Lawson consultant, who no longer works with us) a Perl script to convert .csv file into .xml file to mass-load users into ADAM with loadusers routine. It worked fine on 9.0.2 platform, but on 9.0.3 one, the loadusers chocked because it seems like one of the field names changed - from "Firstname" to "FirstName". It's no big deal to tweak the Perl script, but I was wondering if there was a place this script is maintained and can be downloaded from?
    Thanks!
    Roger French
    Private
    Private
    Veteran Member
    (1266 points)
    Veteran Member
    Posts:522


    Send Message:

    --
    12/26/2008 10:26 AM
    If you still have and are using the script, it should be located somewhere on your Lawson application server.

    I have used many variations on the script itself. Contact me offline if you'd like to discuss.
    Thanks,
    Roger

    rfrench5@gmail.com
    dgims
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    01/28/2009 11:11 AM
    What about a script to convert HR records(additions & changes of employee records) from csv to xml?
    arrobi
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    05/22/2009 8:20 AM

    I'm new to Lawson - but I now have the task of adding and deleting users.  We are using lsf 9.0 w/o PF Integrator .  So I am looking for the process (sql & unix scripts) to add or remove ESS users using the loaduser utility.

    Whatever you have is more than what I have.  arrobi@us.crawco.com

    JudeBac
    Private
    Private
    Veteran Member
    (304 points)
    Veteran Member
    Posts:118


    Send Message:

    --
    05/26/2009 11:59 AM
    Hi all, just curious. Is there a difference between the ldusers.pl that converts csv file to xml and using a third part XML converter instead?
    Jeff Craton
    Private
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    06/05/2009 7:53 AM
    Is this the rmconvert.pl script used as part of the upgrade ? Or is it a different script altogether?
    sped15
    Sr. System Analysst
    Devon Enerty
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    01/12/2010 1:52 PM
    I would be very interested in obtaining a copy of the .pl script to load users. Currently we are doing it by hand and would love to find another (better) solution. If someone has this could you let me know and email it to me?

    Frank Z
    Advanced Member
    (82 points)
    Advanced Member
    Posts:32


    Send Message:

    --
    01/14/2010 3:12 PM
    I am using the one updated in April 2007, and after running there is no xml file created. Has anyone else run into this issue? I used the template to ensure that the correct info is in the correct sopt. Removed the headers, etc.. Still no success.
    JeffL
    Advanced Member
    (50 points)
    Advanced Member
    Posts:20


    Send Message:

    --
    02/11/2010 10:01 AM

    Lawson should have delivered the ldusers.pl script when LSF9 was installed. If you're still doing this manually, let me know. Lawson has provided some decent documentation as well, see: Lawson Administration: Resources and Security

    Frank Z
    Advanced Member
    (82 points)
    Advanced Member
    Posts:32


    Send Message:

    --
    02/11/2010 10:23 AM
    Jeff-

    They did provide the script to us, but I had to do a fair bit of rewriting to get it to work. Now I can't imagine doing it any other way.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    05/07/2010 12:39 PM
    We never received such a script. Could you possibly post it?
    Frank Z
    Advanced Member
    (82 points)
    Advanced Member
    Posts:32


    Send Message:

    --
    05/07/2010 12:46 PM
    I can email it to you. We have moved past this and have started using ProcessFlow to create EMSS accounts.
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    05/07/2010 4:45 PM
    Mail to: MoellerG@GenesisHealth.com

    Thanks much,
    -Greg
    Randy Shekels
    Private
    Private
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    05/17/2010 1:45 PM
    Would you please send a copy of that script to me? rshekels@wmwd.com.

    Thank you very much,
    -Randy
    Karen Sheridan
    Private
    Private
    Veteran Member
    (325 points)
    Veteran Member
    Posts:123


    Send Message:

    --
    06/07/2010 10:27 AM
    This is a question specific to loadusers itself. The documentation says that the SSO password cannot be loaded. That it defaults to the SSO user id. Is that still accurate?

    I have found that the documentation doesn't always keep up with modifications to the utilities. The documentation says on Unix you must use the Lawson user id to run loadusers. Through as CASE session we were told that is not the case, as long as the user attempting to run the utility has security access.

    TIA,
    Karen
    Brian Allen
    Private
    Private
    Veteran Member
    (276 points)
    Veteran Member
    Posts:94


    Send Message:

    --
    06/08/2010 12:42 PM
    Hi Karen -

    The password can be included in the loaduser script. That's the route we took when we initially loaded our users back when we were running version 9.0.0.4.

    I believe that any user with the appropriate security can run the loaduser utility, but only the lawson user has this by default. I have just been using the lawson user until I setup new Lawson Security classes for our admin users. We have about 80% of our users live on Lawson Security at this point.

    Brian
    Brian Allen
    Private
    Private
    Veteran Member
    (276 points)
    Veteran Member
    Posts:94


    Send Message:

    --
    06/08/2010 12:47 PM
    Just to clarify, that's a password in the file with each user entry.

    Something like the following. The environment password was not needed for our UNIX environment.

    <IDENTITY SERVICENAME="SSOP">
    <RDID><![CDATA[aesimpso]]></RDID>
    <user><![CDATA[aesimpso]]></user>
    <password><![CDATA[XJ53Y29]]></password>
    </IDENTITY>
    <IDENTITY SERVICENAME="prod9">
    <RDID><![CDATA[aesimpso]]></RDID>
    <login><![CDATA[aesimpso]]></login>
    <password><![CDATA[password]]></password>
    </IDENTITY>
    xxxxxttysfh
    System admin
    Independent
    Veteran Member
    (127 points)
    Veteran Member
    Posts:61


    Send Message:

    --
    08/12/2015 2:36 PM
    can any one send script for me too please
    You are not authorized to post a reply.