Read through the following topic to understand more about Scribe Integration Maps used for SugarCRM- Acoustic Campaign Synchronization. Each integration schema is described on a block level.
Download the SugarCRM XML Mappings
Mappings for the main Leads & Contacts, Lead Alerts, and Campaign to Contact List can be downloaded here.
Before you Begin
Your Scribe Integration account must be set up and associated with your Acoustic Campaign org. Contact Lists
Execution Order
Mapping Name
Mapping Type
Description
Source System
Target System
1
SugarCRM - Acoustic Campaign Campaign to Contact List
Advanced
Creates new Contact list (or) Updates previously made Contact list.
Sugar
Acoustic Campaign
Lead Alerts
Execution Order
Mapping Name
Mapping Type
Description
Source System
Target System
1
SugarCRM - to Acoustic Campaign - Lead Alerts
Advanced
Insert and Update for Leads/Contacts to SugarCRM
Acoustic Campaign
Sugar
Leads and Contacts
Execution Order
Mapping Name
Mapping Type
Description
Source System
Target System
1
Acoustic Campaign to SugarCRM - Lead Sync
Advanced
Insert and Update for Leads/Contacts to SugarCRM
Acoustic Campaign
Sugar
2
Acoustic Campaign to SugarCRM - Contact Sync
Advanced
Insert and Update for Contacts to SugarCRM
Acoustic Campaign
Acoustic Campaign
3
SugarCRM to Acoustic Campaign - Lead Sync
Advanced
Insert and Update for Leads to the Acoustic Campaign
Sugar
Acoustic Campaign
4
SugarCRM to Acoustic Campaign - Contact Sync
Advanced
Insert and Update for Contacts to Acoustic Campaign
Sugar
Acoustic Campaign
5
SugarCRM to Acoustic Campaign - Lead Sync (Convert)
Advanced
Convert for Leads to Acoustic Campaign
Sugar
Acoustic Campaign
6
SugarCRM to Acoustic Campaign - Leads/Contacts (Merge)
Advanced
Merge Leads and Contacts to Acoustic Campaign
Sugar
Acoustic Campaign
7
SugarCRM to Acoustic Campaign - Leads/Contacts (Delete)
Advanced
Delete for Leads and Contacts to Acoustic Campaign
Sugar
Acoustic Campaign
Parent Account
Execution Order
Mapping Name
Mapping Type
Description
Source System
Target System
1
SugarCRM Acoustic Campaign Parent Account
Advanced
Sync Parent Details to Related Recipients
Sugar
Acoustic Campaign
Email Statistics
Execution Order
Mapping Name
Mapping Type
Description
Source System
Target System
1
SugarCRM - Acoustic Campaign - email Statistics
Advanced
Synchronization of email statistics for all emails in SugarCRM
Sugar
Acoustic Campaign
Order
Block
Description
1
Query Acoustic Campaign
Connects to Sugar Campaign.
2
For Each Result
Pushes each record from the Query block to be processed by the integration schema.
3
Get Acoustic Campaign Contact List
Retrieves the Acoustic Campaign Contact List.
4
If the Acoustic Campaign contact List does not exist
Validates the Acoustic Campaign Contact List. If it does not exist, it goes to Step #5 and creates a new one. If it exists, it goes to Step #6 and deletes all contact list members.
5
Create Contact List
Creates a contact list.
6
for Each Acoustic Campaign Member
Pushes each campaign member from the Query block to be processed by the integration schema.
7
Add Contact List Members to the Contact List
Adds a contact list member to a contact list by matching lookup IDs.
8
Delete Contact List Members
Clears all members from the Contact List.
9
For Each Acoustic Campaign Campaign Member
Pushes each campaign member record from the Query block to be processed by the integration schema.
10
Add Contact List Members to the Contact List
Looks up contact list members and removes them.
SugarCRM > Acoustic Campaign Campaign Member to Contact List Member Scribe Integration Schema
1
Query
Connects to existing contact list or creates a new one.
2
For Each Result
Pushes each record from the Query block to be processed by the integration schema.
3
Get Parent Acoustic Campaign Campaign
Looks up the parent campaign from Sugar.
4
Get Acoustic Campaign Contact List
Retrieves the Contact List.
5
Add Contact List Member to Contact List
Ads Campaign member to contact list.
Lead Alerts
Scribe Integration Schema
Order
Block
Description
1
Query
Retrieves Lead Alerts from Acoustic Campaign.
2
For Each Result
Pushes each record from the Query block to be processed by the integration schema.
3
Get Contact
Updates the SugarCRM lead record based on the Task.CRM_SYNC_ID value.
4
If Contact
Validates whether Sugar_ContactsLookup.Result.RecordsMatched exists, or the Value is greater than zero.
5
Update/Insert Task
Updates the task when sp_alertid equals Task.alert_id.
6
Get Lead
Retrieves the lead when id equals Task.CRM.SYNC.ID or sp_engageid equals task.RECIPIENT_ID.
7
Update/Insert Task
Updates the task when sp_alertid equals Task.alert_id.
Leads and Contacts
Acoustic Campaign to SugarCRM - Lead Sync Scribe Integration Schema
Order
Block
Description
1
Query
Retrieves Lead from Acoustic Campaign.
2
For Each Result
Pushes each record from the Query block to be processed by the integration schema.
3
If CRM_SYNC_ID exists
Validates if the CRM_SYNC_ID field on a source Acoustic Campaign record is populated. If populated, then the integration updates the lead via block #4. If it is not populated, the integration moves forward via blocks #5-6.
4
Update lead
Updates the SugarCRM lead record based on the CRMDatabase_Lead.CRM_SYNC_ID value. Block updates a SugarCRM lead record where internal ID = CRMDatabase_Lead.CRM_SYNC_ID.
5
Update/Insert Leads
Retrieves the SugarCRM customer based on the sp_engageid field. Sp_engageid in SugarCRM stores the Recipient ID of the corresponding Acoustic Campaign record.
6
If the Lead has an Email Address
Validates if the EMAIL field ISNULLOREMPTY. If the result is “false,” then the Email Address is processed in the next block.
7
Update/Insert Email Addresses
Creates or inserts EmailAddresses based on the CMRDatabase_Lead.EMAIL value. Also, processes Opt-Outs using the CRMDatabase_Lead.OPT_OUT.
Acoustic Campaign to SugarCRM > Contact Sync
Scribe Integration Schema
Order
Block
Description
1
Query CRMDatabase_Contact
Retrieves Contact Type recipients from Acoustic Campaign.
2
For Each Result
Pushes each record from the Query block for processing by the integration schema.
3
If CRM_SYNC_ID exists
Validates if the CRM_SYNC_ID field on a source Acoustic Campaign record is populated. If it is populated, the integration moves forward via block #4. If it is not populated, the integration moves forward via block #5.
4
Update Contacts
Updates the SugarCRM Contact record based on the CRMDatabase_Contact.CRM_SYNC_ID value. The block updates a SugarCRM Contact record where id = CRMDatabase_Contact.CRM_SYNC_ID.
5
Update/Insert Contacts
Either create a new SugarCRM Contact record or update an existing one based on CRMDatabase_Contact.RECIPIENT_ID.
6
If the Contact has an Email Address
Validates if the EMAIL field ISNULLOREMPTY. If the result is "false," then the Email Address is processed in the next block.
7
Update/InsertEmailAddresses
Either create a new SugarCRM email record or update an existing one based on CRMDatabase_Contact.EMAIL value. Also, updates Opt-Outs using the CRMDatabase_Contact.OPT_OUT.
SugarCRM to Acoustic Campaign - Lead Sync Scribe Integration Schema
Order
Block
Description
1
Query
Retrieves individual customer records marked with SP Sync To Acoustic Campaign flag from SugarCRM.
2
For Each Result
Pushes each record from the Query block for processing by the integration schema.
3
Update/ Insert Lead
Performs a Lead update from SugarCRM to Acoustic Campaign based on the CRM_SYNC_ID.
SugarCRM to Acoustic Campaign - Update/Insert Contact Scribe Integration Schema
1
Query
Retrieves Contact records from SugarCRM.
2
For Each
Pushes each record from the Query block for processing by the integration schema.
3
Update/ Insert
Performs a Contact update from SugarCRM to Acoustic Campaign based on the CRM_SYNC_ID.
SugarCRM to Acoustic Campaign - Lead Sync (Convert) Scribe Integration Schema
Order
Block
Description
1
Query
Retrieves the Lead type recipient from Acoustic Campaign.
2
For Each Result
Pushes each record from the Query block for processing by the integration schema.
3
Merge CRMDatabase_Contact
Merges leads to the Acoustic Campaign CRM database based on the CRM_SYNC_ID field.
SugarCRM to Acoustic Campaign - Leads/Contacts (Merge) Scribe Integration Schema
Order
Block
Description
1
Query SP_MergedObjectPointer
Retrieves the Merged Object Pointer in SugarCRM.
2
For Each Result
Pushes each record from the Query block for processing by the integration schema.
3
If Lead
Validates the type of merged SugarCRM record. If the type equals Lead, then the integration moves forward via block #4. Otherwise, the integration validates the record as a Contact in block #5.
4
Merge CRMDatabase_lead
Triggers the Merge operation in Acoustic Campaign for the Lead type recipient by mapping Primary ID and secondary ID to Primary_CRM_SYNC_ID and CRM_SYNC_ID correspondingly.
4
If then Else
Validates whether the record type is Contact.
5
Merge CRMDatabase_Contact
Triggers the Merge operation in Acoustic Campaign for the Contact type recipient by mapping Primary ID and secondary ID to PRIMARY_CRM_SYNC_ID and CRM_SYNC_ID correspondingly.
SugarCRM to Acoustic Campaign - Leads/Contacts (Delete) Scribe Integration Schema
Order
Block
Description
1
QuerySP_DeletedObjectPointer
Retrieves the Merged Object Pointer in SugarCRM.
2
For Each Result
Pushes each record from the Query block for processing by the integration schema.
3
If Lead
Validates the type of a merged SugarCRM record. If the type equals Lead, then the integration moves forward via block #4. Otherwise, the integration moves forward via block #5.
4
Delete CRMDatabase_Lead
Deletes the Contact type recipient in Acoustic Campaign by CR_SYNC_ID.
5
Delete CRMDatabase_Contact
Deletes the Contact type recipient in Acoustic Campaign by CR_SYNC_ID.
Parent Account
Scribe Integration Schema
1
Query Accounts
Retrieves parent account records based on the value of the date_modified field.
2
For Each Result
Pushes each record from the Query block for processing by the integration schema.
3
Update CRMDatabase_Account
Updates the Parent account details when CRM_ACCOUNT_ID equals Account ID.
Email Statistics
Scribe Integration Schema
1
Query SP_engageemail
Retrieves email statistics from the last 30 days from the sp_sentdate or current date.
2
For Each Result
Pushes each record from the Query block for processing by the integration schema.
3
Lookup GetemailReportId
Retrieves email statistics by SP_engageemail.sp_engageid, SP_engageemail.sp_sentdate, and SP_engageemail.sp_sentdate.
4
Lookup GetAggregateDataBy email
Retrieves aggregate email statistics by SP_engageemail.sp_engageid and Silverpop_GetemailReportIdLookup.ReportId.
5
Update SP_engageemail
Updates the email statistics based on the SP_engageemail.id.