Export and Import Client/Domain Templates?

[vnchristina]

Is it possible to export and import client/domain templates?

 

[IgorG]

You can do it with mysql dumps, for example. ID of template can be found in 'Templates' table of psa database and all settings for needed template ID can be found in 'TmplData' table.

 

[vnchristina]

thanks!

 

[vnchristina]

I have another question regarding templates. Why is it that there is no way to reference the template an account was created with? In the clients table for the column tmpl_id, all of the accounts show NULL. We made chagnes to our templates and wanted to change the clients to the new ones. However, there doesn't appear to be a way to do this, or am I just missing something?

 

[IgorG]

Client's template can be used only for clients creating and can't be applied to already existing clients. Really, if you enable mysql logging in my.cnf and analyse logs you see that id of template used only during client creating and then replaced with NULL in clients table.

 

[LarsT]

doesnt work for me

hi igor, tried to import client and domain templates from another plesk installation as described above. but in the new plesk installation are only the default client and domain templates visible. is there still another database (psa) table to consider?

thanks for help

greetz lars

sql inserts for new plesk installation (client/domain templates) into psa database :

INSERT INTO `Templates` VALUES(44, 'BusinessWeb Advanced', NULL);
INSERT INTO `Templates` VALUES(45, 'BusinessWeb Power', NULL);
INSERT INTO `Templates` VALUES(46, 'BusinessWeb Standard', NULL);


#####

INSERT INTO `TmplData` VALUES(44, 'allow_ftp_backups', 'false');
INSERT INTO `TmplData` VALUES(44, 'allow_local_backups', 'true');
INSERT INTO `TmplData` VALUES(44, 'change_limits', 'false');
INSERT INTO `TmplData` VALUES(44, 'cp_access', 'true');
INSERT INTO `TmplData` VALUES(44, 'create_domains', 'false');
INSERT INTO `TmplData` VALUES(44, 'disk_space', '20971520000');
INSERT INTO `TmplData` VALUES(44, 'disk_space_soft', '-1');
INSERT INTO `TmplData` VALUES(44, 'excl_ip_num', '0');
INSERT INTO `TmplData` VALUES(44, 'expiration', '-1');
INSERT INTO `TmplData` VALUES(44, 'manage_anonftp', 'false');
INSERT INTO `TmplData` VALUES(44, 'manage_crontab', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_dashboard', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_dns', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_domain_aliases', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_log', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_maillists', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_not_chroot_shell', 'false');
INSERT INTO `TmplData` VALUES(44, 'manage_performance', 'false');
INSERT INTO `TmplData` VALUES(44, 'manage_phosting', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_php_safe_mode', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_quota', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_sh_access', 'false');
INSERT INTO `TmplData` VALUES(44, 'manage_spamfilter', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_subdomains', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_virusfilter', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_webapps', 'true');
INSERT INTO `TmplData` VALUES(44, 'manage_webstat', 'true');
INSERT INTO `TmplData` VALUES(44, 'max_box', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_db', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_dom', '54');
INSERT INTO `TmplData` VALUES(44, 'max_dom_aliases', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_maillists', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_mg', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_redir', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_resp', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_subdom', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_traffic', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_traffic_soft', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_webapps', '-1');
INSERT INTO `TmplData` VALUES(44, 'max_wu', '-1');
INSERT INTO `TmplData` VALUES(44, 'mbox_quota', '1024000000');
INSERT INTO `TmplData` VALUES(44, 'overuse_block', 'false');
INSERT INTO `TmplData` VALUES(44, 'overuse_notify', 'true');
INSERT INTO `TmplData` VALUES(44, 'remote_access_interface', 'true');
INSERT INTO `TmplData` VALUES(44, 'select_db_server', 'false');
INSERT INTO `TmplData` VALUES(44, 'shared_template', 'true');
INSERT INTO `TmplData` VALUES(44, 'site_builder', 'false');
INSERT INTO `TmplData` VALUES(44, 'tmpl_pool_id', '6');
INSERT INTO `TmplData` VALUES(44, 'use_sbnet', '0');