Customer Database

Moderator: crythias

Locked
Gogo
Znuny newbie
Posts: 2
Joined: 23 Nov 2011, 14:28
Znuny Version: latest

Customer Database

Post by Gogo »

Hi there,

Here is what i want to do.
Whenever there is a new Ticket from a customer (xx.zzz@domail.ltd) i wanna be able to automatically add the following into the OTRS databases:
- In the customer table --> The customer_user named xx.zzz with a auto-incremented customer_userID.
- In the client table --> the company Name which i think is Customer_ID (also auto-incremented)

Of course there'll be a check if:
- the user/company name is already in the databases.
- if the company is already created, but this is a new user

For the company name, we are working on the mapping between our accountant software and the OTRS database where we're gonna be able to map the needed field. (btw, this is also well documented)
So in the end, the auto_add users is gonna be needed.

I hope what i wrote is clear :)

Thx for your comments,
Locked