Add dynamic fields to customer company

[Syoxx]

I have some problems with the dynamic field feature on customer companies. For example i would like to add a new dynamic field called “customer_internal_id” to the customer company informations. Unfortunately i don’t find any option to add this dynamic field to the customer company informations. I already did some research on the internet and read several times that this isn´t possible anymore.

Can someone tell me how to do it or what i am doing wrong?

[Stefan Rother]

Hi Syoxx,

That’s not true, I’m sure it’s possible. ;)

You need to add the dynamic field info to the $Self->{CustomerCompany} mapping in Kernel/Config.pm. If this option does not already exist in Kernel/Config.pm, you need copy the entire option from Kernel/Config/Defaults.pm to Kernel/Config.pm:

    $Self->{CustomerCompany} = {

        Name   => Translatable(‘Database Backend’),

        Module => ‘Kernel::System::CustomerCompany::DB’,

.. More Content …

        Map => [

            # Info about dynamic fields:

            #

            # Dynamic Fields of type CustomerCompany can be used within the mapping (see example below).

            # The given storage (third column) then can also be used within the following configurations (see above):

            # CustomerCompanySearchFields, CustomerCompanyListFields

            #

            # Note that the columns ‘frontend’ and ‘readonly’ will be ignored for dynamic fields.

            # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly

            [ ‘CustomerID’,             ‘CustomerID’, ‘customer_id’, 0, 1, ‘var’, ”, 0 ],

            [ ‘CustomerCompanyName’,    ‘Customer’,   ‘name’,        1, 1, ‘var’, ”, 0 ],

            [ ‘CustomerCompanyStreet’,  ‘Street’,     ‘street’,      1, 0, ‘var’, ”, 0 ],

            [ ‘CustomerCompanyZIP’,     ‘Zip’,        ‘zip’,         1, 0, ‘var’, ”, 0 ],

            [ ‘CustomerCompanyCity’,    ‘City’,       ‘city’,        1, 0, ‘var’, ”, 0 ],

            [ ‘CustomerCompanyCountry’, ‘Country’,    ‘country’,     1, 0, ‘var’, ”, 0 ],

            [ ‘CustomerCompanyURL’,     ‘URL’,        ‘url’,         1, 0, ‘var’, ‘[% Data.CustomerCompanyURL | html %]’, 0 ],

            [ ‘CustomerCompanyComment’, ‘Comment’,    ‘comments’,    1, 0, ‘var’, ”, 0 ],

            [ ‘ValidID’,                ‘Valid’,      ‘valid_id’,    0, 1, ‘int’, ”, 0 ],

            # Dynamic field example

#            [ ‘DynamicField_Name_Y’, undef, ‘Name_Y’, 0, 0, ‘dynamic_field’, undef, 0 ],

        ],

    };

 

After that you are able to configure your dynamic fields. Please add the following information to the mapping for each field:

            [ ‘DynamicField_Name_Y’, undef, ‘Name_Y’, 0, 0, ‘dynamic_field’, undef, 0 ],

 

Another possibility is to extend the database table and don’t use a dynamic field:

For MySQL or MariaDB:

root> mysql -uroot otrs

root> ALTER TABLE customercompany add NameOfNewColumn VARCHAR(255);

After that add a new value to the mapping above:

  [ ‘CustomerCompanyNameOfNewColumn’, ‘LabelOfNewColumn’,    ‘NameOfNewColumn’,    1, 0, ‘var’, ”, 0 ],

I hope I could help. Please do not hesitate to contact us if you have any questions.

Best regards from Germany,

Stefan

Team OTOBO

[Syoxx]

Hi Stefan,

thank you so much for your help! It works perfectly.

Best regards,
Syoxx

[Stefan Rother]

You’re welcome, have fun with OTOBO!

[Syoxx]

Hi Stefan,

I’ve tried around with dynamic fields in the last few days but got another problem. I want to add a dropdown field to each customer where i can select the purchased products by the customer. So that I have the opportunity to search for this field and see all customers with product A oder product B.

I successfully created a new field with the type “Multiselect”. This field is shown for each customer but the dropdown menu isn´t working. I´am only able to write numbers in it (because data type is integer). Can you tell me what i’m doing wrong?

Best regards,
Syoxx

[Author]

Posts