Forums

It'd be great if there was a "copy" button for connections. I've got one created and need to create nine more that are basically minor variations on the first one. Having a copy button would greatly speed the process.

Hi Chriscaple,

If you have access to PHPMyAdmin then this should do it

INSERT INTO `jos_chronoconnectivity` (`name`, `tablenames`, `SQL`, `head`,
`body`, `footer`, `edit_template`, `front_edit_template`, `OnSaveCode`, `OnSaveJSCode`,
`OnSaveCodefront`, `OnSaveJSCodefront`, `paramsall`, `Config`, `ClassCode`, `ccCache1`,
`ccCache2`, `published`)
SELECT '##new name here##', 'jos_chronoforms_##new name here##', `SQL`, `head`, `body`, `footer`, `edit_template`, `front_edit_template`, `OnSaveCode`, `OnSaveJSCode`,
`OnSaveCodefront`, `OnSaveJSCodefront`, `paramsall`, `Config`, `ClassCode`, `ccCache1`,
`ccCache2`, `published`
FROM `jos_chronoconnectivity`
WHERE `name` = '##old name here##' ;

Note that there are two places where you need to replace ##new name here## with the new Connection name and one to replace ##old name here## with the old name. You will also need to change the table prefix if you are not using jos_

Bob

Awesome, thanks!