>
Administrator Help > Connectors > Salesforce Connector > Creating a Salesforce Mapping File > Example for Knowledge Base
Salesforce Mapping File Example for Knowledge Base
The mapping file example presented in this topic maps two arbitrary named Knowledge Base objects:
-
MyKBArticleType1
-
MyKBArticleType2
<?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>