Product DocsMenu

Salesforce Mapping File Example for Knowledge Base

When your Salesforce organization includes Knowledge Base articles and you want to index their content, you must include additional mappings for Knowledge content types.

The mapping file example presented in this topic maps two arbitrary named Knowledge Base objects:

  • MyKBArticleType1

  • MyKBArticleType2

CES 7.0.7104+ (October 2014)

<?xml version="1.0" encoding="UTF-8"?>
<Mappings>
    <Version>1</Version>
    <CommonMapping>
        <Fields>
            <Field name="sourcetype">Salesforce</Field>
            <Field name="SfChannelsFlagMerged">Internal App:%[kav_IsVisibleInApp];Customer Portal:%[kav_IsVisibleInCsp];Public Knowledge Base:%[kav_IsVisibleInPkb];Partner Portal:%[kav_IsVisibleInPrm];</Field>
            <Field name="SfOrganizationId">%[coveo_organization_id]</Field>
            <Field name="sysauthor">%[kav_CreatedBy.Name]</Field>
            <Field name="sysdate">%[kav_LastPublishedDate]</Field>
            <Field name="sysSfId">%[ka_id]</Field>
            <Field name="SfId">%[ka_id]</Field>
            <Field name="SfKbId">%[ka_id]</Field>
            <Field name="KbId">%[ka_id]</Field>
            <Field name="SfCreatedDate">%[kav_LastPublishedDate]</Field>
            <Field name="SfCreatedBy">%[ka_CreatedBy.Name]</Field>
            <Field name="SfCreatedById">%[ka_CreatedBy.Id]</Field>
            <Field name="SfIsDeleted">%[kav_IsDeleted]</Field>
            <Field name="SfParticipantId">%[ka_CreatedBy.Id];%[kav_LastModifiedBy.Id];</Field>
            <Field name="SfParticipantName">%[CreatedBy.Name];%[kav_LastModifiedBy.Name];</Field>
        </Fields>
    </CommonMapping>
    <Mapping type="MyKBArticleType1">
        <Title>%[kav_Title]</Title>
        <Body>%[kav_Summary]</Body>
        <Fields>
            <Field name="objecttype">MyKBArticleType1</Field>
            <Field name="objecttypename">My KB Article Type1</Field>
            <Field name="sfinterfaceid">kb</Field>
            <Field name="SfCaseId">%[ka_CaseArticles.CaseId]</Field>
            <Field name="SfCreatedByName">%[kav_CreatedBy.Name]</Field>
            <Field name="SfKbArchivedDate">%[ka_ArchivedDate]</Field>
            <Field name="SfKbArchivedDatefq">%[ka_ArchivedDate_fiscalquarter]</Field>
            <Field name="SfKbArchivedDatefy">%[ka_ArchivedDate_fiscalyear]</Field>
            <Field name="SfKbArticleNumber">%[kav_ArticleNumber]</Field>
            <Field name="SfKbCaseAssociationCount">%[ka_CaseAssociationCount]</Field>
            <Field name="SfKbFirstPublishedDate">%[kav_FirstPublishedDate]</Field>
            <Field name="SfKbFirstPublishedDatefq">%[kav_FirstPublishedDate_fiscalquarter]</Field>
            <Field name="SfKbFirstPublishedDatefy">%[kav_FirstPublishedDate_fiscalyear]</Field>
            <Field name="SfKbIsLatestVersion">%[kav_IsLatestVersion]</Field>
            <Field name="SfKbIsVisibleInApp">%[kav_IsVisibleInApp]</Field>
            <Field name="SfKbIsVisibleInCsp">%[kav_IsVisibleInCsp]</Field>
            <Field name="SfKbIsVisibleInPkb">%[kav_IsVisibleInPkb]</Field>
            <Field name="SfKbIsVisibleInPrm">%[kav_IsVisibleInPrm]</Field>
            <Field name="SfKbLastPublishedDate">%[kav_LastPublishedDate]</Field>
            <Field name="SfKbLastPublishedDatefq">%[kav_LastPublishedDate_fiscalquarter]</Field>
            <Field name="SfKbLastPublishedDatefy">%[kav_LastPublishedDate_fiscalyear]</Field>
            <Field name="SfKbPublishStatus">%[kav_PublishStatus]</Field>
            <Field name="SfKbSummary">%[kav_Summary]</Field>
            <Field name="SfKbTitle">%[kav_Title]</Field>
            <Field name="SfKbUndecipherableContentC">%[kav_Undecipherable_Content__c]</Field>
            <Field name="SfKbUrlName">%[kav_UrlName]</Field>
            <Field name="SfKbVersionNumber">%[kav_VersionNumber]</Field>
            <Field name="SfLanguage">%[kav_Language]</Field>
            <Field name="SfLastModifiedById">%[kav_LastModifiedBy.Id]</Field>
            <Field name="SfLastModifiedByName">%[kav_LastModifiedBy.Name]</Field>
            <Field name="SfLastModifiedDate">%[kav_LastModifiedDate]</Field>
            <Field name="SfLastModifiedDatefq">%[kav_LastModifiedDate_fiscalquarter]</Field>
            <Field name="SfLastModifiedDatefy">%[kav_LastModifiedDate_fiscalyear]</Field>
            <Field name="SfSystemModstamp">%[kav_SystemModstamp]</Field>
            <Field name="SfSystemModstampfq">%[kav_SystemModstamp_fiscalquarter]</Field>
            <Field name="SfSystemModstampfy">%[kav_SystemModstamp_fiscalyear]</Field>
            <Field name="sysfiletype">SalesforceItem</Field>
        </Fields>
    </Mapping>
    <Mapping type="MyKBArticleType2">
        <Title>%[kav_Title]</Title>
        <Body>%[kav_Summary]</Body>
        <Fields>
            <Field name="objecttype">MyKBArticleType2</Field>
            <Field name="objecttypename">My KB Article Type2</Field>
            <Field name="sfinterfaceid">kb</Field>
            <Field name="SfCaseId">%[ka_CaseArticles.CaseId]</Field>
            <Field name="SfCreatedByName">%[kav_CreatedBy.Name]</Field>
            <Field name="SfKbArchivedDate">%[ka_ArchivedDate]</Field>
            <Field name="SfKbArchivedDatefq">%[ka_ArchivedDate_fiscalquarter]</Field>
            <Field name="SfKbArchivedDatefy">%[ka_ArchivedDate_fiscalyear]</Field>
            <Field name="SfKbArticleNumber">%[kav_ArticleNumber]</Field>
            <Field name="SfKbCaseAssociationCount">%[ka_CaseAssociationCount]</Field>
            <Field name="SfKbFirstPublishedDate">%[kav_FirstPublishedDate]</Field>
            <Field name="SfKbFirstPublishedDatefq">%[kav_FirstPublishedDate_fiscalquarter]</Field>
            <Field name="SfKbFirstPublishedDatefy">%[kav_FirstPublishedDate_fiscalyear]</Field>
            <Field name="SfKbIsLatestVersion">%[kav_IsLatestVersion]</Field>
            <Field name="SfKbIsVisibleInApp">%[kav_IsVisibleInApp]</Field>
            <Field name="SfKbIsVisibleInCsp">%[kav_IsVisibleInCsp]</Field>
            <Field name="SfKbIsVisibleInPkb">%[kav_IsVisibleInPkb]</Field>
            <Field name="SfKbIsVisibleInPrm">%[kav_IsVisibleInPrm]</Field>
            <Field name="SfKbLastPublishedDate">%[kav_LastPublishedDate]</Field>
            <Field name="SfKbLastPublishedDatefq">%[kav_LastPublishedDate_fiscalquarter]</Field>
            <Field name="SfKbLastPublishedDatefy">%[kav_LastPublishedDate_fiscalyear]</Field>
            <Field name="SfKbPublishStatus">%[kav_PublishStatus]</Field>
            <Field name="SfKbRecipeC">%[kav_Recipe__c]</Field>
            <Field name="SfKbSummary">%[kav_Summary]</Field>
            <Field name="SfKbTitle">%[kav_Title]</Field>
            <Field name="SfKbUrlName">%[kav_UrlName]</Field>
            <Field name="SfKbVersionNumber">%[kav_VersionNumber]</Field>
            <Field name="SfLanguage">%[kav_Language]</Field>
            <Field name="SfLastModifiedById">%[kav_LastModifiedBy.Id]</Field>
            <Field name="SfLastModifiedByName">%[kav_LastModifiedBy.Name]</Field>
            <Field name="SfLastModifiedDate">%[kav_LastModifiedDate]</Field>
            <Field name="SfLastModifiedDatefq">%[kav_LastModifiedDate_fiscalquarter]</Field>
            <Field name="SfLastModifiedDatefy">%[kav_LastModifiedDate_fiscalyear]</Field>
            <Field name="SfSystemModstamp">%[kav_SystemModstamp]</Field>
            <Field name="SfSystemModstampfq">%[kav_SystemModstamp_fiscalquarter]</Field>
            <Field name="SfSystemModstampfy">%[kav_SystemModstamp_fiscalyear]</Field>
            <Field name="sysfiletype">SalesforceItem</Field>
        </Fields>
    </Mapping>
</Mappings>  

CES 7.0.7022– (September 2014)

<?xml version="1.0" encoding="UTF-8" ?>
<Salesforce>
  <CommonMapping>
    <Fields>
      <ContentType>binarydata</ContentType>
      <ModifiedDate>%[LastModifiedDate]</ModifiedDate>
      <CustomFields>
        <CustomField name="sourcetype">Salesforce</CustomField>
        <CustomField name="SfChannelsFlagMerged">Internal App:%[kav_IsVisibleInApp];Customer Portal:%[kav_IsVisibleInCsp];Public Knowledge Base:%[kav_IsVisibleInPkb];Partner Portal:%[kav_IsVisibleInPrm];</CustomField>
        <CustomField name="SfOrganizationId">%[coveo_organization_id]</CustomField>
        <CustomField name="sysauthor">%[kav_CreatedBy.Name]</CustomField>
        <CustomField name="sysdate">%[kav_LastPublishedDate]</CustomField>
        <CustomField name="sysSfId">%[ka_id]</CustomField>
        <CustomField name="SfId">%[ka_id]</CustomField>
        <CustomField name="SfKbId">%[ka_id]</CustomField>
        <CustomField name="KbId">%[ka_id]</CustomField>
        <CustomField name="SfCreatedDate">%[kav_LastPublishedDate]</CustomField>
        <CustomField name="SfCreatedBy">%[ka_CreatedBy.Name]</CustomField>
        <CustomField name="SfCreatedById">%[ka_CreatedBy.Id]</CustomField>
        <CustomField name="SfIsDeleted">%[kav_IsDeleted]</CustomField>
        <CustomField name="SfParticipantId">%[ka_CreatedBy.Id];%[kav_LastModifiedBy.Id];</CustomField>
        <CustomField name="SfParticipantName">%[CreatedBy.Name];%[kav_LastModifiedBy.Name];</CustomField>
      </CustomFields>
    </Fields>
  </CommonMapping>
  <Mapping type="MyKBArticleType1">
    <Fields>
      <Title>%[kav_Title]</Title>
      <Body>%[kav_Summary]</Body>
      <CustomFields>
        <CustomField name="objecttype">MyKBArticleType1</CustomField>
        <CustomField name="objecttypename">My KB Article Type1</CustomField>
        <CustomField name="sfinterfaceid">kb</CustomField>
        <CustomField name="SfCaseId">%[ka_CaseArticles.CaseId]</CustomField>
        <CustomField name="SfCreatedByName">%[kav_CreatedBy.Name]</CustomField>
        <CustomField name="SfKbArchivedDate">%[ka_ArchivedDate]</CustomField>
        <CustomField name="SfKbArchivedDatefq">%[ka_ArchivedDate_fiscalquarter]</CustomField>
        <CustomField name="SfKbArchivedDatefy">%[ka_ArchivedDate_fiscalyear]</CustomField>
        <CustomField name="SfKbArticleNumber">%[kav_ArticleNumber]</CustomField>
        <CustomField name="SfKbCaseAssociationCount">%[ka_CaseAssociationCount]</CustomField>
        <CustomField name="SfKbFirstPublishedDate">%[kav_FirstPublishedDate]</CustomField>
        <CustomField name="SfKbFirstPublishedDatefq">%[kav_FirstPublishedDate_fiscalquarter]</CustomField>
        <CustomField name="SfKbFirstPublishedDatefy">%[kav_FirstPublishedDate_fiscalyear]</CustomField>
        <CustomField name="SfKbIsLatestVersion">%[kav_IsLatestVersion]</CustomField>
        <CustomField name="SfKbIsVisibleInApp">%[kav_IsVisibleInApp]</CustomField>
        <CustomField name="SfKbIsVisibleInCsp">%[kav_IsVisibleInCsp]</CustomField>
        <CustomField name="SfKbIsVisibleInPkb">%[kav_IsVisibleInPkb]</CustomField>
        <CustomField name="SfKbIsVisibleInPrm">%[kav_IsVisibleInPrm]</CustomField>
        <CustomField name="SfKbLastPublishedDate">%[kav_LastPublishedDate]</CustomField>
        <CustomField name="SfKbLastPublishedDatefq">%[kav_LastPublishedDate_fiscalquarter]</CustomField>
        <CustomField name="SfKbLastPublishedDatefy">%[kav_LastPublishedDate_fiscalyear]</CustomField>
        <CustomField name="SfKbPublishStatus">%[kav_PublishStatus]</CustomField>
        <CustomField name="SfKbSummary">%[kav_Summary]</CustomField>
        <CustomField name="SfKbTitle">%[kav_Title]</CustomField>
        <CustomField name="SfKbUndecipherableContentC">%[kav_Undecipherable_Content__c]</CustomField>
        <CustomField name="SfKbUrlName">%[kav_UrlName]</CustomField>
        <CustomField name="SfKbVersionNumber">%[kav_VersionNumber]</CustomField>
        <CustomField name="SfLanguage">%[kav_Language]</CustomField>
        <CustomField name="SfLastModifiedById">%[kav_LastModifiedBy.Id]</CustomField>
        <CustomField name="SfLastModifiedByName">%[kav_LastModifiedBy.Name]</CustomField>
        <CustomField name="SfLastModifiedDate">%[kav_LastModifiedDate]</CustomField>
        <CustomField name="SfLastModifiedDatefq">%[kav_LastModifiedDate_fiscalquarter]</CustomField>
        <CustomField name="SfLastModifiedDatefy">%[kav_LastModifiedDate_fiscalyear]</CustomField>
        <CustomField name="SfSystemModstamp">%[kav_SystemModstamp]</CustomField>
        <CustomField name="SfSystemModstampfq">%[kav_SystemModstamp_fiscalquarter]</CustomField>
        <CustomField name="SfSystemModstampfy">%[kav_SystemModstamp_fiscalyear]</CustomField>
        <CustomField name="sysfiletype">SalesforceItem</CustomField>
      </CustomFields>
    </Fields>
  </Mapping>
  <Mapping type="MyKBArticleType2">
    <Fields>
      <Title>%[kav_Title]</Title>
      <Body>%[kav_Summary]</Body>
      <CustomFields>
        <CustomField name="objecttype">MyKBArticleType2</CustomField>
        <CustomField name="objecttypename">My KB Article Type2</CustomField>
        <CustomField name="sfinterfaceid">kb</CustomField>
        <CustomField name="SfCaseId">%[ka_CaseArticles.CaseId]</CustomField>
        <CustomField name="SfCreatedByName">%[kav_CreatedBy.Name]</CustomField>
        <CustomField name="SfKbArchivedDate">%[ka_ArchivedDate]</CustomField>
        <CustomField name="SfKbArchivedDatefq">%[ka_ArchivedDate_fiscalquarter]</CustomField>
        <CustomField name="SfKbArchivedDatefy">%[ka_ArchivedDate_fiscalyear]</CustomField>
        <CustomField name="SfKbArticleNumber">%[kav_ArticleNumber]</CustomField>
        <CustomField name="SfKbCaseAssociationCount">%[ka_CaseAssociationCount]</CustomField>
        <CustomField name="SfKbFirstPublishedDate">%[kav_FirstPublishedDate]</CustomField>
        <CustomField name="SfKbFirstPublishedDatefq">%[kav_FirstPublishedDate_fiscalquarter]</CustomField>
        <CustomField name="SfKbFirstPublishedDatefy">%[kav_FirstPublishedDate_fiscalyear]</CustomField>
        <CustomField name="SfKbIsLatestVersion">%[kav_IsLatestVersion]</CustomField>
        <CustomField name="SfKbIsVisibleInApp">%[kav_IsVisibleInApp]</CustomField>
        <CustomField name="SfKbIsVisibleInCsp">%[kav_IsVisibleInCsp]</CustomField>
        <CustomField name="SfKbIsVisibleInPkb">%[kav_IsVisibleInPkb]</CustomField>
        <CustomField name="SfKbIsVisibleInPrm">%[kav_IsVisibleInPrm]</CustomField>
        <CustomField name="SfKbLastPublishedDate">%[kav_LastPublishedDate]</CustomField>
        <CustomField name="SfKbLastPublishedDatefq">%[kav_LastPublishedDate_fiscalquarter]</CustomField>
        <CustomField name="SfKbLastPublishedDatefy">%[kav_LastPublishedDate_fiscalyear]</CustomField>
        <CustomField name="SfKbPublishStatus">%[kav_PublishStatus]</CustomField>
        <CustomField name="SfKbRecipeC">%[kav_Recipe__c]</CustomField>
        <CustomField name="SfKbSummary">%[kav_Summary]</CustomField>
        <CustomField name="SfKbTitle">%[kav_Title]</CustomField>
        <CustomField name="SfKbUrlName">%[kav_UrlName]</CustomField>
        <CustomField name="SfKbVersionNumber">%[kav_VersionNumber]</CustomField>
        <CustomField name="SfLanguage">%[kav_Language]</CustomField>
        <CustomField name="SfLastModifiedById">%[kav_LastModifiedBy.Id]</CustomField>
        <CustomField name="SfLastModifiedByName">%[kav_LastModifiedBy.Name]</CustomField>
        <CustomField name="SfLastModifiedDate">%[kav_LastModifiedDate]</CustomField>
        <CustomField name="SfLastModifiedDatefq">%[kav_LastModifiedDate_fiscalquarter]</CustomField>
        <CustomField name="SfLastModifiedDatefy">%[kav_LastModifiedDate_fiscalyear]</CustomField>
        <CustomField name="SfSystemModstamp">%[kav_SystemModstamp]</CustomField>
        <CustomField name="SfSystemModstampfq">%[kav_SystemModstamp_fiscalquarter]</CustomField>
        <CustomField name="SfSystemModstampfy">%[kav_SystemModstamp_fiscalyear]</CustomField>
        <CustomField name="sysfiletype">SalesforceItem</CustomField>
      </CustomFields>
    </Fields>
  </Mapping>
</Salesforce>
  
People who viewed this topic also viewed