I need to import some customers company and relative users.
In my case a costumer is different from another only by customer ID (but with same name).
In Otrs 6 is there a parameter to allow the duplication of customer name?
Thanks
Rod
How can I allow duplicate customer_company_name? [SOLVED]
Moderator: crythias
-
rodolfor
- Znuny newbie
- Posts: 89
- Joined: 11 Jun 2020, 14:56
- Znuny Version: 6.0.27
- Real Name: Rodolfo Rughi
- Company: none
How can I allow duplicate customer_company_name? [SOLVED]
Last edited by rodolfor on 06 Apr 2023, 09:02, edited 1 time in total.
-
root
- Administrator
- Posts: 3960
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: How can I allow duplicate customer_company_name?
Hi,
Technically only the id must be unique. There are two options: create your own table or remove the unique constraint from the column name.
Just make sure that column customer_id is unique.
- Roy
Technically only the id must be unique. There are two options: create your own table or remove the unique constraint from the column name.
Just make sure that column customer_id is unique.
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
rodolfor
- Znuny newbie
- Posts: 89
- Joined: 11 Jun 2020, 14:56
- Znuny Version: 6.0.27
- Real Name: Rodolfo Rughi
- Company: none
Re: How can I allow duplicate customer_company_name? [SOLVED]
Thanks Roy, it worked
Rod
Rod