Skip to Content
Technical Articles
Author's profile photo Sushil Maurya
Sushil Maurya
November 9, 2019 2 minute read

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.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sushil Maurya
      Sushil Maurya
      Blog Post Author

      Hi Team,

      We have more information to be shared on Employee Profile Picture -

      1. You can now batch export Employee Profile photos by scheduling a Batch Export Employee Photos job in Provisioning (If you don't have access of provisioning, please connect with SAP support team).
      2. ORD reports can also be used for the same.

      Best Regards,
      Sushil Maurya

      Author's profile photo Umesh Chaudhari
      Umesh Chaudhari

      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.

      • 2220377 - Batch Upload of Employee Photos – SFTP Import - SuccessFactors Employee Profile
      • 2094242 - Photos: How to Upload and Edit Live Profile Photos (Personal Information) Single Upload, URL Import & Batch FTP Import - Employee Profile

      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.

       

       

      Author's profile photo Sushil Maurya
      Sushil Maurya
      Blog Post Author

      Hi Umesh,

      Sorry for delay in response.

      As per SAP best practices, below are the dimension that needs to be followed –

      Photo Files Specifications

      • Maximum 2MB size
      • JPEG format
      • Recommended dimensions (pixels)
        • Width: 180
        • Height: 240
      • Filename should not have spaces, example: FirstName_LastName.jpg
      • There should be one file for each photo

      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