Import Company's into OTRS Ticket System (CSV)

[jonathanb]

Hello everyone,

I have made an export from our CMS system where our customer information is located. In the CSV export I have all of our customers which I want to import into the OTRS ticket system. Our OTRS ticket system is on a Windows 2008R2 server. My question is if it's possible to import my CSV file and if it is possible how can I do it.

So in short:
1. I have a CSV file with my customers company's.
2. Is it possible to import that to OTRS ticket System?
3. How can I do that?

Thank you in advance.

---
Jonathan

[crythias]

I have made an export from our CMS system where our customer information is located.

It might be better to simply directly query your CMS from OTRS.

2. Is it possible to import that to OTRS ticket System?

Well, yes and maybe.
OTRS by default works on tickets with Customers as Individuals. If Company Support is enabled, the customers can be assigned a Company, but that assignment is optional. Customers within the same Company should have the same CustomerID (Company Identifier), but they will have individual logins.

"Yes", it is possible to import, but "maybe" it would be better to manage *one* list that is managed in one location (your CMS).

3. How can I do that?

http://doc.otrs.org/3.1/en/html/custome ... ckend.html
The whole page is relevant. Pay attention to the section on multiple backends.

But I really want to import!

viewtopic.php?f=62&t=12410#p50584

[jonathanb]

Thank you crythias for your reply.

It might be better to simply directly query your CMS from OTRS.

I wish that this could be done, but we use Accountview and it hasn't got a SQL database. It uses database files which aren't recognized by programs like OTRS.

With some luck I will get this done with the links that you provided. Thanks! I'll update the post when there is more info.

---
Jonathan

[crythias]

It uses database files which aren't recognized by programs like OTRS.

Like foxpro/dbf? http://search.cpan.org/~janpaz/DBD-XBas ... D/XBase.pm