(Solved)Dashboard Calendar Widget woes OTRS 5.0.4

[jnelson]

Hello all! I'm trying to enable the Events Calendar widget. I've followed the steps in the online manual, as well as looked through a couple threads here with no luck.

http://otrs.github.io/doc/manual/admin/ ... .8.7.2.5.1

I was getting this error in the logs:

Thu Jan 7 15:23:04 2016 error OTRS-CGI-93 Search not executed due to invalid value '1970-01-01 00:00:00' on field 'TicketCalendarStartTime'!
Thu Jan 7 15:23:04 2016 error OTRS-CGI-93 The value for the field Date is in the past! The date needs to be in the future!

So I followed the Date/Time fix instructions here: viewtopic.php?t=23395 editing the file 'EventsTicketCalendar.pm' in /opt/otrs/Kernel/Output/HTML/Dashboard and changing the code to this:

Code: Select all

    my $EventTicketFields  = $ConfigObject->Get('DashboardEventsTicketCalendar::TicketFieldsForEvents');
    my $EventDynamicFields = $ConfigObject->Get('DashboardEventsTicketCalendar::DynamicFieldsForEvents');

    my %DynamicFieldTimeSearch = (
        'DynamicField_' . $StartTimeDynamicField => {
            GreaterThanEquals => '1970-01-01 00:00:01',
        },
        'DynamicField_' . $EndTimeDynamicField => {
            GreaterThanEquals => '1970-01-01 00:00:01',
        },

and now my log errors are this:

Fri Jan 8 07:58:15 2016 error OTRS-CGI-93 Search not executed due to invalid value '1970-01-01 00:00:01' on field 'TicketCalendarStartTime'!
Fri Jan 8 07:58:15 2016 error OTRS-CGI-93 The value for the field Date is in the past! The date needs to be in the future!

When I create a new ticket it shows the proper dates in the future in the ticket zoom:

TicketCalendarStartTime:
01/09/2016 12:15
TicketCalendarEndTime:
01/09/2016 15:33

and it's in the proper queue:

Queue:
Internal::Calendar

Here is a screen cap of the settings at Frontend::Agent::Dashboard::EventsTicketCalendar:

OTRSCalendarSettings.JPG

Anyone have any ideas or areas to look? I did find one other setting in Frontend::Agent::Dashboard::DashboardBackend###0280-DashboardEventsTicketCalendar the Default Key was set to '0' and I changed it to '1' with no apparent effect.


Here's the Dynamic Fields screen:

dynamic fields.JPG

and a snip from NewEmailTicket showing the fields:

dynamic fields1.JPG

[RStraub]

Did you try selecting the dates? without a checked checkboxes the values aren't saved to the ticket.

[jnelson]

Yes. Made sure that start time and end time were correctly entered.

[jnelson]

Here's an example ticket I just made (RIP David)

calendarticket.JPG

The time/date section copy/paste.

TicketCalendarStartTime:
01/11/2016 12:00
TicketCalendarEndTime:
01/11/2016 15:00

Notice it's in the future (currently 9am) and the EndTime is past the StartTime

[jnelson]

Disregarding other peoples advice and actually rebooting the host OS. Voila it works.