Export Ticket Details

Moderator: crythias

Locked
ChrisMachnicki
Znuny newbie
Posts: 40
Joined: 17 Jul 2013, 11:09
Znuny Version: 3.1.6
Real Name: Chris
Company: The Hut Group

Export Ticket Details

Post by ChrisMachnicki »

Hi All,
I was recently building a pyton script which automated an email using details from the DB and I hit a problem where the returned content of the ticket seemingly had a character limit and I could not extract all the details. I shelved this after looking for a while and assumed the details were being stored in blobs somewhere and outside the scope of what I can and cant do.

As we are in the process of moving away from OTRS to a paid for solution - the question has been raised again about how we can migrate the content and history of tickets into the new system maintaining both a history and some sort of redamentary reporting.

Is this possible? If so how?

Thanks
OTRS 3.3.8 & KIX4OTRS 6.06 in both test and live. MySQL 5.1.52 on Red Hat Enterprise Linux Server release 6.0
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Export Ticket Details

Post by reneeb »

It's possible, but that requires a lot of development. You have to map fields from OTRS to the fields in the other solution, you have to ensure that queues, states, users, ... already exist.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
ChrisMachnicki
Znuny newbie
Posts: 40
Joined: 17 Jul 2013, 11:09
Znuny Version: 3.1.6
Real Name: Chris
Company: The Hut Group

Re: Export Ticket Details

Post by ChrisMachnicki »

The mappings aren't a problem. I did it when I upgraded otrs and at the same time cleared it out of 4 years worth of crap. Whilst all the states, types, etc. aren't a problem it's the content of the tickets that are (these weren't an issue when migrating tot he same system)
OTRS 3.3.8 & KIX4OTRS 6.06 in both test and live. MySQL 5.1.52 on Red Hat Enterprise Linux Server release 6.0
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Export Ticket Details

Post by reneeb »

For all details, there are API methods http://otrs.perl-services.de/docs/. Use them...

* TicketGet
* ArticleGet
* HistoryGet
* ArticleAttachmentIndex
* ...
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
ChrisMachnicki
Znuny newbie
Posts: 40
Joined: 17 Jul 2013, 11:09
Znuny Version: 3.1.6
Real Name: Chris
Company: The Hut Group

Re: Export Ticket Details

Post by ChrisMachnicki »

Is there a guide for setting up and using the API? I've used basic rest calls before with an addon client but only following the instructions of the application owners.
Where would I enter these -
my $Result = $OperationObject->Run(...
OTRS 3.3.8 & KIX4OTRS 6.06 in both test and live. MySQL 5.1.52 on Red Hat Enterprise Linux Server release 6.0
Locked