OTRS Import / Export Template Script

[Peter_Riederer]

Hello,

we are going to switch from OTRS to Lansweeper Helpdesk soon. I was wondering if someone already has a migration script to export Tickets from OTRS and a maybe a SQL-Script or CSV-Template to import them into Lansweeper?

Thanks a lot in advance.

Regards

Peter

[kachmar]

Help Desk Migration service offers a simple and ready-to-use solution for OTRS to Lansweeper export. You can move all your records from OTRS to Lansweeper in just a few clicks. They also offer a free demo migration to see how your data will move between the systems. Check it out!

[Peter_Riederer]

Hey Fabio,

thanks a lot, will try it, also wanted to do some experiments the next day, cause we want to start in january with lansweeper helpdesk.

Regards

Peter

[girimonte]

Hi Peter

Here is the SQL Code to export your Tickets from OTRS:

SELECT article.ticket_id, article.a_subject, article.a_body, article.create_time, article.a_from, ticket.customer_user_id, ticket.customer_id, ticket_priority.name, ticket_state.name, queue.name, article.a_cc
FROM article
RIGHT JOIN ticket ON (ticket.id = article.ticket_id)
RIGHT JOIN ticket_priority ON (ticket_priority.id = ticket.ticket_priority_id)
RIGHT JOIN ticket_state ON (ticket_state.id = ticket.ticket_state_id)
RIGHT JOIN queue ON (queue.id = ticket.queue_id)
ORDER BY article.ticket_id

I recommend to work at the beginning with the limit Function... You need to modify the csv file just like the csv import Template from Lansweeper.

Greetings
Fabio

[girimonte]

Same here! We are trying to do the same. It'd be very helpful..

Best Regards
Fabio