DBPATH=[/u/catcom/database:/u/catcom/forms Doing fname = BulkImportForDirectoryETDTramDepots.csv ++++++++++++++++++++++++++++ ===================================================== aline=[OldExtn,OldExtnGgroup,OldDepartment,OldDivision,OldParent,OldPABX,NewVACExtnGroup,NewExtn,NewExtnGroup,NewDepartment,NewDivision,NewParent,NewPABX,NewLocation,NewTelephone,NewComment,NewTEC,NewNode] Skip header ===================================================== aline=[,165ETD,,,VRT,,,,510UC4,,510,VRT,UCP,,,,,] OldExtn=[] OldExtnGroup=[165ETD] OldDepartment=[] OldDivision=[] OldParent=[VRT] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[510UC4] NewDepartment=[] NewDivision=[510] NewParent=[VRT] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "510UC4"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "165ETD" " nrows=0 ERROR: No rows found for Oldextn= OldPABX= OldExtnGroup=165ETD ===================================================== aline=[,ETDVACA,,,VAC,,,,VACUC4,,VAC,VAC,UCP,,,,,] OldExtn=[] OldExtnGroup=[ETDVACA] OldDepartment=[] OldDivision=[] OldParent=[VAC] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VACUC4] NewDepartment=[] NewDivision=[VAC] NewParent=[VAC] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "VACUC4"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "ETDVACA" " nrows=78 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "ETDVACA" " handleOld() recordno=21971 surname=.UNPROGRAMMED firstname= extension=13738 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 21971] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 21971" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 21971] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 21971" handleOld() recordno=25553 surname=.UNPROGRAMMED firstname= extension=13726 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 25553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 25553" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 25553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 25553" handleOld() recordno=159033 surname=.UNPROGRAMMED firstname= extension=13700 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 159033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 159033" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 159033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 159033" handleOld() recordno=27690 surname=.UNPROGRAMMED firstname= extension=13772 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 27690] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 27690" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 27690] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 27690" handleOld() recordno=40044 surname=.UNPROGRAMMED firstname= extension=13702 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40044] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40044" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40044] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40044" handleOld() recordno=40045 surname=.UNPROGRAMMED firstname= extension=13703 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40045] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40045" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40045] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40045" handleOld() recordno=40048 surname=.UNPROGRAMMED firstname= extension=13706 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40048] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40048" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40048] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40048" handleOld() recordno=40050 surname=.UNPROGRAMMED firstname= extension=13708 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40050" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40050" handleOld() recordno=40123 surname=.UNPROGRAMMED firstname= extension=13715 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40123] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40123" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40123] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40123" handleOld() recordno=40124 surname=.UNPROGRAMMED firstname= extension=13716 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40124] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40124" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40124] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40124" handleOld() recordno=40125 surname=.UNPROGRAMMED firstname= extension=13717 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40125] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40125" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40125] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40125" handleOld() recordno=40126 surname=.UNPROGRAMMED firstname= extension=13718 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40126] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40126" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40126] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40126" handleOld() recordno=40127 surname=.UNPROGRAMMED firstname= extension=13719 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40127] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40127" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40127] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40127" handleOld() recordno=40129 surname=.UNPROGRAMMED firstname= extension=13728 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40129] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40129" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40129] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40129" handleOld() recordno=40130 surname=.UNPROGRAMMED firstname= extension=13729 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40130] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40130" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40130] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40130" handleOld() recordno=40133 surname=.UNPROGRAMMED firstname= extension=13732 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40133" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40133" handleOld() recordno=40136 surname=.UNPROGRAMMED firstname= extension=13733 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40136] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40136" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40136] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40136" handleOld() recordno=40157 surname=.UNPROGRAMMED firstname= extension=13734 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40157] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40157" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40157] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40157" handleOld() recordno=40158 surname=.UNPROGRAMMED firstname= extension=13735 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40158] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40158" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40158] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40158" handleOld() recordno=40159 surname=.UNPROGRAMMED firstname= extension=13736 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40159] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40159" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40159] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40159" handleOld() recordno=40160 surname=.UNPROGRAMMED firstname= extension=13737 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40160] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40160" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40160] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40160" handleOld() recordno=40161 surname=.UNPROGRAMMED firstname= extension=13739 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40161] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40161" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40161] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40161" handleOld() recordno=40162 surname=.UNPROGRAMMED firstname= extension=13740 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40162] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40162" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40162] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40162" handleOld() recordno=40164 surname=.UNPROGRAMMED firstname= extension=13741 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40164] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40164" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40164] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40164" handleOld() recordno=40166 surname=.UNPROGRAMMED firstname= extension=13742 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40166] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40166" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40166] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40166" handleOld() recordno=40169 surname=.UNPROGRAMMED firstname= extension=13743 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40169] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40169" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40169] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40169" handleOld() recordno=40170 surname=.UNPROGRAMMED firstname= extension=13744 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40170] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40170" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40170] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40170" handleOld() recordno=40171 surname=.UNPROGRAMMED firstname= extension=13745 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40171] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40171" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40171] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40171" handleOld() recordno=40172 surname=.UNPROGRAMMED firstname= extension=13746 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40172] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40172" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40172] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40172" handleOld() recordno=40173 surname=.UNPROGRAMMED firstname= extension=13747 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40173] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40173" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40173] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40173" handleOld() recordno=40174 surname=.UNPROGRAMMED firstname= extension=13748 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40174] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40174" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40174] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40174" handleOld() recordno=40176 surname=.UNPROGRAMMED firstname= extension=13749 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40176] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40176" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40176] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40176" handleOld() recordno=40178 surname=.UNPROGRAMMED firstname= extension=13750 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40178] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40178" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40178] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40178" handleOld() recordno=40180 surname=.UNPROGRAMMED firstname= extension=13751 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40180] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40180" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40180] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40180" handleOld() recordno=40181 surname=.UNPROGRAMMED firstname= extension=13752 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40181] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40181" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40181] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40181" handleOld() recordno=40182 surname=.UNPROGRAMMED firstname= extension=13753 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40182] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40182" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40182] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40182" handleOld() recordno=40183 surname=.UNPROGRAMMED firstname= extension=13754 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40183] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40183" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40183] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40183" handleOld() recordno=40184 surname=.UNPROGRAMMED firstname= extension=13755 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40184] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40184" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40184] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40184" handleOld() recordno=40185 surname=.UNPROGRAMMED firstname= extension=13756 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40185] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40185" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40185] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40185" handleOld() recordno=40186 surname=.UNPROGRAMMED firstname= extension=13757 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40186] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40186" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40186] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40186" handleOld() recordno=40187 surname=.UNPROGRAMMED firstname= extension=13758 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40187] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40187" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40187] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40187" handleOld() recordno=40188 surname=.UNPROGRAMMED firstname= extension=13759 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40188] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40188" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40188] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40188" handleOld() recordno=40190 surname=.UNPROGRAMMED firstname= extension=13761 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40190] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40190" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40190] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40190" handleOld() recordno=40192 surname=.UNPROGRAMMED firstname= extension=13762 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40192] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40192" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40192] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40192" handleOld() recordno=40194 surname=.UNPROGRAMMED firstname= extension=13763 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40194] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40194" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40194] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40194" handleOld() recordno=40197 surname=.UNPROGRAMMED firstname= extension=13764 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40197] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40197" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40197] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40197" handleOld() recordno=40199 surname=.UNPROGRAMMED firstname= extension=13765 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40199] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40199" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40199] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40199" handleOld() recordno=40201 surname=.UNPROGRAMMED firstname= extension=13766 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40201] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40201" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40201] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40201" handleOld() recordno=40202 surname=.UNPROGRAMMED firstname= extension=13767 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40202] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40202" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40202] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40202" handleOld() recordno=40205 surname=.UNPROGRAMMED firstname= extension=13768 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40205] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40205" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40205] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40205" handleOld() recordno=40208 surname=.UNPROGRAMMED firstname= extension=13769 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40208] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40208" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40208] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40208" handleOld() recordno=40211 surname=.UNPROGRAMMED firstname= extension=13770 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40211] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40211" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40211] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40211" handleOld() recordno=40213 surname=.UNPROGRAMMED firstname= extension=13771 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40213] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40213" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40213] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40213" handleOld() recordno=40214 surname=.UNPROGRAMMED firstname= extension=13777 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40214] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40214" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40214] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40214" handleOld() recordno=40217 surname=.UNPROGRAMMED firstname= extension=13774 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40217] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40217" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40217] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40217" handleOld() recordno=40220 surname=.UNPROGRAMMED firstname= extension=13778 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40220] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40220" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40220] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40220" handleOld() recordno=40223 surname=.UNPROGRAMMED firstname= extension=13779 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40223] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40223" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40223] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40223" handleOld() recordno=40225 surname=.UNPROGRAMMED firstname= extension=13780 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40225] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40225" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40225] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40225" handleOld() recordno=40228 surname=.UNPROGRAMMED firstname= extension=13781 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40228] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40228" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40228] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40228" handleOld() recordno=40230 surname=.UNPROGRAMMED firstname= extension=13782 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40230] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40230" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40230] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40230" handleOld() recordno=40232 surname=.UNPROGRAMMED firstname= extension=13784 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40232] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40232" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40232] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40232" handleOld() recordno=40234 surname=.UNPROGRAMMED firstname= extension=13785 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40234] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40234" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40234] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40234" handleOld() recordno=40235 surname=.UNPROGRAMMED firstname= extension=13783 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40235] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40235" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40235] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40235" handleOld() recordno=40236 surname=.UNPROGRAMMED firstname= extension=13786 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40236] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40236" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40236] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40236" handleOld() recordno=40237 surname=.UNPROGRAMMED firstname= extension=13787 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40237] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40237" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40237] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40237" handleOld() recordno=40238 surname=.UNPROGRAMMED firstname= extension=13788 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40238] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40238" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40238] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40238" handleOld() recordno=40239 surname=.UNPROGRAMMED firstname= extension=13790 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40239] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40239" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40239] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40239" handleOld() recordno=40240 surname=.UNPROGRAMMED firstname= extension=13789 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40240] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40240" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40240] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40240" handleOld() recordno=40242 surname=.UNPROGRAMMED firstname= extension=13792 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40242] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40242" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40242] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40242" handleOld() recordno=40243 surname=.UNPROGRAMMED firstname= extension=13793 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40243] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40243" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40243] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40243" handleOld() recordno=40244 surname=.UNPROGRAMMED firstname= extension=13794 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40244] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40244" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40244] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40244" handleOld() recordno=40245 surname=.UNPROGRAMMED firstname= extension=13795 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40245] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40245" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40245] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40245" handleOld() recordno=40246 surname=.UNPROGRAMMED firstname= extension=13796 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40246] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40246" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40246] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40246" handleOld() recordno=40247 surname=.UNPROGRAMMED firstname= extension=13797 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40247] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40247" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40247] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40247" handleOld() recordno=40369 surname=.UNPROGRAMMED firstname= extension=13775 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40369] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40369" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40369] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40369" handleOld() recordno=40370 surname=.UNPROGRAMMED firstname= extension=13776 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40370] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40370" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40370] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40370" handleOld() recordno=40371 surname=.UNPROGRAMMED firstname= extension=13773 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40371] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 40371" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40371] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 40371" handleOld() recordno=161112 surname=.UNPROGRAMMED firstname= extension=13709 site=ETD extgroupunique=ETDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 161112] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC4" where recordno = 161112" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 161112] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="VAC" where recordno = 161112" nrows=78 ===================================================== aline=[,0323ETD8,,,YTD,,,,0323UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0323ETD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0323UC9] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "0323UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0323ETD8" " nrows=1 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "0323ETD8" " handleOld() recordno=40128 surname=ALMEIDA firstname=JOE extension=13720 site=ETD extgroupunique=0323ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0323UC9" where recordno = 40128] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0323UC9" where recordno = 40128" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40128] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40128" nrows=1 ===================================================== aline=[,0456ETD8,,,YTD,,,,0456UC2,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0456ETD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0456UC2] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "0456UC2"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0456ETD8" " nrows=7 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "0456ETD8" " handleOld() recordno=159781 surname=SAVESKI firstname=ZORAN extension=13731 site=ETD extgroupunique=0456ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 159781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 159781" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159781" handleOld() recordno=160660 surname=TENNENT firstname=JIM extension=13731 site=ETD extgroupunique=0456ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 160660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 160660" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160660" handleOld() recordno=159782 surname=TUMELTY firstname=MARK extension=13731 site=ETD extgroupunique=0456ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 159782] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 159782" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159782] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159782" handleOld() recordno=32407 surname=.ASSIGNED firstname= extension=13727 site=ETD extgroupunique=0456ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 32407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 32407" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 32407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 32407" handleOld() recordno=28381 surname=PARENTE firstname=ERNEST J extension=13731 site=ETD extgroupunique=0456ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 28381] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 28381" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28381] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28381" handleOld() recordno=163647 surname=MENDOLA firstname=GIUSEPPE extension=13731 site=ETD extgroupunique=0456ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 163647] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 163647" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163647] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163647" handleOld() recordno=172979 surname=SUHR firstname=LUKE extension=13731 site=ETD extgroupunique=0456ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 172979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC2" where recordno = 172979" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172979" nrows=7 ===================================================== aline=[,5600ETD8,,,YTD,,,,5600UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5600ETD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5600UC1] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "5600UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5600ETD8" " nrows=3 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "5600ETD8" " handleOld() recordno=4553 surname=CHUC firstname=SA extension=13724 site=ETD extgroupunique=5600ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5600UC1" where recordno = 4553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5600UC1" where recordno = 4553" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4553" handleOld() recordno=40052 surname=GRANO firstname=SEBASTIANO extension=13710 site=ETD extgroupunique=5600ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5600UC1" where recordno = 40052] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5600UC1" where recordno = 40052" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40052] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40052" handleOld() recordno=21364 surname=.ASSIGNED firstname= extension=13730 site=ETD extgroupunique=5600ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5600UC1" where recordno = 21364] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5600UC1" where recordno = 21364" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 21364] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 21364" nrows=3 ===================================================== aline=[,5761ETD8,,,YTD,,,,5761UC10,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5761ETD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5761UC10] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "5761UC10"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5761ETD8" " nrows=40 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "5761ETD8" " handleOld() recordno=169117 surname=ACQUAVIVA firstname=CHARLES extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 169117] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 169117" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 169117] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 169117" handleOld() recordno=161099 surname=GRAHAM firstname=ANDREW extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161099] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161099" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161099] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161099" handleOld() recordno=162734 surname=PUGH firstname=GRANT extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162734] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162734" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162734] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162734" handleOld() recordno=161178 surname=ETIENNETTE firstname=DANIELLE extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161178] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161178" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161178] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161178" handleOld() recordno=161079 surname=FIREBRACE firstname=NAKIA extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161079] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161079" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161079] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161079" handleOld() recordno=164671 surname=ETIENNETTE firstname=DESIRE extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164671] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164671" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164671] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164671" handleOld() recordno=40043 surname=ALDERRUCCIO firstname=PAUL extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 40043] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 40043" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40043] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40043" handleOld() recordno=40047 surname=.ASSIGNED firstname=REV PROT extension=13705 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 40047] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 40047" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40047] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40047" handleOld() recordno=161128 surname=PERERA firstname=IRANDI extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161128] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161128" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161128] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161128" handleOld() recordno=172980 surname=.ASSIGNED firstname= extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 172980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 172980" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172980" handleOld() recordno=162768 surname=D CRUZE firstname=CANDICE extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162768] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162768" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162768] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162768" handleOld() recordno=161155 surname=STAFFA firstname=MARSIO extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161155] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161155" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161155] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161155" handleOld() recordno=161132 surname=TORCASIO firstname=TONY extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161132] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161132" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161132] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161132" handleOld() recordno=161179 surname=ETIENNETTE firstname=JOSEPH extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161179] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161179" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161179] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161179" handleOld() recordno=161102 surname=ORMSBY firstname=FIONA extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161102] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161102" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161102] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161102" handleOld() recordno=161116 surname=SIMOS firstname=NICK extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161116] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161116" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161116] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161116" handleOld() recordno=167436 surname=MUSCAT firstname=KAREN extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 167436] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 167436" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 167436] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 167436" handleOld() recordno=161133 surname=TOTTLE firstname=CHERRA extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161133" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161133" handleOld() recordno=162769 surname=KRUGER firstname=JOHN extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162769" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162769" handleOld() recordno=159816 surname=.ASSIGNED firstname= extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 159816] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 159816" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159816] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159816" handleOld() recordno=161097 surname=CLARK firstname=PETER extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161097] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161097" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161097] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161097" handleOld() recordno=161093 surname=BORG firstname=FRANCIS extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161093] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161093" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161093] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161093" handleOld() recordno=161101 surname=.ASSIGNED firstname= extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161101] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161101" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161101] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161101" handleOld() recordno=162774 surname=NEKIC firstname=DUSKO extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162774] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162774" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162774] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162774" handleOld() recordno=161162 surname=ROUFFA firstname=EDDIE extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161162] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161162" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161162] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161162" handleOld() recordno=161089 surname=ARENAS firstname=SOPHIE extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161089] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161089" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161089] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161089" handleOld() recordno=160924 surname=TAROLA firstname=ANNE extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160924] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160924" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160924] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160924" handleOld() recordno=160925 surname=TRAVAGLINI firstname=DIANNE extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160925" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160925" handleOld() recordno=160927 surname=VINEY firstname=JOHN extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160927" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160927" handleOld() recordno=164672 surname=ETIENNETTE firstname=MARIE extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164672] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164672" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164672] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164672" handleOld() recordno=161129 surname=PROWLING firstname=TERENCE extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161129] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161129" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161129] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161129" handleOld() recordno=160916 surname=BUCKI firstname=KEN extension=13701 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 160916" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160916" handleOld() recordno=161092 surname=ASSAF firstname=GEORGE extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161092] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161092" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161092] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161092" handleOld() recordno=161100 surname=HANNA firstname=FAMI extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161100] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 161100" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161100] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 161100" handleOld() recordno=162741 surname=LO PRESTI firstname=OLIVIA extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162741] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162741" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162741] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162741" handleOld() recordno=162740 surname=MURTHY firstname=VENKAT extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162740] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162740" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162740] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162740" handleOld() recordno=162742 surname=SAVAGE firstname=DANIEL extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162742] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162742" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162742] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162742" handleOld() recordno=164676 surname=FONSEKA firstname=TUDOR extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164676] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164676" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164676] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164676" handleOld() recordno=163704 surname=TAIAWA firstname=MELINA extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163704] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163704" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163704] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163704" handleOld() recordno=163706 surname=TSILFIDIS firstname=ARI extension=13707 site=ETD extgroupunique=5761ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163706] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163706" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163706] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163706" nrows=40 ===================================================== aline=[,5807ETD8,,,YTD,,,,5807UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5807ETD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5807UC9] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "5807UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5807ETD8" " nrows=171 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "5807ETD8" " handleOld() recordno=56743 surname=MCGREGOR firstname=ROSS extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56743] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56743" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56743] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56743" handleOld() recordno=163620 surname=MARIKAR firstname=LINDA extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163620] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163620" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163620] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163620" handleOld() recordno=1140 surname=ABEYAWARDANA firstname=HARSHA P extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 1140] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 1140" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 1140] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 1140" handleOld() recordno=160454 surname=ARULIAH firstname=LEO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160454] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160454" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160454] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160454" handleOld() recordno=160465 surname=HILLARD firstname=STEPHEN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160465] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160465" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160465] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160465" handleOld() recordno=2077 surname=ANGRISH firstname=SARBJIT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2077] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2077" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2077] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2077" handleOld() recordno=162435 surname=BILLOWS firstname=BARRY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 162435] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 162435" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162435] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162435" handleOld() recordno=163628 surname=KUMAR firstname=RAJESH extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163628" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163628" handleOld() recordno=160453 surname=ARDOLIC firstname=ZENUN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160453] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160453" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160453] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160453" handleOld() recordno=163627 surname=KIFLE firstname=SOLOMON extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163627] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163627" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163627] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163627" handleOld() recordno=2520 surname=BALL firstname=ROBERT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2520] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2520" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2520] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2520" handleOld() recordno=2532 surname=BALLOTA firstname=FREDDY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2532] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2532" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2532] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2532" handleOld() recordno=160464 surname=HARRISON firstname=DARREN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160464] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160464" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160464] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160464" handleOld() recordno=2752 surname=BAYER firstname=DUDLEY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 2752" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 2752" handleOld() recordno=27467 surname=BHATIA firstname=ASHOK extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27467] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27467" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27467] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27467" handleOld() recordno=163626 surname=DIMAS firstname=STEVEN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163626] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163626" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163626] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163626" handleOld() recordno=160463 surname=GREEN firstname=CHRIS extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160463] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160463" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160463] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160463" handleOld() recordno=160462 surname=FARRUGIA firstname=RAYMOND extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160462] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160462" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160462] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160462" handleOld() recordno=34952 surname=ATWAL firstname=JASVINDER extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 34952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 34952" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 34952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 34952" handleOld() recordno=4396 surname=CHANTHAPHAVONG firstname=SOMCHAY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4396] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4396" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4396] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4396" handleOld() recordno=4498 surname=CHITTAPHONG firstname=MIXAY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4498] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4498" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4498] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4498" handleOld() recordno=4533 surname=CHRISTODOULAKI firstname=HARALAMBOS extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4533] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4533" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4533] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4533" handleOld() recordno=4550 surname=CHU-PING-SENG firstname=POW CHONG extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 4550" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 4550" handleOld() recordno=32480 surname=SVIRCIC firstname=ALLEN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 32480] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 32480" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 32480] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 32480" handleOld() recordno=160461 surname=GONSALVEZ firstname=ALVIN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160461] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160461" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160461] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160461" handleOld() recordno=56739 surname=KALRA firstname=JATINDER extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56739] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56739" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56739] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56739" handleOld() recordno=5435 surname=CZYZ firstname=RICHARD extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5435] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5435" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5435] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5435" handleOld() recordno=5473 surname=D CRUZ firstname=DAYNE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5473] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5473" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5473] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5473" handleOld() recordno=160459 surname=DE LEON firstname=ANTONIO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160459] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160459" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160459] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160459" handleOld() recordno=56737 surname=GINNANE firstname=MATTHEW extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56737] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56737" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56737] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56737" handleOld() recordno=5657 surname=DAVILA firstname=RAUL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5657] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5657" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5657] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5657" handleOld() recordno=5775 surname=DE-LA-VEGA firstname=ALBERTO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5775] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5775" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5775] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5775" handleOld() recordno=163622 surname=CARUANA firstname=GEOFFREY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163622] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163622" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163622] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163622" handleOld() recordno=5907 surname=DELLOW firstname=ANTHONY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 5907" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 5907" handleOld() recordno=56734 surname=ESKANDER firstname=WADIE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56734] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56734" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56734] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56734" handleOld() recordno=50903 surname=SALAFIA firstname=JOSEPH extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 50903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 50903" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 50903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 50903" handleOld() recordno=162539 surname=DICKINSON firstname=PAUL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 162539] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 162539" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162539] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162539" handleOld() recordno=6235 surname=DO firstname=VAN GHI extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 6235] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 6235" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 6235] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 6235" handleOld() recordno=56755 surname=SINGH firstname=HARVINDER extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56755] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56755" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56755] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56755" handleOld() recordno=6651 surname=EDWARDS firstname=KAREN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 6651] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 6651" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 6651] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 6651" handleOld() recordno=49334 surname=HO firstname=WA LUAN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 49334] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 49334" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 49334] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 49334" handleOld() recordno=56741 surname=LEARMONT firstname=ADAM extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56741] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56741" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56741] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56741" handleOld() recordno=7050 surname=FELSINGER firstname=JOHN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7050" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7050" handleOld() recordno=160458 surname=BOSCOLO firstname=BRUNO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160458] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160458" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160458] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160458" handleOld() recordno=56733 surname=DARMANIN firstname=FRANK extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56733] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56733" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56733] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56733" handleOld() recordno=56735 surname=FROST firstname=MARTIN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56735] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56735" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56735] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56735" handleOld() recordno=7311 surname=FOLINO firstname=SERAFINO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7311] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7311" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7311] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7311" handleOld() recordno=7614 surname=GALEA firstname=BEVERLEY J extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7614" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7614" handleOld() recordno=160456 surname=AZZOPARDI firstname=JOSEPH extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160456] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160456" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160456] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160456" handleOld() recordno=7902 surname=GIBSON firstname=ADRYN J extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 7902" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 7902" handleOld() recordno=40089 surname=DILISIO firstname=BRUNO extension=13711 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40089] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40089" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40089] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40089" handleOld() recordno=8332 surname=WINGARD firstname=JULIE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 8332] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 8332" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 8332] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 8332" handleOld() recordno=8373 surname=GRIMA firstname=JOSEPH extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 8373] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 8373" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 8373] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 8373" handleOld() recordno=27683 surname=DHARMAPRIYA firstname=UKWATTA extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27683] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27683" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27683] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27683" handleOld() recordno=38245 surname=KAITHOTHU firstname=JOSE K extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 38245] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 38245" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 38245] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 38245" handleOld() recordno=40120 surname=FIDIL firstname=SELMANI extension=13712 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40120] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40120" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40120] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40120" handleOld() recordno=40121 surname=GORDON firstname=MARGARET extension=13713 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40121] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40121" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40121] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40121" handleOld() recordno=40122 surname=.ASSIGNED firstname= extension=13714 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40122] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40122" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40122] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40122" handleOld() recordno=164677 surname=AUGUSTUS firstname=CHARMAINE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 164677] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 164677" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164677] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164677" handleOld() recordno=27759 surname=FERNANDES-DA-CR firstname=JOSE M extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27759" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27759" handleOld() recordno=56738 surname=GALLAGHER firstname=KERRY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56738" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56738" handleOld() recordno=163642 surname=NAUGHTON firstname=EDWARD extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163642] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163642" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163642] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163642" handleOld() recordno=9518 surname=HUYNH firstname=KIM XUYEN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 9518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 9518" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 9518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 9518" handleOld() recordno=40189 surname=.ASSIGNED firstname= extension=13760 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40189] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40189" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40189] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40189" handleOld() recordno=50902 surname=PIYATISSA firstname=INDRA extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 50902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 50902" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 50902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 50902" handleOld() recordno=30364 surname=KIOMALL firstname=MARIO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 30364] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 30364" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 30364] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 30364" handleOld() recordno=10057 surname=JORDON firstname=CYRUS extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10057] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10057" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10057] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10057" handleOld() recordno=40241 surname=.ASSIGNED firstname= extension=13791 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40241] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 40241" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40241] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 40241" handleOld() recordno=159039 surname=WARING firstname=DAVID extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 159039] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 159039" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159039] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 159039" handleOld() recordno=10715 surname=KOLAKOVIC firstname=PETAR extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10715] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10715" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10715] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10715" handleOld() recordno=10724 surname=KOLTA firstname=SAFWAT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10724] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10724" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10724] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10724" handleOld() recordno=10752 surname=KOONER firstname=GURDIAL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10752" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10752" handleOld() recordno=10850 surname=KROON firstname=ELMO E extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10850] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10850" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10850] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10850" handleOld() recordno=10997 surname=LAI firstname=HAO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10997] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10997" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10997] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10997" handleOld() recordno=10998 surname=LAI firstname=QUIME extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 10998" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 10998" handleOld() recordno=163610 surname=STREBS firstname=MARTIN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163610] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163610" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163610] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163610" handleOld() recordno=11752 surname=LUU firstname=TU THANG extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 11752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 11752" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 11752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 11752" handleOld() recordno=11759 surname=LY firstname=PHUNG extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 11759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 11759" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 11759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 11759" handleOld() recordno=163635 surname=SRITHARAN firstname=SAMY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163635] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163635" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163635] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163635" handleOld() recordno=56759 surname=VIVO firstname=ROY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56759" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56759" handleOld() recordno=33322 surname=HENIES firstname=JOSEPH extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 33322] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 33322" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 33322] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 33322" handleOld() recordno=28149 surname=SPINKS firstname=TERENCE J extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28149] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28149" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28149] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28149" handleOld() recordno=56751 surname=SOANS firstname=WARREN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56751] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56751" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56751] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56751" handleOld() recordno=12573 surname=LETTOOF firstname=MALCOLM extension=13721 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 12573] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 12573" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 12573] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 12573" handleOld() recordno=56724 surname=ALLEN firstname=SUE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56724] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56724" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56724] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56724" handleOld() recordno=28142 surname=SAINI firstname=DOGAR M extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28142] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28142" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28142] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28142" handleOld() recordno=28141 surname=MARIKAR firstname=TONY M extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28141] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28141" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28141] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28141" handleOld() recordno=28137 surname=PANGLY firstname=SURJIT S extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28137] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28137" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28137] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28137" handleOld() recordno=28136 surname=RABERTS firstname=DAVID J extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28136] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28136" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28136] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28136" handleOld() recordno=56728 surname=BOGIC firstname=JOVAN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56728] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56728" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56728] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56728" handleOld() recordno=13046 surname=MIEU firstname=BRUCE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13046] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13046" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13046] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13046" handleOld() recordno=13293 surname=MOGRIDGE firstname=ROY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13293] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13293" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13293] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13293" handleOld() recordno=13481 surname=MORRISON firstname=VINCENT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13481] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13481" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13481] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13481" handleOld() recordno=13604 surname=MUNE firstname=STELLA extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13604] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13604" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13604] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13604" handleOld() recordno=163639 surname=ZIMMERMANN firstname=PETER extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163639] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163639" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163639] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163639" handleOld() recordno=172982 surname=.ASSIGNED firstname= extension=13725 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 172982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 172982" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172982" handleOld() recordno=30362 surname=ARULANANDAM firstname=MOHAN S extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 30362] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 30362" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 30362] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 30362" handleOld() recordno=13729 surname=NAIR firstname=ANJINA extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13729] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13729" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13729] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13729" handleOld() recordno=13769 surname=NASH firstname=CHARLES extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13769" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13769" handleOld() recordno=13932 surname=.ASSIGNED firstname=TRAM DEPOT extension=13723 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13932] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13932" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13932] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13932" handleOld() recordno=13937 surname=NGUYEN firstname=TAN TAI extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13937] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 13937" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13937] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 13937" handleOld() recordno=56725 surname=AUGUSTUS firstname=LEONARD extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56725] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56725" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56725] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56725" handleOld() recordno=172981 surname=.ASSIGNED firstname= extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 172981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 172981" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172981" handleOld() recordno=14378 surname=OUTHENTHAPANYA firstname=PHENGSACK extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 14378] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 14378" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 14378] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 14378" handleOld() recordno=14413 surname=PACE-UBALDINI firstname=JOSEPH extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 14413] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 14413" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 14413] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 14413" handleOld() recordno=45451 surname=WIN firstname=ZAW extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 45451] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 45451" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 45451] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 45451" handleOld() recordno=163638 surname=VONGKHAM firstname=KHAMPHOU extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163638] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163638" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163638] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163638" handleOld() recordno=15042 surname=PEZZANO firstname=DOMENICO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15042" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15042" handleOld() recordno=15271 surname=POLAK firstname=MICHAEL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15271] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15271" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15271] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15271" handleOld() recordno=49515 surname=CORSO firstname=ANNA extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 49515] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 49515" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 49515] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 49515" handleOld() recordno=27847 surname=HONDI firstname=SAYED D extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27847] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27847" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27847] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27847" handleOld() recordno=15416 surname=PRADO firstname=SOFRONIO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15416] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15416" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15416] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15416" handleOld() recordno=15430 surname=PREAP firstname=BUNNY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15430" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15430" handleOld() recordno=56726 surname=BRADSHAW firstname=RODNEY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56726] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56726" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56726] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56726" handleOld() recordno=48827 surname=TRAN firstname=BON THIEN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 48827] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 48827" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 48827] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 48827" handleOld() recordno=27846 surname=HOANG firstname=VAN KHUONG extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27846] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 27846" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27846] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 27846" handleOld() recordno=15817 surname=REGEL firstname=WENDAL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15817] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15817" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15817] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15817" handleOld() recordno=15827 surname=REID firstname=CARLYLE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15827] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 15827" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15827] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 15827" handleOld() recordno=16024 surname=RIZKALLA firstname=MAGDI extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 16024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 16024" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 16024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 16024" handleOld() recordno=163637 surname=VASISHT firstname=MAHINDER extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163637] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163637" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163637] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163637" handleOld() recordno=28112 surname=SOANS firstname=CLIVE S extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28112] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28112" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28112] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28112" handleOld() recordno=56736 surname=GUNAWARDENA firstname=LAKSHMAN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56736] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56736" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56736] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56736" handleOld() recordno=17117 surname=SIAOSI firstname=FUE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17117] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17117" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17117] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17117" handleOld() recordno=17363 surname=SINGH firstname=VIJENDRA extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17363] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17363" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17363] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17363" handleOld() recordno=17545 surname=SMITH firstname=IAN M extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17545] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17545" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17545] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17545" handleOld() recordno=56727 surname=BUSANO firstname=REYNALDO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56727] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56727" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56727] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56727" handleOld() recordno=17692 surname=SOPHABMIXAY firstname=SINGTHONG extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17692] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 17692" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17692] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 17692" handleOld() recordno=18147 surname=SUAFOA firstname=FILI extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18147] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18147" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18147] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18147" handleOld() recordno=18258 surname=SYNAPHET firstname=KHAMPHIENE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18258] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18258" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18258] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18258" handleOld() recordno=18298 surname=TAHIR firstname=HASAN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18298] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18298" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18298] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18298" handleOld() recordno=56760 surname=WALSH firstname=NEIL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56760] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56760" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56760] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56760" handleOld() recordno=36333 surname=MALIK firstname=KHALIL Q extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 36333] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 36333" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 36333] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 36333" handleOld() recordno=18990 surname=TRENCHER firstname=EDWIN G extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 18990" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 18990" handleOld() recordno=35674 surname=WOOD firstname=DAVID V extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 35674] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 35674" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 35674] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 35674" handleOld() recordno=28143 surname=SALVADOR firstname=VIRGILIO extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28143] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 28143" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28143] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 28143" handleOld() recordno=19571 surname=VELLA firstname=JOE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 19571] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 19571" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 19571] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 19571" handleOld() recordno=163636 surname=SURACE firstname=VINCE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163636] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163636" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163636] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163636" handleOld() recordno=19663 surname=VIRAVOUTH firstname=SAYVONGSON extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 19663] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 19663" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 19663] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 19663" handleOld() recordno=19664 surname=VIRAVOUTH firstname=SOMVONGDON extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 19664] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 19664" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 19664] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 19664" handleOld() recordno=163634 surname=SMITH firstname=DAVID C extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163634] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163634" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163634] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163634" handleOld() recordno=56757 surname=SAWIRES firstname=MEDHAT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56757] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56757" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56757] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56757" handleOld() recordno=20049 surname=WELDU firstname=FEKADU extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20049] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20049" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20049] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20049" handleOld() recordno=20115 surname=WHEELER firstname=CHRISTOPHE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20115] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20115" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20115] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20115" handleOld() recordno=20117 surname=WHEELER firstname=JANET A extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20117] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20117" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20117] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20117" handleOld() recordno=20169 surname=WHITLEY firstname=ROBERT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20169] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20169" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20169] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20169" handleOld() recordno=20188 surname=WICKRAMAGE firstname=LIONEL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20188] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20188" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20188] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20188" handleOld() recordno=20203 surname=WIJEYESINGHE firstname=NORBERT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20203] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20203" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20203] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20203" handleOld() recordno=56758 surname=SPITERI firstname=LES extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56758] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56758" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56758] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56758" handleOld() recordno=56748 surname=PRATT firstname=DAVID extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56748] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56748" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56748] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56748" handleOld() recordno=163633 surname=SINNEMA firstname=CHRISTOPHE extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163633] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163633" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163633] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163633" handleOld() recordno=20440 surname=WINDSOR firstname=ROYSTON extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20440] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20440" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20440] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20440" handleOld() recordno=20445 surname=WINGARD firstname=RONALD extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20445] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 20445" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20445] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 20445" handleOld() recordno=49514 surname=TRUONG firstname=TANTAI extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 49514] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 49514" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 49514] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 49514" handleOld() recordno=172978 surname=.ASSIGNED firstname= extension=13704 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 172978] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 172978" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172978] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 172978" handleOld() recordno=163632 surname=QUINN firstname=MATTHEW extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163632] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163632" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163632] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163632" handleOld() recordno=163629 surname=MADAMPERUMA firstname=SAMATH extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163629" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163629" handleOld() recordno=163630 surname=MAUNDERS firstname=PAUL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163630] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163630" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163630] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163630" handleOld() recordno=163631 surname=POCI firstname=VINCENT extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163631] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163631" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163631] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163631" handleOld() recordno=56750 surname=RANKOVIC firstname=PETER extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56750] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 56750" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56750] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 56750" handleOld() recordno=162564 surname=SORTINO firstname=NEIL extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 162564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 162564" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 162564" handleOld() recordno=160468 surname=MORATH firstname=MARK extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160468] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160468" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160468] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160468" handleOld() recordno=160469 surname=MUSIQUE firstname=BERNARD extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160469] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160469" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160469] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160469" handleOld() recordno=160470 surname=ROSARIO firstname=PETER extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160470] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160470" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160470] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160470" handleOld() recordno=160472 surname=SAM firstname=WARREN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160472] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160472" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160472] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160472" handleOld() recordno=160474 surname=WILLIAMS firstname=STEWART extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160474] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160474" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160474] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160474" handleOld() recordno=160475 surname=WILLIAMS firstname=ROSLYN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160475] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 160475" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160475] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 160475" handleOld() recordno=163609 surname=BELL firstname=STEPHEN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163609] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163609" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163609] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163609" handleOld() recordno=163625 surname=DELA CRUZ firstname=FROILAN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163625] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163625" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163625] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163625" handleOld() recordno=163624 surname=D CRUZ firstname=GARY extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163624" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163624" handleOld() recordno=163623 surname=DAVID firstname=EDWIN extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163623] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 163623" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163623] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 163623" handleOld() recordno=164673 surname=QUINN firstname=MATTHEW extension=13722 site=ETD extgroupunique=5807ETD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 164673] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5807UC9" where recordno = 164673" sqlcmd=[update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164673] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="05/06/2018" ,jobno="RS050618ETDTRAMDEPOT" ,division="YTF" where recordno = 164673" nrows=171