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 Master ID and Slave ID to MASTER_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 Master ID and Slave ID to MASTER_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. |