On Wed, Sep 21, 2005 at 09:34:47AM +0200, Danie Theron wrote:
Thanks for your input Owen ,
Your welcome.
I noticed you had some questions on SQL , and this is probably a little off topic.We have a SQL 2000 database with some customer info , is there a way (LDAP , AD , ODBC ?) to query or insert this data into the OTRS Customer Backend? I think this is probably a developer question , but thought I'd try my luck :)
I am not aware of any automated method, I know that for agent accounts attached to LDAP you can specify what fields from the LDAP record you would like to be used in creation of the agent record the first time the login. I don't know if that exists for the customer backend or not. The customer tables are not that complicated I am sure that you could write an export/import query to transfer the data. -- Owen