SAP Knowledge Base Article - Public

3599931 - How to Mass Apply 'Job Posting Header and Footer Template' to Job Requisitions using Integration Center - Recruiting Management

Symptom

Mass apply the Job Posting Header and Footer Template to Job Requisitions using Integration Center.

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

Reproducing the Issue

  1. Create/update a header and footer template in 'Manage Job Posting Header and Footer'.
  2. Need to apply changes to existing job requisitions.

Resolution

** Before you proceed with any changes, we highly recommend that you run this test on your test environment first. Integration Center is a tool that have the potential to change configuration and information, which might cause malfunction on the environment and/or audit non conformities due to data change **

Recruiting OData API Permissions:

  • Recruiting Permissions > OData API Job Requisition Update

Steps:

1. Build a CSV (UTF-8) file containing the following columns (labels can be anything):

  1. JobReqID 
  2. isDraft boolean - Enter the value "true".
  3. templateHeaderFooter - Use this field to apply a template from 'Manage Job Posting Header and Footer'. Enter the exact template name.
  4. locale (for multi-language only) - Enter the locale code, e.g. "en_US". If the locale is not provided, the system will use the default language.

To update multiple languages for one single job requisition, prepare separate import files for different locales and run the integration separately.

IMPORTANT: If you save your file using Excel, the 'true' value will automatically be saved as 'TRUE'. This will not work as expected once you upload the file. As a workaround, you can either change the cell format to Text and make sure the 'true' value is in small letters; or edit the file using Notepad++ and change all the 'TRUE' values to 'true'. Save it again and use that file for the upload.

2. Upload the file to an FTP server (Name must not contain spaces).

3. Create an input integration to import the data.

  1. Go to Integration Center > My Integrations.
  2. Click Create and select Scheduled CSV Input Integration.
  3. Search for "JobRequisition" and select the entity.
  4. Click Select button.
  5. Go to Configure Fields tab. Click Upload Sample CSV to upload a sample file for mapping the data to fields.
    (You can upload the same import file but only the first 10 records will be picked in the sample data view.)
  6. Click the link icon to switch to Field Mapping View.
  7. Map the CSV columns to the destination fields by 'Drag and Drop'. Mapped fields will appear in Preview on the right side.


    We can also set isDraft=true as a fixed value for all rows. Here is how:
    1. Click the list icon to switch to Details View.
    2. Select isDraft on the left.
    3. Click the pin icon to set a Fixed Value.
    4. Set 'true' as the Default Value.


  8. Click the triangle icon to switch to File Import Test View.
  9. Click Run Preview Records to update job requisitions based on the sample data. Check if the job requisitions can be updated successfully.
    Note: This step will update the job requisitions and not just a 'Preview'.
  10. Go to Source Settings tab. Setup File Server Settings, File Name and Folder Settings of the import file.
  11. Go to Scheduling tab to configure the occurrence if this will be a scheduled job.
  12. Save and run the integration.

To directly update the Job Description Header and Footer without using a template, follow instructions for the jobReqLocale entity fields in the KBA 3508419.

See Also

KBA 2771951 - How to update Job Requisition fields using Integration Center - Recruiting Management

KBA 3508419 - How to Mass Create Job Requisitions using Integration Center - Recruiting Management

Keywords

RCM, INT, Job Requisition, Job Description, Job Posting, Header, Footer, Template, Mass Update, Bulk, OData API, intJobDescHeader, intJobDescFooter, extJobDescHeader, extJobDescFooter , KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM-JOB , Job Postings & Requisitions , How To

Product

SAP SuccessFactors Recruiting all versions