8.1.2 Move products from one instance into another

Here are the steps on how to copy your inventory from one to another Salesforce instance. 

For the export and import you should be familiar with tools such as the Dataloader.io, G-Connector for Salesforce or Salesforce Dataloader.

Step 1 : Set up AdServer Login (ASL) and Transfer AdServer Data

If you are using an AdServer Connection please create the AdServer Login(s) first.

The following data needs to be imported via "Transfer From AdServer" button of the ASL record (if necessary):

  • Targeting IDs
  • Creative Template Data
  • Inventory Data
  • Geo- / Technical- Targeting Data
  • Key Value Data
  • Video Content
  • Content Bundles

Step 2 : Picklist values

Before importing the product data, please double-check the picklist values below as they need to be up-to-date.

ObjectField NameFieldPicklist Values (examples)  
advendio__site__cMediaType
  • TV
  • Radio
  • Online
  • Print - Newspaper
  • Print - Magazines
advendio__placement__cMedia Segment
  • Sections
  • Classifieds
  • Fix Positons
  • Services
  • MultiScreen
  • InBrowser
  • Housing
  • InApp/Mobile
  • Recruiting
advendio__ad_type__cMedia Differentiation
  • InStream
  • InPage
  • Black and White
  • Color
advendio__ad_price__cRate Criterion
  • Monday - Thursday
  • Friday - Saturday
  • Sunday
  • Black  and White
  • Color

Step 3 : Export all Objects containing your Products from ADvendio

Here is the list of the objects relevant to your inventory. Please check which of these objects are used in your org and whether you need to import them.

OrderObject NameObject API NameMandatory
1Siteadvendio__site__cx
2Publication DateADvendio__PublicationDate__c
3Placementadvendio__placement__cx
4Ad Typeadvendio__ad_type__cx
5

Ad Spec

advendio__ad_specs__cx
6AdserverID Adspec AssignmentAdServer_ID_AdSpec_Assigment__c
7Ad priceadvendio__ad_price__cx
8Packet componentADvendio__PacketComponent_ _c
9RateStepADvendio__Ratestep__c
10Contentadvendio__content__c
11Placement Content Assignmentadvendio__placementcontentassignment__c
12Content Ad Price Assignmentadvendio__contentadpriceassignment__c
13Key Ad Price AssignmentADvendio__KeyAdPriceAssignment__c
14KeyValue PresetADvendio__KeyValuePreset__c
15KeyValue Preset Ad Price AssignmentADvendio__KeyValuePresetAdPriceAssignment__c
16Value AdPrice AssignmentADvendio__ValueAdPriceAssignment__c
17EventDateADvendio__EventDate__c
18Site Ad Type AssignmentADvendio__SiteAdTypeAssignment__c
19RateCardADvendio__Pricelist__cx

Step 4: Import all Objects to new Salesforce Org

Please consider that: 

  • The import for Master-Detail objects involves additional mapping of the record data. First, Master record data need to be inserted. Lets take an example of Site & Publication Date: First Site data needs to be imported to the Org. Then run a query to get the imported records to fetch the record ID. Populate the Site record ID to the related Publication Date record and import.
  • Lookup Fields: Please handle similar to Master-Detail relationships. Create the linked object first. Obtain the IDs and update. 

Below listed objects are to be imported in the above described way for all the Master-Detail related objects. Hence it involves more time for processing the data. Here is the sequence to follow to import the data to your import Org. 

Packages and Content

Please note that Packages and Content have references to themself and therefore need to be imported with caution.

OrderObject NameObject API Name
1Siteadvendio__site__c
2Publication DateADvendio__PublicationDate__c
3Placementadvendio__placement__c
4Ad Typeadvendio__ad_type__c
5

Ad Spec

advendio__ad_specs__c
6AdserverID Adspec AssignmentAdServer_ID_AdSpec_Assigment__c
7RateCardADvendio__Pricelist__c
8Ad priceadvendio__ad_price__c
9Packet componentADvendio__PacketComponent_ _c
10RateStepADvendio__Ratestep__c
11Contentadvendio__content__c
12Placement Content Assignmentadvendio__placementcontentassignment__c
13Content Ad Price Assignmentadvendio__contentadpriceassignment__c
14Key Ad Price AssignmentADvendio__KeyAdPriceAssignment__c
15KeyValue PresetADvendio__KeyValuePreset__c
16KeyValue Preset Ad Price AssignmentADvendio__KeyValuePresetAdPriceAssignment__c
17Value AdPrice AssignmentADvendio__ValueAdPriceAssignment__c
18EventDateADvendio__EventDate__c
19Site Ad Type AssignmentADvendio__SiteAdTypeAssignment__c