SugarCRM & Google Calendar integration problem

[swissblade]

Hello everyone!

I am using the MyCRM Connector Tool for Google Calendar module to integrate my installation with my Google calendar. However, I am facing a problem.
Even though the meetings, Calls & Tasks get successfully created in the calendar, the date defaults to 1-1-1970, indicating a malformed or missing date for the event.
The logs indicate that the date passed to the Google API is wrong, leaving me to think that some part of the code is messing up.
For your information, the google_calendar_plg.php file seems to be doing all the logic...

Since I started on this, I tried changing time formats (for my account, for the system and in the config.php file), but nothing happened.
I can post any part of the code if someone has any ideas about this. I would really appreciate your help, because after 5 days of snooping around, I am starting to not even recognize basic PHP functions anymore, and integration is critical for me...!

I am using SugarCRM ver 6.1.4 under a Windows 2008R2 machine, running the Default environment of a FastTrack Installer with MySQL.

Thanks in advance!

[modida]

Hi,

Are you solved your problem ?
I had the same problem and i found a solution.
If you want i can send you the modification to do in the google_calendar_plg.php code

[swissblade]

No, I was unable to find a solution for this yet.
All I could do is make the dates appear OK, but the time is always off, and no matter what offset I pass, it seems to be ignored...

I would appreciate it if you could send me the code by pm!!!

Thanks!

[modida]

Hi,

I just modify 2 lines in custom/include/Calls/google_calendar_plg.php.
My problem is that i had specified dd/mm/yyyy as date format in my user en general preference but the value store in sugar database was always in YYYY/mm/dd format.
In google_calendar_plg.php these 2 lines that swap date format from user preferences and so give a bad date.
I just desactivate this function by modifing the line 82 and 83 like this :

line 82 : date_start_in_db_fmt=$pd ; //$td->swap_formats($s["startDay"], $td->get_date_time_format(true, $current_user), $td->get_db_date_time_format());

line 83 : $date_end_in_db_fmt1=$bean->date_due ; //$td->swap_formats($bean->date_due, $td->get_date_time_format(true, $current_user), $td->get_db_date_time_format());


i hope that solution your problem

[swissblade]

Hey...Thanks!

That worked! Finally, I got to see dates in my calendar!!!
Any ideas on the time offset? All events are 3 hours behind!!!

Thanks again!

[blak3r]

Not familiar with the plugin but sounds like in your calendar it's displaying the GMT time instead of local time.

[modida]

Hi,

I had the same probleme with another instance of sugarcrm.
Does anyone find a solution for this problems of 3 hours behind ?

Thanks a lot

Modida

[tamit]

Hi,
I installed Google Calendar on my SugarCRM. It has been working ok. But something is wrong with hour! I don't know why?
For example:
In my SugarCRM, i selected 1pm on Log Call. Then, it has shown 6am on Google Calendar.
I also changed timezone. Can everyone help me this?

Thanks