Attaching Employee Pictures using Process Automation -

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

DanB

Basic Member

Posts: 7

9/24/2014 6: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

New Member

Posts: 1

9/26/2014 8:17 PM

how about using LSD?

Tags: LPA IPA Talent Management

Woozy

Veteran Member

Posts: 709

9/29/2014 1:24 PM

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

Attachments

Load_Binary_Files_into_Landmark.pdf

Tags: LPA IPA Talent Management

DanB

Basic Member

Posts: 7

9/30/2014 12:00 PM

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

Tags: LPA IPA Talent Management

Chris

Advanced Member

Posts: 20

4/7/2016 4: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

Tags: LPA IPA Talent Management

JimY

Veteran Member

Posts: 510

4/8/2016 10:05 AM

I am curious also. It would be nice if there is a way to do it through IPA.

Tags: LPA IPA Talent Management

Shane Jones

Veteran Member

Posts: 460

4/14/2016 12:10 PM

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....

Tags: LPA IPA Talent Management

blmackey

Basic Member

Posts: 6

8/26/2016 5: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

Tags: LPA IPA Talent Management

Joan Herzfeldt

Veteran Member

Posts: 74

8/29/2016 12:09 PM

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

Tags: LPA IPA Talent Management

Chris

Advanced Member

Posts: 20

10/28/2016 5: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...

Tags: LPA IPA Talent Management

Chris

Advanced Member

Posts: 20

10/28/2016 7: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.

Tags: LPA IPA Talent Management

Vlad Alcasid

New Member

Posts: 3

6/3/2021 1:55 AM

Hi everyone,

I would like to ask if anyone has tried Mass Update/Upload of Resource Profile Picture? Thanks in advance.

Tags: LPA IPA Talent Management