Export / Import objects

[Paulo Tebet]

I am facing a situation where I will have to create many associations between users and groups. I was thinking if there is a way of do it for a couple of users, then export it, manage it in excel where I coould speed up the process, copying and pasting and changing some itens and then import them back to the OTRS system.

Can this be done?

[crythias]

Customers or agents?

[Paulo Tebet]

Customers

[crythias]

Out of band, the proper way would be to use the API:

Code: Select all

 GroupMemberAdd()

to add a member to a group

    Permission: ro,move_into,priority,create,rw

    my $ID = $CustomerGroupObject->GroupMemberAdd(
        GID => 12,
        UID => 6,
        Permission => {
            ro        => 1,
            move_into => 1,
            create    => 1,
            owner     => 1,
            priority  => 0,
            rw        => 0,
        },
        UserID => 123,
    );

But if you look at Kernel/System/CustomerGroup.pm, the code is (verify information, then...)

Code: Select all

$Self->{DBObject}->Do(
            SQL => 'INSERT INTO group_customer_user '
                . '(user_id, group_id, permission_key, permission_value, '
                . 'create_time, create_by, change_time, change_by) '
                . 'VALUES (?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)',
            Bind => [
                \$Param{UID}, \$Param{GID}, \$Type, \$Param{Permission}->{$Type}, \$Param{UserID},
                \$Param{UserID},
            ],
        );

What you do with this is up to you.

[Paulo Tebet]

Thanks