Where is the calendar with the marked dates of holidays and days off?

Moderator: crythias

Post Reply
andrewkochn
Znuny newbie
Posts: 3
Joined: 05 Sep 2018, 17:25
Znuny Version: 6.0.4

Where is the calendar with the marked dates of holidays and days off?

Post by andrewkochn »

Hi

We make a report on QlikView.
In order to understand the expired application or not, we need to take into account the production calendar.

The question in which table of the OTRS 6 database is a calendar with marked dates of holidays and holidays?

Or are these data stored in the OTRS itself in files, but are not they in the database?

Thank you
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Where is the calendar with the marked dates of holidays and days off?

Post by root »

Hi,

There is not own table for this. Calendar setting are System Configuration settings. Since OTRS 6 these settings are store in the database but not really usable in queries. Why don't you use a report (TicketList) containing all calculations and use this a a datasource for QlikView?

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
andrewkochn
Znuny newbie
Posts: 3
Joined: 05 Sep 2018, 17:25
Znuny Version: 6.0.4

Re: Where is the calendar with the marked dates of holidays and days off?

Post by andrewkochn »

root, thank you for your prompt response

Sorry for the long answer.

The point is that we have configured the QlikView connection directly to the OTRS database. I.e QlikView receives the necessary data from the database.

We had difficulties at the stage of determining when to consider the ticket as "overdue".

Answering your question. You can try to upload the report file from OTRS and QlikView will take data from this file, but the report in QlikView will in this case not be automatic. Since TicketList will have to be unloaded manually (or modify the OTRS core, which is difficult). In addition, I would like to have one source - the OTRS database.
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Where is the calendar with the marked dates of holidays and days off?

Post by root »

Hi,

You won't get the result you like as easy as you expect. I you insist if the OTRS database as a datasource I see only one approach which isn't very hard to implent:
  • Create a ticket list report containing all data you need
  • Run this report via cron on a regular base creating a csv file
  • Take this file and create/update a table from it
  • use this table for QlikView
- Roy

P.S. That's the value in the database for the setting TimeWorkingHours::Calendar1

Code: Select all

Fri:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Mon:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Sat: []
Sun: []
Thu:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Tue:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Wed:
- '8'
- '9'
- '10'
- '11'
- '12'
- '13'
- '14'
- '15'
- '16'
- '17'
- '18'
- '19'
- '20'
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
andrewkochn
Znuny newbie
Posts: 3
Joined: 05 Sep 2018, 17:25
Znuny Version: 6.0.4

Re: Where is the calendar with the marked dates of holidays and days off?

Post by andrewkochn »

root, thanks for the explanation.

That variant of the solution of the problem that you wrote us was considered.
But we came to the conclusion that it is easier to implement the production calendar directly in QlikView. There also to calculate the tickets that were overdue.
Post Reply