→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Peter_Riederer
Engaged Sweeper III
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
4 REPLIES 4
kachmar
Engaged Sweeper
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
Engaged Sweeper III
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
Engaged Sweeper II
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
Engaged Sweeper II
Same here! We are trying to do the same. It'd be very helpful..

Best Regards
Fabio