Cloning a survey

Yup, me too. Got a nice big survey form that needs to be replicated 50 times. Must be a way to do it using the database, no? Anyone?

interesting feature... i'll look into this. patches accepted of course :)

this will be a cool feature,

yup, this would be useful.. but i changed the title as "cloning" is a more accurate term for this.. "repeating" sounds like taking the survey multiple times.. which prevention of this is another feature that i think this module should have..

this would be useful indeed has any one got any news about this?

There are a number of modules that provide this functionality. Node Clone comes to mind, but I think a number of other modules provide this functionality as well.

FYI I know this isn't a fix, but this may lead to developing an add-on for the module... possibly?

FIrst things first create a new survey node (and note the nid for the node).

I did this by doing an sql dump of the form_field table (only the fid's for the survey you want to clone, find replace the fid with a new fid number that isn't already present in the form_field table):
Using PHPMyAdmin

SELECT  `fid` ,  `title` ,  `explanation` ,  `page` ,  `type` ,  `weight` ,  `required` ,  `flags` ,  `validation` ,  `options` ,  `multiple` 
FROM  `form_fields` 
WHERE fid =  '4'

And then checking select all and then clicking on export at the bottom will give you an sql dump interface and I just pull this data sql insert code out:

INSERT INTO `form_fields` (`fid`, `title`, `explanation`, `page`, `type`, `weight`, `required`, `flags`, `validation`, `options`, `multiple`) VALUES 
(4, 'field #2', '', '', 'textfield', 0, 1, 'a:2:{s:3:"nid";s:3:"302";s:6:"submit";s:10:"Save field";}', '', '', 0),
(4, 'field #2', '', '', 'textarea', 0, 0, 'a:2:{s:3:"nid";s:3:"302";s:6:"submit";s:10:"Save field";}', '', '', 0);

You will need to change it to something like this (changing the 4 and 302 from above):

INSERT INTO `form_fields` (`fid`, `title`, `explanation`, `page`, `type`, `weight`, `required`, `flags`, `validation`, `options`, `multiple`) VALUES 
(5, 'field #2', '', '', 'textfield', 0, 1, 'a:2:{s:3:"nid";s:3:"303";s:6:"submit";s:10:"Save field";}', '', '', 0),
(5, 'field #2', '', '', 'textarea', 0, 0, 'a:2:{s:3:"nid";s:3:"303";s:6:"submit";s:10:"Save field";}', '', '', 0);

The 303 is the NID for the cloned survey node.

Dump the INSERT command back into PHPMyAdmin, and then modify the value in form_fields for the sequences table for form_fields_ffid entry to the highest value ffid value plus 1. So if the highest ffid value in form_fields is 59 you would enter 60. I encountered errors not doing this after the insert command dump when trying to add more fields to the survey. Doing this fixed the error.

Again not a fix, but for a large form it saves you a little bit. I could see replicating the insert command as many times as you wanted to clone it for duplicating as many survey's as you wanted to.

This was closed because other modules exist to provide this functionality, however, the Node Clone module does not successfully copy surveys. I'm suggesting a reopen as a feature request.

I agree... seems worthwhile to have a specific survey clone tool built into survey.

Survey module is no longer being maintained, use Webform module instead.

---Closing down issue queue of survey module---