SAP Knowledge Base Article - Public

2582360 - Data Extraction Request - Candidate’s Resume and Cover Letters - Recruiting Management

Symptom

How to extract a candidate’s data (both resumes and cover letter's) from the system?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Recruiting Management

Resolution

Candidate’s attachments can be exported via Integration Center. There is now an Attachment outbound integration to download attachments to an SFTP location.

Important Notes:

  • Make sure Integration Center is set up
  • Below permissions are prerequisites to successfully extract data from Integration Center

RBP Customers:

  • Manage Permission Roles → Recruiting Permissions → OData API Candidate Export permission
  • Manage Permission Roles → Metadata Framework → Admin access to MDF OData API

Non-RBP Customers:

  • Set User Permissions → Administrative Privileges → Recruiting Permissions → OData API Candidate Export permission
  • Set User Permissions → Administrative Privileges → Metadata Framework → Admin access to MDF OData API

Steps to create an Attachment outbound integration:

  1. From admin center → Integration Center. Click on My Integrations

my_integrations.jpg

  1. Once on My Integrations page, select Create → More Integration types

ic.jpg

Then select: "Attachment" as per screenshot below

ic1.jpg

  1. You will then be direct to below screen. From here, select the starting entity (We are starting with Candidate and fetching the Resume). It would also be possible to select the entity "JobApplication" for information present in the candidate job application.

s3.jpg

  1. Enter the Integration name

s4.jpg

  1. Select Configure Fields tab. User needs to associate the content as well as the content type (Note: If we start with Attachments/Photo as the starting entity these content and content type is associated by default)

s5.jpg

6. Click on Associate Content button.

s6.jpg

7. Field Dialogue opens. Select Entity Tree View → Candidate → Resume → File content field in Resume entity

s7.jpg

  1. Next, select Associate Content type

s8.jpg

9. Field Dialogue opens. Select Entity Tree View → Candidate → Resume → Mime Type

s9.jpg

10. Now you can see the preview in the Configure Fields page provided the candidate has the resume (Note: Files with .docx extension are not shown on the preview. Engineering is still figuring a way out to display this)

The corresponding attachment can be downloaded using Download Content.

s10.jpg

11. Navigate to Filter and Sort Page if the user wants to filter for any specific Candidates. Click on the browse button which opens the same dialogue as step 6 or 7 to select the fields.

s11.jpg

12. Navigate to Destination Settings page to enter the SFTP details. Click on Calculated File name to provide a unique file name.

s12.jpg

13. In the Advanced Calculation Dialogue, Create a Calculation using the Associate field button beside the field (Ex: <CandidateID> concatenate/append <filename>). To be able to get the file extension at the end of each document being uploaded/downloaded, also add a ("Concatenate/Append" → More Field Options → Default Value "." → another "Concatenate/Append" > fileExtention From Attachment).

s13.jpg

14. Schedule the integration (if needed). Provide the frequency, start and End dates.

To run immediately go to step 13.

s14.jpg

15. Navigate to Review and Run page. Check the details. Save the integration and click on Run Now to run immediately. (Save and Click on Set Schedule to run at a specific scheduled time)

s15.jpg

16. Go to the specified folder in SFTP location once the job is complete to see the attachment. The job completion status can be seen by clicking the refresh button beside Last Run time field.

Once the job is completed a hyperlink is displayed which takes you to the Execution Manager showing the details of the job.

s16.jpg

If there are a huge number of attachments that needs to be extracted then we suggest to use filter and run the integration center job by batch. If there were multiple errors on different batch, please raise a written case via launchpad so that Product Support team can look into the error and can also proceed with the data extraction request.

Additionally, please note that you must configure one integration for each attachment type you wish to extract. In the example above, we configured the integration to extract candidate resumes, but if you need the candidate cover letter or another attachment, then a separate integration must be created.

See Also

2209164 - How to enable integration Center in SuccessFactors System? - SAP SucessFactors HXM Suite

Keywords

Recruiting, Data, Extraction, Download, Resume, Cover, Letter, Contract, Renew, Export, Attachment , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , How To

Product

SAP SuccessFactors Recruiting all versions