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:
- From admin center → Integration Center. Click on My Integrations
- Once on My Integrations page, select Create → More Integration types
Then select: "Attachment" as per screenshot below
- 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.
- Enter the Integration name
- 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)
6. Click on Associate Content button.
7. Field Dialogue opens. Select Entity Tree View → Candidate → Resume → File content field in Resume entity
- Next, select Associate Content type
9. Field Dialogue opens. Select Entity Tree View → Candidate → Resume → Mime Type
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.
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.
12. Navigate to Destination Settings page to enter the SFTP details. Click on Calculated File name to provide a unique file name.
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).
14. Schedule the integration (if needed). Provide the frequency, start and End dates.
To run immediately go to step 13.
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)
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.
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