Category=Database Maintenance
Name=1.2 Import Conjectures
Description=Grabs data from Filemaker export and imports it into the CONJECTURE table

OutputLevel=3

Heading=Grabs data from Filemaker export and imports it into the CONJECTURE table

ImportDupCheck=SELECT 1 FROM ntconjectures.CONJECTURE WHERE CONJID={0}
ImportFile=FM_Conjectures_LO.csv|INSERT INTO ntconjectures.CONJECTURE (CONJID, INDEXSTART, INDEXEND, WORDSTART, WORDEND, OPERATION, MCTREADING, CONJREADING, ATTESTED, EDALT, MISUNDERSTOOD, NESTLEPRESENT, MCTCONTEXT) values ({0},2000000000+({1}*1000000)+({2}*1000)+{4},2000000000+({1}*1000000)+(CAST(CASE WHEN '{3}'='' THEN '{2}' ELSE '{3}' END AS UNSIGNED)*1000)+CAST(CASE WHEN '{5}'='' THEN '{4}' ELSE '{5}' END AS UNSIGNED), {6}, CAST(CASE WHEN '{7}'='' THEN '{6}' ELSE '{7}' END AS UNSIGNED), '{8}', '{9}', '{10}', {11}, {12}, {13}, {14}, '{15}')
SQL=NA