• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Employee/Company number changes

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
David Benayoun
Basic Member Send Private Message
Posts: 4
Basic Member
7/31/2009 1:33 PM
 Good morning all,

I am pretty new with the lawson environment and I am getting used to it. Now I have been given a task which there has to be an easier way to do.

We have a list of 454 employees whose employee and/or company numbers will be changing. As of right now the only safe way I know how to do this is manually doing it one at a time. So my question is if there is an easier and way faster way to do this.

This week I needed to get a list of portal users and just did an ldif export from ADAM so I was wondering if an import of the new infomation would also work?

Whatever information someone has I would appreciate it.

Thanks.
John Henley
Send Private Message
Posts: 3351
7/31/2009 2:12 PM
You can use loadusers with an XML file to re-populate their xxx_EMPLOYEE identity with the new company and employee.  Here's an article on using the loadusers utility: Converting LID/Portal Users for LSF9
Thanks for using the LawsonGuru.com forums!
John
David Benayoun
Basic Member Send Private Message
Posts: 4
Basic Member
7/31/2009 4:51 PM
Awesome thanks John. Now one more quick question, can i just load those changes or will I need to populate every field?
wintergreen
Veteran Member Send Private Message
Posts: 93
Veteran Member
7/31/2009 5:29 PM
There is a perl script that will convert the CSV file into the XML file which is needed for the lawson utility, loadusers.
David Benayoun
Basic Member Send Private Message
Posts: 4
Basic Member
7/31/2009 6:16 PM
I created an XML file and I cant see anything wrong with it but everytime i try and load it, it just fails am I doing something wrong? 

?xml version="1.0" encoding="ISO-8859-1"?>
XML>
IDENTITIES>
IDENTITY ID="bkey" SERVICE="dev9_Employee" COMPANY="2" EMPLOYEE="4343"/>
/IDENTITIES>
/XML>

There is < in front of all of them but i could not paste the exact code here as it would appear blank

loadusers -f a.xml
Errors Encountered. Please check the log file for further details
Jimmy Chiu
Veteran Member Send Private Message
Posts: 641
Veteran Member
8/23/2009 2:38 AM
Is that service "dev9_employee" loaded?