-
Display NameOLGA MARTOS LOZANO
-
Website
-
Member SinceJune 9th, 2016
-
Last SeenJanuary 25th, 2021
OLGA MARTOS LOZANO does not have any add-ons for sale.
-
Support October 13th, 2020 @ 11:30 am
Hello,
Is it possible, currently?
We have a very critical SugarCRM use case and we'd need to reach fields of a custom module from MailChimp.
We'd need to design the specific emails from MailChimp using those fields.
That custom module (Bookings) is related to Accounts but that relationship is 0-N (any account could have 0 or many Bookings).
So we can't create custom fields on Accounts to loading that fields.Please could you tell me please, if there is any solution using SugarChimp? or any workaround?
Thank you very muchBeatriz Reviejo
View Comment
Project Lead at redk Spain
-
Support September 25th, 2018 @ 8:20 am
Good morning,
I have any email and I should send feedback our customer.
Please, may you write me an email (breviejo@redk.net) and tell me how long would you need for compatible package implementing?
An estimated timing is enough, just I'd need to know the estimation to inform our customer.Thank you very much
RegardsBeatriz Reviejo
View Comment
Business Analyst and Product Owner in redk
-
-
Support September 20th, 2018 @ 10:52 am
Hi,
Any new?Thanks
View Comment
Beatriz Reviejo
Business Analyst and Product Owner in redk
-
Support September 19th, 2018 @ 3:34 pm
Hi,
Our customer is interested because they were using another kind of integration between Mautic and SugarCRM and currently it doesn't work.
They were looking for a new solutions and they've asked for your solution directly.
If you'd change the priority to high priority....How long should they wait before getting a compatible package for SugarCRM onCloud instances?Thank you and regards
Beatriz ReviejoBusiness Analyst and Product Owner in redk
View Comment
-
Support September 5th, 2018 @ 8:47 am
Hi Jon,
We've checked it and the MailChimp activities are already syncing from MailChimp to SugarCRM module. There're new records related to the actions/activities of the subscribers (clicks, opens or sends). It works :)
The problem is the sync of invalid emails. This action isn't syncing to SugarCRM.
Note: we shouldn't to activate the subscribers sync because we must to avoid the data updating in SugarCRM (Name, Surname, Address...)
So we think the execution of the following command is right:
SUGAR.App.api.call('CREATE',SUGAR.App.api.buildURL('SugarChimp/setting/subscriber_sync_enabled/0'),{},{}); Isn't it?We'd need keep activated the sync:
1- From MailChimp to SugarCRM, over the field of email in SugarCRM (invalid, refused emails mangement)
2- MailChimp activities into SugarCRM module
Also we'd need to keep disabled the subscribers data sync (Name, Surname, Address...) from MailChimp to SugarCRMIs it possible? If we don't solve this problem the customer won't use SugarChimp no more.
Any idea or solution?I hope you can help us
Thank you very much and regardsBeatriz
View Comment
-
Support August 23rd, 2018 @ 1:24 pm
Hi Jon,
It explains how the records sync to MailChimp and how the number of records is so low.
Now I understand everything :)You can close this case because I haven't any other question of this behaviour of the plugin.
I would like thank you for your time and help.Thank you very much, Jon
View Comment
Kind regards
Bea
-
Support August 22nd, 2018 @ 11:20 am
Hello Jon,
When the SQL was setup the number of records (leads whose should be sent to MailChimp) was 99 but after the first sync only a few subscribers were sent to MailChimp.
After the first sync, every hour and everyday the number of subscribers in MailChimp increases. Currently there are 65 subscribers.
I have one more example with another Target List.
In this case the number of records (result of my SQL) was 35 and the first sync only sent a few of subscribers. Currently this number increases because SugarChimp is sending small batches every hour yet.
In both cases if I check the SQL result (I have created reports in SugarCRM using those SQLs), I can see just a kind of update over those Leads (subscribers) => Modified Date of email field.
But checking those email addresses, they haven't been changed just their modified dates have beed changed.
Those dates are always 1 minute after the sync to MailChimp so I think is SugarChimp who changes those dates.
It looks like SugarChimp always sends small batches of subscribers or Is there other criteria to get the batch of data?
Perhaps, the scheduler is executed every hour but its during is a few minutes, isn't it?Thanks!!!
View Comment
Kind regards
Bea
-
Support August 21st, 2018 @ 6:44 am
Good morning Jon,
It looks like everything works fine :)
From last week, we have two list on SugarCRM and they're synced data to MailChimp via SQL.I've noticed than the sync happens every hour because the scheduler "SugarChimp - Smartlist" is executed on this frequency.
Also I've noticed the sync sends a stack of data every hour and those records are added to MailChimp list automatically.I've created two reports on SugarCRM to support my following of added records on MailChimp list and there I can see the block of data every hour:
- Why does it send a stack of data and not the all data?
- Which is the criteria to get the data stack? Because my SQL creates the main data stack but then the data are synced by blocks. Why?
- Could you explain me this behaviour, please? It would be great :)
Thank you very much for your help
Regards
View Comment
Bea
-
Support August 17th, 2018 @ 12:34 pm
Hi Jon,
Thank you very much for your instructions.
I'll try follow every step and I'll write you again with the result.Have a nice weekend
View Comment
Regards
Bea
-
Support August 16th, 2018 @ 12:14 pm
Hi Jon,
Finally I got to reach the "smart List" via UI, please look at this:
I've executed by url: http://62.97.109.190:88/#SugarChimp/layout/adminsmartlist
And there are 20 records. The last 11 records of this table are testings that we've done those two weeks.I have inspect the interface and I've seen the button for clearing this table is empty:
SugarChimp Queued Records _<!--<button class="sc-empty-table" id="sugarchimp">Empty Table-->_
And I've checked the code and I've seen the clearing of this queue is disabled on the code. Could you explain me the reason? It is right?
Which would be my next step?
Attached the sugarcrm.log trying to send data from SugarCRM to MailChimp by "SQL from SugarChimp":_Thu Aug 16 14:10:07 2018 [29728][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'sugarchimp'
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] SugarChimp:debug:1534421410: SugarChimp_Queue::queue_mailchimp_subscribers table_name: sugarchimp_mc
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts
Thu Aug 16 14:10:10 2018 [29728][1][DEBUG] SugarChimp:debug:1534421410: SugarChimp_Queue::queue_mailchimp_subscribers: batch insert sql: INSERT INTO sugarchimp_mc (id,mailchimp_list_id,data,date_entered,date_modified,deleted) VALUES (UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NzoibWFwcGluZyI7YTo0OntzOjg6IkNvbnRhY3RzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NToiRk5BTUUiO3M6ODoiSGFuZ2VsZGkiO3M6NToiTE5BTUUiO3M6NzoiQXNoeXJvdiI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjU6IkxlYWRzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo4OiJBY2NvdW50cyI7YToyOntzOjk6Ik5FVy1FTUFJTCI7czoxOToiYXNoeXJvdi5oQGdtYWlsLmNvbSI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO319fQ==','2018-08-16 12:10:05','2018-08-16 12:10:05',0),(UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo3OiJtYXBwaW5nIjthOjQ6e3M6ODoiQ29udGFjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo1OiJMZWFkcyI7YTo0OntzOjk6Ik5FVy1FTUFJTCI7czoyNDoibWlndWVsLmpvcmRhb0BneXBmb3IuY29tIjtzOjU6IkZOQU1FIjtzOjA6IiI7czo1OiJMTkFNRSI7czoxNjoiQ3Jpc3RpbmEgU2VycmFubyI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjg6IkFjY291bnRzIjthOjI6e3M6OToiTkVXLUVNQUlMIjtzOjI0OiJtaWd1ZWwuam9yZGFvQGd5cGZvci5jb20iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9fX0=','2018-08-16 12:10:05','2018-08-16 12:10:05',0)
Thu Aug 16 14:10:10 2018 [29728][1][INFO] Query:INSERT INTO sugarchimp_mc (id,mailchimp_list_id,data,date_entered,date_modified,deleted) VALUES (UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NzoibWFwcGluZyI7YTo0OntzOjg6IkNvbnRhY3RzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MTk6ImFzaHlyb3YuaEBnbWFpbC5jb20iO3M6NToiRk5BTUUiO3M6ODoiSGFuZ2VsZGkiO3M6NToiTE5BTUUiO3M6NzoiQXNoeXJvdiI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjU6IkxlYWRzIjthOjQ6e3M6OToiTkVXLUVNQUlMIjtzOjE5OiJhc2h5cm92LmhAZ21haWwuY29tIjtzOjU6IkZOQU1FIjtzOjg6IkhhbmdlbGRpIjtzOjU6IkxOQU1FIjtzOjc6IkFzaHlyb3YiO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo4OiJBY2NvdW50cyI7YToyOntzOjk6Ik5FVy1FTUFJTCI7czoxOToiYXNoeXJvdi5oQGdtYWlsLmNvbSI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO319fQ==','2018-08-16 12:10:05','2018-08-16 12:10:05',0),(UUID(),'e1e28f048d','YTozOntzOjc6Imxpc3RfaWQiO3M6MTA6ImUxZTI4ZjA0OGQiO3M6NToiZW1haWwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo3OiJtYXBwaW5nIjthOjQ6e3M6ODoiQ29udGFjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo5OiJQcm9zcGVjdHMiO2E6NDp7czo5OiJORVctRU1BSUwiO3M6MjQ6Im1pZ3VlbC5qb3JkYW9AZ3lwZm9yLmNvbSI7czo1OiJGTkFNRSI7czowOiIiO3M6NToiTE5BTUUiO3M6MTY6IkNyaXN0aW5hIFNlcnJhbm8iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9czo1OiJMZWFkcyI7YTo0OntzOjk6Ik5FVy1FTUFJTCI7czoyNDoibWlndWVsLmpvcmRhb0BneXBmb3IuY29tIjtzOjU6IkZOQU1FIjtzOjA6IiI7czo1OiJMTkFNRSI7czoxNjoiQ3Jpc3RpbmEgU2VycmFubyI7czoxMzoiTUVNQkVSX1JBVElORyI7aToyO31zOjg6IkFjY291bnRzIjthOjI6e3M6OToiTkVXLUVNQUlMIjtzOjI0OiJtaWd1ZWwuam9yZGFvQGd5cGZvci5jb20iO3M6MTM6Ik1FTUJFUl9SQVRJTkciO2k6Mjt9fX0=','2018-08-16 12:10:05','2018-08-16 12:10:05',0)
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '05874397d2' AND deleted=0
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '05874397d2' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '05874397d2' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '765b489df2' AND deleted=0
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '765b489df2' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '765b489df2' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '8812706746' AND deleted=0
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '8812706746' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = '8812706746' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'be278cb7a5' AND deleted=0
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'be278cb7a5' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'be278cb7a5' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'cdb3f31752' AND deleted=0
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'cdb3f31752' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'cdb3f31752' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd063c54264' AND deleted=0
Thu Aug 16 14:10:11 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd063c54264' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:11 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd063c54264' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd19f0bcbf2' AND deleted=0
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd19f0bcbf2' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'd19f0bcbf2' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'e1e28f048d' AND deleted=0
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'e1e28f048d' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'e1e28f048d' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'ece48cdd43' AND deleted=0
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'ece48cdd43' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'ece48cdd43' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'f5277d7167' AND deleted=0
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'f5277d7167' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'f5277d7167' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Retrieve SugarChimpMCList: SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'fadea88974' AND deleted=0
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] Limit Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'fadea88974' AND deleted=0 Start: 0 count: 1
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT sugarchimp_mc_list.* FROM sugarchimp_mc_list WHERE mailchimp_list_id = 'fadea88974' AND deleted=0 LIMIT 0,1
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] SugarChimp:debug:1534421412: SugarChimp_List::mark_other_lists_as_deleted: sql: UPDATE sugarchimp_mc_list
SET deleted_from_mailchimp=1
WHERE mailchimp_list_id NOT IN ('05874397d2','765b489df2','8812706746','be278cb7a5','cdb3f31752','d063c54264','d19f0bcbf2','e1e28f048d','ece48cdd43','f5277d7167','fadea88974')
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:UPDATE sugarchimp_mc_list
SET deleted_from_mailchimp=1
WHERE mailchimp_list_id NOT IN ('05874397d2','765b489df2','8812706746','be278cb7a5','cdb3f31752','d063c54264','d19f0bcbf2','e1e28f048d','ece48cdd43','f5277d7167','fadea88974')
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT mailchimp_campaign_id, name FROM sugarchimp_mc_campaign
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] SugarChimp:debug:1534421412: SugarChimp_Scheduler_MailchimpListToSugarCRM->run: checking sugarchimp_mc_cleaned_email queue for cleaned emails to process in queue
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:SELECT DISTINCT mailchimp_list_id AS mailchimp_list_id, name AS name FROM sugarchimp_backup_queue
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Contacts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Prospects
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Leads
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Accounts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Contacts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Prospects
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Leads
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_ece48cdd43|Accounts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Contacts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Prospects
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Accounts
Thu Aug 16 14:10:12 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads
Thu Aug 16 14:10:12 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_mc WHERE id='52c4ae26-a14d-11e8-ad47-9ed167c316be'
Thu Aug 16 14:10:13 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_e1e28f048d|Leads
Thu Aug 16 14:10:13 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_mc WHERE id='52c8d61b-a14d-11e8-ad47-9ed167c316be'
Thu Aug 16 14:10:13 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_site_url
Thu Aug 16 14:10:18 2018 [29728][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'sugarchimp'
Thu Aug 16 14:10:20 2018 [29728][1][DEBUG] SugarChimp:debug:1534421420: SugarChimp_Scheduler_SugarToMailchimp->delete_jobs delete the jobs that we just ran: DELETE FROM sugarchimp
WHERE
mailchimp_list_id = 'ece48cdd43' AND
name = 'AddWebhook'ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:20 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp
WHERE
mailchimp_list_id = 'ece48cdd43' AND
name = 'AddWebhook'ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:20 2018 [29728][1][DEBUG] sugarchimp_Setting::retrieve a setting value does not exist for sugarchimp_site_url
Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'sugarchimp'
Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarToMailchimp->delete_jobs delete the jobs that we just ran: DELETE FROM sugarchimp
WHERE
mailchimp_list_id = 'e1e28f048d' AND
name = 'AddWebhook'ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp
WHERE
mailchimp_list_id = 'e1e28f048d' AND
name = 'AddWebhook'ORDER BY date_entered ASC LIMIT 200Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup sql: DELETE FROM sugarchimp_batches WHERE DATE_ADD(date_entered, INTERVAL 7 DAY) < '2018-08-16 12:10:05'
Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_batches WHERE DATE_ADD(date_entered, INTERVAL 7 DAY) < '2018-08-16 12:10:05'
Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup->removed batches from the sugarchimp_batches table.
Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup sql: DELETE FROM sugarchimp_lock WHERE DATE_ADD(date_entered, INTERVAL + CONCAT(0, ':', 5) HOUR_MINUTE) < '2018-08-16 12:10:05'
Thu Aug 16 14:10:22 2018 [29728][1][INFO] Query:DELETE FROM sugarchimp_lock WHERE DATE_ADD(date_entered, INTERVAL + CONCAT(0, ':', 5) HOUR_MINUTE) < '2018-08-16 12:10:05'
Thu Aug 16 14:10:22 2018 [29728][1][DEBUG] SugarChimp:debug:1534421422: SugarChimp_Scheduler_SugarChimpCleanup->removed records from the sugarchimp_lock table removed._I think everything should be rightly configured so I attach the content of config table:
I hope you can find the issue.
Thanks a lot
View Comment
Bea
-
Support August 16th, 2018 @ 7:19 am
Hi Jon,
Following your instructions, I found some problems........
I get an error 500 if I try to execute "/layout/adminsmartlistqueue":
Here you can see the detail:
General:
Request URL: http://62.97.109.190:88/rest/v10/SugarChimp/adminsmartlistqueue
Request Method: GET
Status Code: 500 Internal Server Error
Remote Address: 62.97.109.190:88
Referrer Policy: no-referrer-when-downgradeResponse Headers:
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Connection: close
Content-Encoding: gzip
Content-Length: 20
Content-Type: text/html
Date: Thu, 16 Aug 2018 07:15:27 GMT
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Pragma: no-cache
Server: Apache/2.2.22 (Ubuntu)
Vary: Accept-Encoding
X-Powered-By: PHP/5.4.45-4+deprecated+dontuse+deb.sury.org~precise+1Request Headers:
Accept: application/json, text/javascript, /; q=0.01
Accept-Encoding: gzip, deflate
Accept-Language: es-ES,es;q=0.9,en;q=0.8,de;q=0.7,ca;q=0.6
Connection: keep-alive
Content-Type: application/json
Cookie: download_token_base=9edc971a-dc9a-23da-e0d7-5b75179a95df; PHPSESSID=9e9fd83c-4e48-a964-9826-5b751750b562
Host: 62.97.109.190:88
OAuth-Token: 9e9fd83c-4e48-a964-9826-5b751750b562
Referer: http://62.97.109.190:88/
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36
X-Metadata-Hash: a2fdc1597c026d75f20518c26719e5e3
X-Requested-With: XMLHttpRequest
X-Userpref-Hash: 0a6586f2a3806d0592927c908239aeacAlso if I execute the command: SUGAR.App.api.call('get',SUGAR.App.api.buildURL('Smartlist/setting/logger/debug'),{},{});
I get anr error too:/rest/v10/Smartlist/setting/logger/debug 404 (Not Found)
error: "no_method", error_message: "Could not find a route with 4 elements"}
error: "no_method"
error_message:"Could not find a route with 4 elements"
I'm sorry but I'm not able to check anything If I get those errors.
What could I do?Thanks
View Comment
Bea
-
OLGA MARTOS LOZANO has not rated any add-ons.
OLGA MARTOS LOZANO has not verified any add-ons.
OLGA MARTOS LOZANO has not created any Wanted Add-ons.
Keep up to date on the latest additions