How to enable the "Customer with multiple IDs" on SQLSRV

Moderator: crythias

Locked
meoukg
Znuny newbie
Posts: 12
Joined: 15 Nov 2013, 04:50
Znuny Version: 3.3.9
Real Name: Haley Le

How to enable the "Customer with multiple IDs" on SQLSRV

Post by meoukg »

Hi All,

I know the feature "Customer with multiple IDs (Company tickets)" which has been shared a lot and I knew the way to use this feature by 2 simple steps below:

1. Add a new column in the table customer_user by this command: ALTER TABLE customer_user ADD customer_ids VARCHAR (250)
2.Adding a UserCustomerIDs field to the Kernel/Config.pm file
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly
[...]
[ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],

But I don't know how to complete the above steps with the OTRS Server which is running Windows Server and Microsoft SQL Server (managed by SQL Server Management Studio). And don't know how to insert the information to Config.pm file & how to run this file on Microsoft Windows OS.

Kindly help.
Running the OTRS Server on Windows Server 2012 R2 Standard & Microsoft SQL Server 2012 Standard
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: How to enable the "Customer with multiple IDs" on SQLSRV

Post by crythias »

start by add column in SSMS.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
meoukg
Znuny newbie
Posts: 12
Joined: 15 Nov 2013, 04:50
Znuny Version: 3.3.9
Real Name: Haley Le

Re: How to enable the "Customer with multiple IDs" on SQLSRV

Post by meoukg »

crythias wrote:start by add column in SSMS.
Hi Crythias, already add the column, but how can I modify and run config.pm?
Running the OTRS Server on Windows Server 2012 R2 Standard & Microsoft SQL Server 2012 Standard
Locked