by Rolustech

Boost your SugarCRM with seamless Google integration. Sync contacts, meetings, and Drive files. Streamline workflows and elevate productivity.

Free Trial

By clicking you consent to share your profile with the developer

#308 - Sync calendar

Closed Bug? created by francoiseric 10 years ago

Hello,

Once the sync module is installed I have problems with creating and syncing calendar events. When I try to create a task in the SUgarCRM Calendar, I get the error "Error saving".

Also as you can see in the log below, a calendar sync seems to fail. On a side note it seems to sync every minute even though I chose to sync it every 5 minutes.

Any idea?

Thanks

Fri Nov 29 22:00:02 2013 [17588][1][FATAL] STARTED: Drive sync: francois.eric@jarca.ca(francois.eric@jarca.ca) Fri Nov 29 22:00:02 2013 [17588][1][FATAL] GOOGLE-TO-SUGAR Fri Nov 29 22:00:02 2013 [17587][1][FATAL] STARTED: Calendar sync: francois.eric@jarca.ca(francois.eric@jarca.ca) Fri Nov 29 22:00:03 2013 [17587][1][FATAL] Meeting::save: Bad date 2013-12-04 17:00:00 for format Y-m-d H:i Fri Nov 29 22:00:03 2013 [17587][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngine QueueManager.php Fri Nov 29 22:00:03 2013 [17587][1][ERROR] fromUser: Conversion of from user format Y-m-d H:i failed Fri Nov 29 22:00:03 2013 [17587][1][FATAL] Job a7b3fbfa-2e04-5888-6c95-5299545855d3 (Sync Calendar) failed in CRON run Fri Nov 29 22:00:03 2013 [17587][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngine QueueManager.php Fri Nov 29 22:00:05 2013 [17588][1][FATAL] SUGAR-TO-GOOGLE Fri Nov 29 22:00:05 2013 [17588][1][FATAL] COMPLETED: Drive sync: francois.eric@jarca.ca(francois.eric@jarca.ca) Fri Nov 29 22:00:05 2013 [17588][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngine QueueManager.php Fri Nov 29 22:00:05 2013 [17588][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngine QueueManager.php Fri Nov 29 22:00:05 2013 [17588][1][FATAL] STARTED: Calendar sync: francois.eric@jarca.ca(francois.eric@jarca.ca) Fri Nov 29 22:00:06 2013 [17588][1][FATAL] Meeting::save: Bad date 2013-12-04 17:00:00 for format Y-m-d H:i Fri Nov 29 22:00:06 2013 [17588][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngine QueueManager.php Fri Nov 29 22:00:06 2013 [17588][1][ERROR] fromUser: Conversion of from user format Y-m-d H:i failed Fri Nov 29 22:00:06 2013 [17588][1][FATAL] Job b09559ee-5bfe-b620-ee56-5299548b88f3 (Sync Calendar) failed in CRON run Fri Nov 29 22:00:06 2013 [17588][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngine QueueManager.php

  1. francoiseric member avatar

    francoiseric

    10 years ago

    Just to let you know, I tried uninstalling the module completely (with tables) and reinstalling it again. Once its uninstalled, I have no problems but when I install it again, the same problem persists.

    I have sugarcrm ce 6.5.16.

    Thanks

  2. francoiseric member avatar

    francoiseric

    10 years ago

    I also tried deactivating the Calendar Sync in the GSync options. Now I still get errors when I modify the calendar events but its easier to pinpoint the error message which is:

    Sun Dec 1 16:46:46 2013 [20662][1][ERROR] fromUser: Conversion of from user format Y-m-d H:i failed

    Anyway, not sure if any of this helps, but I'm letting you know what I find as I move forward.

  3. vetmike member avatar

    datasync

    10 years ago

    We are sorry to hear about your installation problems. Thank you so much for sharing your errors.

    1. First, we do want to make sure that you installed the correct package for your SugarCRM services. If your URL is (ex. francoiseric.sugarondemand.com) you would need the OnDemand Package. If (ex. francoiseric.sugarcrm.com), then use the OnSite package. Right now we don't have a way of tracking exactly what instance you downloaded (OnDemand or OnSite) so we apologize for this confirmation request.
    2. Double check the Cron job and make sure this is set up properly on your end as well?
    3. Please refer back to the Installation Guide https://www.sugaroutfitters.com/docs/gmail-sync/installation-guide to confirm that there were no missed steps.

    If all 3 above requests checkout correctly, we will open a ticket with our Developers to check deeper into your problem. In this case, they will need to have your SugarCRM URL with an Admin User Name & Password to access the download. This can be emailed to us at modulesales@datasyncorp.com .OR, we can schedule a GoTo meeting for screen sharing. (English preferred language) Let us know what would work best for you.

    Thank you, DataSync ModuleSales Team

  4. francoiseric member avatar

    francoiseric

    10 years ago

    Hello, 1) Thanks for your answer. Just to make sure I uninstalled the package, redownloaded the on site version (version 20131118) and reinstalled from scratch 2) Yes here is the cron of my www-data user: * * * * * cd /var/www/sugarcrm; php -f cron.php > /dev/null 2>&1. The www-data user is the php and apache user. Everything under /var/www/sugarcrm is under ownership of www-data 3) I reinstalled everything following the guide step by step.

    I still have the same problem. Yes I would like to schedule a GoTo meeting. Let me know how you wish to procede. I am available all day today. English is perfect.

    Thank you, François

  5. vetmike member avatar

    datasync

    10 years ago

    Thank you, Let me have our Developer take a look at your case & we will be back in touch soon. If a GoTo Meeting is required after our research, we will be sure to schedule this immediately DataSync ModuleSales Team

  6. francoiseric member avatar

    francoiseric

    10 years ago

    Hello, Do you have any idea of the timeframe to look into my problem. I don't want to put any pressure but I have to uninstall the module in the meantime because my whole calendar is not working.

    Thank you.

  7. vetmike member avatar

    datasync

    10 years ago

    Thank you for your patience on this. This is what our Developer said. "I have looked into this ticket but couldn't find anything in log which can help us out. I need to debug this issue by logging into their system. Let me know if they can give us access to their system or we have to do a GoToMeeting session with them."

    I am not sure of your timezone but I do believe a GoToMeeting w/the Developer is the most logical next step. DataSync will send you a separate invite with the LOGIN information. Please reply immediately if the date & time does not work for you. Thank you- DataSync Module Sales Team.

    • francoiseric member avatar

      francoiseric

      10 years ago

      Thank you. I have accepted the meeting and will be available at the scheduled time.

  8. rolustech-primary-contact member avatar

    Rolustech Verified Purchase

    10 years ago

    Hi, As we had a long discussion on email and resolved your issues except contacts sync. And we suggest you to take a look into this ticket www.sugaroutfitters.com/support/gmail-sync/355 and follow necessary steps ,may it helps you. Let us know if you still have any issue

    Thanks, Support

  9. francoiseric member avatar

    francoiseric

    10 years ago

    Hello,

    I have tried the above link but the SSL is already not forced.

    Here is a resume of all the problems I am encoutering right now: 1) Calendar not syncing at all for user jp.harvey@jarca.ca (Reason: Bad Authentication) 2) Events for which a user is invited are not synced to Google Calendar. For example if JP invites François to a meeting, François will see the event in his SugarCRM calendar but will not see it in the Google Calendar (the log does not give an error message). The event is just not synced. 3) Contacts not synced: No contacts are synced for any user. We only wish to activate the Sugar->Google sync but it does not work.

    I have to say that this is getting frustrating as I like the concept of your project since it has what I desire but it just doens't work.

    François

  10. rolustech-primary-contact member avatar

    Rolustech Verified Purchase

    10 years ago

    Hi, We have conducted meeting and All other issues has been resolved except 3rd one . We are trying to trace this issue using backup and will update you soon.

    Thanks

  11. rolustech-primary-contact member avatar

    Rolustech Verified Purchase

    10 years ago

    Hi, This issue has been resolved. If anyone else facing this issue in their contacts module can get help from following

    1. Login to your Google apps admin account
    2. Point your browser to https://admin.google.com/AdminHome#ServiceSettings/service=Contacts&notab=1
    3. Unmark checkbox "Enforce SSL" in front of Contacts APIs
    4. Press save changes

    After following above instructions update/create any contact in sugar and wait for scheduler to run and then check it should be synced.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Been trying to get this to work for two weeks. Very little support. I hope it works but to this day, it does not." - meyerwells

    Read More Reviews