Technical Articles
SAP SuccessFactors Employee Profile Photo Report Extract via Integration Center
Now a days multiple customer raise a request to SAP regarding a report on Employee Profile Photo and as per the blog #2397776 its not feasible as of now.
We have a simple solution to achieve this via Integration Center without any custom coding. In this blog will we see the detailed steps to generate the report.
Symptom
- Not able to generate a report on Photo from employees on the instance.
- Is there a report for which employees have Photos on their profile?
- Employees who have Photo and who don’t have Photo on employee profile.
Environment
- SAP SuccessFactors – Employee Profile
- SAP SuccessFactors Workforce Analytics
- Adhoc reporting
- Online report Designer
- Advanced reporting
Resolution
Please refer the below steps to generate the report.
Prerequisite before generating the report:
- Understanding of Integration Center
- SFTP credential
Step 1 : SAP SuccessFactors Integration Center
As we know Integration Center is a marvellous tool for creating file base integration and generation OData Api.
Login to SAP Successfactors Bizx Suite and navigate to Admin Center. Click on “Company Setting” under Company Processes & Cycles and click on “Integration Center“.
Note: If you are not able to find integration center then check permissions.
Step 2 : Report Creation
Under Integration Center select “My Integration“.
Click on Create and select “Scheduled Simple File Output Integration” this will schedule the report on SFTP.
Under “Search for Entities by Entities Name” search for keyword “Photo” and select Photo as highlighted in below screenshot.
Step 3 : Select “userId” & “photoId” as shown in the below screenshot. This will generate the give the list of users from whom the profile photo is uploaded.
Step 4 : Provide the file name, if required select filter and navigate to Destination Settings.
Under Destination Settings provide the below details –
- SFTP User Name & SFTP Password
Ignore the remaining fields because its optional
Under File Name & Folder Settings
- Date Suffix Format: None
- File Extension: csv
-
Step 5 : Click Next button and under Scheduling select the frequency of report as per business requirement.
Select the Start Time i.e to schedule job
Email To: To get notified
Click on Next.
Step 6 : Under Review and Run you can Set Scheduler or Run Now.
Job Progress can be seen under Last Run Time refer the below screenshot.
Soon we will also be writing the blog on PPTC in detailed #SAP SuccessFactors.
Hi Team,
We have more information to be shared on Employee Profile Picture -
Best Regards,
Sushil Maurya
Hi Sushil,
Really a useful blog. I have one question related to upload of the photos, while we already have below KBAs to upload photos, but there is nothing to validate the photo size, format, dimension, could you please let me know if there is any solution available here.
Some of the customers have requirements to validate the photo size, formats, dimensions not only for SuccessFactors but also for using these photos while printing the Employee ID card.
Please suggest if there is any feature in SuccessFactors with which we can achieve this requirement.
Regards,
Umesh Chaudhari.
Hi Umesh,
Sorry for delay in response.
As per SAP best practices, below are the dimension that needs to be followed –
Photo Files Specifications
NOTE: But when we deploy the batch file report we can still see large size images are getting successfully processed. As per my knowledge we cannot validated the image size as of now.
Best Regards,
Sushil