[SOLVED] Dynamic filed database filled with customers

Moderator: crythias

Post Reply
Sayannara
OTRS wizard
Posts: 109
Joined: 22 May 2012, 12:37
OTRS Version?: OTRS 6.03
Real Name: Yann
Company: FVE
Contact:

[SOLVED] Dynamic filed database filled with customers

Post by Sayannara » 14 Jun 2018, 16:43

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.
OpenseSuse 13 / OTRS::ITSM 6 / Business Solutions / MariaDB / Apache

wurzel
OTRS guru
Posts: 2383
Joined: 08 Jul 2010, 22:25
OTRS Version?: 6.0.x

Re: Dynamic filed database filled with customers

Post by wurzel » 14 Jun 2018, 17:05

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)) Community Edition 6.0.x, LAMP LIVE auf Debian 9
    OTRS 6 Managed Silver

    -- 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
    OTRS wizard
    Posts: 109
    Joined: 22 May 2012, 12:37
    OTRS Version?: OTRS 6.03
    Real Name: Yann
    Company: FVE
    Contact:

    Re: Dynamic filed database filled with customers

    Post by Sayannara » 15 Jun 2018, 10:19

    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.
    OpenseSuse 13 / OTRS::ITSM 6 / Business Solutions / MariaDB / Apache

    wurzel
    OTRS guru
    Posts: 2383
    Joined: 08 Jul 2010, 22:25
    OTRS Version?: 6.0.x

    Re: Dynamic filed database filled with customers

    Post by wurzel » 15 Jun 2018, 11:00

    Hi,

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

    Flo
      ((OTRS)) Community Edition 6.0.x, LAMP LIVE auf Debian 9
      OTRS 6 Managed Silver

      -- 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
      OTRS wizard
      Posts: 109
      Joined: 22 May 2012, 12:37
      OTRS Version?: OTRS 6.03
      Real Name: Yann
      Company: FVE
      Contact:

      Re: Dynamic filed database filled with customers

      Post by Sayannara » 15 Jun 2018, 11:29

      uh ?

      Clean caches of MYSQL? Or OTRS?

      Thank you
      OpenseSuse 13 / OTRS::ITSM 6 / Business Solutions / MariaDB / Apache

      wurzel
      OTRS guru
      Posts: 2383
      Joined: 08 Jul 2010, 22:25
      OTRS Version?: 6.0.x

      Re: Dynamic filed database filled with customers

      Post by wurzel » 15 Jun 2018, 11:31

      Hi,

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

      Flo
        ((OTRS)) Community Edition 6.0.x, LAMP LIVE auf Debian 9
        OTRS 6 Managed Silver

        -- 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
        OTRS wizard
        Posts: 109
        Joined: 22 May 2012, 12:37
        OTRS Version?: OTRS 6.03
        Real Name: Yann
        Company: FVE
        Contact:

        Re: Dynamic filed database filled with customers

        Post by Sayannara » 15 Jun 2018, 12:54

        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.
        OpenseSuse 13 / OTRS::ITSM 6 / Business Solutions / MariaDB / Apache

        Post Reply