[otrs] Re: Getting customer data in to OTRS, fields for address, OS, postcode etc?

Mike Dent schrieb:

On 5/8/07, Shawn Beasley wrote:

...

Mike Dent schrieb:

...

Hi, I'm new to OTRS, so please forgive me, I've been using RT for a couple of years but it lacks some features which I hope otrs can help with.

I'm currently trying to see how to set up customers (they dont need web access to otrs) in otrs. I can export my tickets from RT and create a CSV with names, email, address etc. Can I import this in to OTRS? Can I then add custom fields, so that when a new customer is added (usually over the phone) I can populate these fields?

Many thanks

Mike _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/

Check this out, with a little technichal understanding you will get it.

---I did :=)

http://doc.otrs.org/2.2/en/html/x1536.html#customer-backend-db

-Shawn

Shawn thanks for your reply. So am I right in thinking the only way to add custom fields for customers is to change the mysql database direct? And then edit one of the perl files?

How do I import 200 customers lets say in to the otrs customer database?

thanks again

Mike _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/

Mike, You can try the script included. I did it manualy in PHPMyadmin. And then as I found that I also needed more fields, I upgraded the information later (as well manually). The script can be found in $OTRSHOME/scripts and is called syncuser_csv2otrs.pl There are instructions included in the file. I hope this helped. --Shawn