SAP Knowledge Base Article - Public

2458909 - Position Sync using Integration Center-Onboarding

Symptom

  • Position sync using integration center.

Environment

  • Applicable To All DataCenters.
  • Onboarding
  • EC

Resolution

  • Customers will be syncing position using integration center from EC-ONB.
  • Partners  should follow implementation guide to create a report using integration center.
  • With respect to onboarding, partners should create an separate position.xslt file. Create a requet for the file to be uploaded on the server side by our operations team.
  • This should be carried out using the partner portal.
  • Below are sample file of position.xslt file, foundation import and foundation import field mapping file :

Importposition.xslt file:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl" xmlns="http://online-onboarding.com/Users.xsd">
  <xsl:output method="xml" omit-xml-declaration="yes" indent="no"/>

  <xsl:param name="Action"/>
 
  <xsl:template match='/'>
    <Package xmlns="http://online-onboarding.com/Schemas/ReferenceFiles.xsd">
      <xsl:element name="Items">
        <xsl:attribute name="Action">
          <xsl:value-of select="$Action"/>
        </xsl:attribute>
        <xsl:attribute name="Class">Position</xsl:attribute>
        <xsl:apply-templates select="//csvline"/>
      </xsl:element>
    </Package>
  </xsl:template>

<xsl:template match='//csvline'>
    <Item>
      <xsl:choose>
        <xsl:when test="csvcolumn[@name='@OrgLevel@']=5">
          <xsl:element name='ClientID'>
              <xsl:value-of select="./csvcolumn[@name='@ClientID@']"/>
            </xsl:element>
          <xsl:element name='OrgLevel'>5</xsl:element>
          <xsl:element name='Name'>
              <xsl:value-of select="./csvcolumn[@name='@Name@']"/>
            </xsl:element>

        <xsl:element name='Properties' xmlns="http://online-onboarding.com/Schemas/ReferenceFiles.xsd">
          
           <xsl:element name='Property' xmlns="http://online-onboarding.com/Schemas/ReferenceFiles.xsd">
            <xsl:element name='Name'>DeptCode</xsl:element>
            <xsl:element name='Value'>
            <xsl:value-of select="./csvcolumn[@name='@DeptCode@']"/>
          </xsl:element>
        </xsl:element>

        <xsl:element name='Property' xmlns="http://online-onboarding.com/Schemas/ReferenceFiles.xsd">
            <xsl:element name='Name'>FTE</xsl:element>
            <xsl:element name='Value'>
            <xsl:value-of select="./csvcolumn[@name='@FTE@']"/>
          </xsl:element>
        </xsl:element>

        <xsl:element name='Property' xmlns="http://online-onboarding.com/Schemas/ReferenceFiles.xsd">
            <xsl:element name='Name'>Company</xsl:element>
            <xsl:element name='Value'>
            <xsl:value-of select="./csvcolumn[@name='@Company@']"/>
          </xsl:element>
        </xsl:element>
  
  </xsl:element>
    </xsl:when>
    <xsl:otherwise>
      <xsl:element name='ClientID'>
        <xsl:value-of select="./csvcolumn[@name = '@ClientID@']"/>
      </xsl:element>
       <xsl:element name='OrgLevel'>
        <xsl:choose>
        <xsl:when test="./csvcolumn[@name = '@OrgLevel@']=4">
          <xsl:text>4</xsl:text>
        </xsl:when>
      </xsl:choose>
      </xsl:element>
      <xsl:element name='Name'>
        <xsl:value-of select="./csvcolumn[@name = '@Name@']"/>
      </xsl:element>
   </xsl:otherwise>
 </xsl:choose>
    </Item>
  </xsl:template>
</xsl:stylesheet>

 Foundation Import:

 <FoundationImportConfiguration id="SuccessFactorsPosition">
        <ImportType>CorpStructure</ImportType>
        <FileMask>{AccountName}_Position*.csv</FileMask>
        <HasHeader>Yes</HasHeader>
        <Delimiter>,</Delimiter>
        <ImportXslt>ImportPosition.xslt</ImportXslt>
        <DataTable>
            <Field name="@ClientID@" type="String"/>
            <Field name="@Name@" type="String"/>
            <Field name="@DeptCode@" type="String"/>
            <Field name="@FTE@" type="String"/>
            <Field name="@Company@" type="String"/>
           
        </DataTable>
    </FoundationImportConfiguration>

 

Foundation import field mapping file:

<Import name="SuccessFactorsPosition">
  <Field key="@ClientID@" value="ClientID"/>
  <Field key="@OrgLevel@" value="OrgLevel"/>
  <Field key="@Name@" value="Name"/>
  <Field key="@Company@" value="Company"/>
  <Field key="@DeptCode@" value="Location"/>
  <Field key="@FTE@" value="FTE"/>
 </Import>

Keywords

  • Position sync
  • Integration center.
  • EC
  • Onboarding.
, KBA , LOD-SF-OBD-INT , Integrations with Onboarding , Problem

Product

SAP SuccessFactors Onboarding all versions