Versions Compared

Old Version 6

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Warning

This feature is deprecated and set to be removed from ADvendio. Please see our deprecation Schedule for more information: Deprecation/Deletion Schedule for 2023/2024


Installing the ADvendio package will create a standard mapping for you which you can customize to your needs. Also please map the fields you have newly created to export data correctly to XML. 

Mandatory Mapping

Navigate to Setup > Develop > Custom Settings > ImportExportMapping > Manage



Please navigate to the mapping click on manage and edit the following four fields:

  1. Click Edit at the field CTPricemodel StandardpricemodelOvkparticipantsenderid:
      Click Edit at the field Ovkparticipantsenderid:
      1. Offer Field Notation: ADvendio__Advertising_Media__r.OVKBillingCategory__c.Pricelist Field Notation:  ADvendio__Ad_Prices__r.OVKBillingCategory__c.
    1. Click Edit at the field CTOfferposition Unit:
      1. Offer Field Notation: ADvendio__Advertising_Media__r.Unit__c
    2. Click Edit at the field CTOffer Type:
      1. Offer Field Notation: OVKOfferType__c
      1. Offer Field Notationt: SenderID12345*.
      2. Pricelist Field Notation: SenderID12345*.
      3. Advertisements Field Notation: SenderID12345*.
      4. Placements Field NotationtNotation: SenderID12345*.

    *Note: Please use your own OVK sender ID.

    Custom Field Mapping

    You can also map your own fields by matching the fields in the custom setting with your ADvendio fields. 

    ...

    Use the views to filter. i.e. Placements: You will find your start object under Name: Start.

     

     


    Info

    To see which fields are required from AGOF Connect please have loom here: 140307_Elemente XSD Stammdaten.xlsx and 140128_Elemente XSD Offer - Überarbeitet.xlsx


    Example Mapping

    NameOffer Field NotationPricelist Field NotationAdvertisements Field NotationPlacements Field Notation
    Ovkparticipantsenderid*100014100014100014100014
    CTCompany Type PublisherVermarkter


    CTCompany Type InvoicerecipientRechnungsempfänger


    CTOffer Status AcceptedPositive Feedback (Agency/Advertiser)


    CTOffer Status DiscardedOut of date


    CTOffer Status OfferedOffer on Request


    CTOffer Status DeclinedOffer denied


    CTOffer CampaignName


    CTCompany Type ContactKontakt


    CTOffer Status EnquiredInitial Offer (w/o request)


    CTCompany Type BenefitrecipientContact Beneficiary


    CTCompany Type AgencyContact Agency


    CTCompany Type CustomerContact Advertiser


    CTOffer Status AssignedBooked


    CTOffer StatusADvendio__Stage__c


    CTAdAssignment PlacementADvendio__Placement__cADvendio__Placement__c

    CTOffer TypeADvendio__OVKOfferType__c


    CTOffer OfferidADvendio__Offer_Number__c


    StartADvendio__MediaCampaign__cADvendio__Pricelist__cADvendio__Ad_Type__cADvendio__Placement__c
    CTPricecalculation GrossB1 SPCADvendio__Gross_amount__c


    CTPricecalculation GrossB3 SPCADvendio__Gross_amount_B3__c


    CTPricecalculation GrossB2 SPCADvendio__Gross_amount_B2__c


    CTOffer ExternalcampaignADvendio__external_Media_Campaign_Name__c


    CTPricecalculation CustomernetN1 SPCADvendio__Discounted_Amount__c


    CTOffer ValidtoADvendio__Close_Date__c


    CTContactperson TelephoneADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Phone


    CTContactperson NameADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Name


    CTContactperson FaxADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Fax


    CTContactperson EmailADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Email


    CTCompany Name CompanyADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.Name


    CTAddress Street CompanyADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingStreet


    CTAddress Zipcode CompanyADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingPostalCode


    CTAddress Countrycode CompanyADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingCountry


    CTAddress City CompanyADvendio__Campaing_Contacts__r.ADvendio__Contact__r.Account.BillingCity


    CTCompany TypeADvendio__Campaing_Contacts__r.ADvendio__Campaign_Contact_Role__c


    Start ContactpersonADvendio__Campaing_Contacts__r


    CTPricecalculation AgencynetN2 SPCADvendio__Amount_net_net__c


    CTCompany Name AgencyADvendio__Agency__r.Name


    CTAddress Street AgencyADvendio__Agency__r.BillingStreet


    CTAddress Zipcode AgencyADvendio__Agency__r.BillingPostalCode


    CTAddress Countrycode AgencyADvendio__Agency__r.BillingCountry


    CTAddress City AgencyADvendio__Agency__r.BillingCity


    CTOffer OvkparticipantreceiveridADvendio__Agency__r.ADvendio__OVKParticipantID__c


    CTOfferposition BookingtoADvendio__Advertising_Media__r.ADvendio__until_Date__c


    CTOfferposition UnitADvendio__Advertising_Media__r.ADvendio__Unit__c


    CTTargetingADvendio__Advertising_Media__r.ADvendio__Targetingabbrevation__c


    CTOfferposition BookedamountADvendio__Advertising_Media__r.ADvendio__Quantity__c


    CTPricemodel StandardpricemodelADvendio__Advertising_Media__r.ADvendio__OVKBillingCategory__cADvendio__Ad_Prices__r.ADvendio__OVKBillingCategory__c

    CTPrice BasicpriceB3ADvendio__Advertising_Media__r.ADvendio__List_Price__cADvendio__Ad_Prices__r.ADvendio__List_price__c

    CTOfferposition GuaranteedamountADvendio__Advertising_Media__r.ADvendio__Guaranteed_AI__c


    CTOfferposition BookingfromADvendio__Advertising_Media__r.ADvendio__from_Date__c


    CTFc QuantityADvendio__Advertising_Media__r.ADvendio__FC_Quantity__c


    CTFc PeriodADvendio__Advertising_Media__r.ADvendio__FC_Period__c


    CTFc PerADvendio__Advertising_Media__r.ADvendio__FC_Ad_served_every__c


    CTPricecalculation AgencynetN2 PCADvendio__Advertising_Media__r.ADvendio__Amount_net_net__c


    CTPricecalculation CustomernetN1 PCADvendio__Advertising_Media__r.ADvendio__Amount_net__c


    CTPricecalculation GrossB1 PCADvendio__Advertising_Media__r.ADvendio__Amount__c


    CTPricecalculation GrossB3 PCADvendio__Advertising_Media__r.ADvendio__Amount_B3__c


    CTPricecalculation GrossB2 PCADvendio__Advertising_Media__r.ADvendio__Amount_B2__c


    CTPlacement NameADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.NameADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.Name
    		Name
    CTMedia NameADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.NameADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.Name
    		ADvendio__Site__r.Name
    CTMedia DescriptionADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.ADvendio__External_Name__cADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__Site__r.ADvendio__External_Name__c
    		ADvendio__Site__r.ADvendio__External_Name__c
    CTPlacement DescriptionADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__External_Name__cADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__r.ADvendio__External_Name__c
    		ADvendio__External_Name__c
    CTPlacementADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Placement__cADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Placement__c

    CTAdvertisement NameADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.NameADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.NameName
    CTAdvertisement AttributesADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__AgofAttributes__cADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__AgofAttributes__cADvendio__AgofAttributes__c
    CTAdvertisementtype NameADvendio__Advertising_Media__r.ADvendio__Ad_Price__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__Adtype__cADvendio__Ad_Prices__r.ADvendio__Ad_Spec__r.ADvendio__Ad_Type__r.ADvendio__Adtype__cADvendio__Adtype__c
    Start OfferpositionADvendio__Advertising_Media__r


    CTAdvertisement Name AAADvendio__Ad_Type__r.NameADvendio__Ad_Type__r.Name

    CTAdvertisementtype Name AAADvendio__Ad_Type__r.ADvendio__Adtype__cADvendio__Ad_Type__r.ADvendio__Adtype__c

    Start AvailableadvertisementADvendio__Ad_Specs__cADvendio__Ad_Specs__c

    CTPriceItem ExportADvendio__Ad_Price__r.ADvendio__AgofExport__cADvendio__AgofExport__c

    CTCompany Name CustomerADvendio__Account__r.Name


    CTAddress Street CustomerADvendio__Account__r.BillingStreet


    CTAddress Zipcode CustomerADvendio__Account__r.BillingPostalCode


    CTAddress Countrycode CustomerADvendio__Account__r.BillingCountry


    CTAddress City CustomerADvendio__Account__r.BillingCity


    CTOfferposition Businesssegment



    CTOfferposition Expectedamount



    CTOfferposition PriceItemId



    CTPlacement AGIDs VID


    		ADvendio__AGOF_ID__c
    CTPlacement AGvalidity Validfrom



    CTPrice AGIDs VID



    CTPricechange BasicpriceB2 SPC



    CTPricechange Description SPC



    CTPricechange Operation SPC



    CTPricechange Value SPC



    CTPricemodel Specialpricemodel



    CTPricecalculation Annotation PC



    CTPricecalculation BasicpriceB2 PC



    CTPricechange BasicpriceB2 PC



    CTPricechange Description PC



    CTPricechange Operation PC



    CTPricechange Value PC



    CTPricemodel Description



    CTTargetingtype Type



    CTAddress Additionaladdress Agency



    CTAddress Additionaladdress Customer



    CTAdvertisement AGIDs EID



    CTAdvertisement AGIDs VID



    CTAdvertisement OVKID



    CTAdAssignment AGv Validto



    CTAdvertisementspec Description



    CTAddress Additionaladdress Company



    CTAdvertisementtype AGIDs EID



    CTAdvertisementtype AGIDs VID



    CTAdvertisementtype OVKID



    CTAnnotation Annotationtext Notice



    CTCalculationstep BasePrice PCAE



    CTCalculationstep BasePrice PCD



    CTCalculationstep BasePrice SPCB2



    CTCalculationstep Description PCAE



    CTAdvertisement AGIDs EID AA



    CTAdvertisement AGIDs VID AA



    CTCalculationstep Description PCD



    CTCalculationstep Description SPCB2



    CTCalculationstep Operation PCAE



    CTCalculationstep Operation PCD



    CTCalculationstep Operation SPCB2



    CTCalculationstep Result PCAE



    CTCalculationstep Result PCD



    CTCalculationstep Result SPCB2



    CTCalculationstep Subtotal PCAE



    CTCalculationstep Subtotal PCD



    CTAdvertisement OVKID AA



    CTAdAssignment AGv Validfrom



    CTAdAssignment Fc Fccapable



    CTAdvertisementspec Description AA



    CTAdvertisementtype AGIDs EID AA



    CTAdvertisementtype AGIDs VID AA



    CTAnnotation Annotationtext GTC



    CTAnnotation Annotationtext Other



    CTCalculationstep Subtotal SPCB2



    CTCalculationstep Type PCAE



    CTCalculationstep Type PCD



    CTCalculationstep Type SPCB2



    CTCalculationstep Value PCAE



    CTCalculationstep Value PCD



    CTCalculationstep BasePrice PCB2



    CTCalculationstep BasePrice SPCAE



    CTCalculationstep BasePrice SPCD



    CTCalculationstep Description PCB2



    CTCalculationstep Description SPCAE



    CTCalculationstep Description SPCD



    CTCalculationstep Operation PCB2



    CTCalculationstep Operation SPCAE



    CTCalculationstep Operation SPCD



    CTCalculationstep Result PCB2



    CTCalculationstep Value SPCB2



    CTCommitment AGIDs EID



    CTCommitment Commitment



    CTCommitment Version



    CTCompany AGIDs EID Company



    CTCompany AGIDs VID Agency



    CTCompany AGIDs VID Customer



    CTCompany NielsenID Agency



    CTCompany NielsenID Customer



    CTCalculationstep Result SPCAE



    CTCalculationstep Result SPCD



    CTCalculationstep Subtotal PCB2



    CTCalculationstep Subtotal SPCAE



    CTCalculationstep Subtotal SPCD



    CTCalculationstep Type PCB2



    CTCalculationstep Type SPCAE



    CTCalculationstep Type SPCD



    CTCalculationstep Value PCB2



    CTCalculationstep Value SPCAE



    CTContactperson AGIDs EID



    CTCalculationstep Value SPCD



    CTCommitment AGIDs VID



    CTCommitment Version Attr



    CTCompany AGIDs EID Agency



    CTCompany AGIDs EID Customer



    CTCompany AGIDs VID Company



    CTCompany NielsenID Company



    CTMedia AGIDs VID



    CTNaturaldiscount Nd



    CTOffer AGIDs EID



    CTContactperson AGIDs VID



    CTMedia AGIDs EID



    CTMedia AGOF AGOFID



    CTOffer Version



    CTNaturaldiscount Ndtype



    CTOffer AGIDs VID



    CTOffer Referenceid



    CTOfferposition Availableamount



    CTOfferposition Referenceid



    CTPlacement AGIDs EID



    CTPlacement AGOF AGOFID



    CTPlacement AGvalidity Validto



    CTPrice AGIDs EID



    CTPricecalculation Annotation SPC



    CTPricecalculation BasicpriceB2 SPC



    CTPriceItem AGvalidity Validfrom
    		ADvendio__Ad_Prices__r.ADvendio__Valid_from__c

    CTPriceItem AGIDs VID



    CTPricelist Name
    		Name

    CTPriceItem AGvalidity Validto
    		ADvendio__Ad_Prices__r.ADvendio__Valid_to__c

    CTPricelist AGvalidity Validto



    CTPricelist AGvalidity Validfrom



    CTPriceItem Currency
    		CurrencyIsoCode

    CTPriceItem AGIDs EID



    CTPriceItem Active
    		ADvendio__Active__c

    CTPricelist Checksum



    CTPricelist AGIDs EID



    Start PriceItem
    		ADvendio__Ad_Prices__r

    CTPricelist AGIDs VID



    CTPricelist Version
    		1

    CTOffer Ovkparticipantsenderid



    CTAddress Postofficebox Agency



    CTAddress Postofficebox Customer



    CTAddress Postofficebox Company



    CTPricelist Ovkparticipantsenderid



    *Note: Please use your own OVK sender ID.