PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/02/2021 9:55 PM by  Vlad Alcasid
Attaching Employee Pictures using Process Automation
 11 Replies
Sort:
You are not authorized to post a reply.
Author Messages
DanB
Private
Private
Basic Member
(13 points)
Basic Member
Posts:5


Send Message:

--
09/24/2014 2:50 PM
    We currently have employee pictures in jpg format stored in a file system directory that are created by our employee badge system.  I am attempting to attach these picture to the employees in Talent Management using the Landmark node in Process Automation.  Here is the Landmark transaction string I am using.
    _dataArea="ltmtest" & _module="hr" & _objectName="Employee" & _actionName="Update" & _actionOperator="NONE" & _actionType="CreateUpdateDelete" & _pageSize="30" & _effectiveDate="20140924" & Employee="5285" & HROrganization="1000" & ResourcePicture.File="\\\\GCSLLMK01\\crsref\\Picture166296.jpg" & ResourcePicture.Title="Picture166296.jpg" & ResourcePicture.MimeType="image/jpeg"

    The flow runs with no errors but the picture is not displayed in the rich canvas.  When I click on the picture icon and select open a text file is opened that display the full path of the ResourcePicutre.File in the transaction string above.  

    I can add a picture when the employee is created through the rich canvas and the picture is displayed as expected.  Has anyone been successful attaching pictures using Process Automation?  We have over 9000 employee pictures so attaching manually is not an option.

    Thanks!
    Tags: LPA IPA Talent Management
    Shang Lin
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    09/26/2014 4:17 PM
    how about using LSD?
    Woozy
    Private
    Private
    Veteran Member
    (3493 points)
    Veteran Member
    Posts:709


    Send Message:

    --
    09/29/2014 9:24 AM
    Hi Dan,

    Unfortunately, I don't think it will work the way your are trying to do it.  The "ResourcePicture.File" field is actually a CLOB field that holds the binary picture data, rather than a referance to an external image file.  The images actually have to be uploaded into that field as binary data using the delivered 'dbupdatelobs' command.

    I've attached a document we put together for doing mass uploads of Employee Photos (or other binary data, such as Office documents).  I'm guessing you should be able to adapt this to what you are doing.  The csv file name must be the name of the business class you are uploading to.  I imagine the images could be on a remote server, as long as they are accessible from the Landmark server, but I haven't tried this.

    Note that we are on a UNIX server, and some of these commands are specific to our environment - basically, this stuff needs to be done as a user with full rights - "lawson" being the safest.

    Because the images are stored in the database, file size is a concern.  Appropriate image resizing prior to upload is pretty important.

    Good Luck!  It would be great to hear what solution you ended up with.

    Kelly

    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Attachments
    DanB
    Private
    Private
    Basic Member
    (13 points)
    Basic Member
    Posts:5


    Send Message:

    --
    09/30/2014 8:00 AM
    Kelly,
    Thanks for the info.  I'll take a look at what you posted and see what I can do.  I'll post back my results either way.

    Dan
    Chris
    Analyst
    UCHealth
    Advanced Member
    (56 points)
    Advanced Member
    Posts:20


    Send Message:

    --
    04/07/2016 12:31 PM
    Were you ever able to load your files via processflow? I know its an old thread, but I was hoping you found your solution. I am in a similar situation. I like Kelly's approach but have not played with the load program yet. Do you recall what you ended up doing? Many thanks - Chris
    JimY
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    04/08/2016 6:05 AM
    I am curious also. It would be nice if there is a way to do it through IPA.
    Shane Jones
    Private
    Private
    Veteran Member
    (1246 points)
    Veteran Member
    Posts:460


    Send Message:

    --
    04/14/2016 8:10 AM
    I am doing the picture load with ipa for ess/mss....(S3) However that just needs a specific file name saved in a specific folder....
    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...
    blmackey
    Sr. Computer Programmer/Analyst
    Private
    Basic Member
    (14 points)
    Basic Member
    Posts:6


    Send Message:

    --
    08/26/2016 1:50 PM

    This thread is a starting to age nicely, but I'd like to add that we're automating the upload of photos into Talent Management using IPA.

    We use Woozy's method referenced in this thread in a Windows environment.

    Essentially, we use IPA to kick off a PowerShell script that creates the required Employee.csv file.
    The process then runs a System Command to upload the photos using the dbupdatelobs command.
    Once that finishes, another PowerShell script is called to clean out the directory and archive the photos and Employee.csv file for a few days.

    I'd be happy to walk anyone through the specifics.
    -Bryant
    Joan Herzfeldt
    Private
    Private
    Veteran Member
    (186 points)
    Veteran Member
    Posts:74


    Send Message:

    --
    08/29/2016 8:09 AM

    Hi Bryant - This is on our list but has not been implemented yet.  Slightly off topic.  We had a PowerShell training class, but I haven't used it enough and have probably forgotten more then I learned ;-)  Would you be willing to share your PowerShell scripts?  It would be nice to have an example of something that works.

    Thanks - Joan

    Chris
    Analyst
    UCHealth
    Advanced Member
    (56 points)
    Advanced Member
    Posts:20


    Send Message:

    --
    10/28/2016 1:58 PM
    I am still trying to do this with IPA - I won't give up!!! had anyone had success doing it purely in IPA with LndMrk Trx nodes? I like Bryant's approach too. I just came back from Infor TechEd and asked them there if it could be done. Sadly, no one has been able to make it work with just IPA...
    Chris
    Analyst
    UCHealth
    Advanced Member
    (56 points)
    Advanced Member
    Posts:20


    Send Message:

    --
    10/28/2016 3:33 PM
      
     I tried using Kelly's approach (Woozy) for loading a PDF to the EmployeeDocument and it says it completed successfully, but there is no file to be seen in the Rich Client or the data base. Here is what I did:
    1. Made a .csv file called "EmployeeDocument.csv".
    2. In this file, I created 4 columns and one record, like so:

    HROrganization,Employee,SequenceNumber,DocumentFile.File
    7000,12345,1,D:/LMKProd/interfaces/LOADDOCS/12345.pdf

    3. In the path listed is the pdf file as well as the master csv.
    4. I ran the utility and no errors, but also, no file.


    Vlad Alcasid
    BA
    Private
    New Member
    (5 points)
    New Member
    Posts:3


    Send Message:

    --
    06/02/2021 9:55 PM
    Hi everyone,

    I would like to ask if anyone has tried Mass Update/Upload of Resource Profile Picture? Thanks in advance.
    You are not authorized to post a reply.