copying agents to another installation

[Nemiroff_84]

Good day everybody!
First of all, I'm sorry for my bad English, because my native is Russian.

Is there any way to copy account of agents, customers company and customers from one installation to another?

[crythias]

Better, you don't have to copy them. Just reference them in the other database.

*how?*

Read Kernel/Config/Defaults.pm
Copy relevant sections to Kernel/Config.pm and uncomment fields
Something like

Code: Select all

$Self->{CustomerUser}->{Params} = {
            # if you want to use an external database, add the
            # required settings
#            DSN  => 'DBI:odbc:yourdsn',
#            Type => 'mssql', # only for ODBC connections
#            DSN => 'DBI:mysql:database=customerdb;host=customerdbhost',
#            User => '',
#            Password => '',
            Table => 'customer_user',
            # if your frontend is unicode and the charset of your
            # customer database server is iso-8859-1, use these options.
#           SourceCharset => 'iso-8859-1',
#           DestCharset => 'utf-8',

            # CaseSensitive will control if the SQL statements need LOWER()
            #   function calls to work case insensitively. Setting this to
            #   1 will improve performance dramatically on large databases.
            CaseSensitive => 0,

};
$Self->{CustomerUser}->{CustomerCompanySupport} = 1;
$Self->{CustomerCompany}->{Params} = {
            # if you want to use an external database, add the
            # required settings
#            DSN  => 'DBI:odbc:yourdsn',
#            Type => 'mssql', # only for ODBC connections
#            DSN => 'DBI:mysql:database=customerdb;host=customerdbhost',
#            User => '',
#            Password => '',
            Table => 'customer_company',
#            ForeignDB => 0,    # set this to 1 if your table does not have create_time, create_by, change_time and change_by fields

            # CaseSensitive will control if the SQL statements need LOWER()
            #   function calls to work case insensitively. Setting this to
            #   1 will improve performance dramatically on large databases.
            CaseSensitive => 0,
};

Unfortunately, there's no external DB provision for Agents, but it doesn't seem unreasonable to export/import them by database table. This isn't *exactly* by the book, though. Back up databases, configs, etc, before you try these things. There might be configuration or syntax errors in the above.

[Nemiroff_84]

Thank you.