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

 17 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Anya
New Member Send Private Message
Posts: 3
New Member
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
Veteran Member Send Private Message
Posts: 549
Veteran Member
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
Deleted User
New Member Send Private Message
Posts: 0
New Member
What about a script to convert HR records(additions & changes of employee records) from csv to xml?
arrobi
New Member Send Private Message
Posts: 1
New Member

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
Veteran Member Send Private Message
Posts: 129
Veteran Member
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
Send Private Message
Posts: 3
Is this the rmconvert.pl script used as part of the upgrade ? Or is it a different script altogether?
sped15
New Member Send Private Message
Posts: 2
New Member
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?
Deleted User
New Member Send Private Message
Posts: 0
New Member
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.
Deleted User
New Member Send Private Message
Posts: 0
New Member

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

Deleted User
New Member Send Private Message
Posts: 0
New Member
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
Veteran Member Send Private Message
Posts: 1498
Veteran Member
We never received such a script. Could you possibly post it?
Deleted User
New Member Send Private Message
Posts: 0
New Member
I can email it to you. We have moved past this and have started using ProcessFlow to create EMSS accounts.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Mail to: MoellerG@GenesisHealth.com Thanks much, -Greg
Randy Shekels
New Member Send Private Message
Posts: 3
New Member
Would you please send a copy of that script to me? rshekels@wmwd.com. Thank you very much, -Randy
Karen Sheridan
Veteran Member Send Private Message
Posts: 142
Veteran Member
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
Veteran Member Send Private Message
Posts: 104
Veteran Member
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
Veteran Member Send Private Message
Posts: 104
Veteran Member
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.
xxxxxttysfh
Veteran Member Send Private Message
Posts: 62
Veteran Member
can any one send script for me too please