7.3.3.6 Key and Values - Migration Steps (Version 2.64 or older only)

Due to this standardization of field names and functionality, the following existing fields key value fields are discontinued (but are still transmitted to the ad server).

Please use the field ADvendio__KeyValues__c in all Objects.

The following fields are discontinued:

Object	Field
Ad Spec	ADvendio_Keywords_Key_Values_c
Ad Type	ADvendio_Keyvalue_Keyword_c
Placement	ADvendio_AdServer_Keywords_Key_Values_c

If you want to use the new fields, follow these steps:

Install ADvendio Version 2.65 (Winter '16) or newer and perform the following commands (copy & paste) via the developer console.

Ad Spec

Code Example for Ad Spec:

List<ADvendio__Ad_Specs__c> adSpecForUpdate = [SELECT id, ADvendio__Keywords_Key_Values__c, ADvendio__KeyValues__c
                                                    FROM ADvendio__Ad_Specs__c WHERE ADvendio__Keywords_Key_Values__c != null];
for(ADvendio__Ad_Specs__c adSpec : adSpecForUpdate ){
    adSpec.ADvendio__KeyValues__c = adSpec.ADvendio__Keywords_Key_Values__c;
    adSpec.ADvendio__Keywords_Key_Values__c = null;
}
update adSpecForUpdate;

Ad Type

Code Example for Ad Type:

List<ADvendio__Ad_Type__c> adTypeForUpdate = [SELECT id, ADvendio__Keyvalue_Keyword__c, ADvendio__KeyValues__c
                                                    from ADvendio__Ad_Type__c where ADvendio__Keyvalue_Keyword__c != null];
for(ADvendio__Ad_Type__c adType : adTypeForUpdate ){
    adType.ADvendio__KeyValues__c = adType.ADvendio__Keyvalue_Keyword__c;
    adType.ADvendio__Keyvalue_Keyword__c = null;
}
update adTypeForUpdate;

Placement

Code Example for Placement:

List<ADvendio__Placement__c> placementsForUpdate = [SELECT id, ADvendio__AdServer_Keywords_Key_Values__c, ADvendio__KeyValues__c
                                                    from ADvendio__Placement__c where ADvendio__AdServer_Keywords_Key_Values__c != null];
for(ADvendio__Placement__c placement : placementsForUpdate ){
    placement.ADvendio__KeyValues__c = placement.ADvendio__AdServer_Keywords_Key_Values__c;
    placement.ADvendio__AdServer_Keywords_Key_Values__c = null;
}
update placementsForUpdate;