Category=Database Maintenance
Name=09. Migrate- Features
Description=Grabs data from current VMR tables and imports it to populate the Features table

Heading=Import Page Data Into FEATURES
OutputLevel=1


Import2LSQL=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where sSi='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('ScanStatusInfo', {0}, {1}, {2}, '{3}')
IgnoreException=Error Code: 1146

Import2LSQL2=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where bib='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('LibraryShelfNumber', {0}, {1}, {2}, '{3}')
IgnoreException2=Error Code: 1146

Import2LSQL3=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where miT='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('MicrofilmTitle', {0}, {1}, {2}, '{3}')
IgnoreException3=Error Code: 1146

Import2LSQL4=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where nte='1' or oAV='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('NoteSurrogate', {0}, {1}, {2}, '{3}')
IgnoreException4=Error Code: 1146

Import2LSQL5=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where sca='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('Scale', {0}, {1}, {2}, '{3}')
IgnoreException5=Error Code: 1146

Import2LSQL6=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where bnd='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('Binding', {0}, {1}, {2}, '{3}')
IgnoreException6=Error Code: 1146

Import2LSQL7=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where bSc='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('BlackScan', {0}, {1}, {2}, '{3}')
IgnoreException7=Error Code: 1146

Import2LSQL8=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where caT='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('CanonTables', {0}, {1}, {2}, '{3}')
IgnoreException8=Error Code: 1146

Import2LSQL9=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where kep='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('KephalaiaList', {0}, {1}, {2}, '{3}')
IgnoreException9=Error Code: 1146

Import2LSQL10=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where hyp='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('Hypothesis', {0}, {1}, {2}, '{3}')
IgnoreException10=Error Code: 1146

Import2LSQL11=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where inL='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('LectionIndex', {0}, {1}, {2}, '{3}')
IgnoreException11=Error Code: 1146

Import2LSQL12=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where col='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('Colophone', {0}, {1}, {2}, '{3}')
IgnoreException12=Error Code: 1146

Import2LSQL13=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where blP='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('Blank', {0}, {1}, {2}, '{3}')
IgnoreException13=Error Code: 1146

Import2LSQL14=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID, oMV	\
from cont{0} where oMV='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('NonBiblicalContentDescription', {0}, {1}, {2}, '{3}')
IgnoreException14=Error Code: 1146

Import2LSQL15=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where ill='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('Illuminations', {0}, {1}, {2}, '{3}')
IgnoreException15=Error Code: 1146

Import2LSQL16=SELECT DOCUMENTID from DOCUMENT|SELECT DISTINCT '{0}', lfNr, coalesce((SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME=inst), 49) USERINSTITUTIONID, abbr USERID	\
from cont{0} where dek='1' \
|INSERT INTO FEATURE (FEATURECODE, DOCUMENTID, PAGEID, USERINSTITUTIONID, USERID) VALUES ('Headpieces', {0}, {1}, {2}, '{3}')
IgnoreException16=Error Code: 1146

