Category=Database Maintenance
Name=2.2 Import Conjecture History
Description=Grabs data from Filemaker export and imports it into the CONJHISTORY table

OutputLevel=3

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

ImportDupCheck=SELECT 1 FROM ntconjectures.CONJHISTORY WHERE CONJHISTID={0}
ImportFile=FM_Sources_LO.csv|INSERT INTO ntconjectures.CONJHISTORY (CONJHISTID, CONJID, AUTHOR, AUTHORID, BIBLIOSHORT, BIBLIOLONG, BIBLIORANGE, BIBLIOID, REMARKS, YEAR, KIND, CITATION) values ({0},{1},'{3}',{2},'{8}','{7}','{9}',{6},'{10}',{4}, '{5}', '{11}')
SQL=NA