Migration from Autotask

[Safron]

Forgive me if this topic has already been posted...

Basically Ill get to the meat of this; is it feasible to take the information from a .bak file from Autotask and import into OTRS? I just wanted to know if I'm going to hit a wall before I spend a week's time on this.

My idea was to export from SQL Server to CSV or into an Excel spreadsheet to get a more universal format.

Thank you for your thoughts,


-Safron

[jojo]

what kind of information?

but basically you can not import most data from other systems

[Safron]

The information would be addresses, phone numbers, client names, billing information, past tickets etc. It was exported in a .bak file from what I was told from a MS SQL database by the Autotask Company. I was able to open it up using MS SQL Server Management Studio no problem but there appears to be hundreds and hundreds of tables. Far too much to go through manually which is what I'm afraid I will have to leave this company to do, since I take on a new job in 13 days.

[jojo]

as the data tables are not compatible import is not possible.

[Safron]

Do you think that if I can export this to a CSV or Excel spreadsheet would OTRS be able to bring that in?

[jojo]

this might work for agents, status and some customer data but not for tickets.

Also you need to analyse data sturctures of both systems

[crythias]

Safron, no.
impossible import is impractical.

Imagine: You're already talking about the source having "hundreds and hundreds of tables"

In order to convert, you'd have to create customers, queues, agents, priorities, services, types, and anything else that is analogous to the source.
Then, you'd need to create tickets and assign said customers, queues, agents, priorities, services, types, etc ...
Then you'd need to create articles and article types and attach them to the newly created tickets from analogous source materials.

Could it be done? Sure. But not like you'd expect from "Can I import from csv?" and certainly not something this forum should be able to provide.

[Safron]

Thank you Jojo and Crythias for weighing in on this. I had no experience with OTRS before today and you saved me an enormous amount of time. Much appreciated.

[jojo]

well this is not OTRS specific. You can not just export data from one system and import into a totally different one...