PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/19/2013 12:55 PM by  Dave Curtis
uploading to HR15.2
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Ronnie
Business Analyst
BMH
Veteran Member
(364 points)
Veteran Member
Posts:152


Send Message:

--
09/18/2013 8:06 AM
    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
    Business Analyst
    BMH
    Veteran Member
    (364 points)
    Veteran Member
    Posts:152


    Send Message:

    --
    09/18/2013 8:22 AM
    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
    Business Analyst
    BMH
    Veteran Member
    (364 points)
    Veteran Member
    Posts:152


    Send Message:

    --
    09/18/2013 8:51 AM
    It almost looks like I would need to do something like https://www.lawsonguru.com/Articles/View/tabid/346/ArticleId/434/default.aspx

    But does anyone know of an easier way??

    Ronnie
    Business Analyst
    BMH
    Veteran Member
    (364 points)
    Veteran Member
    Posts:152


    Send Message:

    --
    09/18/2013 10:04 AM
    Also wondering if this can be done through HR515 somehow? Sorry, I am not too familiar with uploading data into lawson.
    Ronnie
    Business Analyst
    BMH
    Veteran Member
    (364 points)
    Veteran Member
    Posts:152


    Send Message:

    --
    09/18/2013 11:27 AM

    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
    stephanie
    Veteran Member
    (922 points)
    Veteran Member
    Posts:330


    Send Message:

    --
    09/19/2013 4: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
    HRIS Lead
    University of Maryland Medical System
    Veteran Member
    (325 points)
    Veteran Member
    Posts:113


    Send Message:

    --
    09/19/2013 12: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.
    You are not authorized to post a reply.