DBPATH=[/u/catcom/database:/u/catcom/forms Doing fname = BulkImportForDirectorySTDTramDepots.csv ++++++++++++++++++++++++++++ ===================================================== aline=[OldExtn,OldExtnGgroup,OldDepartment,OldDivision,OldParent,OldPABX,NewVACExtnGroup,NewExtn,NewExtnGroup,NewDepartment,NewDivision,NewParent,NewPABX,NewLocation,NewTelephone,NewComment,NewTEC,NewNode] Skip header ===================================================== aline=[,165STD,,,VRT,,,,510UC5,,510,VRT,UCP,,,,,] OldExtn=[] OldExtnGroup=[165STD] OldDepartment=[] OldDivision=[] OldParent=[VRT] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[510UC5] 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 = "510UC5"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "165STD" " nrows=0 ERROR: No rows found for Oldextn= OldPABX= OldExtnGroup=165STD ===================================================== aline=[,STDVACA,,,VAC,,,,VACUC5,,VAC,VAC,UCP,,,,,] OldExtn=[] OldExtnGroup=[STDVACA] OldDepartment=[] OldDivision=[] OldParent=[VAC] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VACUC5] 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 = "VACUC5"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "STDVACA" " nrows=52 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 = "STDVACA" " handleOld() recordno=57023 surname=.UNPROGRAMMED firstname= extension=13562 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 57023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 57023" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 57023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 57023" handleOld() recordno=36279 surname=.UNPROGRAMMED firstname= extension=13597 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 36279] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 36279" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 36279] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 36279" handleOld() recordno=31438 surname=.UNPROGRAMMED firstname= extension=13541 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 31438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 31438" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 31438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 31438" handleOld() recordno=39946 surname=.VACANT firstname= extension=13510 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39946" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39946" handleOld() recordno=39955 surname=.UNPROGRAMMED firstname= extension=13516 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39955" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39955" handleOld() recordno=39956 surname=.UNPROGRAMMED firstname= extension=13517 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39956] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39956" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39956] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39956" handleOld() recordno=39957 surname=.UNPROGRAMMED firstname= extension=13518 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39957" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39957" handleOld() recordno=39958 surname=.UNPROGRAMMED firstname= extension=13519 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39958" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39958" handleOld() recordno=39964 surname=.UNPROGRAMMED firstname= extension=13526 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39964" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39964" handleOld() recordno=55477 surname=.UNPROGRAMMED firstname= extension=13544 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 55477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 55477" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 55477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 55477" handleOld() recordno=57319 surname=.UNPROGRAMMED firstname= extension=13592 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 57319] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 57319" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 57319] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 57319" handleOld() recordno=39972 surname=.UNPROGRAMMED firstname= extension=13530 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39972" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39972" handleOld() recordno=39976 surname=.VACANT firstname= extension=13533 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39976" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39976" handleOld() recordno=39979 surname=.VACANT firstname= extension=13536 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39979" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39979" handleOld() recordno=39983 surname=.UNPROGRAMMED firstname= extension=13542 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39983" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39983" handleOld() recordno=39987 surname=.UNPROGRAMMED firstname= extension=13547 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39987" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39987" handleOld() recordno=39988 surname=.UNPROGRAMMED firstname= extension=13548 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39988] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39988" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39988] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39988" handleOld() recordno=39990 surname=.UNPROGRAMMED firstname= extension=13550 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39990" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39990" handleOld() recordno=39991 surname=.UNPROGRAMMED firstname= extension=13551 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39991] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39991" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39991] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39991" handleOld() recordno=39993 surname=.UNPROGRAMMED firstname= extension=13553 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39993] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39993" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39993] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39993" handleOld() recordno=39994 surname=.UNPROGRAMMED firstname= extension=13554 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39994" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39994" handleOld() recordno=39996 surname=.UNPROGRAMMED firstname= extension=13556 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39996] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39996" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39996] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39996" handleOld() recordno=39997 surname=.UNPROGRAMMED firstname= extension=13559 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39997] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39997" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39997] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39997" handleOld() recordno=39998 surname=.VACANT firstname= extension=13560 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 39998" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 39998" handleOld() recordno=40004 surname=.UNPROGRAMMED firstname= extension=13566 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40004] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40004" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40004] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40004" handleOld() recordno=40007 surname=.UNPROGRAMMED firstname= extension=13569 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40007] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40007" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40007] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40007" handleOld() recordno=40008 surname=.UNPROGRAMMED firstname= extension=13570 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40008] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40008" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40008] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40008" handleOld() recordno=40009 surname=.UNPROGRAMMED firstname= extension=13571 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40009] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40009" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40009] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40009" handleOld() recordno=40011 surname=.UNPROGRAMMED firstname= extension=13573 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40011" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40011" handleOld() recordno=40012 surname=.UNPROGRAMMED firstname= extension=13574 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40012" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40012" handleOld() recordno=40013 surname=.UNPROGRAMMED firstname= extension=13575 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40013] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40013" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40013] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40013" handleOld() recordno=40014 surname=.UNPROGRAMMED firstname= extension=13576 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40014] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40014" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40014] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40014" handleOld() recordno=40015 surname=.UNPROGRAMMED firstname= extension=13577 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40015" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40015" handleOld() recordno=40016 surname=.UNPROGRAMMED firstname= extension=13578 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40016] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40016" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40016] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40016" handleOld() recordno=40017 surname=.UNPROGRAMMED firstname= extension=13579 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40017] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40017" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40017] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40017" handleOld() recordno=40018 surname=.UNPROGRAMMED firstname= extension=13580 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40018] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40018" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40018] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40018" handleOld() recordno=40019 surname=.UNPROGRAMMED firstname= extension=13581 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40019] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40019" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40019] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40019" handleOld() recordno=40020 surname=.UNPROGRAMMED firstname= extension=13582 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40020] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40020" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40020] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40020" handleOld() recordno=40021 surname=.UNPROGRAMMED firstname= extension=13583 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40021] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40021" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40021] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40021" handleOld() recordno=40022 surname=.UNPROGRAMMED firstname= extension=13584 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40022] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40022" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40022] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40022" handleOld() recordno=40023 surname=.UNPROGRAMMED firstname= extension=13585 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40023" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40023" handleOld() recordno=40025 surname=.UNPROGRAMMED firstname= extension=13587 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40025" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40025" handleOld() recordno=40026 surname=.VACANT firstname= extension=13588 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40026] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40026" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40026] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40026" handleOld() recordno=40031 surname=.VACANT firstname= extension=13594 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40031] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40031" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40031] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40031" handleOld() recordno=40033 surname=.UNPROGRAMMED firstname= extension=13596 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 40033" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 40033" handleOld() recordno=159823 surname=.UNPROGRAMMED firstname= extension=13500 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 159823] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 159823" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 159823] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 159823" handleOld() recordno=159821 surname=.UNPROGRAMMED firstname= extension=13506 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 159821] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 159821" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 159821] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 159821" handleOld() recordno=47433 surname=.UNPROGRAMMED firstname= extension=13511 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 47433] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 47433" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 47433] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 47433" handleOld() recordno=49680 surname=.UNPROGRAMMED firstname= extension=13529 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 49680] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 49680" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 49680] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 49680" handleOld() recordno=167644 surname=.UNPROGRAMMED firstname= extension=13590 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 167644] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 167644" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 167644] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 167644" handleOld() recordno=57020 surname=.VACANT firstname= extension=13508 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 57020] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 57020" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 57020] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 57020" handleOld() recordno=168106 surname=.UNPROGRAMMED firstname= extension=13537 site=STD extgroupunique=STDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 168106] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC5" where recordno = 168106" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 168106] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="VAC" where recordno = 168106" nrows=52 ===================================================== aline=[,0459STD8,,,YTD,,,,0459UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0459STD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0459UC1] 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 = "0459UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0459STD8" " nrows=57 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 = "0459STD8" " handleOld() recordno=162590 surname=JELOVIC firstname=RALPH extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162590] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162590" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162590] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162590" handleOld() recordno=32914 surname=GAUCI firstname=JOSEPH extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32914] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32914" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32914] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32914" handleOld() recordno=32135 surname=SARAH firstname=ANDREW extension=13558 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32135] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32135" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32135] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32135" handleOld() recordno=163644 surname=KOLESKI firstname=JONCE extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163644] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163644" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163644] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163644" handleOld() recordno=173011 surname=.ASSIGNED firstname= extension=13561 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 173011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 173011" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173011] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173011" handleOld() recordno=173010 surname=.ASSIGNED firstname= extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 173010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 173010" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173010" handleOld() recordno=163660 surname=KARLUSIC firstname=STEPHEN extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163660" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163660" handleOld() recordno=160267 surname=.ASSIGNED firstname= extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160267] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160267" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160267] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160267" handleOld() recordno=39933 surname=.ASSIGNED firstname= extension=13501 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39933] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39933" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39933] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39933" handleOld() recordno=39938 surname=.ASSIGNED firstname= extension=13505 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39938] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39938" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39938] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39938" handleOld() recordno=39948 surname=.ASSIGNED firstname= extension=13512 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39948" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39948" handleOld() recordno=39960 surname=.ASSIGNED firstname= extension=13520 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39960" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39960" handleOld() recordno=6701 surname=ELFICK firstname=GEORGE N extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 6701] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 6701" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 6701] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 6701" handleOld() recordno=39981 surname=LEWIS firstname=GARY extension=13539 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39981" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39981" handleOld() recordno=39982 surname=.ASSIGNED firstname= extension=13540 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39982" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39982" handleOld() recordno=39992 surname=SALEH firstname=MERVAT extension=13552 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39992] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39992" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39992] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39992" handleOld() recordno=39995 surname=TACEY firstname=STEPHEN extension=13555 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39995] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 39995" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39995] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39995" handleOld() recordno=40001 surname=.ASSIGNED firstname= extension=13563 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40001" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40001" handleOld() recordno=40003 surname=.ASSIGNED firstname= extension=13565 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40003] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40003" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40003] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40003" handleOld() recordno=40005 surname=.ASSIGNED firstname= extension=13567 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40005] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40005" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40005] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40005" handleOld() recordno=40006 surname=.ASSIGNED firstname= extension=13568 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40006] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 40006" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40006] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40006" handleOld() recordno=162592 surname=LUNAN firstname=DAVID P extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162592] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162592" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162592] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162592" handleOld() recordno=8452 surname=GUN firstname=MELVUT extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 8452] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 8452" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 8452] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 8452" handleOld() recordno=8691 surname=HARALAMPOPOULO firstname=ANTONIOS extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 8691] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 8691" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 8691] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 8691" handleOld() recordno=49469 surname=FINCH firstname=NORMAN extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 49469] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 49469" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 49469] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 49469" handleOld() recordno=162597 surname=TROTTA firstname=STEPHEN S extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162597" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162597" handleOld() recordno=9981 surname=JOHNSTONE firstname=ROSS K extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 9981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 9981" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9981" handleOld() recordno=10412 surname=KEMP firstname=BERNARD extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 10412] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 10412" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 10412] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 10412" handleOld() recordno=162589 surname=BULNER firstname=FREDRICH extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162589" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162589" handleOld() recordno=47103 surname=FERNANDEZ firstname=JOSEPH extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 47103] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 47103" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 47103] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 47103" handleOld() recordno=28443 surname=MOSTICONE firstname=MARIO extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 28443] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 28443" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28443] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28443" handleOld() recordno=32817 surname=JOHNSON firstname=KENNETH W extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32817] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32817" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32817] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32817" handleOld() recordno=162595 surname=SMITH firstname=RUSSELL W extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162595" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162595" handleOld() recordno=162596 surname=SUGANTHIRAKUMAR firstname=ARASAKULAR extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162596] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162596" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162596] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162596" handleOld() recordno=13072 surname=MIKHAIL firstname=ADEL extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 13072] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 13072" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 13072] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 13072" handleOld() recordno=57037 surname=INCORVAJA firstname=VINCENT extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 57037] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 57037" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 57037] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 57037" handleOld() recordno=163645 surname=LEE firstname=WEISI extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163645] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163645" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163645] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163645" handleOld() recordno=56042 surname=HUNTER firstname=TERRY extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 56042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 56042" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56042" handleOld() recordno=162591 surname=LAW firstname=DOUGLAS extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162591] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162591" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162591] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162591" handleOld() recordno=44895 surname=.ASSIGNED firstname=BREAKDOWN extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 44895] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 44895" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 44895] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 44895" handleOld() recordno=158982 surname=MCKENZIE firstname=BRUCE extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 158982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 158982" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158982" handleOld() recordno=160659 surname=VANETTE firstname=DAVID extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160659] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160659" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160659] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160659" handleOld() recordno=160658 surname=TRAN firstname=XUAN extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160658] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160658" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160658] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160658" handleOld() recordno=47101 surname=SCHINTEIE firstname=DANILA M extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 47101] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 47101" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 47101] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 47101" handleOld() recordno=22314 surname=WILSON firstname=JEFF extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 22314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 22314" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 22314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 22314" handleOld() recordno=28372 surname=MACK firstname=DEAN A extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 28372] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 28372" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28372] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28372" handleOld() recordno=16911 surname=SELTSIOTIS firstname=DEMETRE extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 16911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 16911" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 16911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 16911" handleOld() recordno=17412 surname=SKLAVENITIS firstname=GERRY extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 17412] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 17412" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 17412] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 17412" handleOld() recordno=162588 surname=ANGELOS firstname=GEORGE extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162588] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 162588" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162588] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162588" handleOld() recordno=22087 surname=CORKEN firstname=ROBERT extension=13557 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 22087] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 22087" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 22087] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 22087" handleOld() recordno=159829 surname=.ASSIGNED firstname= extension=13504 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 159829] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 159829" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 159829] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 159829" handleOld() recordno=47320 surname=ASHWORTH firstname=MALCOLM extension=13543 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 47320] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 47320" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 47320] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 47320" handleOld() recordno=32904 surname=WONG firstname=TAK extension=13527 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 32904" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32904" handleOld() recordno=55812 surname=VAN ETTE firstname=DAVID extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 55812] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 55812" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 55812] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 55812" handleOld() recordno=160211 surname=VIERIA firstname=JOHN extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160211] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 160211" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160211] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160211" handleOld() recordno=35564 surname=EBRAHIM firstname=MEDHAT extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 35564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 35564" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 35564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 35564" handleOld() recordno=163617 surname=SIKIRIC firstname=ADNAN extension=13531 site=STD extgroupunique=0459STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163617] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0459UC1" where recordno = 163617" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163617] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163617" nrows=57 ===================================================== aline=[,0461STD8,,,YTD,,,,0461UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0461STD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0461UC1] 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 = "0461UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0461STD8" " nrows=8 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 = "0461STD8" " handleOld() recordno=31372 surname=GIULIANO firstname=MATHIEU extension=13538 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 31372] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 31372" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 31372] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 31372" handleOld() recordno=39935 surname=EVANS firstname=BARRY extension=13502 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39935" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39935" handleOld() recordno=39949 surname=.ASSIGNED firstname= extension=13513 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39949" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39949" handleOld() recordno=39953 surname=HANKS firstname=SUSAN extension=13515 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39953] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39953" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39953] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39953" handleOld() recordno=39989 surname=HIRIMUTHUGODA firstname=JANAKA extension=13549 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 39989" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39989" handleOld() recordno=9118 surname=VAN RHEENEN firstname=ALEX extension=13593 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 9118] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 9118" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9118] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9118" handleOld() recordno=159834 surname=STEVEN firstname=BRABHAM extension=13595 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 159834] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 159834" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 159834] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 159834" handleOld() recordno=160407 surname=BART firstname=PAINO extension=13564 site=STD extgroupunique=0461STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 160407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0461UC1" where recordno = 160407" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160407" nrows=8 ===================================================== aline=[,0462STD8,,,YTD,,,,0462UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0462STD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0462UC9] 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 = "0462UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0462STD8" " 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 = "0462STD8" " handleOld() recordno=45233 surname=.ASSIGNED firstname= extension=13589 site=STD extgroupunique=0462STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0462UC9" where recordno = 45233] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0462UC9" where recordno = 45233" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 45233] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 45233" nrows=1 ===================================================== aline=[,5761STD8,,,YTD,,,,5761UC10,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5761STD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5761UC10] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "5761UC10"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5761STD8" " nrows=38 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 = "5761STD8" " handleOld() recordno=162795 surname=AZIDIS firstname=VOULA extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162795] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162795" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162795] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162795" handleOld() recordno=162800 surname=FORSTNER firstname=KATRINA extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162800] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162800" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162800] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162800" handleOld() recordno=162762 surname=CAVALLIN firstname=JOHN PAUL extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162762] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162762" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162762] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162762" handleOld() recordno=163683 surname=HOGBEN firstname=JAMES extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163683] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163683" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163683] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163683" handleOld() recordno=162794 surname=ARBACI firstname=JOANNE extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162794] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162794" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162794] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162794" handleOld() recordno=162761 surname=BRAGANZA firstname=RUPERT extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162761] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162761" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162761] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162761" handleOld() recordno=162797 surname=COCHRANE firstname=EVAN extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162797] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162797" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162797] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162797" handleOld() recordno=163682 surname=FITZSIMMONS firstname=SHERRYN extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163682] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163682" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163682] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163682" handleOld() recordno=39944 surname=.ASSIGNED firstname= extension=13509 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 39944] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 39944" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39944] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39944" handleOld() recordno=163679 surname=COLLINSON firstname=GUYLAINE extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163679] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163679" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163679] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163679" handleOld() recordno=163681 surname=FISHER firstname=JANICE extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163681] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163681" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163681] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163681" handleOld() recordno=162796 surname=BRISSON firstname=IVY extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162796] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162796" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162796] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162796" handleOld() recordno=163692 surname=WIJEYASIRI firstname=SARATH extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163692] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163692" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163692] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163692" handleOld() recordno=163691 surname=SEREN firstname=SINAN extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163691] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163691" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163691] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163691" handleOld() recordno=163690 surname=PRENTICE firstname=JODIE extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163690] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163690" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163690] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163690" handleOld() recordno=162798 surname=DAVIES firstname=JENNIFER extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162798] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162798" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162798] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162798" handleOld() recordno=162759 surname=AZZOPARDI firstname=LISA extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162759" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162759] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162759" handleOld() recordno=163689 surname=POLOMARKAKIS firstname=NICK extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163689] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163689" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163689] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163689" handleOld() recordno=163688 surname=PIMENTA firstname=MARK extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163688] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163688" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163688] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163688" handleOld() recordno=173012 surname=.ASSIGNED firstname= extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 173012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 173012" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173012" handleOld() recordno=159819 surname=.ASSIGNED firstname= extension=13507 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 159819] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 159819" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 159819] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 159819" handleOld() recordno=163687 surname=OHIS firstname=MICHAEL extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163687] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163687" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163687] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163687" handleOld() recordno=163680 surname=DILIBERTO firstname=ROBERT extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163680] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163680" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163680] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163680" handleOld() recordno=163686 surname=MOORE firstname=JOHN extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163686] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163686" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163686] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163686" handleOld() recordno=163685 surname=LAZATIN firstname=ORLANDO extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163685] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163685" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163685] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163685" handleOld() recordno=162803 surname=MORRISON firstname=ROGER extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162803" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162803" handleOld() recordno=163684 surname=IBANEZ firstname=EFRAIN extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163684] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163684" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163684] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163684" handleOld() recordno=162760 surname=BEBER firstname=BENJAMIN extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162760] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162760" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162760] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162760" handleOld() recordno=162801 surname=MEHLERT firstname=GEORGE extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162801] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162801" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162801] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162801" handleOld() recordno=162763 surname=CHAND firstname=NITIN extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162763] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162763" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162763] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162763" handleOld() recordno=162806 surname=THOMPSON firstname=DES extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162806] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162806" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162806] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162806" handleOld() recordno=162792 surname=ABELA firstname=MELISSA extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162792] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162792" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162792] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162792" handleOld() recordno=162807 surname=WHALLEY firstname=DIANNE extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162807] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162807" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162807] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162807" handleOld() recordno=162802 surname=MOORE firstname=BREE extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162802] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162802" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162802] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162802" handleOld() recordno=164704 surname=SYNAN firstname=BEV extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164704] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164704" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164704] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164704" handleOld() recordno=162799 surname=EPA firstname=LISA extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162799] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 162799" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162799] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162799" handleOld() recordno=164706 surname=PAGE firstname=BARBARA extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164706] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 164706" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164706] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164706" handleOld() recordno=163703 surname=VAUGHNS firstname=SCOTT extension=13591 site=STD extgroupunique=5761STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163703] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC10" where recordno = 163703" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163703] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163703" nrows=38 ===================================================== aline=[,5800STD8,,,YTD,,,,5800UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5800STD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5800UC1] 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 = "5800UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5800STD8" " nrows=151 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 = "5800STD8" " handleOld() recordno=158912 surname=MORAN firstname=COLIN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158912] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158912" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158912] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158912" handleOld() recordno=162430 surname=SALVO firstname=SLAVATORE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162430" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162430" handleOld() recordno=56899 surname=LOUIS firstname=PETER extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56899] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56899" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56899] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56899" handleOld() recordno=33946 surname=GRANADA firstname=ARSENIO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 33946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 33946" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 33946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 33946" handleOld() recordno=160642 surname=DHILLON firstname=ATTAR extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160642] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160642" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160642] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160642" handleOld() recordno=56891 surname=DEAN firstname=PAMELA extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56891] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56891" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56891] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56891" handleOld() recordno=161512 surname=POPPEN firstname=DALE extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161512] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161512" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161512] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161512" handleOld() recordno=163572 surname=MITCHELL firstname=ANDREW extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163572] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163572" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163572] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163572" handleOld() recordno=56918 surname=HAWTHORN firstname=DON extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56918" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56918" handleOld() recordno=3661 surname=BRUNO firstname=ANTHONY extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 3661] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 3661" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 3661] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 3661" handleOld() recordno=56888 surname=COOKE firstname=RAYMOND extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56888] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56888" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56888] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56888" handleOld() recordno=158902 surname=BREHANE firstname=AMHA extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158902" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158902" handleOld() recordno=56887 surname=CHURCHLEY firstname=TIM extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56887] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56887" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56887] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56887" handleOld() recordno=56886 surname=CHATELIER firstname=REGINALD extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56886] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56886" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56886] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56886" handleOld() recordno=163569 surname=LIMBO firstname=MANOLITO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163569] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163569" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163569] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163569" handleOld() recordno=4362 surname=CHALERMKIAT firstname=PADUNGSAK extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 4362] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 4362" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 4362] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 4362" handleOld() recordno=56915 surname=MORAN firstname=MARK extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56915] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56915" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56915] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56915" handleOld() recordno=4551 surname=CHU-PING-SENG firstname=TAN FONG extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 4551] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 4551" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 4551] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 4551" handleOld() recordno=4555 surname=CHUI firstname=JOSEPH extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 4555] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 4555" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 4555] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 4555" handleOld() recordno=56884 surname=ANDERSON firstname=STEVEN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56884] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56884" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56884] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56884" handleOld() recordno=27745 surname=ESPIGA firstname=MELVIN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27745] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27745" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27745] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27745" handleOld() recordno=27746 surname=ESPINOZA firstname=NATALIO N extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27746] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27746" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27746] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27746" handleOld() recordno=160492 surname=KNIGHT firstname=PETER extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160492] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160492" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160492] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160492" handleOld() recordno=5908 surname=DELOSSANTOS firstname=MARIA R extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 5908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 5908" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 5908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 5908" handleOld() recordno=160491 surname=LOBO firstname=SHELBY I extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160491] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160491" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160491] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160491" handleOld() recordno=39936 surname=.ASSIGNED firstname= extension=13503 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39936" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39936" handleOld() recordno=167314 surname=ROBB firstname=SIOBHAN extension=13523 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 167314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 167314" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 167314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 167314" handleOld() recordno=57033 surname=ZORZI firstname=MICHELLE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 57033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 57033" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 57033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 57033" handleOld() recordno=39951 surname=.ASSIGNED firstname= extension=13514 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39951" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39951" handleOld() recordno=6421 surname=.ASSIGNED firstname= extension=13528 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 6421] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 6421" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 6421] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 6421" handleOld() recordno=161509 surname=DIMOV firstname=NIKOLA extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161509" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161509" handleOld() recordno=39975 surname=.ASSIGNED firstname= extension=13532 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39975" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39975" handleOld() recordno=39985 surname=.ASSIGNED firstname= extension=13545 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 39985" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 39985" handleOld() recordno=28669 surname=DAGSA firstname=DONATO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28669] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28669" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28669] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28669" handleOld() recordno=28671 surname=EDOUARD firstname=JEAN C extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28671] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28671" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28671] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28671" handleOld() recordno=158903 surname=DEKAUWE firstname=MARLON extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158903" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158903" handleOld() recordno=54015 surname=TZAROS firstname=NICK extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 54015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 54015" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 54015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 54015" handleOld() recordno=160408 surname=UPADHYAY firstname=DHARVAN extension=13534 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160408] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160408" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160408] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160408" handleOld() recordno=160409 surname=CANNING firstname=DOUGLAS extension=13534 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160409] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160409" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160409] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160409" handleOld() recordno=162509 surname=WALDRON firstname=HUGH extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162509" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162509" handleOld() recordno=158904 surname=DI LISIO firstname=BRUNO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158904" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158904" handleOld() recordno=40010 surname=GRANO firstname=SAM extension=13572 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 40010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 40010" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40010" handleOld() recordno=7064 surname=FENWICK firstname=TREVOR extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 7064] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 7064" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 7064] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 7064" handleOld() recordno=160497 surname=WILSON firstname=FREDERICK extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160497] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160497" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160497] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160497" handleOld() recordno=40024 surname=.ASSIGNED firstname= extension=13586 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 40024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 40024" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 40024" handleOld() recordno=53997 surname=FEATHERBY firstname=JAMES extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 53997] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 53997" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 53997] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 53997" handleOld() recordno=163573 surname=PEREIRA firstname=BEDE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163573] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163573" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163573] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163573" handleOld() recordno=158908 surname=KING firstname=MICHAEL extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158908" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158908" handleOld() recordno=7935 surname=GILBERT firstname=KERRY C extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 7935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 7935" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 7935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 7935" handleOld() recordno=28359 surname=LIO firstname=THAI HEE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28359] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28359" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28359] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28359" handleOld() recordno=45656 surname=STEWART firstname=JOHN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 45656] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 45656" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 45656] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 45656" handleOld() recordno=32051 surname=MAYIMER firstname=NEBIYAT K extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 32051] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 32051" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32051] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 32051" handleOld() recordno=160490 surname=KIFLE firstname=MAYIMER extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160490] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160490" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160490] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160490" handleOld() recordno=29713 surname=JAYASINGHE firstname=SAMITHA H extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 29713] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 29713" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 29713] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 29713" handleOld() recordno=9941 surname=JOHNSON firstname=GINA extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 9941] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 9941" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9941] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9941" handleOld() recordno=9952 surname=JOHNSON firstname=ROBERT extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 9952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 9952" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 9952" handleOld() recordno=27793 surname=GIBSON firstname=IMELDA extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27793] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27793" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27793] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27793" handleOld() recordno=28322 surname=SJO firstname=JULIE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28322] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28322" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28322] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28322" handleOld() recordno=27614 surname=COLLORE firstname=RAJENDRAN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27614" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27614" handleOld() recordno=173013 surname=.ASSIGNED firstname= extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 173013] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 173013" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173013] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173013" handleOld() recordno=56902 surname=NGUYEN firstname=HOANG extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56902" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56902" handleOld() recordno=10356 surname=KELLY firstname=ADAM extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 10356] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 10356" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 10356] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 10356" handleOld() recordno=27403 surname=AZEMOTHE firstname=JOSEPH extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27403] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27403" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27403] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27403" handleOld() recordno=28438 surname=MORAL firstname=MARCIAL extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28438" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28438" handleOld() recordno=28439 surname=MUNRO firstname=GARY W extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28439] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 28439" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28439] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 28439" handleOld() recordno=11150 surname=LAUINA firstname=TOMA SIAKI extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 11150] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 11150" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 11150] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 11150" handleOld() recordno=56913 surname=MALGERI firstname=DOMENIC extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56913] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56913" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56913] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56913" handleOld() recordno=11556 surname=JONES firstname=ALLAN extension=13521 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 11556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 11556" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 11556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 11556" handleOld() recordno=56892 surname=DEGRAAFF firstname=ANTHONY extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56892] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56892" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56892] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56892" handleOld() recordno=12594 surname=MCGILL firstname=OLIVA extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 12594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 12594" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 12594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 12594" handleOld() recordno=12705 surname=MCKILLOP firstname=ANDREW C extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 12705] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 12705" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 12705] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 12705" handleOld() recordno=163574 surname=TREE firstname=MATTHEW extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163574] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163574" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163574] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163574" handleOld() recordno=56911 surname=SMITH firstname=DARREN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56911" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56911" handleOld() recordno=56897 surname=JASSI firstname=MAKHAN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56897] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56897" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56897] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56897" handleOld() recordno=56910 surname=RICKARDS firstname=TREVOR extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56910" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56910" handleOld() recordno=163568 surname=BLUME firstname=ANDREW extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163568] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163568" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163568] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163568" handleOld() recordno=13402 surname=MORALES firstname=LUIS extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 13402] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 13402" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 13402] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 13402" handleOld() recordno=164715 surname=STEVENSON firstname=DALE extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 164715] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 164715" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164715] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164715" handleOld() recordno=13814 surname=NEGRELLO firstname=ALDO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 13814] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 13814" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 13814] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 13814" handleOld() recordno=162563 surname=JOHNSON firstname=SARAH extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162563] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162563" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162563] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162563" handleOld() recordno=14115 surname=NWOSU firstname=EMMANUEL extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 14115] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 14115" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 14115] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 14115" handleOld() recordno=163571 surname=LUMSDEN firstname=PETER extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163571] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163571" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163571] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163571" handleOld() recordno=50819 surname=NGUYEN firstname=MINH extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 50819] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 50819" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 50819] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 50819" handleOld() recordno=56909 surname=REITHER firstname=ALASTAIR extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56909" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56909" handleOld() recordno=160496 surname=SHAW firstname=JENNIFER R extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160496] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160496" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160496] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160496" handleOld() recordno=27858 surname=HENSHAW firstname=CHRISTINE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27858] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27858" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27858] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27858" handleOld() recordno=14748 surname=PAVLIS firstname=KYM extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 14748] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 14748" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 14748] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 14748" handleOld() recordno=14792 surname=PEARSE firstname=NYREE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 14792] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 14792" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 14792] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 14792" handleOld() recordno=158910 surname=LARRAIN firstname=DAVID extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158910" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158910" handleOld() recordno=53998 surname=KEOGH firstname=WAYNE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 53998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 53998" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 53998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 53998" handleOld() recordno=15251 surname=PLUMECOCQ firstname=MICHEL extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 15251] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 15251" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 15251] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 15251" handleOld() recordno=15348 surname=PORTER firstname=GRAEME extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 15348] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 15348" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 15348] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 15348" handleOld() recordno=158906 surname=GRIGGS firstname=SHAYNE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158906] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158906" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158906] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158906" handleOld() recordno=56907 surname=PRIESTLY firstname=DAVID extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56907" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56907" handleOld() recordno=56896 surname=HALABUT firstname=JENNY extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56896" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56896" handleOld() recordno=158921 surname=YARGI firstname=BULENT extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158921] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158921" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158921] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158921" handleOld() recordno=163570 surname=LIMBO firstname=SUSAN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163570] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163570" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163570] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163570" handleOld() recordno=158909 surname=KING firstname=PETER extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158909" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158909" handleOld() recordno=162320 surname=GAMBIROZA firstname=MILAN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162320] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162320" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162320] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162320" handleOld() recordno=161511 surname=ISKANDER firstname=MARCELLE extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161511" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161511" handleOld() recordno=16662 surname=SASSOUNIAN firstname=NORBERTO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 16662] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 16662" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 16662] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 16662" handleOld() recordno=16880 surname=SECOMBE firstname=MAKELESI extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 16880] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 16880" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 16880] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 16880" handleOld() recordno=160493 surname=RYAN firstname=JOHN A extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160493] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160493" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160493] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160493" handleOld() recordno=162425 surname=BAKARI firstname=ABI extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162425] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162425" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162425] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162425" handleOld() recordno=160495 surname=SCOTT firstname=GEOFFREY extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160495] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160495" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160495] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160495" handleOld() recordno=57025 surname=KEBEDE firstname=SOLOMAN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 57025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 57025" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 57025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 57025" handleOld() recordno=27296 surname=ABINOJA firstname=AMADO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27296] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27296" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27296] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27296" handleOld() recordno=55772 surname=SCHOLTEN firstname=JOHN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 55772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 55772" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 55772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 55772" handleOld() recordno=158911 surname=MCLEAN firstname=ROSS extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158911" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158911" handleOld() recordno=27594 surname=CHINNAPPA firstname=AMRITHRAJ extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27594" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27594" handleOld() recordno=54009 surname=TEASDALE firstname=MARK extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 54009] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 54009" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 54009] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 54009" handleOld() recordno=18415 surname=TAURO firstname=RONALD extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 18415] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 18415" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 18415] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 18415" handleOld() recordno=18558 surname=TESI firstname=PITA extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 18558] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 18558" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 18558] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 18558" handleOld() recordno=160488 surname=GILBERT firstname=DENIESE M extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160488] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160488" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160488] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160488" handleOld() recordno=18781 surname=TO firstname=HON CHONG extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 18781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 18781" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 18781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 18781" handleOld() recordno=160487 surname=BROCK firstname=STEPHEN J extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160487] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160487" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160487] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160487" handleOld() recordno=19055 surname=TRUONG firstname=THE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 19055] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 19055" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 19055] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 19055" handleOld() recordno=19133 surname=TUHAKA firstname=LUCY extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 19133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 19133" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 19133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 19133" handleOld() recordno=158901 surname=BLEVINS firstname=WILLIAM R extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158901] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158901" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158901] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158901" handleOld() recordno=27597 surname=CHOROWSKI firstname=BARRY extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 27597" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 27597" handleOld() recordno=56898 surname=KLOTHOS firstname=PETER extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56898] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56898" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56898] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56898" handleOld() recordno=56894 surname=FARAGHER firstname=DOUGLAS extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56894" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56894" handleOld() recordno=19631 surname=.ASSIGNED firstname= extension=13535 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 19631] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 19631" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 19631] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 19631" handleOld() recordno=56905 surname=PERERA firstname=OLIVER extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56905] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56905" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56905] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56905" handleOld() recordno=33458 surname=PETROV firstname=DENIS extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 33458] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 33458" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 33458] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 33458" handleOld() recordno=158920 surname=VORTMAN firstname=PHILIP extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158920" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158920" handleOld() recordno=20550 surname=WOON firstname=CHEE KHEON extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 20550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 20550" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 20550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 20550" handleOld() recordno=56904 surname=PAOLI firstname=SILVIO extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 56904" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 56904" handleOld() recordno=160410 surname=STRACHAN firstname=ANTHONY extension=13534 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160410] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160410" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160410] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160410" handleOld() recordno=55796 surname=KING firstname=GREGORY extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 55796] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 55796" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 55796] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 55796" handleOld() recordno=173014 surname=AUGUSTUS firstname=NOEL extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 173014] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 173014" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173014] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173014" handleOld() recordno=158907 surname=JAMES firstname=LYNETTE extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158907" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158907" handleOld() recordno=162428 surname=KELAART firstname=WENDELL extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162428] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162428" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162428] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162428" handleOld() recordno=163711 surname=MOREIRA firstname=PETER extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163711] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163711" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163711] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163711" handleOld() recordno=158916 surname=SCHONFELDER firstname=BRENDEN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158916" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158916" handleOld() recordno=162546 surname=GRAY firstname=THOMAS extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162546] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162546" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162546] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162546" handleOld() recordno=163554 surname=CHANCE firstname=DARREN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163554] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163554" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163554] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163554" handleOld() recordno=158913 surname=MURPHY firstname=STEPHEN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158913] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158913" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158913] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158913" handleOld() recordno=158918 surname=TABONE firstname=MARTIN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158918" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158918" handleOld() recordno=158915 surname=PENNY firstname=ANDREW extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158915] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 158915" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158915] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158915" handleOld() recordno=163710 surname=EVANGELISTA firstname=NESTOR extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163710] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 163710" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163710] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 163710" handleOld() recordno=160643 surname=EKSIRY firstname=AZIM extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160643] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160643" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160643] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160643" handleOld() recordno=160645 surname=KOPINATHAN firstname=KANDIAH extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160645] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160645" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160645] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160645" handleOld() recordno=160646 surname=MARSHALL firstname=PETER extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160646] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160646" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160646] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160646" handleOld() recordno=160648 surname=ORILLA firstname=TERESITA extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160648] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160648" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160648] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160648" handleOld() recordno=160649 surname=SELEMIDIS firstname=GEORGE extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160649] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 160649" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160649] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 160649" handleOld() recordno=164709 surname=KY firstname=JOHN extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 164709] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 164709" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164709] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164709" handleOld() recordno=162429 surname=NEDANOVSKI firstname=STEVEN extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162429] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162429" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162429] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162429" handleOld() recordno=162427 surname=CONNOR firstname=MARK extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162427] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162427" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162427] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162427" handleOld() recordno=162426 surname=BARRY firstname=COLUMB extension=13522 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162426] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 162426" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162426] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 162426" handleOld() recordno=161508 surname=CAESAR firstname=BARBARA extension=13525 site=STD extgroupunique=5800STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161508] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5800UC1" where recordno = 161508" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161508] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 161508" nrows=151 ===================================================== aline=[,5813STD8,,,YTD,,,,5813UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5813STD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5813UC1] 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 = "5813UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5813STD8" " nrows=7 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "5813STD8" " handleOld() recordno=158922 surname=STOKES firstname=IAN extension=13524 site=STD extgroupunique=5813STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 158922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 158922" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 158922" handleOld() recordno=173015 surname=WELCOME firstname=CLINTON extension=13546 site=STD extgroupunique=5813STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 173015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 173015" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 173015" handleOld() recordno=164714 surname=SUGUNARATNAM firstname=GUNAWATHIE extension=13546 site=STD extgroupunique=5813STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164714] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164714" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164714] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164714" handleOld() recordno=164713 surname=SHAW firstname=SCOT extension=13546 site=STD extgroupunique=5813STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164713] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164713" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164713] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164713" handleOld() recordno=164712 surname=MUSTAPHA firstname=ALAWI extension=13546 site=STD extgroupunique=5813STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164712] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164712" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164712] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164712" handleOld() recordno=164711 surname=HICKEY firstname=JOHN extension=13546 site=STD extgroupunique=5813STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164711] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164711" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164711] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164711" handleOld() recordno=164710 surname=BHASIN firstname=ANITA extension=13546 site=STD extgroupunique=5813STD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164710] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5813UC1" where recordno = 164710" sqlcmd=[update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164710] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="19/06/2018" ,jobno="RS190618STDTRAMDEPOT" ,division="YTF" where recordno = 164710" nrows=7