jaysitcc
Forum Replies Created
-
Forum: Plugins
In reply to: [Object Sync for Salesforce] SF Custom Object => WordPress UsersThank you for your prompt response, Jonathan.
LOG message on create:
Success: Update WordPress user with ID of [WP ID] (Salesforce [objectName] Id of [Salesforce
ID)1. I’m not receiving a ‘create’ log like I am for the corresponding post, just a log with update user #ID.
2. Searching the ID returns an invalid user ID error.
3. No error logs in wp/error-logs or Cpanel=>metrics=>errors (It’s very likely I’m looking in the wrong place)
4. phpMyAdmin table does not create a wpny_users entry. But it is creating a wpny_object_sync_sf_object_map row for the POSTS using the same ID it references in the logs for the user Update.
Thank you for your time.
*excuse my ignorance…
OFFSET is just negating the first (x) records that match?
The query
SELECT Id, Email from Contact WHERE LastModifiedDateWould naturally sort this is descending chronological order, right? So it will always pull (up to) the last 2000 records that were modified.
So this example request would call Contact, and query the last 2k records that were modified (regardless of the fields that need to be mapped in the plugin)
Thanks @jonathanstegall,
Just want to recap the API…am I understanding this correctly?
– 1 API call per {schedule}
-example – so at {schedule = 6 minutes} 10(hour)*24(hours in day) = 240 API calls per day?
– # of Updated records in {schedule} cannot exceed more than 2000
My issue has been fixed. But I thought I would share a few things (and ask a question while I’m at it)
1. Running the schedule every (2) minutes instead of every (1) minute seems to have fixed the issue.
2. DO NOT attempt to map two separate post types in WP with the same object in SF. The plugin seems to create the same post ID for each entry which was likely causing the error.
Question for you! – When this plugin runs on the schedule. Is it a single API call to SF? Or is it (1) call per updated record? Because SF imposes limits on the API this is good information to know so the plugin doesn’t stop working suddenly due to going over the API limit your SF environment.
OK….update?
Not sure what I did, but I’m receiving success logs now (yay progress)
Here is what is strange. I’m trying to pull SF records to drafts in WP. I created two flows to try and debug this issue which are both mapped to the same object in SF, but with separate post types in WP.
*If the log entry is “Success Update WordPress (post)” – The plugin is working and the post is created.
*If the log entry is “Success Create WordPress (post) . There is NO data in WP. As far as I can tell this log entry is invalid.
Hi @jonathanstegall,
Is this anything in particular I should be looking for with regards to the cron issue?
My cron is scheduling other tasks just fine, and there don’t appear to be any issues with other plugins on my site accessing it.
Is there any other information I can provide you with that may help?
Forum: Plugins
In reply to: [Object Sync for Salesforce] Field Mapping issueOK.
I thought about this a bit more…If you’re more handy on the SF end of things and want to steer clear of using dev hooks…you may be able to workaround it. (this is assuming you want to keep the relationship between Contact and Account)
1. create a custom object (let’s call it Contact2)
2. map your current ‘Contact’ object over to it via the dataloader. (if you don’t have many custom fields in ‘Contact’ that you need to map, don’t worry about this step)
3. Remove the required default dependency on the related account on ‘Contact2’ (but keep the field relationship)
4. Add a child relationship on ‘Accounts’ for ‘Contact2’
5. Create TWO workflows with the Object Sync for Salesforce.
1. Create the ‘Contact2’ record.
– Map an ACF_meta field with the ‘Contact2’ ID
– Have the record update via a flow/process in Salesforce -> Object Sync for Salesforce Updates the ACF_meta field with the ‘Contact2’ ID
2. Create the ‘Account’ Record via separate field mapping on User WP
– Have the ‘Contact2’ ID mapped to the Account relationshipDisclosure- I have NOT attempted this personally, and I cannot guaranty it will work. I’ll cross my fingers for you if you wish to attempt it. =)
- This reply was modified 7 years, 3 months ago by jaysitcc.
Forum: Plugins
In reply to: [Object Sync for Salesforce] Field Mapping issueI see. Hopefully one of the developers see’s this because what I’m about to say COULD be incorrect…I’ve never tried to use the plugin this way, and I actually have some support requests in as well at the moment…so this is just a theory/my two cents.
This plugin by default maps ONE object in SF to ONE (post-type, tax, etc.) in WP. The ‘Contact’ record you are trying to create from the User panel requires a related ‘Account’ in order for SF to create the ‘Contact’ record.
*If the ‘Account’ record is already created in SF, and your fields are already mapped, SF can create the ‘Contact’ and related it to the ‘Account’.
https://i.imgur.com/vt9tOOC.png is a screenshot showing that the Account Relation is required in SF.
—–
There are posts on this forum about Related Object Requirement Mapping using developer hooks
Forum: Plugins
In reply to: [Object Sync for Salesforce] Field Mapping issueHi @shwky
Based on my limited experience here, the following things would help diagnose your issue.
1. *Check your DB Table (mysql or equivalent) – Log into your PHPmyadmin and see if the following tables
* object_sync_sf_object_map
* object_sync_sf_field_maphave been created (screenshot below for your convenience)
2. Is it WP-cron? – Download this plugin (Wp Crontrol)
Then
1. Go to the scheduling tab and re-save the settings >> https://i.imgur.com/rZCUh2t.png
2. Check {{yourdomain}}/wp-admin/tools.php?page=action-scheduler and {{yourdomain}}/wp-admin/tools.php?page=crontrol_admin_manage_page to see if there are any cron events scheduled for the object-sync-for-salesforce plugin.
3. Check (Process asynchronously) under the ‘Field Maps’ tab on the Object Sync For Salesforce plugin – https://i.imgur.com/8ySgM3p.png
*Regarding your LOG – Turn on Debug mode and see if the plugin creates logs for API events with SF – https://i.imgur.com/HREZkDi.png **Note, my log isn’t functioning as intended either, but I was able to find events in my RAW ACCESS LOG on my server that ‘seem’ to correspond to the plugin (it’s hard for me to tell)
Forum: Plugins
In reply to: [Object Sync for Salesforce] Sorry, you are not allowed to access this page.No problem. I’m happy to help!
Forum: Plugins
In reply to: [Object Sync for Salesforce] Sorry, you are not allowed to access this page.Not sure if this will help or not…
I had the same issue with version 1.7 after trying to reinstall it. I was able to get past this by going to
https://wordpress.org/plugins/object-sync-for-salesforce/advanced/ and installing the 1.6 version (see screenshot below)
After installing 1.6. I updated via the wordpress plugin panel to 1.7 and I was able to access the page.
Hope this helps!
Jonathan,
Thank you for your prompt reply, and for all of the other valuable information you have posted here (I’ve learned a lot in my failed efforts to fix this because of you).
Cron Events does not show anything after re-saving the scheduler
Here are the list of Cron Scheduled Actions (last time it was successful was 1/16/2019)
Here is the last time it failed (1/16/2019)
No entries after this…is it strange that the Scheduled date is 5 weeks prior to the log? These entries were created on 1/16/2019….so why are they scheduled for 12/23/2018
My host’s cron (through WHM) doesn’t show any pending jobs either.
Regarding 2 — Is there anything in particular I should reach out to my host regarding ‘cron issues’, assuming this is the step I need to take?
Continuing down the rabbit hole—
I found a post here that mentioned the plugins reliance on cron https://wordpress.org/support/topic/scheduled-sync-not-running/
GREAT INFO
So I confirmed with the cron manage plugin, and in my c-panel, that there are no cron jobs queued.
****
___If this is the ‘only’ issue that is occurring. How do I manually adjust the settings of cron to permit OBJECT SYNC FOR SALESFORCE to initialize a cron job?
****–Continuing Further–
If I turn DEBUG Mode ON, log is generated API HTTP requests to Salesforce
In the request I can see the objects that is attempting to map (with code 200)…so no error
For example I can plainly see every ‘picklist’ value for a field on the object I am attempting to map.
—Continuing this support request based on other posts I have seen here:
* I Have uninstalled (with removing all data from plugin) 1.7 from my WP, and installed 1.6 (which was the last working version). The error seems to persist even when downgrading to 1.6
I can confirm that BOTH
object_sync_sf_field_map
AND
object_sync_sf_object_map
Tables have been created in my DB.
So the plugin is successfully creating the tables, and syncing with SF. BUT it doesn’t seem to be updating the tables based on records that are created in SF, and isn’t logging errors.
Any ideas on what is happening?
