Extend the agent user table

[sciolto]

Hi board,
I have searched this without any result across the board..

Is there any possibility to extend the agent user db table to store more information and map some agent information from ldap with $Self->{'AuthSyncModule::LDAP::UserSyncMap'} ?

Many thanks in advance!

[crythias]

User demographics isn't (shouldn't be?) synced from LDAP. If you want more info from LDAP, add Map fields.

[sciolto]

User demographics isn't (shouldn't be?) synced from LDAP. If you want more info from LDAP, add Map fields.

Hi crythias thanks for the quick answer! What are Map fields? Do you mean that additional field's values could be taken from an LDAP search?

thanks !

[crythias]

Yes, the Map in Config.pm

[sciolto]

Yes, the Map in Config.pm

Hi there! Sorry but I can't find anything regarding Map fields in the OTRS Docu. Do you have any link ?

Thanks so much!

[crythias]

I made a mistake, confusing Customers with Agents.

No, you can't, because User.pm GetUserData only covers:

Code: Select all

    while ( my @Row = $Self->{DBObject}->FetchrowArray() ) {
        $Data{UserID}        = $Row[0];
        $Data{UserLogin}     = $Row[1];
        $Data{UserTitle}     = $Row[2];
        $Data{UserFirstname} = $Row[3];
        $Data{UserLastname}  = $Row[4];
        $Data{UserPw}        = $Row[5];
        $Data{ValidID}       = $Row[6];
        $Data{CreateTime}    = $Row[7];
        $Data{ChangeTime}    = $Row[8];
    }

My apologies for the confusion on this.

[jojo]

Try to use the user preferences and do the sync via preferences key. Some more information on extending the preferences you'll find here:

http://blog.otrs.org/2011/09/05/agent-s ... ignatures/

[sciolto]

I made a mistake, confusing Customers with Agents.

No, you can't, because User.pm GetUserData only covers:

Code: Select all

    while ( my @Row = $Self->{DBObject}->FetchrowArray() ) {
        $Data{UserID}        = $Row[0];
        $Data{UserLogin}     = $Row[1];
        $Data{UserTitle}     = $Row[2];
        $Data{UserFirstname} = $Row[3];
        $Data{UserLastname}  = $Row[4];
        $Data{UserPw}        = $Row[5];
        $Data{ValidID}       = $Row[6];
        $Data{CreateTime}    = $Row[7];
        $Data{ChangeTime}    = $Row[8];
    }

My apologies for the confusion on this.

No prob ! But it would be nice to have the same map we can use for customers to manage agent details as well. I think I will post it on ideascale !

[sciolto]

Try to use the user preferences and do the sync via preferences key. Some more information on extending the preferences you'll find here:

http://blog.otrs.org/2011/09/05/agent-s ... ignatures/

Thanks this is a good workaround !

[michab]

sorry, for me it´s not clear if i have to add or modify anthing at the DB.
i have an old version here: 2.3.4
i added the XML and activated the new block at the sysconfig, but the user preferences does not show anything.
thanks for any help!

[jojo]

2.3. is really outdated. Please update to a new version