Category=Database Maintenance - CAUTION
Name=Import Arabic Gospels Into Database
Description=Import Arabic Gospels Into Database from arb-gospels.csv

Heading=Import Arabic Gospels
ImportDupCheck=SELECT * FROM DOCUMENT WHERE DOCUMENTID={0}
ImportFile=arb-gospels.csv|INSERT INTO DOCUMENT (DOCUMENTID, GANUMBER, LANGUAGE, ORIGINYEAREARLY, ORIGINYEARLATE, ORIGINYEARDESCRIPTION, CONTENTOVERVIEW, LEAVESDESCRIPTION, COLUMNS, COLUMNSMAX, LINECOUNT, LINECOUNTMAX, LINECOUNTDESCRIPTION, HEIGHT, HEIGHTMAX, WIDTH, WIDTHMAX) VALUES ({0}, \
CONCAT('Arb', MOD({0}, 900000)), \
CASE WHEN LENGTH('{2}') > 0 THEN '{2}' ELSE NULL END, \
CASE WHEN LENGTH('{3}') > 0 THEN '{3}' ELSE NULL END, \
CASE WHEN LENGTH('{4}') > 0 THEN '{4}' ELSE NULL END, \
CASE WHEN LENGTH('{5}') > 0 THEN '{5}' ELSE NULL END, \
CASE WHEN LENGTH('{6}') > 0 THEN '{6}' ELSE NULL END, \
CASE WHEN LENGTH('{7}') > 0 THEN '{7}' ELSE NULL END, \
CASE WHEN LENGTH('{8}') > 0 THEN '{8}' ELSE NULL END, \
CASE WHEN LENGTH('{9}') > 0 THEN '{9}' ELSE NULL END, \
CASE WHEN LENGTH('{10}') > 0 THEN '{10}' ELSE NULL END, \
CASE WHEN LENGTH('{11}') > 0 THEN '{11}' ELSE NULL END, \
CASE WHEN LENGTH('{12}') > 0 THEN '{12}' ELSE NULL END, \
CASE WHEN LENGTH('{13}') > 0 THEN '{13}' ELSE NULL END, \
CASE WHEN LENGTH('{14}') > 0 THEN '{14}' ELSE NULL END, \
CASE WHEN LENGTH('{15}') > 0 THEN '{15}' ELSE NULL END, \
CASE WHEN LENGTH('{16}') > 0 THEN '{16}' ELSE NULL END \
)
SQL=NA

