Updating User fields through Ess

 14 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
MichelleW
Basic Member
Posts: 20
Basic Member

    Has anyone successfully done this?  We are lsf 9.0.05 portal and apps as well.  We would like to add cell phone and pager number, but are hoping that we can have the employees udate this information themselves.

     

    Shane Jones
    Veteran Member
    Posts: 460
    Veteran Member

      This should be easy but I think you will need a different ESS page for each of the User Fields...  I just think the AGS will be difficult (if not impossible) to create for two different user fields within one AGS.  

      I wonder if you could create an ESS to update the Additional Contacts numbers form.   Probably a better solution then using 2 of your 99 user fields.   (I am thinking it would not be that difficult to copy and modify the Certifications ESS to work with the additional contact numbers.)

       

      Shane Jones
      Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
      Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
      ** Teach others to fish...
      Gary Davies
      Veteran Member
      Posts: 248
      Veteran Member
        The only problem with adding User Fields is HR11 is not friendly for doing that, The easiest way to do this in the background would be to create a personnel action with these fields, and in your customization if these values change do an additional call PA52 for that action (with immediate).
        John Henley
        Posts: 3353
          For my clients, I provide a wrapper module ("DA15") that updates user fields using standard Lawson logic, but with a simple interface, i.e. company, employee, user field name, value, date, etc. that can be used from AGS calls, addins, etc.

          Thanks for using the LawsonGuru.com forums!
          John
          kdcoate
          Veteran Member
          Posts: 44
          Veteran Member
            We have a custom Design Studio page that updates a user field to populate a room location. Basically, on load the page executes a DME call to see if a value exists for the employee, holds the value and populates it on the form if it exists. When the employee submits the form, an 'OnBeforeTransaction' event is triggered to see if the value has changed, adds it via AGS call if it didn't exist before, or changes it via AGS call if it has changed. It's pretty staightforward. We also have a page that updates the cell phone - but we use the additional contact info (HRCONTNBR) to store that.
            Shane Jones
            Veteran Member
            Posts: 460
            Veteran Member
              KDCOATE,
              Any chance you would share your ESS page for updating the Cell Phone?
              Shane
              Shane Jones
              Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
              Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
              ** Teach others to fish...
              kdcoate
              Veteran Member
              Posts: 44
              Veteran Member
                Hi Shane,
                What's your e-mail address?
                LisaN
                Veteran Member
                Posts: 53
                Veteran Member
                  KDCOATE,
                  We are trying to update user fields also. Could you also share your DS page with us?
                  Thank you,
                  Lisa (Lisa.Noles@moffitt.org)
                  Shane Jones
                  Veteran Member
                  Posts: 460
                  Veteran Member
                    KDCOATE,
                    I would love to have a copy of the pages.... THANKS
                    sjones@johnsonbank.com

                    Shane Jones
                    Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
                    Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
                    ** Teach others to fish...
                    lpetroff
                    Basic Member
                    Posts: 15
                    Basic Member
                      We have different entry rules for benefit eligibility and the only way we are able to do this is through user fields. This sounds as though this is what we are looking for - for the employee to be able to populate the fields through a qualifying event. Am I understanding correctly that this can be done?
                      wilcoxmad
                      Veteran Member
                      Posts: 87
                      Veteran Member

                        I did as John suggested, wrote a simple Lawson program to do Maintenance on HREMPUSF table. I used Lawson's 4gl auto-paint tools using HREMPUSF as the table. I named the Program/form GH88. The user never sees this form. The form has the following fields:

                        HEU-COMPANY.

                        HEU-EMP-APP.

                        HEU-EMPLOYEE.

                        HEU-FIELD-KEY.

                        HEU-A-FIELD.

                        HEU-N-FIELD.

                        HEU-D-FIELD.

                        HEU-CURRENCY-CODE.

                        HEU-CURR-ND.

                        HEU-BASE-CURRENCY.

                        HEU-BASE-ND.

                        HEU-BASE-AMOUNT.

                        We do not use ESS but you could make the same type call from there as I did in my Design Studio form that we use for HR11. In it I call the GH88 program to update the userfield, which we use for Orientation date.

                        function callgh88()
                        {
                         //Convert Orientation Date, mm/dd/yyyy to yyyymmdd.
                         var orienDt = lawForm.getFormValue("text208");
                         vMonth = orienDt.substr(0,2);
                         vDay = orienDt.substr(3,2);
                         vYear = orienDt.substr(6,4);

                         vDate = vYear + vMonth + vDay;
                         //alert (vDate);
                         
                         //build string to use in call of GH88.1 (User Field Maintenance)
                         var s = top.AGSPath + "?_PDL=";
                        // s += top.lawsonPortal.getUserVariable("PRODLINE"); - This is the way to do it in 8.1            

                        s += portalWnd.oUserProfile.getAttribute("ProductLine");
                         s += "&_TKN=GH88.1&_EVT=ADD&LFN=ALL&TDS=IGNORE&FC=A";
                         s += "&HEU-COMPANY=" + lawForm.getFormValue("text1");
                         s += "&HEU-EMP-APP=0";
                         s += "&HEU-EMPLOYEE=" + lawForm.getFormValue("text2");
                         s += "&HEU-FIELD-KEY=94";
                         s += "&HEU-D-FIELD=" + vDate;
                         s += "&_OUT=XML&_EOT=TRUE";

                         //Send API to the server
                         portalWnd.httpRequest(s);

                        }

                        Joe O'Toole
                        Veteran Member
                        Posts: 314
                        Veteran Member
                          KDCOATE or Shane,
                          We are looking for a way to have employees enter their own cell phone and email address.
                          Would you mind sharing your ESS page that does this?
                          My email address is jjotoole@qchek.com
                          Thanks,
                          Joe
                          Joe O'Toole
                          Veteran Member
                          Posts: 314
                          Veteran Member
                            Thanks for the email Kathy.

                            Did everyone who implemented these new fields put them on a new DS screen or did you modify an existing ESS screen?
                            Jim C
                            New Member
                            Posts: 1
                            New Member
                              I am trying to update User Field through ESS also.  We are trying to create a W2 page that allows employees to print their own however we need to have an Opt In / Opt Out indicator due to IRS rules.  I wanted to use a user field for that.  I can't however get the AGS call to actually update.  I recieve a "Change Complete" but it doesn't acually update.  I am able to do it by using referencing a custom program that updates user fields but I also need to have HRHISTORY updated so that doesn/t work.  Could you please provide a copy of your ESS page that update User fields.

                              Any help would be greatly appreciated.

                              Mary Porter
                              Veteran Member
                              Posts: 337
                              Veteran Member
                                Jim C - what are you using to let them print their own W2? We thought the only way this was possible was by purchasing MHC software or something like it.