DBPATH=[/u/catcom/database:/u/catcom/forms Doing fname = BulkImportForDirectoryKTDTramDepots.csv ++++++++++++++++++++++++++++ ===================================================== aline=[OldExtn,OldExtnGgroup,OldDepartment,OldDivision,OldParent,OldPABX,NewVACExtnGroup,NewExtn,NewExtnGroup,NewDepartment,NewDivision,NewParent,NewPABX,NewLocation,NewTelephone,NewComment,NewTEC,NewNode] Skip header ===================================================== aline=[,165KTD,,,VRT,,,,510UC1,,510,VRT,UCP,,,,,] OldExtn=[] OldExtnGroup=[165KTD] OldDepartment=[] OldDivision=[] OldParent=[VRT] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[510UC1] 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 = "510UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "165KTD" " nrows=0 ERROR: No rows found for Oldextn= OldPABX= OldExtnGroup=165KTD ===================================================== aline=[,KTDVACA,,,VAC,,,,VACUC1,,VAC,VAC,UCP,,,,,] OldExtn=[] OldExtnGroup=[KTDVACA] OldDepartment=[] OldDivision=[] OldParent=[VAC] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VACUC1] 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 = "VACUC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "KTDVACA" " nrows=75 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 = "KTDVACA" " handleOld() recordno=38844 surname=.UNPROGRAMMED firstname= extension=13494 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38844] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38844" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38844] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38844" handleOld() recordno=55092 surname=.UNPROGRAMMED firstname= extension=13466 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 55092] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 55092" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 55092] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 55092" handleOld() recordno=160261 surname=.UNPROGRAMMED firstname= extension=13421 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 160261] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 160261" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 160261] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 160261" handleOld() recordno=10631 surname=.UNPROGRAMMED firstname= extension=13431 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 10631] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 10631" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 10631] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 10631" handleOld() recordno=38846 surname=.UNPROGRAMMED firstname= extension=13495 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38846] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38846" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38846] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38846" handleOld() recordno=38849 surname=.UNPROGRAMMED firstname= extension=13496 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38849] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38849" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38849] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38849" handleOld() recordno=38850 surname=.UNPROGRAMMED firstname= extension=13497 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38850] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38850" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38850] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38850" handleOld() recordno=38842 surname=.UNPROGRAMMED firstname= extension=13493 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38842] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38842" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38842] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38842" handleOld() recordno=38840 surname=.UNPROGRAMMED firstname= extension=13492 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38840] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38840" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38840] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38840" handleOld() recordno=38832 surname=.UNPROGRAMMED firstname= extension=13488 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38832] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38832" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38832] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38832" handleOld() recordno=38834 surname=.UNPROGRAMMED firstname= extension=13489 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38834] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38834" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38834] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38834" handleOld() recordno=38836 surname=.UNPROGRAMMED firstname= extension=13490 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38836] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38836" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38836] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38836" handleOld() recordno=38821 surname=.UNPROGRAMMED firstname= extension=13483 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38821] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38821" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38821] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38821" handleOld() recordno=38824 surname=.UNPROGRAMMED firstname= extension=13484 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38824] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38824" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38824] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38824" handleOld() recordno=38826 surname=.UNPROGRAMMED firstname= extension=13485 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38826] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38826" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38826] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38826" handleOld() recordno=38829 surname=.UNPROGRAMMED firstname= extension=13486 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38829] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38829" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38829] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38829" handleOld() recordno=38830 surname=.UNPROGRAMMED firstname= extension=13487 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38830] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38830" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38830] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38830" handleOld() recordno=38814 surname=.UNPROGRAMMED firstname= extension=13479 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38814] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38814" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38814] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38814" handleOld() recordno=38815 surname=.UNPROGRAMMED firstname= extension=13480 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38815] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38815" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38815] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38815" handleOld() recordno=38818 surname=.UNPROGRAMMED firstname= extension=13481 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38818] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38818" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38818] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38818" handleOld() recordno=38820 surname=.UNPROGRAMMED firstname= extension=13482 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38820] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38820" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38820] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38820" handleOld() recordno=38804 surname=.UNPROGRAMMED firstname= extension=13469 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38804] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38804" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38804] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38804" handleOld() recordno=38805 surname=.UNPROGRAMMED firstname= extension=13470 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38805" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38805" handleOld() recordno=38806 surname=.UNPROGRAMMED firstname= extension=13471 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38806] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38806" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38806] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38806" handleOld() recordno=38807 surname=.UNPROGRAMMED firstname= extension=13472 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38807] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38807" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38807] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38807" handleOld() recordno=38808 surname=.UNPROGRAMMED firstname= extension=13473 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38808] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38808" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38808] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38808" handleOld() recordno=38809 surname=.UNPROGRAMMED firstname= extension=13474 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38809] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38809" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38809] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38809" handleOld() recordno=38810 surname=.UNPROGRAMMED firstname= extension=13475 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38810] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38810" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38810] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38810" handleOld() recordno=163653 surname=.UNPROGRAMMED firstname= extension=13427 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 163653] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 163653" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 163653] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 163653" handleOld() recordno=38811 surname=.UNPROGRAMMED firstname= extension=13476 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38811] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38811" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38811] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38811" handleOld() recordno=38812 surname=.UNPROGRAMMED firstname= extension=13477 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38812] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38812" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38812] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38812" handleOld() recordno=38813 surname=.UNPROGRAMMED firstname= extension=13478 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38813] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38813" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38813] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38813" handleOld() recordno=38796 surname=.UNPROGRAMMED firstname= extension=13461 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38796] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38796" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38796] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38796" handleOld() recordno=38797 surname=.UNPROGRAMMED firstname= extension=13462 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38797] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38797" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38797] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38797" handleOld() recordno=38798 surname=.UNPROGRAMMED firstname= extension=13463 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38798] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38798" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38798] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38798" handleOld() recordno=38799 surname=.UNPROGRAMMED firstname= extension=13464 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38799] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38799" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38799] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38799" handleOld() recordno=38800 surname=.UNPROGRAMMED firstname= extension=13465 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38800] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38800" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38800] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38800" handleOld() recordno=38802 surname=.UNPROGRAMMED firstname= extension=13467 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38802] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38802" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38802] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38802" handleOld() recordno=38803 surname=.UNPROGRAMMED firstname= extension=13468 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38803" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38803" handleOld() recordno=38785 surname=.UNPROGRAMMED firstname= extension=13450 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38785] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38785" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38785] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38785" handleOld() recordno=38786 surname=.UNPROGRAMMED firstname= extension=13451 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38786" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38786" handleOld() recordno=38787 surname=.UNPROGRAMMED firstname= extension=13452 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38787] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38787" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38787] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38787" handleOld() recordno=38788 surname=.UNPROGRAMMED firstname= extension=13453 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38788] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38788" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38788] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38788" handleOld() recordno=38789 surname=.UNPROGRAMMED firstname= extension=13454 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38789] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38789" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38789] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38789" handleOld() recordno=38790 surname=.UNPROGRAMMED firstname= extension=13455 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38790] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38790" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38790] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38790" handleOld() recordno=38791 surname=.UNPROGRAMMED firstname= extension=13456 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38791] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38791" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38791] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38791" handleOld() recordno=38792 surname=.UNPROGRAMMED firstname= extension=13457 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38792] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38792" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38792] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38792" handleOld() recordno=38793 surname=.UNPROGRAMMED firstname= extension=13458 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38793] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38793" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38793] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38793" handleOld() recordno=38794 surname=.UNPROGRAMMED firstname= extension=13459 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38794] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38794" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38794] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38794" handleOld() recordno=38777 surname=.UNPROGRAMMED firstname= extension=13442 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38777] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38777" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38777] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38777" handleOld() recordno=38780 surname=.UNPROGRAMMED firstname= extension=13445 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38780] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38780" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38780] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38780" handleOld() recordno=38781 surname=.UNPROGRAMMED firstname= extension=13446 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38781" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38781" handleOld() recordno=38782 surname=.UNPROGRAMMED firstname= extension=13447 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38782] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38782" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38782] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38782" handleOld() recordno=38783 surname=.UNPROGRAMMED firstname= extension=13448 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38783" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38783" handleOld() recordno=38784 surname=.UNPROGRAMMED firstname= extension=13449 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38784] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38784" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38784] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38784" handleOld() recordno=38766 surname=.VACANT firstname= extension=13430 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38766] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38766" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38766] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38766" handleOld() recordno=38767 surname=.UNPROGRAMMED firstname= extension=13432 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38767] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38767" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38767] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38767" handleOld() recordno=38769 surname=.UNPROGRAMMED firstname= extension=13434 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38769" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38769" handleOld() recordno=38770 surname=.UNPROGRAMMED firstname= extension=13435 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38770] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38770" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38770] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38770" handleOld() recordno=38771 surname=.UNPROGRAMMED firstname= extension=13436 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38771] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38771" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38771] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38771" handleOld() recordno=38772 surname=.UNPROGRAMMED firstname= extension=13437 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38772" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38772" handleOld() recordno=38773 surname=.UNPROGRAMMED firstname= extension=13438 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38773] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38773" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38773] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38773" handleOld() recordno=38774 surname=.UNPROGRAMMED firstname= extension=13439 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38774] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38774" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38774] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38774" handleOld() recordno=38775 surname=.UNPROGRAMMED firstname= extension=13440 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38775] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38775" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38775] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38775" handleOld() recordno=38776 surname=.UNPROGRAMMED firstname= extension=13441 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38776] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38776" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38776] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38776" handleOld() recordno=38759 surname=.UNPROGRAMMED firstname= extension=13417 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38759" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38759" handleOld() recordno=38762 surname=.VACANT firstname= extension=13420 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38762] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38762" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38762] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38762" handleOld() recordno=38764 surname=.UNPROGRAMMED firstname= extension=13428 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38764] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38764" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38764] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38764" handleOld() recordno=38765 surname=.UNPROGRAMMED firstname= extension=13429 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38765] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38765" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38765] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38765" handleOld() recordno=38754 surname=.VACANT firstname= extension=13412 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38754] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38754" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38754] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38754" handleOld() recordno=38752 surname=.VACANT firstname= extension=13410 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38752" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38752" handleOld() recordno=38753 surname=.VACANT firstname= extension=13411 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38753] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38753" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38753] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38753" handleOld() recordno=45898 surname=.VACANT firstname= extension=13402 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 45898] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 45898" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 45898] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 45898" handleOld() recordno=22595 surname=.UNPROGRAMMED firstname= extension=13423 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 22595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 22595" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 22595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 22595" handleOld() recordno=38839 surname=.UNPROGRAMMED firstname= extension=13491 site=KTD extgroupunique=KTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38839] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC1" where recordno = 38839" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38839] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="VAC" where recordno = 38839" nrows=75 ===================================================== aline=[,0318KTD8,,,YTD,,,,0318UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0318KTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0318UC9] 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 = "0318UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0318KTD8" " 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 = "0318KTD8" " handleOld() recordno=53683 surname=MOREL firstname=MARIO extension=13400 site=KTD extgroupunique=0318KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0318UC9" where recordno = 53683] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0318UC9" where recordno = 53683" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 53683] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 53683" nrows=1 ===================================================== aline=[,0453KTD8,,,YTD,,,,0453UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0453KTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0453UC1] 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 = "0453UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0453KTD8" " nrows=5 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 = "0453KTD8" " handleOld() recordno=36028 surname=SULLIVAN firstname=JOHN extension=13404 site=KTD extgroupunique=0453KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 36028] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 36028" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 36028] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 36028" handleOld() recordno=38758 surname=.ASSIGNED firstname= extension=13416 site=KTD extgroupunique=0453KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 38758] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 38758" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38758] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38758" handleOld() recordno=32990 surname=REDFERN firstname=BEN extension=13403 site=KTD extgroupunique=0453KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 32990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 32990" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 32990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 32990" handleOld() recordno=36044 surname=.ASSIGNED firstname= extension=13401 site=KTD extgroupunique=0453KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 36044] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 36044" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 36044] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 36044" handleOld() recordno=33527 surname=.ASSIGNED firstname= extension=13405 site=KTD extgroupunique=0453KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 33527] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0453UC1" where recordno = 33527" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 33527] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 33527" nrows=5 ===================================================== aline=[,0456KTD8,,,YTD,,,,0456UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0456KTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0456UC1] 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 = "0456UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0456KTD8" " 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 = "0456KTD8" " handleOld() recordno=161160 surname=.ASSIGNED firstname= extension=13413 site=KTD extgroupunique=0456KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC1" where recordno = 161160] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC1" where recordno = 161160" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161160] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161160" handleOld() recordno=44616 surname=.ASSIGNED firstname= extension=13407 site=KTD extgroupunique=0456KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC1" where recordno = 44616] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC1" where recordno = 44616" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 44616] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 44616" handleOld() recordno=172939 surname=BOTROS firstname=GEORGE extension=13408 site=KTD extgroupunique=0456KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC1" where recordno = 172939] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0456UC1" where recordno = 172939" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 172939] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 172939" nrows=3 ===================================================== aline=[,5761KTD8,,,YTD,,,,5761UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5761KTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5761UC9] 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 = "5761UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5761KTD8" " nrows=32 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 = "5761KTD8" " handleOld() recordno=161059 surname=SILBY firstname=DAMIEN extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161059] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161059" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161059] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161059" handleOld() recordno=157899 surname=KAPOOR firstname=PRADEEP extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 157899] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 157899" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 157899] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 157899" handleOld() recordno=163696 surname=WILLIAMS firstname=MURRAY extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163696] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163696" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163696] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163696" handleOld() recordno=163695 surname=MEHTA firstname=JIGNESH extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163695] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163695" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163695] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163695" handleOld() recordno=163694 surname=GLADSTONE firstname=ROBERT extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163694] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163694" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163694] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163694" handleOld() recordno=161062 surname=STONE firstname=TERESA extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161062] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161062" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161062] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161062" handleOld() recordno=163693 surname=GIBSON firstname=BRAITHE extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163693] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 163693" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163693] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163693" handleOld() recordno=161087 surname=VERTIGAN firstname=IAN extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161087] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161087" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161087] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161087" handleOld() recordno=57011 surname=RIGAS firstname=YIOTA extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 57011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 57011" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57011" handleOld() recordno=161050 surname=ANDERSON firstname=JAMIE extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161050" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161050" handleOld() recordno=161082 surname=LINTON firstname=TONY extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161082] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161082" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161082] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161082" handleOld() recordno=157895 surname=MOSKOVITA firstname=SUSAN extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 157895] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 157895" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 157895] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 157895" handleOld() recordno=55805 surname=BYRNE firstname=STEPHEN extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 55805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 55805" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 55805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 55805" handleOld() recordno=56974 surname=MUDHER firstname=SURINDER extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 56974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 56974" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56974" handleOld() recordno=38768 surname=.ASSIGNED firstname= extension=13433 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 38768] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 38768" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38768] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38768" handleOld() recordno=57010 surname=PITTAS firstname=CHRISTOS extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 57010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 57010" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57010" handleOld() recordno=55803 surname=BRADFORD firstname=KEVIN extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 55803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 55803" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 55803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 55803" handleOld() recordno=161081 surname=GRANT firstname=ANDREW extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161081] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161081" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161081] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161081" handleOld() recordno=56993 surname=MEACHAM firstname=KERRY extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 56993] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 56993" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56993] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56993" handleOld() recordno=57015 surname=TAYLOR firstname=ROSS extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 57015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 57015" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57015" handleOld() recordno=161078 surname=BARRETT firstname=MARK extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161078] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161078" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161078] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161078" handleOld() recordno=161052 surname=DEAN firstname=ANNE extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161052] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161052" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161052] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161052" handleOld() recordno=161051 surname=CROUTHER firstname=CARL extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161051] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161051" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161051] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161051" handleOld() recordno=161157 surname=HEMI firstname=SUZANNE extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161157] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161157" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161157] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161157" handleOld() recordno=162738 surname=GRIVAS firstname=MARK extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 162738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 162738" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162738" handleOld() recordno=161159 surname=LORD firstname=ANDREW extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161159] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161159" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161159] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161159" handleOld() recordno=161056 surname=MOYSEY firstname=DEB extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161056] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161056" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161056] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161056" handleOld() recordno=161156 surname=EVERITT firstname=DIANNE extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161156] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161156" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161156] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161156" handleOld() recordno=160983 surname=TOMAR firstname=AMAR extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 160983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 160983" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160983" handleOld() recordno=161166 surname=RODERO firstname=PORFIRIO extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161166] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 161166" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161166] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 161166" handleOld() recordno=162754 surname=SIDDIQUI firstname=NADEEM extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 162754] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 162754" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162754] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162754" handleOld() recordno=173006 surname=.ASSIGNED firstname= extension=13424 site=KTD extgroupunique=5761KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 173006] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC9" where recordno = 173006" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 173006] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 173006" nrows=32 ===================================================== aline=[,5806KTD8,,,YTD,,,,5806UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5806KTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5806UC9] 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 = "5806UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5806KTD8" " nrows=131 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 = "5806KTD8" " handleOld() recordno=158962 surname=SHANAHAN firstname=DARREN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158962" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158962" handleOld() recordno=45438 surname=HARPER firstname=PAUL R extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 45438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 45438" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 45438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 45438" handleOld() recordno=52147 surname=FREEMAN firstname=ALAN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 52147] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 52147" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 52147] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 52147" handleOld() recordno=158959 surname=COLLYER firstname=STEPHEN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158959" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158959" handleOld() recordno=2045 surname=ANDREWS firstname=HELEN M extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2045] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2045" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2045] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2045" handleOld() recordno=2052 surname=ANDRONIS firstname=ANGELIS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2052] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2052" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2052] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2052" handleOld() recordno=28011 surname=QUACH firstname=LIEU KIEN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 28011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 28011" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 28011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 28011" handleOld() recordno=2556 surname=BANKS firstname=GRAHAM A extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2556" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2556" handleOld() recordno=57002 surname=SPITERI firstname=MARIO extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57002] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57002" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57002] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57002" handleOld() recordno=2582 surname=FERNANDO firstname=DINANTHI extension=13425 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2582] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2582" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2582] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2582" handleOld() recordno=2711 surname=BATES firstname=LEONARD R extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2711] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2711" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2711] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2711" handleOld() recordno=30350 surname=SMITH firstname=GERALD W extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 30350] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 30350" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 30350] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 30350" handleOld() recordno=163514 surname=TRAN firstname=MINH extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163514] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163514" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163514] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163514" handleOld() recordno=163506 surname=DUPARC firstname=PHILIPPE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163506] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163506" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163506] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163506" handleOld() recordno=2959 surname=BERNARD firstname=JEAN J extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 2959" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 2959" handleOld() recordno=3228 surname=BOKTOR firstname=AMIR extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 3228] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 3228" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 3228] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 3228" handleOld() recordno=32856 surname=.ASSIGNED firstname= extension=13409 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 32856] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 32856" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 32856] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 32856" handleOld() recordno=3366 surname=BOWMAN firstname=ALLAN W extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 3366] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 3366" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 3366] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 3366" handleOld() recordno=163504 surname=CHAMPION firstname=SHERRY ANN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163504] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163504" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163504] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163504" handleOld() recordno=163508 surname=HOLTEN firstname=SIMON extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163508] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163508" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163508] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163508" handleOld() recordno=163502 surname=BOWSHALL firstname=DAVID extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163502] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163502" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163502] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163502" handleOld() recordno=56980 surname=CHLIAKHTINE firstname=ANATOLE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56980" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56980" handleOld() recordno=4532 surname=CHRISTO firstname=ANNA extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 4532] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 4532" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 4532] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 4532" handleOld() recordno=4936 surname=CONIDONI firstname=DOMENICO extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 4936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 4936" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 4936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 4936" handleOld() recordno=179398 surname=MCKEON firstname=ANTHONY extension=13418 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 179398] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 179398" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 179398] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 179398" handleOld() recordno=5525 surname=DAGHISTANI firstname=GHASSAN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 5525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 5525" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 5525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 5525" handleOld() recordno=5556 surname=DAM firstname=TO extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 5556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 5556" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 5556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 5556" handleOld() recordno=5836 surname=DE-ZILVA firstname=CHRISTOPHE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 5836] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 5836" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 5836] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 5836" handleOld() recordno=6181 surname=PRENDERGAST firstname=DUONG extension=13426 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 6181] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 6181" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 6181] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 6181" handleOld() recordno=6234 surname=DO firstname=VAN PHAT extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 6234] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 6234" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 6234] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 6234" handleOld() recordno=160558 surname=VIRK firstname=RAJINDER extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160558] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160558" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160558] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160558" handleOld() recordno=162312 surname=KOROMINAS firstname=CHRIS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162312] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162312" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162312] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162312" handleOld() recordno=163503 surname=CADAN firstname=PHILLIP extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163503] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163503" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163503] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163503" handleOld() recordno=160544 surname=BREHAUT firstname=CHRIS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160544] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160544" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160544] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160544" handleOld() recordno=7032 surname=FEELY firstname=JAMES extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 7032] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 7032" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 7032] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 7032" handleOld() recordno=163510 surname=LINDEMANN firstname=PETER extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163510" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163510" handleOld() recordno=27769 surname=FLORES firstname=JAIME E extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27769" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27769] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27769" handleOld() recordno=162418 surname=.ASSIGNED firstname= extension=13414 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162418] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162418" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162418] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162418" handleOld() recordno=56972 surname=HEINRICH firstname=KAY P extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56972" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56972" handleOld() recordno=162544 surname=LAMBERT firstname=MARTYN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162544] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162544" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162544] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162544" handleOld() recordno=56984 surname=DICKSON firstname=JAMIE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56984] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56984" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56984] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56984" handleOld() recordno=57000 surname=PRIDGEON firstname=ERNEST extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57000] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57000" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57000] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57000" handleOld() recordno=56981 surname=CRLJEN firstname=DANIEL extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56981" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56981" handleOld() recordno=56977 surname=BAKIC firstname=PETER extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56977" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56977" handleOld() recordno=11257 surname=LEAUPEPE firstname=DEREK extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11257] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11257" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11257] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11257" handleOld() recordno=57006 surname=LEE firstname=ANDREW S extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57006] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57006" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57006] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57006" handleOld() recordno=11375 surname=LEOUSIS firstname=DIMITRIOS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11375] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11375" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11375] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11375" handleOld() recordno=11682 surname=LU firstname=QUAN THE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11682] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11682" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11682] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11682" handleOld() recordno=11738 surname=LUONG firstname=TUNG extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11738" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11738" handleOld() recordno=11765 surname=LY firstname=VINH extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11765] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11765" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11765] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11765" handleOld() recordno=54001 surname=MCKENZIE firstname=VINCENT extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 54001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 54001" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 54001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 54001" handleOld() recordno=11909 surname=MAHANIVONG firstname=SOMCHANH extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11909" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11909" handleOld() recordno=11934 surname=MAIMONIS firstname=THEO extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 11934" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 11934" handleOld() recordno=160557 surname=VAN BUUREN firstname=CASSANDRA extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160557] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160557" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160557] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160557" handleOld() recordno=12250 surname=MASARATI firstname=MEHRDAD extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 12250] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 12250" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 12250] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 12250" handleOld() recordno=163507 surname=HENNESSEY firstname=MATHEW extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163507] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163507" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163507] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163507" handleOld() recordno=12668 surname=MCKEE firstname=SUSAN L extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 12668] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 12668" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 12668] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 12668" handleOld() recordno=12776 surname=MCMILLAN firstname=BRIAN J extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 12776] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 12776" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 12776] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 12776" handleOld() recordno=160555 surname=SHAW firstname=MARK extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160555] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160555" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160555] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160555" handleOld() recordno=13407 surname=MORAN firstname=RONALD K extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13407" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13407" handleOld() recordno=38795 surname=.ASSIGNED firstname= extension=13460 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38795] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38795" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38795] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38795" handleOld() recordno=38778 surname=.ASSIGNED firstname=TRAM DEPOT extension=13443 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38778] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38778" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38778] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38778" handleOld() recordno=38779 surname=.ASSIGNED firstname= extension=13444 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38779] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38779" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38779] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38779" handleOld() recordno=13783 surname=NATHANIEL firstname=ZARIN S extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13783" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13783" handleOld() recordno=27866 surname=HORVAT firstname=MARIJAN M extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27866] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27866" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27866] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27866" handleOld() recordno=13893 surname=NGAKHAM firstname=INH extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13893] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13893" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13893] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13893" handleOld() recordno=13910 surname=NGUYEN firstname=DUY BUU extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13910" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13910" handleOld() recordno=13928 surname=NGUYEN firstname=MINH HOANG extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 13928" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 13928" handleOld() recordno=32736 surname=SANTOS firstname=CHRIS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 32736] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 32736" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 32736] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 32736" handleOld() recordno=173007 surname=.ASSIGNED firstname= extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 173007] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 173007" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 173007] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 173007" handleOld() recordno=14040 surname=NOME firstname=ELIEPA extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 14040] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 14040" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 14040] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 14040" handleOld() recordno=38761 surname=COOLING firstname=LUKE extension=13419 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38761] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38761" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38761] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38761" handleOld() recordno=160554 surname=REILLY firstname=TREVOR extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160554] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160554" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160554] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160554" handleOld() recordno=38760 surname=POWELL firstname=ADRIAN extension=13418 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38760] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 38760" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38760] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 38760" handleOld() recordno=27864 surname=HOLTHAM firstname=DAVID J extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27864] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27864" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27864] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27864" handleOld() recordno=163509 surname=LESCUN firstname=DAVID extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163509" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163509" handleOld() recordno=14954 surname=PETERS firstname=DIANE R extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 14954] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 14954" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 14954] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 14954" handleOld() recordno=15050 surname=PHAM firstname=HUYNH HUNG extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 15050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 15050" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 15050] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 15050" handleOld() recordno=15397 surname=POWELL firstname=JOHN M extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 15397] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 15397" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 15397] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 15397" handleOld() recordno=160553 surname=NATTRASS firstname=WAYNE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160553" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160553" handleOld() recordno=56982 surname=DALY firstname=BRIAN M extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56982" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56982" handleOld() recordno=15665 surname=RAJAPAKSHA firstname=SUMITHRASE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 15665] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 15665" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 15665] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 15665" handleOld() recordno=35675 surname=LIM firstname=BENG BIAN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 35675] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 35675" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 35675] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 35675" handleOld() recordno=16276 surname=ROSSI firstname=GERMAN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16276] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16276" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16276] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16276" handleOld() recordno=163505 surname=CRUZ firstname=NORBERTO extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163505] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163505" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163505] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163505" handleOld() recordno=16498 surname=SAID firstname=NADER extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16498] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16498" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16498] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16498" handleOld() recordno=33145 surname=WOLD firstname=GREGORY J extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 33145] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 33145" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 33145] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 33145" handleOld() recordno=16628 surname=SAO firstname=ANN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16628" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16628" handleOld() recordno=56996 surname=MCDONALD firstname=ALISTAIR extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56996] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56996" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56996] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56996" handleOld() recordno=16916 surname=SEMERCI firstname=ARTIN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 16916" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 16916" handleOld() recordno=51486 surname=SHEIKH firstname=TARIK extension=13406 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 51486] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 51486" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 51486] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 51486" handleOld() recordno=31923 surname=LOW firstname=JOHN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 31923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 31923" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 31923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 31923" handleOld() recordno=162311 surname=FERNANDO firstname=GIHAN R extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162311] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162311" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162311] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162311" handleOld() recordno=56973 surname=ANDREWS firstname=HARVEY J extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56973] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56973" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56973] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56973" handleOld() recordno=56994 surname=KYPREOS firstname=PETER extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56994" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56994" handleOld() recordno=160550 surname=HAMAWI firstname=SALLY extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160550" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160550" handleOld() recordno=160549 surname=GALAM firstname=NOELY extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160549] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160549" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160549] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160549" handleOld() recordno=163513 surname=POTTS firstname=GUY extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163513] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163513" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163513] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163513" handleOld() recordno=17883 surname=STATHIS firstname=ATHANASSIO extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 17883] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 17883" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 17883] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 17883" handleOld() recordno=55761 surname=SOLTAN firstname=MARY extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 55761] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 55761" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 55761] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 55761" handleOld() recordno=163511 surname=MARSH firstname=DAVID extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163511" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163511" handleOld() recordno=160548 surname=EVANS firstname=JESSE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160548" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160548" handleOld() recordno=158958 surname=BROMAGE firstname=GREG extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158958" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158958" handleOld() recordno=27375 surname=AMIRIDIS firstname=PANAGIOTIS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27375] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 27375" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27375] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 27375" handleOld() recordno=56987 surname=JONES firstname=LAURENCE C extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56987" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56987" handleOld() recordno=56983 surname=DAVID firstname=DOUGLAS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56983" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56983" handleOld() recordno=18772 surname=TIPOUGIKIDIS firstname=BILL extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 18772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 18772" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 18772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 18772" handleOld() recordno=18936 surname=TRAN firstname=CONG NGAN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 18936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 18936" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 18936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 18936" handleOld() recordno=160547 surname=EGAN firstname=EMILY extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160547] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160547" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160547] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160547" handleOld() recordno=18955 surname=TRAN firstname=VAN NGHIA extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 18955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 18955" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 18955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 18955" handleOld() recordno=19051 surname=TRUONG firstname=MYN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 19051] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 19051" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 19051] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 19051" handleOld() recordno=160546 surname=COX firstname=CHARLES extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160546] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 160546" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160546] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 160546" handleOld() recordno=56976 surname=ANTONOPOULOS firstname=NICHOLAS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56976" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56976" handleOld() recordno=22400 surname=.ASSIGNED firstname= extension=13415 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 22400] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 22400" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 22400] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 22400" handleOld() recordno=57005 surname=WHITTAKER firstname=BRENTON extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57005] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57005" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57005] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57005" handleOld() recordno=57009 surname=PIOQUINTO firstname=FELBEN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57009] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 57009" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57009] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 57009" handleOld() recordno=53994 surname=GOODMAN firstname=TREVOR extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 53994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 53994" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 53994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 53994" handleOld() recordno=20624 surname=YACOUB firstname=MAHER extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20624" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20624" handleOld() recordno=20628 surname=YAN-YUE-PANG firstname=HI SIN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20628" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20628" handleOld() recordno=20629 surname=YAN-YUE-PANG firstname=LOY SIN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20629" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20629" handleOld() recordno=20805 surname=ZOTALIS firstname=DIMITRIOS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 20805" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 20805" handleOld() recordno=56975 surname=SOENY firstname=ASHOK extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 56975" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 56975" handleOld() recordno=162545 surname=MCKEDDIE firstname=JOHN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162545] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162545" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162545] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162545" handleOld() recordno=163518 surname=YANNOUKAS firstname=JOHN extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163518" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163518" handleOld() recordno=163515 surname=WESTON firstname=LYNETTE extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163515] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163515" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163515] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163515" handleOld() recordno=163516 surname=WU firstname=SIMON extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163516] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163516" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163516] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163516" handleOld() recordno=163517 surname=XENITOPOULOS firstname=NICHOLAS extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163517] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163517" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163517] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163517" handleOld() recordno=158963 surname=SMITH firstname=DAVID extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158963] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 158963" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158963] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 158963" handleOld() recordno=163512 surname=PEACOCK firstname=DESMOND extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163512] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 163512" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163512] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 163512" handleOld() recordno=162543 surname=KEI firstname=MILO extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162543] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162543" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162543] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162543" handleOld() recordno=162542 surname=HEARSE firstname=PHILLIP extension=13422 site=KTD extgroupunique=5806KTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162542] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5806UC9" where recordno = 162542" sqlcmd=[update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162542] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="29/05/2018" ,jobno="RS290518KTDTRAMDEPOT" ,division="YTF" where recordno = 162542" nrows=131