fortafy

1. Record and record id are confirmed to exist in Salesforce. I’ve copied the Salesforce ID I’m using and pasting into Saleforce URL.

2. I have it set with the exact same settings as another custom post type that is working. The one that is working, however, is on Accounts (not Contacts) and it has record types. My Contact does not have any custom Record Types (using Master).

3. Where would I find filters? Are you referring to the Direction?

‘team’ is the custom post type. on the team record I have WordPress User ID and Salesforce ID.

Thanks Jonathan. I will seek out a developer to build this. Getting alerted when there’s a mapping error is a definite need — whether an email or something with the WordPress dashboard. Currently it’s a daily reminder to go make sure nothing unexpected happened.

How much would you charge to develop this into the product? I use Object Sync in multiple environments and this would be very, very useful. Thanks.

@jonathanstegall Thanks for responding. We finally worked through all the issues and I believe we’re up and running. Effectively, here are the things that occurred:
1. Upon install the wp_object_sync_sf_field_map table was not created
2. We manually created the wp_object_sync_sf_field_map table from your documentation but pull_to_drafts was a missing field from the mysql statement
3. We manually created the pull_to_drafts field
4. We deselected ‘Process asynchronously’ and finally it started working

Thanks again for responding. We use your plugin quite a bit. Time to donate!

Okay, did some more testing. I turned off the ‘Process asynchronously’ setting for the field mapping, made an update in Salesforce, and voila! Record syncd as expected. I’ve had this issue occur on another project as well.

PHP ERROR LOGS

[01-May-2021 12:35:20 UTC] WordPress database error Table 'pantheon.wp_object_sync_sf_field_map' doesn't exist for query SELECTid,label,wordpress_object,salesforce_object,salesforce_record_types_allowed,salesforce_record_type_default,fields,pull_trigger_field,sync_triggers,push_async,push_drafts,pull_to_drafts,weight,version`
FROM wp_object_sync_sf_field_map made by require_once(‘wp-admin/admin.php’), do_action(‘settings_page_object-sync-salesforce-admin’), WP_Hook->do_action, WP_Hook->apply_filters, Object_Sync_Sf_Admin->show_admin_page, Object_Sync_Sf_Mapping->get_fieldmaps`

As a note, I’ve added the field ‘push_drafts’ to the table but it still is throwing errors.

[01-May-2021 15:07:05 UTC] WordPress database error Unknown column <strong>'pull_to_drafts'</strong> in 'field list' for query SELECTid,label,wordpress_object,salesforce_object,salesforce_record_types_allowed,salesforce_record_type_default,fields,pull_trigger_field,sync_triggers,push_async,push_drafts,pull_to_drafts,weight,versionFROM wp_object_sync_sf_field_map made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, Object_Sync_Sf_Salesforce_Push->add_actions, Object_Sync_Sf_Mapping->get_fieldmaps

However, the field ‘pull_to_drafts’ does exist in the table wp_object_sync_sf_field_map