How do I export my Tickets from OTRS 5 to CSV

psharer4062 · Post by **psharer4062** » 25 Oct 2018, 23:05

I need to know how to export my ticket database to csv. Any and all help would be appreciated.

Post by **root** » 26 Oct 2018, 08:22

Hi Paul,

There is no builtin way in OTRS to export tickets as CVS. What's the use case?

- Roy

psharer4062 · Post by **psharer4062** » 26 Oct 2018, 14:49

Thanks for your response, the company I am currently working for is shifting ticketing software and needs to get all of the current database tickets from OTRS into a csv file to be able to import them to the new software.

Post by **root** » 26 Oct 2018, 15:01

Hi,

This will be a challenge, think about newlines in articles, how do you like to present the unknown numbers of articles for each ticket? Any idea how the CVS should look like?

- Roy

christianclavet · Post by **christianclavet** » 29 Oct 2018, 14:25

Hi, as mentionned there is no direct way to export the tickets in .CSV. But you could try to dump the MYSQL dB in CSV.
Found this article here:
https://www.electrictoolbox.com/using-m ... csv-files/

Znuny and ((OTRS)) Community Edition

How do I export my Tickets from OTRS 5 to CSV

How do I export my Tickets from OTRS 5 to CSV

Re: How do I export my Tickets from OTRS 5 to CSV

Re: How do I export my Tickets from OTRS 5 to CSV

Re: How do I export my Tickets from OTRS 5 to CSV

Re: How do I export my Tickets from OTRS 5 to CSV