• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

uploading to HR15.2

 6 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Ronnie
Veteran Member Send Private Message
Posts: 152
Veteran Member
9/18/2013 12:06 PM
I have a spreadsheet my HR department has given me that has
column A (company number) found in PA02
col B (pos number) found in PA02
col C (effect date) found in PA02
col D (pos desc) found in PA02
col E (add flag) need add in HR15.2
col F (badge title) need add in HR15.2
col G (badge title desc) defined in PA04.5

So the only things i need to do is really use column E and F for the upload, but need the other columns so that the spreadsheet can determine what position gets what badge title I need to add.

I tried to just do an add so that anything that is already entered into Lawson will just bypass. I ran this and it said add completed, but then I go to HR15.2 and the badge title I am needing to add with column F is still blank.

Here are examples of what I am using...





Ronnie
Veteran Member Send Private Message
Posts: 152
Veteran Member
9/18/2013 12:22 PM
BTW. PA02 references HR15.2 (that I am needing to update) with a "User Fields" button at the bottom of PA02. You click user fields and it goes to HR15.2 where I am needing to upload the badge titles.

Ronnie
Veteran Member Send Private Message
Posts: 152
Veteran Member
9/18/2013 12:51 PM
It almost looks like I would need to do something like https://www.lawsonguru.co...eId/434/default.aspx

But does anyone know of an easier way??

Ronnie
Veteran Member Send Private Message
Posts: 152
Veteran Member
9/18/2013 2:04 PM
Also wondering if this can be done through HR515 somehow? Sorry, I am not too familiar with uploading data into lawson.
Ronnie
Veteran Member Send Private Message
Posts: 152
Veteran Member
9/18/2013 3:27 PM

Lawson Support gave me a nice little template. I have filled it out in with the info I needed and also used the OBJ-ID they mention in their template. I run the upload. Says add-complete. I go and look and nothing has changed nor been added.

Here is their template:

Attachments
Deleted User
New Member Send Private Message
Posts: 0
New Member
9/19/2013 8:29 AM
Not sure if this is helpful to you, but here's another HR15.2 template (we don't use position user fields, so I can't comment how well this particular template works).  Good luck!
Dave Curtis
Veteran Member Send Private Message
Posts: 136
Veteran Member
9/19/2013 4:55 PM
Uploading the user fields is dependent on using the field keys. If you have the option of using a conversion file instead, you may find that easier. It can be done on the conversion file.