ldusers.pl - script to convert .csv file into .xml file for loadusers

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

What about a script to convert HR records(additions & changes of employee records) from csv to xml?

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

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?

Is this the rmconvert.pl script used as part of the upgrade ? Or is it a different script altogether?

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?

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.

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

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.

We never received such a script. Could you possibly post it?

I can email it to you. We have moved past this and have started using ProcessFlow to create EMSS accounts.

Mail to: MoellerG@GenesisHealth.com

Thanks much,
-Greg

Would you please send a copy of that script to me? rshekels@wmwd.com.

Thank you very much,
-Randy

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

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

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>

can any one send script for me too please