[SOLVED] Dynamic filed database filled with customers

Moderator: crythias

Post Reply
Sayannara
Znuny advanced
Posts: 118
Joined: 22 May 2012, 12:37
Znuny Version: OTRS 7.06
Real Name: Yann
Company: FVE
Contact:

[SOLVED] Dynamic filed database filled with customers

Post by Sayannara »

Hello

I am able to use a dynamic field, database type, to fill values with agents as I can get them from the users table of my OTRS DB. I would do the same with customers but my tables are empty.

customer_user
customer_user_customer

Should I change my Config.pm to sync them? They currently log in with LDAP auth and everything is working.

Any suggestion to accomplish this?

It looks that it used to be a specific customer type-field:
https://www.youtube.com/watch?v=ZdTlIld7hyE

Thanks a lot for your help.
Last edited by Sayannara on 15 Jun 2018, 13:08, edited 1 time in total.
Centos 7 / OTRS::ITSM 6 Business Solutions / MariaDB / Apache
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Dynamic filed database filled with customers

Post by wurzel »

Hi,

if you have all customer users in LDAP, they are not stored in local database. So customer_user table is empty.

I would not sync them. I assume you are using OTRS (OTRS Business Solution)? There is a feature for dynamic fields type customer. This could help you.

Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Sayannara
Znuny advanced
Posts: 118
Joined: 22 May 2012, 12:37
Znuny Version: OTRS 7.06
Real Name: Yann
Company: FVE
Contact:

Re: Dynamic filed database filled with customers

Post by Sayannara »

Here is the feature
https://otrs.com/otrs-feature/feature-a ... ct-fields/

I decided to create a database otrs_data and with PowerShell I'll populate my own customers table every day.

Thank you.
Centos 7 / OTRS::ITSM 6 Business Solutions / MariaDB / Apache
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Dynamic filed database filled with customers

Post by wurzel »

Hi,

if you do so, do not forget to clean caches.

Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Sayannara
Znuny advanced
Posts: 118
Joined: 22 May 2012, 12:37
Znuny Version: OTRS 7.06
Real Name: Yann
Company: FVE
Contact:

Re: Dynamic filed database filled with customers

Post by Sayannara »

uh ?

Clean caches of MYSQL? Or OTRS?

Thank you
Centos 7 / OTRS::ITSM 6 Business Solutions / MariaDB / Apache
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Dynamic filed database filled with customers

Post by wurzel »

Hi,

any manual changes in the OTRS DB require a Maint::Cache::Delete

Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Sayannara
Znuny advanced
Posts: 118
Joined: 22 May 2012, 12:37
Znuny Version: OTRS 7.06
Real Name: Yann
Company: FVE
Contact:

Re: Dynamic filed database filled with customers

Post by Sayannara »

Okay thank you.

Actually I created on the local server a second database otrs_data to not change the default database so everything is fine.
Centos 7 / OTRS::ITSM 6 Business Solutions / MariaDB / Apache
Post Reply