fortafy

I do not work for MinOrange by the way….

This is resolved. It appears to have been a caching issue after all.

You can find different versions here: https://github.com/MinnPost/object-sync-for-salesforce/releases

Grab the .zip source files

1. Delete the old version (make sure that delete all data is false)
2. Upload new plugin
3. Even if it appears to be connected to Salesforce, I would disconnect and reestablish to make sure

Same. ver 2.1 was the culprit. We deleted the plugin and reinstalled 2.0.x and it’s working as expected.

ver 2.1 appears to be buggy. we had to rollback to 2.0.x in order to get it working again.

Thanks. This appears to be a working solution.

you mean you are using the “Other SMTP” mailer in our plugin settings, which is using the Mandril SMTP server to send emails?

Yes, that is correct.

Are only the user registration emails coming through if the “Do not send” setting is enabled in WP Mail SMTP Misc settings?

Yes, it appears to be new registration, password resets (so all account related activities)

Could you please check out the “original message” for one of those registration emails that come through to your inbox and see what the value for “X-Mailer” is?

From: TimeSlips Creative Storytelling <[email protected]>
Subject: [TimeSlips] New User Registration
Received: from [35.236.123.73] by mandrillapp.com id e7f9d8b13cc6453b9dcb163809b4960f; Tue, 26 Oct 2021 06:11:15 +0000
X-Mailer: WPMailSMTP/Mailer/smtp 3.0.3
Message-Id: <N0sWjG2Dcjh39SXB65BTtdTQm5FBweYbYnlG2KjRCw@devtimeslips.kinsta.cloud>
To: [email protected]
X-Report-Abuse: Please forward a copy of this message, including all headers, to [email protected]
X-Report-Abuse: You can also report abuse here: https://mandrillapp.com/contact/abuse?id=31218925.e7f9d8b13cc6453b9dcb163809b4960f
X-Mandrill-User: md_31218925`

We are using a custom mailer via Mandril. We have the following plugins installed:

1. MemberMouse
2. LearnDash
3. Toolset
4. Gravity Forms
5. MemberMouse
6. WP Bakery
7. Modern Events Calendar
8. User Role Editor

And some other, utility plugins that are either addons to the above or for a specific purpose like:

1. CBX Bookmark & Favorite
2. GDPR Cookie Consent
3. Media Library Folders for WordPress
4. Object Sync for Salesforce
5. One User Avatar
6. etc…

Pretty big bug (I unknowingly sent out 892 emails from my staging environment). Thanks for looking in to this.

yes, I’d be willing to give it a try.

I had an ah-ha! and wanted to bounce it off you. We are running 2 different feeds on the same Salesforce Object. The first is User –> Salesforce Contact and is a one way sync from WordPress to Salesforce. The second is a Team (cpt) <– Salesforce Contact and is one way sync from Salesforce to WordPress. Is is possible that having 2 different feeds is causing an issue?

FULL DEBUG LOG ENTRY

---

HTTP method: GET

URL of API call to Salesforce: https://timeslipscreativestorytellinginc--fortafyuat.my.salesforce.com/services/data/v52.0/query?q=SELECT+Id%2C+fortafy_wp_id__c%2C+Email%2C+fortafy_occupation__c%2C+fortafy_display_on_web__c%2C+fortafy_training_level__c%2C+fortafy_website__c%2C+MailingCity%2C+MailingState%2C+MailingLongitude%2C+MailingLatitude%2C+MailingCountry%2C+fortafy_facebook__c%2C+fortafy_twitter__c%2C+fortafy_tiktok__c%2C+fortafy_linkedIn__c%2C+fortafy_instagram__c%2C+MailingPostalCode%2C+LastModifiedDate%2C+CreatedDate+FROM+Contact+WHERE+LastModifiedDate+%3E+2021-08-16T15%3A57%3A42Z+ORDER+BY+LastModifiedDate+ASC+LIMIT+100

SOQL query that was sent to Salesforce

SELECT Id, fortafy_wp_id__c, Email, fortafy_occupation__c, fortafy_display_on_web__c, fortafy_training_level__c, fortafy_website__c, MailingCity, MailingState, MailingLongitude, MailingLatitude, MailingCountry, fortafy_facebook__c, fortafy_twitter__c, fortafy_tiktok__c, fortafy_linkedIn__c, fortafy_instagram__c, MailingPostalCode, LastModifiedDate, CreatedDate FROM Contact WHERE LastModifiedDate > 2021-08-16T15:57:42Z ORDER BY LastModifiedDate ASC LIMIT 100

API result from Salesforce
Array
(
[code] => 200
[data] => Array
(
[totalSize] => 0
[done] => 1
[records] => Array
(
)

)

[from_cache] =>
[cached] =>
[is_redo] =>
)

• This reply was modified 3 years, 3 months ago by Jan Dembowski.
• This reply was modified 3 years, 3 months ago by Jan Dembowski. Reason: Formatting

Hey Jonathan, me again. I’ve turned on debug and with respect to the syncing this is the SOQL statement I’m seeing in the debug logs:

SELECT Id, fortafy_wp_id__c, Email, …. WHERE LastModifiedDate > 2021-08-16T15:57:42Z ORDER BY LastModifiedDate ASC LIMIT 100

Why is it looking for records greater than LastModifiedDate of when the script runs? For example, I modified some records in Salesforce and then ran the Sync. Inevitably it didn’t find any records because the record I modified had a modification date 1 minute less than when I ran the cron.

I ran the specific query in Workbench and sure enough 0 results.

Appreciate the help.

Jonathan, thank you for generosity of time and information. I do have a WordPress developer I can lean on, so that might be might be might next step. Just one last clarifying question. Is it correct to assume that if I’m only pulling records from Salesforce that the record doesn’t have to first exist in WordPress? And if it does exist in WordPress can I use ‘Prematch’ on an unique id like user id to ensure I’m updating an existing record and not creating a new one?

I’m at a loss. Here is what I’m doing. I have a custom post type I created called ‘team’. The ‘team’ cpt stores user meta and has fields for wp_user_id and sf_contact_id. So no, I’m not using wp_usermeta with the Contact ID.

The ‘team’ record is created from a Gravity Form which successfully stores both the wp_user_id and sf_contact_id. The Gravity Form also syncs with Salesforce through Gravity Forms for Salesforce successfully.

All changes should happen in Salesforce and get pulled into the ‘team’ table (source of truth) moving forward. No changes should occur in the ‘team’ table.

Using the sf_contact_id, I am setting up Object Sync to pull updates from Salesforce into the ‘team’ object in 30 minute asynchronous requests. However, no matter what I do, nothing is syncing. I have removed the Prematch option but am using sf_contact_id as the Salesforce Key.