Okay
  Public Ticket #3701215
Google Calendar does not show the correct time of the event created in Amelia
Closed

Comments

  •  2
    Karelia Carcasses started the conversation

    I’m using the Amelia plugin on my site to create appointments. When an appointment is made, an event is created in my employees’ Calendar (Collaborators). Everything was working fine until, without making any changes to the time zone settings in Worpress or in the Gmail Calendars, every time a reservation is made in the Gmail Calendar, the event appears one hour before the time indicated in the Amelia Calendar or in the interface that I have designed to create reservations.
    Note: I have not changed time zone settings and there was no time change in Mexico.
    Please help me find the reason why the Gmail Calendar shifts the indicated time to one hour before.

  •  1,500
    Uroš replied

    Hello Karelia,

    Thank you for reaching out to us.

    Amelia doesn't have any time zone settings, and it relies on WordPress' General settings. Here's how it works:

    All times in the back-end of Amelia will be shown exactly how you save them, so (for example) if your employee works from 09:00 - 17:00, or if there's an appointment from 09:00 - 10:00, that's how you will see them in the back-end.

    If you enable "Show booking slots in client time zone" in Amelia's General settings, though, that may not be what your customers see, depending on where they're located, and what your WordPress site has been configured.

    If this option in Amelia's General settings is disabled, all times on the front end will be the same as times in the back end. So, if your employee's work hours are from 09:00 - 17:00 in UTC+1, with this option disabled, regardless if your customer is in UTC+1, or in UTC+10 - they will still see times from 09:00 - 17:00, so if you have customers in multiple time zones, it's advisable to enable this option in Amelia's General Settings.

    Important: In order for Amelia to store correct appointment times in the database (which is almost always in UTC time zone), you need to edit the WordPress time zone to show the city you're in (or the city in your time zone), like this:

    3081614015.png

    This way, when Daylight Savings Time starts (or ends), the times will be adjusted accordingly and you won't have to worry about them anymore.

    If you save your Time Zone in UTC+/- format, you may experience issues with Daylight Savings Time:

    2232514789.png

    Explanation: When you configure the time zone to be "UTC+1" it will always be UTC+1. So, if we take Belgrade, Serbia as an example - without Daylight Savings Time, it is in UTC+1 time zone, but when Daylight Savings Time starts, Belgrade is in UTC+2. If you leave the time zone to be hard-coded to UTC+1, the times that your customers book on the front end will not be properly adjusted to what you see in the back end. 

    Example with UTC+1 configured: It is mid-summer, and Belgrade is in UTC+2. "Show booking slots in client time zone" is enabled, and a customer from Belgrade opens your website to book an appointment. The working hours of your employee are set from 09:00 - 17:00 (in UTC+1), but the customer sees them as 10:00 - 18:00. This is because the time zone is hard-coded in the back-end, while on the front-end it shows the time in UTC+2. So, a customer books an appointment for 10:00, and shows up at 10:00, while you expect to see them at 09:00.

    Please note: If you hard-coded the time zone, and you have booked appointments, once you switch the time zone in WordPress to your city, it will adjust the times in Amelia's appointments to fit the time zone your city is currently in. This happens because (as mentioned above) the times are saved in UTC in the database, and it's adjusted in the plugin programmatically. So, if you have a hard-coded time zone set to UTC+1, and someone booked an appointment for 09:00, that time is saved as 08:00 in the database. When you change the time zone to your city (which is now in UTC+2), the appointment time will be adjusted to the time saved in the database 08:00 + 2:00, so the appointment time will switch to 10:00. The only solution, in this case, is to manually modify the appointment times, but it's the only way to make sure your time zone is properly configured, and that the future appointments will be saved and displayed correctly both for you and your customers on the front-end.

    Summary: When you select the city you're in, in WordPress' General Settings, the system automatically calculates the Daylight Savings Time, and shifts the clock accordingly, so if you have any issues with what you see on the front end vs what you see in the back-end, always check the Time Zone in WordPress

    Kind Regards, 

    Uros Jovanovic
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  2
    Karelia Carcasses replied

    Hello, thank you very much for answering.
    I have reviewed the settings you mention and I have the WordPress time zone set to Mexico City and I also have the option you mention "Show booking slots in client time zone" activated. Fortunately, within Amelia Calendar and in the employee panel, the schedules are correct. The problem is that the reservation times are being displayed in Google Calendar one hour before the time indicated within Amelia. I have reviewed and the configuration of the Google Calendar of all my employees is set to the Mexico City time zone, just like in WordPress. This suddenly started happening about two months ago, without making any configuration changes in WordPress, Amelia or Google Calendar. I reiterate that it happens to all of my employees' Google Calendars.

  •  1,500
    Uroš replied

    Hello Karelia,

    Thank you for the update on this.

    Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.

    Kind Regards, 

    Uros Jovanovic
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Karelia Carcasses replied privately
  •  1,500
    Uroš replied

    Hello Karelia,

    At the moment, I can see the error message displayed for a Google Calendar.

    If you see an error in the top right, that says "Unable to connect to Google Calendar" when you enter your employee's profile, you probably already connected this employee to the Google Calendar, but (s)he dropped out.

    9761862658.png

    They usually drop out when the App you created in Google Developers Console is not published, so first access your Google Developers Console, and go to the OAuth Consent Screen. In there, make sure the app is published:

    1270691228.png

    After you do this, you'll need to access your database (via phpMyAdmin, or some other database management tool) and access the wp_amelia_providers_to_google_calendar table (please note that wp_ is the default database prefix, but on your end, it could be anything, so look for your_prefix_amelia_providers_to_google_calendar table). Delete all rows from that table, and after that, you should be able to connect your employees to the Google Calendar.

    2181616784.png


    Kind Regards, 

    Uros Jovanovic
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables