DBPATH=[/u/catcom/tx/uc/testdb:/u/catcom/forms Doing fname = BulkImportForDirectoryHoneywell.csv ++++++++++++++++++++++++++++ ===================================================== aline=[OldExtn,OldExtnGgroup,OldDepartment,OldDivision,OldParent,OldPABX,NewVACExtnGroup,NewExtn,NewExtnGroup,NewDepartment,NewDivision,NewParent,NewPABX,NewLocation,NewTelephone,NewComment,NewTEC,NewNode] Skip header ===================================================== aline=[,ACO03SSD,,,,,,,ACO11UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[ACO03SSD] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[ACO11UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "ACO11UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "ACO03SSD" " nrows=6 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "ACO03SSD" " handleOld() recordno=167071 surname=DODD firstname=ALEXANDRA extension=11694 site=SSD extgroupunique=ACO03SSD handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 167071] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 167071" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 167071] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 167071" handleOld() recordno=128712 surname=TULL firstname=RYAN extension=11695 site=SSD extgroupunique=ACO03SSD handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 128712] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 128712" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 128712] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 128712" handleOld() recordno=134441 surname=REED firstname=ASHLEY extension=11693 site=SSD extgroupunique=ACO03SSD handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134441] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134441" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134441] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134441" handleOld() recordno=151302 surname=MAGIC firstname=LUDOVIC extension=11697 site=SSD extgroupunique=ACO03SSD handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 151302] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 151302" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 151302] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 151302" handleOld() recordno=151542 surname=CHANTER firstname=COLIN extension=11692 site=SSD extgroupunique=ACO03SSD handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 151542] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 151542" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 151542] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 151542" handleOld() recordno=152545 surname=ZABRIESZACH firstname=MARINA extension=11696 site=SSD extgroupunique=ACO03SSD handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 152545] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 152545" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 152545] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 152545" nrows=6 ===================================================== aline=[,VACUCOP,,,,,,,ACO11UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[VACUCOP] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[ACO11UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "ACO11UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "VACUCOP" " nrows=14 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "VACUCOP" " handleOld() recordno=104483 surname=.UNPROGRAMMED firstname= extension=12735 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 104483] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 104483" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 104483] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 104483" handleOld() recordno=120043 surname=.UNPROGRAMMED firstname= extension=12754 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 120043] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 120043" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 120043] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 120043" handleOld() recordno=120977 surname=.UNPROGRAMMED firstname= extension=12733 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 120977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 120977" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 120977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 120977" handleOld() recordno=122448 surname=.UNPROGRAMMED firstname= extension=12740 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 122448] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 122448" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 122448] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 122448" handleOld() recordno=126386 surname=.UNPROGRAMMED firstname= extension=12730 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 126386] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 126386" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 126386] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 126386" handleOld() recordno=131718 surname=.UNPROGRAMMED firstname= extension=12734 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 131718] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 131718" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 131718] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 131718" handleOld() recordno=134275 surname=.UNPROGRAMMED firstname= extension=12753 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134275] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134275" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134275] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134275" handleOld() recordno=134548 surname=.UNPROGRAMMED firstname= extension=12736 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134548" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134548" handleOld() recordno=134549 surname=.UNPROGRAMMED firstname= extension=12738 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134549] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134549" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134549] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134549" handleOld() recordno=134550 surname=.UNPROGRAMMED firstname= extension=12739 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 134550" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134550" handleOld() recordno=140838 surname=.UNPROGRAMMED firstname= extension=12755 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 140838] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 140838" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 140838] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 140838" handleOld() recordno=145417 surname=.UNPROGRAMMED firstname= extension=12731 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 145417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 145417" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 145417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 145417" handleOld() recordno=150495 surname=.UNPROGRAMMED firstname= extension=12737 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 150495] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 150495" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 150495] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 150495" handleOld() recordno=151330 surname=.UNPROGRAMMED firstname= extension=12732 site=UCP extgroupunique=VACUCOP handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 151330] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 151330" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 151330] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 151330" nrows=14 ===================================================== aline=[,SSDVACA2,,,,,,,ACO11UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[SSDVACA2] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[ACO11UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "ACO11UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "SSDVACA2" " nrows=2 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "SSDVACA2" " handleOld() recordno=113444 surname=.UNPROGRAMMED firstname= extension=11698 site=SSD extgroupunique=SSDVACA2 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 113444] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 113444" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 113444] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 113444" handleOld() recordno=152548 surname=.VACANT firstname= extension=11699 site=SSD extgroupunique=SSDVACA2 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 152548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="ACO11UC" ,general1="OPSCUCM" where recordno = 152548" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 152548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 152548" nrows=2 ===================================================== aline=[,HWL03SSD,,,,,,,HWL02UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[HWL03SSD] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[HWL02UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "HWL02UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "HWL03SSD" " nrows=0 ERROR: No rows found for Oldextn= OldPABX= OldExtnGroup=HWL03SSD ===================================================== aline=[,VACUCOP6,,,,,,,HWL02UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[VACUCOP6] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[HWL02UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "HWL02UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "VACUCOP6" " nrows=3 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "VACUCOP6" " handleOld() recordno=130839 surname=.UNPROGRAMMED firstname= extension=12741 site=UCP extgroupunique=VACUCOP6 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL02UC" ,general1="OPSCUCM" where recordno = 130839] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL02UC" ,general1="OPSCUCM" where recordno = 130839" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 130839] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 130839" handleOld() recordno=134551 surname=.UNPROGRAMMED firstname= extension=12742 site=UCP extgroupunique=VACUCOP6 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL02UC" ,general1="OPSCUCM" where recordno = 134551] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL02UC" ,general1="OPSCUCM" where recordno = 134551" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134551] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134551" handleOld() recordno=136042 surname=.UNPROGRAMMED firstname= extension=12743 site=UCP extgroupunique=VACUCOP6 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL02UC" ,general1="OPSCUCM" where recordno = 136042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL02UC" ,general1="OPSCUCM" where recordno = 136042" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 136042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 136042" nrows=3 ===================================================== aline=[,VACUCOP3,,,,,,,HWL03UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[VACUCOP3] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[HWL03UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "HWL03UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "VACUCOP3" " nrows=4 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "VACUCOP3" " handleOld() recordno=166926 surname=.UNPROGRAMMED firstname= extension=12750 site=UCP extgroupunique=VACUCOP3 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 166926] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 166926" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 166926] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 166926" handleOld() recordno=134553 surname=.UNPROGRAMMED firstname= extension=12747 site=UCP extgroupunique=VACUCOP3 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 134553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 134553" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134553] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 134553" handleOld() recordno=144418 surname=.UNPROGRAMMED firstname= extension=12748 site=UCP extgroupunique=VACUCOP3 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 144418] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 144418" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 144418] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 144418" handleOld() recordno=145326 surname=.UNPROGRAMMED firstname= extension=12749 site=UCP extgroupunique=VACUCOP3 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 145326] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL03UC" ,general1="OPSCUCM" where recordno = 145326" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 145326] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 145326" nrows=4 ===================================================== aline=[,VACUCOP4,,,,,,,HWL04UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[VACUCOP4] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[HWL04UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "HWL04UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "VACUCOP4" " nrows=1 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "VACUCOP4" " handleOld() recordno=121966 surname=.UNPROGRAMMED firstname= extension=12751 site=UCP extgroupunique=VACUCOP4 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL04UC" ,general1="OPSCUCM" where recordno = 121966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL04UC" ,general1="OPSCUCM" where recordno = 121966" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 121966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 121966" nrows=1 ===================================================== aline=[,VACUCOP2,,,,,,,HWL05UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[VACUCOP2] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[HWL05UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "HWL05UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "VACUCOP2" " nrows=1 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "VACUCOP2" " handleOld() recordno=106804 surname=.UNPROGRAMMED firstname= extension=12756 site=UCP extgroupunique=VACUCOP2 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL05UC" ,general1="OPSCUCM" where recordno = 106804] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="HWL05UC" ,general1="OPSCUCM" where recordno = 106804" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 106804] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 106804" nrows=1 ===================================================== aline=[,VACUCOP1,,,,,,,VLP01UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[VACUCOP1] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VLP01UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "VLP01UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "VACUCOP1" " nrows=3 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "VACUCOP1" " handleOld() recordno=100560 surname=.UNPROGRAMMED firstname= extension=12746 site=UCP extgroupunique=VACUCOP1 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP01UC" ,general1="OPSCUCM" where recordno = 100560] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP01UC" ,general1="OPSCUCM" where recordno = 100560" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 100560] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 100560" handleOld() recordno=135695 surname=.UNPROGRAMMED firstname= extension=12744 site=UCP extgroupunique=VACUCOP1 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP01UC" ,general1="OPSCUCM" where recordno = 135695] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP01UC" ,general1="OPSCUCM" where recordno = 135695" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 135695] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 135695" handleOld() recordno=150597 surname=.UNPROGRAMMED firstname= extension=12745 site=UCP extgroupunique=VACUCOP1 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP01UC" ,general1="OPSCUCM" where recordno = 150597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP01UC" ,general1="OPSCUCM" where recordno = 150597" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 150597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 150597" nrows=3 ===================================================== aline=[,VACUCOP7,,,,,,,VLP02UC,,HWL,HWL,UCP,,,,,OPSCUCM] OldExtn=[] OldExtnGroup=[VACUCOP7] OldDepartment=[] OldDivision=[] OldParent=[] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VLP02UC] NewDepartment=[] NewDivision=[HWL] NewParent=[HWL] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[OPSCUCM] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "VLP02UC"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "VACUCOP7" " nrows=1 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, 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 = "VACUCOP7" " handleOld() recordno=146523 surname=.UNPROGRAMMED firstname= extension=12752 site=UCP extgroupunique=VACUCOP7 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP02UC" ,general1="OPSCUCM" where recordno = 146523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "O" ,site="UCP" ,extgroupunique="VLP02UC" ,general1="OPSCUCM" where recordno = 146523" sqlcmd=[update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 146523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="21/09/2017" ,jobno="RS230917_HONEYWELL" ,division="HWL" where recordno = 146523" nrows=1