DBPATH=[/u/catcom/database:/u/catcom/forms Doing fname = BulkImportForDirectoryGTDTramDepots.csv ++++++++++++++++++++++++++++ ===================================================== aline=[OldExtn,OldExtnGgroup,OldDepartment,OldDivision,OldParent,OldPABX,NewVACExtnGroup,NewExtn,NewExtnGroup,NewDepartment,NewDivision,NewParent,NewPABX,NewLocation,NewTelephone,NewComment,NewTEC,NewNode] Skip header ===================================================== aline=[,165GTD,,,VRT,,,,510UC6,,510,VRT,UCP,,,,,] OldExtn=[] OldExtnGroup=[165GTD] OldDepartment=[] OldDivision=[] OldParent=[VRT] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[510UC6] 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 = "510UC6"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "165GTD" " nrows=0 ERROR: No rows found for Oldextn= OldPABX= OldExtnGroup=165GTD ===================================================== aline=[,GTDVACA,,,VAC,,,,VACUC6,,VAC,VAC,UCP,,,,,] OldExtn=[] OldExtnGroup=[GTDVACA] OldDepartment=[] OldDivision=[] OldParent=[VAC] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VACUC6] 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 = "VACUC6"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "GTDVACA" " nrows=80 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 = "GTDVACA" " handleOld() recordno=21974 surname=.UNPROGRAMMED firstname= extension=13134 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 21974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 21974" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 21974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 21974" handleOld() recordno=25660 surname=.UNPROGRAMMED firstname= extension=13135 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 25660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 25660" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 25660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 25660" handleOld() recordno=29515 surname=.UNPROGRAMMED firstname= extension=13136 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 29515] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 29515" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 29515] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 29515" handleOld() recordno=160218 surname=.UNPROGRAMMED firstname= extension=13124 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 160218] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 160218" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 160218] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 160218" handleOld() recordno=41319 surname=.VACANT firstname= extension=13102 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41319] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41319" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41319] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41319" handleOld() recordno=41323 surname=.VACANT firstname= extension=13106 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41323] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41323" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41323] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41323" handleOld() recordno=41326 surname=.VACANT firstname= extension=13107 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41326] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41326" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41326] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41326" handleOld() recordno=41341 surname=.UNPROGRAMMED firstname= extension=13111 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41341] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41341" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41341] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41341" handleOld() recordno=41348 surname=.UNPROGRAMMED firstname= extension=13112 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41348] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41348" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41348] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41348" handleOld() recordno=41351 surname=.UNPROGRAMMED firstname= extension=13113 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41351] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41351" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41351] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41351" handleOld() recordno=41353 surname=.UNPROGRAMMED firstname= extension=13114 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41353] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41353" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41353] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41353" handleOld() recordno=41358 surname=.UNPROGRAMMED firstname= extension=13116 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41358] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41358" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41358] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41358" handleOld() recordno=41360 surname=.UNPROGRAMMED firstname= extension=13117 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41360] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41360" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41360] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41360" handleOld() recordno=41361 surname=.UNPROGRAMMED firstname= extension=13118 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41361] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41361" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41361] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41361" handleOld() recordno=41363 surname=.UNPROGRAMMED firstname= extension=13119 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41363] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41363" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41363] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41363" handleOld() recordno=41367 surname=.UNPROGRAMMED firstname= extension=13120 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41367] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41367" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41367] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41367" handleOld() recordno=41368 surname=.UNPROGRAMMED firstname= extension=13123 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41368] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41368" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41368] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41368" handleOld() recordno=41372 surname=.UNPROGRAMMED firstname= extension=13128 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41372] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41372" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41372] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41372" handleOld() recordno=41373 surname=.UNPROGRAMMED firstname= extension=13129 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41373] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41373" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41373] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41373" handleOld() recordno=41376 surname=.UNPROGRAMMED firstname= extension=13137 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41376] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41376" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41376] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41376" handleOld() recordno=41377 surname=.UNPROGRAMMED firstname= extension=13138 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41377] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41377" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41377] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41377" handleOld() recordno=41378 surname=.UNPROGRAMMED firstname= extension=13139 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41378] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41378" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41378] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41378" handleOld() recordno=41379 surname=.UNPROGRAMMED firstname= extension=13140 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41379] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41379" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41379] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41379" handleOld() recordno=41380 surname=.UNPROGRAMMED firstname= extension=13141 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41380] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41380" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41380] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41380" handleOld() recordno=41381 surname=.UNPROGRAMMED firstname= extension=13142 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41381] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41381" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41381] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41381" handleOld() recordno=41382 surname=.UNPROGRAMMED firstname= extension=13143 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41382] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41382" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41382] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41382" handleOld() recordno=41383 surname=.UNPROGRAMMED firstname= extension=13144 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41383] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41383" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41383] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41383" handleOld() recordno=41384 surname=.UNPROGRAMMED firstname= extension=13145 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41384] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41384" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41384] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41384" handleOld() recordno=41385 surname=.UNPROGRAMMED firstname= extension=13146 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41385] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41385" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41385] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41385" handleOld() recordno=41386 surname=.UNPROGRAMMED firstname= extension=13147 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41386] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41386" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41386] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41386" handleOld() recordno=41387 surname=.UNPROGRAMMED firstname= extension=13148 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41387] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41387" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41387] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41387" handleOld() recordno=41388 surname=.UNPROGRAMMED firstname= extension=13149 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41388] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41388" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41388] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41388" handleOld() recordno=41389 surname=.UNPROGRAMMED firstname= extension=13151 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41389] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41389" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41389] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41389" handleOld() recordno=41390 surname=.UNPROGRAMMED firstname= extension=13152 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41390] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41390" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41390] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41390" handleOld() recordno=41391 surname=.UNPROGRAMMED firstname= extension=13153 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41391] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41391" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41391] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41391" handleOld() recordno=41392 surname=.UNPROGRAMMED firstname= extension=13154 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41392] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41392" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41392] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41392" handleOld() recordno=41393 surname=.UNPROGRAMMED firstname= extension=13155 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41393] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41393" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41393] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41393" handleOld() recordno=41394 surname=.UNPROGRAMMED firstname= extension=13156 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41394] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41394" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41394] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41394" handleOld() recordno=41395 surname=.UNPROGRAMMED firstname= extension=13157 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41395] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41395" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41395] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41395" handleOld() recordno=41396 surname=.UNPROGRAMMED firstname= extension=13158 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41396] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41396" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41396] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41396" handleOld() recordno=41397 surname=.UNPROGRAMMED firstname= extension=13159 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41397] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41397" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41397] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41397" handleOld() recordno=41399 surname=.UNPROGRAMMED firstname= extension=13161 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41399] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41399" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41399] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41399" handleOld() recordno=41400 surname=.UNPROGRAMMED firstname= extension=13162 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41400] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41400" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41400] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41400" handleOld() recordno=41401 surname=.UNPROGRAMMED firstname= extension=13163 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41401] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41401" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41401] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41401" handleOld() recordno=41402 surname=.UNPROGRAMMED firstname= extension=13164 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41402] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41402" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41402] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41402" handleOld() recordno=41403 surname=.UNPROGRAMMED firstname= extension=13165 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41403] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41403" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41403] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41403" handleOld() recordno=41404 surname=.UNPROGRAMMED firstname= extension=13166 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41404] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41404" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41404] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41404" handleOld() recordno=41405 surname=.UNPROGRAMMED firstname= extension=13167 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41405] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41405" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41405] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41405" handleOld() recordno=41406 surname=.UNPROGRAMMED firstname= extension=13168 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41406] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41406" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41406] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41406" handleOld() recordno=41407 surname=.UNPROGRAMMED firstname= extension=13169 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41407" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41407] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41407" handleOld() recordno=41408 surname=.UNPROGRAMMED firstname= extension=13170 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41408] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41408" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41408] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41408" handleOld() recordno=41409 surname=.UNPROGRAMMED firstname= extension=13171 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41409] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41409" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41409] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41409" handleOld() recordno=41410 surname=.UNPROGRAMMED firstname= extension=13172 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41410] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41410" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41410] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41410" handleOld() recordno=41411 surname=.UNPROGRAMMED firstname= extension=13173 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41411] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41411" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41411] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41411" handleOld() recordno=41412 surname=.UNPROGRAMMED firstname= extension=13174 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41412] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41412" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41412] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41412" handleOld() recordno=41413 surname=.UNPROGRAMMED firstname= extension=13175 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41413] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41413" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41413] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41413" handleOld() recordno=41414 surname=.UNPROGRAMMED firstname= extension=13176 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41414] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41414" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41414] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41414" handleOld() recordno=41415 surname=.UNPROGRAMMED firstname= extension=13177 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41415] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41415" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41415] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41415" handleOld() recordno=41417 surname=.UNPROGRAMMED firstname= extension=13178 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41417" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41417" handleOld() recordno=41418 surname=.UNPROGRAMMED firstname= extension=13179 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41418] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41418" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41418] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41418" handleOld() recordno=41419 surname=.UNPROGRAMMED firstname= extension=13180 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41419] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41419" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41419] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41419" handleOld() recordno=41421 surname=.UNPROGRAMMED firstname= extension=13181 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41421] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41421" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41421] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41421" handleOld() recordno=41423 surname=.UNPROGRAMMED firstname= extension=13182 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41423] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41423" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41423] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41423" handleOld() recordno=41424 surname=.UNPROGRAMMED firstname= extension=13183 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41424] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41424" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41424] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41424" handleOld() recordno=41426 surname=.UNPROGRAMMED firstname= extension=13184 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41426] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41426" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41426] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41426" handleOld() recordno=41427 surname=.UNPROGRAMMED firstname= extension=13185 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41427] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41427" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41427] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41427" handleOld() recordno=41428 surname=.UNPROGRAMMED firstname= extension=13186 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41428] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41428" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41428] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41428" handleOld() recordno=41430 surname=.UNPROGRAMMED firstname= extension=13187 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41430" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41430" handleOld() recordno=41457 surname=.UNPROGRAMMED firstname= extension=13188 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41457] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41457" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41457] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41457" handleOld() recordno=41458 surname=.UNPROGRAMMED firstname= extension=13189 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41458] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41458" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41458] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41458" handleOld() recordno=41459 surname=.UNPROGRAMMED firstname= extension=13190 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41459] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41459" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41459] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41459" handleOld() recordno=41460 surname=.VACANT firstname= extension=13191 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41460] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41460" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41460] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41460" handleOld() recordno=41461 surname=.VACANT firstname= extension=13192 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41461] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41461" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41461] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41461" handleOld() recordno=41462 surname=.VACANT firstname= extension=13193 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41462] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41462" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41462] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41462" handleOld() recordno=41463 surname=.VACANT firstname= extension=13194 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41463] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41463" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41463] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41463" handleOld() recordno=41464 surname=.UNPROGRAMMED firstname= extension=13195 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41464] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41464" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41464] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41464" handleOld() recordno=41465 surname=.UNPROGRAMMED firstname= extension=13196 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41465] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41465" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41465] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41465" handleOld() recordno=41466 surname=.UNPROGRAMMED firstname= extension=13197 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41466] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 41466" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41466] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 41466" handleOld() recordno=172836 surname=.UNPROGRAMMED firstname= extension=13130 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 172836] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 172836" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 172836] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 172836" handleOld() recordno=172835 surname=.VACANT firstname= extension=13109 site=GTD extgroupunique=GTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 172835] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC6" where recordno = 172835" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 172835] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="VAC" where recordno = 172835" nrows=80 ===================================================== aline=[,0458GTD8,,,YTD,,,,0458UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0458GTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0458UC1] 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 = "0458UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0458GTD8" " nrows=12 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 = "0458GTD8" " handleOld() recordno=162570 surname=MEYER firstname=MICHAEL extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 162570] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 162570" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162570] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162570" handleOld() recordno=162569 surname=ALWIS firstname=EDWIN extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 162569] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 162569" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162569] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162569" handleOld() recordno=159783 surname=TORRE firstname=LUIGI extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159783" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159783" handleOld() recordno=162567 surname=HUGHES firstname=BARRY extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 162567] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 162567" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162567] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162567" handleOld() recordno=163652 surname=THOMAS firstname=MATTHEW extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 163652] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 163652" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163652] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163652" handleOld() recordno=159791 surname=GIANNAKOPOULOS firstname=PAVLOS extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159791] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159791" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159791] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159791" handleOld() recordno=159786 surname=SMALLMAN firstname=MARTIN extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159786" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159786" handleOld() recordno=159785 surname=BARBARINO firstname=ALFIO extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159785] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159785" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159785] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159785" handleOld() recordno=159790 surname=TOOLEY firstname=TRENT B extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159790] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 159790" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159790] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159790" handleOld() recordno=172983 surname=POROPAT firstname=ANTON extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 172983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 172983" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172983" handleOld() recordno=163618 surname=VALSAMOULIS firstname=CON extension=13131 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 163618] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 163618" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163618] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163618" handleOld() recordno=41327 surname=.ASSIGNED firstname= extension=13108 site=GTD extgroupunique=0458GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 41327] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0458UC1" where recordno = 41327" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41327] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41327" nrows=12 ===================================================== aline=[,5761GTD8,,,YTD,,,,5761UC11,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5761GTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5761UC11] 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 = "5761UC11"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5761GTD8" " nrows=34 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 = "5761GTD8" " handleOld() recordno=163697 surname=PALDYNA firstname=ELLEN extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163697] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163697" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163697] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163697" handleOld() recordno=161170 surname=CLARKE firstname=PRISCILLA extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161170] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161170" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161170] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161170" handleOld() recordno=160856 surname=TRAN firstname=THAN HAI extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160856] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160856" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160856] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160856" handleOld() recordno=161134 surname=ALLEN firstname=OONAGH extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161134] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161134" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161134] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161134" handleOld() recordno=161149 surname=VITHANGE firstname=SAMANDRA extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161149] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161149" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161149] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161149" handleOld() recordno=161141 surname=JAYAWARDANE firstname=IDA extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161141] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161141" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161141] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161141" handleOld() recordno=161174 surname=WRAY firstname=GLENN extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161174] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161174" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161174] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161174" handleOld() recordno=161138 surname=GUDDAT firstname=JOHN extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161138] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161138" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161138] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161138" handleOld() recordno=161142 surname=MADDEN firstname=MARTIN extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161142] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161142" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161142] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161142" handleOld() recordno=160852 surname=CATALANO firstname=VINCENT extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160852] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160852" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160852] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160852" handleOld() recordno=161140 surname=HUNDEL firstname=HABRINDER extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161140] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161140" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161140] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161140" handleOld() recordno=160860 surname=BAKER firstname=NATASCHA extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160860] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160860" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160860] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160860" handleOld() recordno=160857 surname=PERKINS firstname=ANDREW extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160857] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160857" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160857] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160857" handleOld() recordno=161135 surname=ARULKADACHAM firstname=JEREMY extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161135] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161135" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161135] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161135" handleOld() recordno=161143 surname=MULLEN firstname=PETER extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161143] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161143" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161143] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161143" handleOld() recordno=161113 surname=CHILDS firstname=MARTIN extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161113] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161113" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161113] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161113" handleOld() recordno=160847 surname=PERERA firstname=ASHOK extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160847] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160847" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160847] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160847" handleOld() recordno=161146 surname=PERRY firstname=DAVID extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161146] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161146" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161146] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161146" handleOld() recordno=161144 surname=PALYDYNA firstname=PETER extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161144] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161144" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161144] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161144" handleOld() recordno=160858 surname=BARTHOLOMEUZ firstname=FITZROY extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160858] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160858" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160858] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160858" handleOld() recordno=161148 surname=SAXON firstname=GARY extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161148] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161148" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161148] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161148" handleOld() recordno=161139 surname=HARDIE firstname=JUDIE extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161139] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161139" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161139] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161139" handleOld() recordno=160855 surname=LOIELO firstname=GERRY extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160855] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160855" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160855] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160855" handleOld() recordno=161145 surname=PALYDYNA firstname=EVELYN extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161145] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161145" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161145] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161145" handleOld() recordno=41375 surname=.ASSIGNED firstname=TRAM DEPOT extension=13133 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 41375] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 41375" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41375] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41375" handleOld() recordno=163698 surname=PALDYNA firstname=PIOTR extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163698] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163698" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163698] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163698" handleOld() recordno=161171 surname=ELKINGTON firstname=ROBERT extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161171] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161171" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161171] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161171" handleOld() recordno=160850 surname=MANUEL firstname=EUGENE extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160850] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 160850" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160850] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160850" handleOld() recordno=161173 surname=HEATH firstname=MICHAEL extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161173] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161173" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161173] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161173" handleOld() recordno=161136 surname=DAVEY firstname=HECTOR extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161136] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161136" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161136] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161136" handleOld() recordno=161137 surname=DIEGO firstname=RANDY extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161137] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 161137" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161137] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 161137" handleOld() recordno=163699 surname=PERRY firstname=DEAN extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163699] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163699" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163699] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163699" handleOld() recordno=163700 surname=ROGERS firstname=RHYS extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163700] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163700" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163700] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163700" handleOld() recordno=163701 surname=WOLNAREK firstname=ISABELLE extension=13100 site=GTD extgroupunique=5761GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163701] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5761UC11" where recordno = 163701" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163701] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163701" nrows=34 ===================================================== aline=[,5805GTD8,,,YTD,,,,5805UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5805GTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5805UC9] 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 = "5805UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5805GTD8" " nrows=170 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 = "5805GTD8" " handleOld() recordno=56028 surname=ALAME firstname=GHASSAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56028] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56028" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56028] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56028" handleOld() recordno=1262 surname=ALAGARATNAM firstname=THILAGARA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 1262] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 1262" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 1262] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 1262" handleOld() recordno=1274 surname=ALCANTARA firstname=CID extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 1274] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 1274" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 1274] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 1274" handleOld() recordno=56016 surname=GALARET firstname=MARCEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56016] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56016" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56016] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56016" handleOld() recordno=56015 surname=FINCHER firstname=ALISTAIR extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56015" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56015] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56015" handleOld() recordno=1927 surname=ALTHAM firstname=STEVEN J extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 1927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 1927" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 1927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 1927" handleOld() recordno=2105 surname=ANTONAKIS firstname=IOANNIS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2105] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2105" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2105] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2105" handleOld() recordno=162303 surname=ANDRAWIS firstname=MARK extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162303] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162303" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162303] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162303" handleOld() recordno=172990 surname=.ASSIGNED firstname= extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172990" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172990" handleOld() recordno=2247 surname=ARUMA firstname=MARK extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2247] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2247" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2247] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2247" handleOld() recordno=35620 surname=MAHAMOOTH firstname=YASMIN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 35620] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 35620" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 35620] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 35620" handleOld() recordno=162327 surname=DJURIC firstname=MICHAEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162327] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162327" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162327] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162327" handleOld() recordno=56012 surname=DRAKOPOULOS firstname=PETER extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56012" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56012" handleOld() recordno=31943 surname=BERENGER firstname=FABIAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 31943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 31943" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 31943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 31943" handleOld() recordno=57069 surname=FRASER firstname=NEVILLE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57069] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57069" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57069] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57069" handleOld() recordno=2509 surname=BALDSING firstname=KENNETH extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2509" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2509] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2509" handleOld() recordno=2699 surname=BASSY firstname=HAROLD J extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2699] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 2699" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2699] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 2699" handleOld() recordno=55995 surname=NICHOLLS firstname=TONY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55995] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55995" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55995] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55995" handleOld() recordno=3229 surname=BOLDT firstname=KEVIN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 3229] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 3229" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 3229] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 3229" handleOld() recordno=50899 surname=SAWIRIS firstname=KHAIRY Y extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 50899] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 50899" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 50899] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 50899" handleOld() recordno=3471 surname=BRETTARGH firstname=MARK H extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 3471] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 3471" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 3471] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 3471" handleOld() recordno=56010 surname=BUCKLAND firstname=MELISSA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56010" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56010] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56010" handleOld() recordno=3624 surname=BROWN firstname=RENFORD R extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 3624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 3624" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 3624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 3624" handleOld() recordno=160528 surname=ANDERSON firstname=JANET extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160528] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160528" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160528] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160528" handleOld() recordno=160535 surname=HERFT firstname=JASON extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160535] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160535" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160535] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160535" handleOld() recordno=4303 surname=CATANIA firstname=CHARLES P extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 4303] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 4303" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 4303] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 4303" handleOld() recordno=159040 surname=LA ROCCA firstname=JOE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 159040] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 159040" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159040] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 159040" handleOld() recordno=160534 surname=GRIEVESON firstname=MELVYN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160534] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160534" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160534] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160534" handleOld() recordno=160530 surname=CLARK firstname=PHILLIP extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160530] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160530" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160530] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160530" handleOld() recordno=4473 surname=CHIEW firstname=PAUL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 4473] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 4473" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 4473] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 4473" handleOld() recordno=4556 surname=CHUNG firstname=HA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 4556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 4556" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 4556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 4556" handleOld() recordno=34397 surname=DOMINGUE firstname=MARIE H extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 34397] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 34397" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 34397] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 34397" handleOld() recordno=163584 surname=ABDELMALEK firstname=FADI extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163584] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163584" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163584] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163584" handleOld() recordno=56007 surname=BARBOZA firstname=DESMOND extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56007] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56007" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56007] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56007" handleOld() recordno=57070 surname=HANLEY firstname=CAROL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57070] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57070" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57070] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57070" handleOld() recordno=5315 surname=CRUZ firstname=JOSE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5315] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5315" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5315] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5315" handleOld() recordno=41318 surname=.ASSIGNED firstname= extension=13101 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41318] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41318" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41318] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41318" handleOld() recordno=5470 surname=D COSTA firstname=DEREK extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5470] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5470" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5470] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5470" handleOld() recordno=5510 surname=DA COSTA firstname=FELICIANO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5510" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5510" handleOld() recordno=163599 surname=PINA firstname=CIPRIANO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163599] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163599" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163599] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163599" handleOld() recordno=5777 surname=DELOTTO firstname=NELLO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5777] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5777" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5777] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5777" handleOld() recordno=5822 surname=DE-SILVA firstname=DEV extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5822] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 5822" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5822] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 5822" handleOld() recordno=163608 surname=KNOX firstname=DIANNE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163608] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163608" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163608] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163608" handleOld() recordno=56005 surname=ANDREASEN firstname=MARK extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56005] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56005" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56005] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56005" handleOld() recordno=56003 surname=VENVILLE firstname=RODNEY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56003] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56003" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56003] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56003" handleOld() recordno=6078 surname=DIAS firstname=RANDOLPH extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 6078] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 6078" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 6078] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 6078" handleOld() recordno=163597 surname=NIGLI firstname=LLOYD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163597" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163597" handleOld() recordno=56001 surname=SCULLY firstname=PATRICK extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56001" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56001" handleOld() recordno=33328 surname=SALIB firstname=MONIR extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 33328] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 33328" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 33328] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 33328" handleOld() recordno=6817 surname=ERTAN firstname=NAKIYE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 6817] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 6817" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 6817] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 6817" handleOld() recordno=27964 surname=STARR firstname=ROBERT J extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 27964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 27964" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 27964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 27964" handleOld() recordno=55999 surname=ROSETH firstname=TAMAS JOEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55999] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55999" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55999] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55999" handleOld() recordno=7144 surname=FIELDS firstname=TERENCE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 7144] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 7144" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 7144] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 7144" handleOld() recordno=7453 surname=FRASER firstname=NORMAN E extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 7453] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 7453" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 7453] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 7453" handleOld() recordno=172985 surname=.ASSIGNED firstname= extension=13127 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172985" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172985" handleOld() recordno=8057 surname=GODJALI firstname=DADANG extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 8057] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 8057" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 8057] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 8057" handleOld() recordno=8161 surname=GOTH firstname=HEINZ extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 8161] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 8161" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 8161] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 8161" handleOld() recordno=8314 surname=GREENWOOD firstname=BERNARD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 8314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 8314" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 8314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 8314" handleOld() recordno=57078 surname=WILLIAMSON firstname=RUDY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57078] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57078" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57078] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57078" handleOld() recordno=9024 surname=HENRIQUES firstname=ABILIO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9024" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9024" handleOld() recordno=9307 surname=HORNG firstname=CHHING extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9307] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9307" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9307] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9307" handleOld() recordno=163589 surname=D ROZARIO firstname=ANTHONY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163589" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163589" handleOld() recordno=163591 surname=HELDT firstname=FLOYD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163591] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163591" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163591] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163591" handleOld() recordno=163585 surname=ARLAND firstname=DENVER extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163585] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163585" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163585] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163585" handleOld() recordno=9755 surname=JAHANS firstname=JAMES extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9755] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9755" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9755] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9755" handleOld() recordno=9800 surname=JANSEN firstname=ADRIAN T extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9800] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 9800" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9800] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 9800" handleOld() recordno=10067 surname=JOSEPH firstname=MERUYN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10067] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10067" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10067] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10067" handleOld() recordno=10490 surname=KERRY firstname=ATTILA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10490] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10490" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10490] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10490" handleOld() recordno=50894 surname=BASILY firstname=WASFY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 50894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 50894" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 50894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 50894" handleOld() recordno=10511 surname=KHALIL firstname=GEORGE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10511" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10511" handleOld() recordno=10738 surname=KONITZER firstname=UWE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 10738" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10738] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 10738" handleOld() recordno=163640 surname=FERNANDO firstname=NISHAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163640] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163640" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163640] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163640" handleOld() recordno=55989 surname=KEMP firstname=ROBERT extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55989" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55989" handleOld() recordno=163595 surname=MATTHEWS firstname=ALBERT extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163595" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163595" handleOld() recordno=33133 surname=SUPARDI firstname=IMAM extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 33133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 33133" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 33133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 33133" handleOld() recordno=11428 surname=LIAKOS firstname=ROSS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11428] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11428" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11428] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11428" handleOld() recordno=11464 surname=LIM firstname=LEANG extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11464] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11464" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11464] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11464" handleOld() recordno=11518 surname=LIU firstname=WING extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11518" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11518" handleOld() recordno=11685 surname=LUANGPHAKDY firstname=SENKEO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11685] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11685" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11685] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11685" handleOld() recordno=11927 surname=MAHONY firstname=MICHAEL ST extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 11927" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 11927" handleOld() recordno=163598 surname=PETERSON firstname=WARREN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163598] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163598" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163598] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163598" handleOld() recordno=172989 surname=FENDER firstname=ALLAN extension=13125 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172989" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172989" handleOld() recordno=55986 surname=HURTIS firstname=MICHAEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55986] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55986" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55986] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55986" handleOld() recordno=55987 surname=JOHNSON firstname=DENNIS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55987" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55987" handleOld() recordno=12314 surname=MATHURANAYAGAM firstname=EUSTACE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 12314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 12314" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 12314] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 12314" handleOld() recordno=12323 surname=MATTHEISZ firstname=RODNEY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 12323] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 12323" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 12323] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 12323" handleOld() recordno=164781 surname=REDDY firstname=GARY extension=13105 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 164781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 164781" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 164781] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 164781" handleOld() recordno=160529 surname=BURBY firstname=STAFFORD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160529] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160529" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160529] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160529" handleOld() recordno=57071 surname=KASSER firstname=THOMAS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57071] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57071" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57071] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57071" handleOld() recordno=13017 surname=MICHAEL firstname=CEDRIC extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 13017] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 13017" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 13017] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 13017" handleOld() recordno=13275 surname=MIZZI firstname=MARIO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 13275] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 13275" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 13275] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 13275" handleOld() recordno=160525 surname=ABDELMESIEH firstname=PAUL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160525" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160525" handleOld() recordno=163593 surname=HUTCHENS firstname=JOHN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163593] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163593" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163593] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163593" handleOld() recordno=55996 surname=PHILLIPS firstname=GODWIN RAJ extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55996] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55996" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55996] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55996" handleOld() recordno=163607 surname=GRANROTT firstname=LUKE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163607] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163607" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163607] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163607" handleOld() recordno=14090 surname=NOYAHR firstname=FRANCIS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14090] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14090" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14090] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14090" handleOld() recordno=160527 surname=ALEXANDROU firstname=EFSTRATIOS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160527] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160527" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160527] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160527" handleOld() recordno=55985 surname=HICKMAN firstname=DESIDERIUS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55985" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55985" handleOld() recordno=14424 surname=PADAZELOS firstname=CHRISTOS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14424] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14424" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14424] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14424" handleOld() recordno=163590 surname=FOTHERGILL firstname=IAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163590] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163590" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163590] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163590" handleOld() recordno=57076 surname=O NEAL firstname=MICHAEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57076] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57076" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57076] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57076" handleOld() recordno=14806 surname=.ASSIGNED firstname= extension=13121 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14806] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14806" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14806] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14806" handleOld() recordno=14917 surname=PERRIMAN firstname=MARGARET extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14917] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14917" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14917] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14917" handleOld() recordno=14943 surname=PERUMAL firstname=JOSEPH extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 14943" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 14943" handleOld() recordno=163596 surname=MORTON firstname=KAY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163596] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163596" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163596] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163596" handleOld() recordno=160531 surname=DAVIS firstname=CHRISTINE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160531] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160531" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160531] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160531" handleOld() recordno=15593 surname=QUINTRELL firstname=IAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 15593] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 15593" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 15593] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 15593" handleOld() recordno=28110 surname=SWAN firstname=USHANI S extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 28110] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 28110" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 28110] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 28110" handleOld() recordno=16158 surname=RODRIGO firstname=DERAINE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16158] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16158" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16158] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16158" handleOld() recordno=16160 surname=RODRIGO firstname=NIMAL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16160] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16160" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16160] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16160" handleOld() recordno=16174 surname=ROGERS firstname=CHERYL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16174] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16174" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16174] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16174" handleOld() recordno=16341 surname=ROZARIO firstname=HOWARD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16341] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16341" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16341] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16341" handleOld() recordno=160532 surname=D CRUZ firstname=FLOYD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160532] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160532" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160532] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160532" handleOld() recordno=163588 surname=DICICCO firstname=RAFFAELE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163588] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163588" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163588] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163588" handleOld() recordno=163592 surname=HUGHES firstname=MICHAEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163592] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163592" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163592] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163592" handleOld() recordno=16758 surname=SCHNEIDER firstname=ALAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16758] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16758" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16758] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16758" handleOld() recordno=16885 surname=SEDHOM firstname=ASHRAF extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16885] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16885" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16885] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16885" handleOld() recordno=16949 surname=SERRAO firstname=CONRAD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 16949" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 16949" handleOld() recordno=17305 surname=SIMMONS firstname=BERNADINE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17305] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17305" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17305] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17305" handleOld() recordno=17556 surname=SMITH firstname=KARL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17556" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17556" handleOld() recordno=17755 surname=SPELDEWINDE firstname=MICHAEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17755] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17755" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17755] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17755" handleOld() recordno=17866 surname=STANLEY firstname=TUAIALUGA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17866] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 17866" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17866] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 17866" handleOld() recordno=18014 surname=STIEN firstname=BRADLEY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18014] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18014" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18014] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18014" handleOld() recordno=18222 surname=SWAN firstname=BERNARD extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18222] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18222" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18222] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18222" handleOld() recordno=18632 surname=THOMAS firstname=RAYMOND P extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18632] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18632" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18632] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18632" handleOld() recordno=18680 surname=THOMPSON firstname=RAYMOND extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18680] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 18680" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18680] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 18680" handleOld() recordno=57068 surname=FITZGERALD firstname=RAY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57068] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 57068" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57068] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 57068" handleOld() recordno=27376 surname=ANDERSON firstname=PETER extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 27376] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 27376" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 27376] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 27376" handleOld() recordno=163600 surname=QUINLESS firstname=DOMINIC extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163600] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163600" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163600] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163600" handleOld() recordno=32656 surname=MOSTANOVSKI firstname=TOME extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 32656] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 32656" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 32656] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 32656" handleOld() recordno=19720 surname=VYTILINGAM firstname=SHANTI DIL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 19720] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 19720" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 19720] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 19720" handleOld() recordno=19734 surname=WAHED firstname=HALIM extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 19734] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 19734" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 19734] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 19734" handleOld() recordno=163601 surname=REEKIE firstname=BRUCE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163601" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163601" handleOld() recordno=172988 surname=.ASSIGNED firstname= extension=13103 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172988] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 172988" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172988] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 172988" handleOld() recordno=20468 surname=DIHARDJO firstname=SUBAGYO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 20468] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 20468" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 20468] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 20468" handleOld() recordno=20606 surname=WYLDE firstname=OSCAR extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 20606] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 20606" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 20606] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 20606" handleOld() recordno=20807 surname=ZOUMBOULIS firstname=DIMITRIA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 20807] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 20807" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 20807] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 20807" handleOld() recordno=56029 surname=CLARKE firstname=BRYAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56029] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 56029" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56029] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 56029" handleOld() recordno=41332 surname=SLATTERY firstname=PETER extension=13110 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41332] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41332" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41332] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41332" handleOld() recordno=41357 surname=.ASSIGNED firstname= extension=13115 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41357] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41357" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41357] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41357" handleOld() recordno=41370 surname=.ASSIGNED firstname= extension=13126 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41370] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41370" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41370] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41370" handleOld() recordno=41374 surname=.ASSIGNED firstname= extension=13132 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41374] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41374" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41374] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41374" handleOld() recordno=41398 surname=.ASSIGNED firstname= extension=13160 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41398] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 41398" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41398] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 41398" handleOld() recordno=55998 surname=REYES firstname=RAOUL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 55998" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 55998" handleOld() recordno=158066 surname=SMITH firstname=GARY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 158066] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 158066" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 158066] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 158066" handleOld() recordno=157922 surname=MANSARAY firstname=MARION extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 157922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 157922" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 157922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 157922" handleOld() recordno=163604 surname=LEONARD firstname=KERRY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163604] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163604" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163604] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163604" handleOld() recordno=160537 surname=MYADAM firstname=SHATHANAND extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160537] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160537" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160537] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160537" handleOld() recordno=160539 surname=O BRIEN firstname=BRETT extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160539] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160539" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160539] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160539" handleOld() recordno=160541 surname=SHORROCK firstname=BRIAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160541] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160541" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160541] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160541" handleOld() recordno=160542 surname=SYMONDS firstname=MICHAEL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160542] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160542" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160542] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160542" handleOld() recordno=160543 surname=WEBB firstname=BRONWYN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160543] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 160543" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160543] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160543" handleOld() recordno=163594 surname=LIM firstname=SIV extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163594" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163594" handleOld() recordno=163587 surname=BAHMDUN firstname=ABDALLA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163587] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163587" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163587] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163587" handleOld() recordno=163586 surname=AUGUSTUS firstname=JUDE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163586] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 163586" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163586] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 163586" handleOld() recordno=162328 surname=D SILVA firstname=LINUS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162328] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162328" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162328] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162328" handleOld() recordno=162329 surname=FOOTMAN firstname=CLINTON extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162329] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162329" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162329] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162329" handleOld() recordno=162330 surname=GO firstname=RODOLFO extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162330] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162330" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162330] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162330" handleOld() recordno=162331 surname=GOETJENS firstname=BEN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162331] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162331" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162331] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162331" handleOld() recordno=162333 surname=GOZMAO firstname=BRENDAN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162333] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162333" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162333] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162333" handleOld() recordno=162334 surname=HAAS firstname=KIM extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162334] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162334" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162334] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162334" handleOld() recordno=162335 surname=HELMLING firstname=LAURIE extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162335] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162335" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162335] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162335" handleOld() recordno=162336 surname=KHALIL firstname=ANTOUN extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162336] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162336" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162336] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162336" handleOld() recordno=162337 surname=LUCK firstname=AARON extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162337] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162337" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162337] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162337" handleOld() recordno=162340 surname=MALEK firstname=FADI extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162340] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162340" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162340] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162340" handleOld() recordno=162343 surname=MOFFAT firstname=LINDSAY extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162343] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162343" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162343] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162343" handleOld() recordno=162413 surname=PEREIRA firstname=FRANCIS extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162413] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162413" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162413] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162413" handleOld() recordno=162414 surname=SINGH firstname=MANDEEP extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162414] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162414" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162414] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162414" handleOld() recordno=162416 surname=STANLEY firstname=BELINDA extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162416] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162416" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162416] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162416" handleOld() recordno=162417 surname=WALKER firstname=RODWELL extension=13122 site=GTD extgroupunique=5805GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5805UC9" where recordno = 162417" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 162417" nrows=170 ===================================================== aline=[,5814GTD8,,,YTD,,,,5814UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5814GTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5814UC9] 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 = "5814UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5814GTD8" " 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 = "5814GTD8" " handleOld() recordno=160999 surname=SPECK firstname=RICARDO extension=13104 site=GTD extgroupunique=5814GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5814UC9" where recordno = 160999] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5814UC9" where recordno = 160999" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160999] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 160999" nrows=1 ===================================================== aline=[,6037GTD8,,,YTD,,,,6037UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[6037GTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[6037UC9] 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 = "6037UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "6037GTD8" " 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 = "6037GTD8" " handleOld() recordno=24903 surname=.ASSIGNED firstname= extension=13150 site=GTD extgroupunique=6037GTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="6037UC9" where recordno = 24903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="6037UC9" where recordno = 24903" sqlcmd=[update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 24903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/06/2018" ,jobno="RS210618GTDTRAMDEPOT" ,division="YTF" where recordno = 24903" nrows=1