Export Feature OTRS 3.3

Moderator: crythias

Locked
Volkmar
Znuny newbie
Posts: 1
Joined: 26 Apr 2016, 14:25
Znuny Version: OTRS 3.3
Real Name: Volkmar
Company: ExempTec

Export Feature OTRS 3.3

Post by Volkmar »

Hello, I am rather new to OTRS, so excuse the hopefully not too obvious question.

We are running OTRS productively already, but ran into a wall with a new project.
We need to export tickets of a certain kind (closed, certain fields and so on) into a XML file, but any filetype would be fine honestly - I'd just prefere XML.
Our OTRS does have an export feature, but it's unable to export tickets - COnfig Item and CustomerUser are my only options, so this is not enough.
I also did find promising stuff on GitHub, altough it looks like all those Export features cannot be used with a running system.
But we cannot afford to stop our servers for an update.
Statistics came to mind as well, but we need more information of the tickets than the statistics feature provides.
According to my admin, I also wont be able to get direct access to the database itself, so I cant just writte some SQL queries to get what i need from the source (Is this correct? If not, where does OTRS store its database?)

So, is there any chance to get my ticket information without stopping our servers?

Thanks a lot in advance
wurzel
Znuny guru
Posts: 3274
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Export Feature OTRS 3.3

Post by wurzel »

Hi,

without getting access to your database you are stuck to the OTRS features.

You might get a Webservice running. As far as I know you get xml data from it. All Ticket function.
@developpers: please correct me, if I am wrong.

check here for dev information
http://otrs.github.io/doc/api/otrs/stab ... ch.pm.html

Florian
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Locked