Category=Database Maintenance
Name=06. Migrate- Transcription Data to SURROGATETRANSCRIPTION
Description=Grabs data from current VMR tables and imports it to populate the SurrogateTranscription table

Heading=Import Page Data Into SurrogateTranscription

OutputLevel=1
Import2LSQL=SELECT DOCUMENTID from DOCUMENT|	\
SELECT		\
 DISTINCT '{0}'  DOCUMENTID,	\
 lfNr PAGEID,	\
 (SELECT INSTITUTIONID FROM INSTITUTION WHERE NAME='Bibelmuseum') AS INSTITUTIONID,	\
 '10' SURROGATEID, \
 concat('http://intf.uni-muenster.de/vmr/NTVMR/trans/','{0}','_trans/',trans) as FULLTRANSURL	\
 from cont{0} where trans is not null and CHAR_LENGTH(trans) > 1 order by lfNr|		\
			\
 INSERT INTO SURROGATETRANSCRIPTION (		\
 DOCUMENTID,		\
 PAGEID,		\
 INSTITUTIONID,		\
 SURROGATEID,		\
 SURROGATEURI		\
 ) VALUES ({0}, {1}, {2}, '{3}', '{4}')
IgnoreException=Error Code: 1146

