Webform Migration Notes

Notes from the migration of the WebForm from _D6Site to _2014. This was a direct database migration of content. The structure was manually created.

 

Form        Old NID        New NID
X3D Chairs                1692
Showcase                1693
Comment                    1694

 

SQL code for migration

TRUNCATE spi3der_2014.webform_submissions;
TRUNCATE spi3der_2014.webform_submitted_data;

INSERT INTO spi3der_2014.webform_submissions
    (sid,nid,uid,is_draft,submitted,remote_addr)
    SELECT sid,1694,uid,is_draft,submitted,remote_addr FROM spi3der_D6site.webform_submissions WHERE nid=174;
    
INSERT INTO spi3der_2014.webform_submitted_data
    (nid,sid,cid,no,data)
    SELECT 1694,sid,cid,no,data FROM spi3der_D6site.webform_submitted_data WHERE nid=174;

INSERT INTO spi3der_2014.webform_submissions
    (sid,nid,uid,is_draft,submitted,remote_addr)
    SELECT sid,1693,uid,is_draft,submitted,remote_addr FROM spi3der_D6site.webform_submissions WHERE nid=371;
    
INSERT INTO spi3der_2014.webform_submitted_data
    (nid,sid,cid,no,data)
    SELECT 1693,sid,cid,no,data FROM spi3der_D6site.webform_submitted_data WHERE nid=371;
    

INSERT INTO spi3der_2014.webform_submissions
    (sid,nid,uid,is_draft,submitted,remote_addr)
    SELECT sid,1692,uid,is_draft,submitted,remote_addr FROM spi3der_D6site.webform_submissions WHERE nid=246;
    
INSERT INTO spi3der_2014.webform_submitted_data
    (nid,sid,cid,no,data)
    SELECT 1692,sid,cid,no,data FROM spi3der_D6site.webform_submitted_data WHERE nid=246;
    

_submissions: 263 :
_submitted: 1926 :

for 1693:
Change mapping
job title SHOWS AS 'Organization'
organization SHOWS AS 'Web3D Member?'
sessions of interest SHOWS AS 'Interest in Web3D'
web3d member SHOWS AS 'Other'
interest SHOWS AS 'Job Title'
other SHOWS as 'Sessions'

 

Column Node 371 (D6)

Node 1693 (2014)
organization 4 5
web3d member 5 7
interest 6 8
other 7 9
job title 8 4
sessions 9 6
     

 

UPDATE spi3der_2014.webform_submitted_data SET cid=12 WHERE nid=1693 AND cid=4;
UPDATE spi3der_2014.webform_submitted_data SET cid=4  WHERE nid=1693 AND cid=8;
UPDATE spi3der_2014.webform_submitted_data SET cid=8  WHERE nid=1693 AND cid=6;
UPDATE spi3der_2014.webform_submitted_data SET cid=6  WHERE nid=1693 AND cid=9;
UPDATE spi3der_2014.webform_submitted_data SET cid=9  WHERE nid=1693 AND cid=7;
UPDATE spi3der_2014.webform_submitted_data SET cid=7  WHERE nid=1693 AND cid=5;
UPDATE spi3der_2014.webform_submitted_data SET cid=5  WHERE nid=1693 AND cid=12;

4 -> 12
8 -> 4
6 -> 8
9 -> 6
7 -> 9
5 -> 7
12 -> 5