#! /bin/sh # VCS DIR #Name #Organisation #Position #Location #Address #Phone Type #Phone Number # VicTrack Telmax21 DIR #First Name Last Name #Customer #Title #Section #Location # #Extn/Mobile logfile="$0.log" # set environment variables. . /u/catcom/catcom_vars if [ -n "$1" ]; then XMLOUTFILE="$1" else XMLOUTFILE="vcs2.xml" fi if [ "$XMLOUTFILE" = "-" ]; then XMLOUTFILE="" SQLLOG="/dev/null" else SQLLOG="$logfile" fi ################################### tmpfile1="/tmp/vcs1tmp1_$$.unl" tmpfile2="/tmp/vcs1tmp2_$$.unl" tmpfile3="/tmp/vcs1tmp3_$$.unl" rm -f $tmpfile1 rm -f $tmpfile2 rm -f $tmpfile3 runisql 1>$SQLLOG 2>&1 <>"$logfile" 2>&1 awk -F '|' \ -v "tbsCustomerfile=$tmpfile3" \ -v "outfile=$tmpfile2" \ ' function trim(s) { sub(/^[ \t]*/,"",s) sub(/[ \t]*$/,"",s) gsub(/\,/,";",s) return s } function quotexmlval(s) { gsub(/\&/,"\&\;",s) gsub(//,"\>\;",s) gsub(/\"/,"\"\;",s) return s } function ld_tcustomer(tcustomerfile) { printf("ld_tcustomer(%s)\n", tcustomerfile) while ( (getline aline < tcustomerfile) > 0 ) { split(aline, a_arr, "|") ##printf("aline=%s\n", aline) CustomerID = trim(a_arr[1]) ShipTo = trim(a_arr[2]) FullName = trim(a_arr[3]) ShipToCode = trim(a_arr[4]) Address01 = trim(a_arr[5]) ShipTo = toupper(ShipTo) ShipToDesc = FullName ShipTo_to_ShipToDesc_arr[ShipTo] = ShipToDesc print "ShipTo_to_ShipToDesc_arr[" ShipTo "]=[" ShipTo_to_ShipToDesc_arr[ShipTo] "]" ShipTo_to_ShipToCode_arr[ShipTo] = ShipToCode print "ShipTo_to_ShipToCode_arr[" ShipTo "]=[" ShipTo_to_ShipToCode_arr[ShipTo] "]" if ( do_CustomerCode_arr[ShipToCode] != "1" ) { print "ex_CustomerCode_arr[\"" ShipToCode "\"] = \"1\" # " ShipToDesc } } close(tcustomerfile) print "done." } BEGIN { # ----------------------------- # Exclude Surname... ex_Surname_arr[".UNPROGRAMMED"] = "1" ex_Surname_arr[".VACANT"] = "1" # ----------------------------- # Exclude Customer... ex_CustomerCode_arr["10000002"] = "1" # 3GIS PTY LTD ex_CustomerCode_arr["10000008"] = "1" # AAPT LTD ex_CustomerCode_arr["10000011"] = "1" # ABI GROUP CONTRACTORS ex_CustomerCode_arr["10000011"] = "1" # ABIGROUP CONTRACTORS PTY LTD ex_CustomerCode_arr["10000012"] = "1" # ACCESS PTY LTD ex_CustomerCode_arr["10000026"] = "1" # AG ACME CONSTRUCTION GROUP ex_CustomerCode_arr["10000043"] = "1" # ALINTA ASSET MANAGEMENT PTY LTD ex_CustomerCode_arr["10000049"] = "1" # ALLIANZ AUSTRALIA WORKERS0x27 COMPENSATION ex_CustomerCode_arr["10000054"] = "1" # ALSTOM AUSTRALIA AND THIESS PTY LTD ex_CustomerCode_arr["10000055"] = "1" # ALSTOM AUSTRALIA LTD ex_CustomerCode_arr["10000059"] = "1" # AMG SECURITY SERVICES ex_CustomerCode_arr["10000074"] = "1" # APT AM HOLDINGS PTY LTD ex_CustomerCode_arr["10000074"] = "1" # APT AP HOLDINGS PTY LTD ex_CustomerCode_arr["10000090"] = "1" # ARMSTRONG KIRI ex_CustomerCode_arr["10000094"] = "1" # LIBRARY BOARD OF VICTORIA ex_CustomerCode_arr["10000095"] = "1" # ASCON CONSTRUCTION AND ENGINEERING ex_CustomerCode_arr["10000098"] = "1" # ASIA PACIFIC RAIL ex_CustomerCode_arr["10000104"] = "1" # ATLAS RODEK FENCING ex_CustomerCode_arr["10000107"] = "1" # AURECON AUSTRALIA PTY LTD ex_CustomerCode_arr["10000112"] = "1" # AUSTRALIAN AND NDT SERVICES ex_CustomerCode_arr["10000126"] = "1" # AUZCABLE NETWORKS PTY LTD ex_CustomerCode_arr["10000136"] = "1" # BAGUETTE FLINDERS STREET PTY LTD ex_CustomerCode_arr["10000151"] = "1" # BANYULE CITY COUNCIL ex_CustomerCode_arr["10000159"] = "1" # BARTON AUSTRALIA GROUP PTY LTD ex_CustomerCode_arr["10000162"] = "1" # BARWON REGION WATER AUTHORITY ex_CustomerCode_arr["10000164"] = "1" # BASSLINK TELECOMS PTY LTD ex_CustomerCode_arr["10000167"] = "1" # BAW BAW SHIRE COUNCIL ex_CustomerCode_arr["10000169"] = "1" # BAYBROWN CONSTRUCTION PTY LTD ex_CustomerCode_arr["10000174"] = "1" # BECA PTY LTD ex_CustomerCode_arr["10000175"] = "1" # BECTON EAST MELB CONSTRUCTION PTY LTD ex_CustomerCode_arr["10000189"] = "1" # BENDIGO LIQUOR WAREHOUSE NEDIS PTY LTD ex_CustomerCode_arr["10000191"] = "1" # BENDIGO RAILWAY STATION KIOSK ex_CustomerCode_arr["10000192"] = "1" # BENDIGO REGIONAL INSTITUTE OF TAFE ex_CustomerCode_arr["10000206"] = "1" # CONNEQ INFRASTUCTURE SERVICES PTY LTD ex_CustomerCode_arr["10000216"] = "1" # BLUESCOPE STEEL ex_CustomerCode_arr["10000225"] = "1" # BOMBARDIER TRANSPORTATION ex_CustomerCode_arr["10000269"] = "1" # BTB AUSTRALIA ex_CustomerCode_arr["10000285"] = "1" # C W TANG PTY LTD ex_CustomerCode_arr["10000286"] = "1" # CABLE AND WIRELESS OPTUS LTD ex_CustomerCode_arr["10000302"] = "1" # CAPACITY JOINT VENTURE ex_CustomerCode_arr["10000303"] = "1" # CARDINIA SHIRE COUNCIL ex_CustomerCode_arr["10000322"] = "1" # CARWOODE PTY LTD ex_CustomerCode_arr["10000324"] = "1" # CASTLEMAINE AND MALDON RAIL PRESERVA SOC ex_CustomerCode_arr["10000333"] = "1" # CENTRAL GIPPSLAND INSTITUTE OF TAFE ex_CustomerCode_arr["10000340"] = "1" # CFCLA AUSTRALIA PTY LTD ex_CustomerCode_arr["10000355"] = "1" # CHOCO CHURRO ex_CustomerCode_arr["10000366"] = "1" # BAYSIDE CITY COUNCIL ex_CustomerCode_arr["10000368"] = "1" # BALLARAT CITY COUNCIL ex_CustomerCode_arr["10000369"] = "1" # BOROONDARA CITY COUNCIL ex_CustomerCode_arr["10000371"] = "1" # DAREBIN CITY COUNCIL ex_CustomerCode_arr["10000374"] = "1" # MELBOURNE CITY COUNCIL ex_CustomerCode_arr["10000376"] = "1" # MORELAND CITY COUNCIL ex_CustomerCode_arr["10000377"] = "1" # PORT PHILLIP CITY COUNCIL ex_CustomerCode_arr["10000378"] = "1" # YARRA CITY COUNCIL ex_CustomerCode_arr["10000380"] = "1" # CITY RIVER CRUISES PTY LTD ex_CustomerCode_arr["10000382"] = "1" # CITY WIDE SERVICE ex_CustomerCode_arr["10000399"] = "1" # CMJV PROJECTS ex_CustomerCode_arr["10000401"] = "1" # COATES HIRE OPERATIONS ex_CustomerCode_arr["10000410"] = "1" # COFFEE HQ PTY LTD ex_CustomerCode_arr["10000411"] = "1" # COFFEY ENVIRONMENTS PTY LTD ex_CustomerCode_arr["10000413"] = "1" # COI BUILDING GROUP ex_CustomerCode_arr["10000424"] = "1" # COMGROUP AUSTRALIA PTY LTD ex_CustomerCode_arr["10000427"] = "1" # COMPUTER SCIENCE CORPORATION ex_CustomerCode_arr["10000436"] = "1" # CONNEX MAINCO JOINT VENTURE ex_CustomerCode_arr["10000450"] = "1" # CORKE INSTRUMENT ENGINEERING AUSTRALIA ex_CustomerCode_arr["10000457"] = "1" # COUNTRY FIRE AUTHORITY ex_CustomerCode_arr["10000458"] = "1" # COUNTRY LINK ex_CustomerCode_arr["10000478"] = "1" # DALTON CONSULTING ENGINEERS TY LTD ex_CustomerCode_arr["10000479"] = "1" # DALYS CONSTRUCTION AUSTRALIA PTY LTD ex_CustomerCode_arr["10000499"] = "1" # DAZZA PTY LTD ex_CustomerCode_arr["10000511"] = "1" # DEGRAVES COFFEE PLAZA ex_CustomerCode_arr["10000513"] = "1" # DELAWARE NORTH COMPANIES AUSTRALIA ex_CustomerCode_arr["10000519"] = "1" # DELTA PTY LTD ex_CustomerCode_arr["10000526"] = "1" # DEPT OF EDUCATION AND EARLY CHILD DE ex_CustomerCode_arr["10000528"] = "1" # DEPARTMENT OF HUMAN SERVICES ex_CustomerCode_arr["10000529"] = "1" # DEPARTMENT OF JUSTICE ex_CustomerCode_arr["10000531"] = "1" # DEPARTMENT OF PRIMARY INDUSTRIES ex_CustomerCode_arr["10000532"] = "1" # DEPT OF SUSTAINABILITY AND ENVIRONMENT ex_CustomerCode_arr["10000533"] = "1" # DEPARTMENT OF TRANSPORT ex_CustomerCode_arr["10000534"] = "1" # DEPARTMENT OF TREASURY AND FINANCE ex_CustomerCode_arr["10000535"] = "1" # DEPT OF INNOVATION IND AND REGIONAL DEVE ex_CustomerCode_arr["10000535"] = "1" # DIIRD ex_CustomerCode_arr["10000537"] = "1" # DESIGNANDSERVEY BRANCH; SOUTH EAST WATER ex_CustomerCode_arr["10000545"] = "1" # DIESEL RAIL MOTOR PRESERVATION ASSOCIATI ex_CustomerCode_arr["10000568"] = "1" # DOWNER EDI WORKS PTY LTD ex_CustomerCode_arr["10000591"] = "1" # EASTERN SIGNALS AND COMMS ex_CustomerCode_arr["10000593"] = "1" # EDLINGTON PTY LTD ex_CustomerCode_arr["10000596"] = "1" # EL ZORRO TRANSPORT PTY LTD ex_CustomerCode_arr["10000604"] = "1" # ELTHAM ECOVILLAGE PTY LTD ex_CustomerCode_arr["10000618"] = "1" # EPTEC PTY LTD ex_CustomerCode_arr["10000621"] = "1" # ERG TRANSIT SYSTEMS LTD ex_CustomerCode_arr["10000642"] = "1" # FIBRECOM TECHNOLOGY PTY LTD ex_CustomerCode_arr["10000682"] = "1" # FRYGMA PTY LTD ex_CustomerCode_arr["10000684"] = "1" # FULTON HOGAN PTY LTD ex_CustomerCode_arr["10000685"] = "1" # FUNNELL LISA ex_CustomerCode_arr["10000711"] = "1" # GENESEE AND WYOMING AUSTRALIA ex_CustomerCode_arr["10000717"] = "1" # GHD PTY LTD ex_CustomerCode_arr["10000717"] = "1" # GHD SERVICES PTY LTD ex_CustomerCode_arr["10000731"] = "1" # GJ AND KM MCLEOD AND ASSOCIATES PTY LTD ex_CustomerCode_arr["10000741"] = "1" # GOLDER ASSOCIATES PTY LTD ex_CustomerCode_arr["10000746"] = "1" # GORDON INSTITUTE OF TAFE ex_CustomerCode_arr["10000763"] = "1" # GREAT SOUTHERN RAILWAY LTD ex_CustomerCode_arr["10000765"] = "1" # GREATER DANDENONG CITY COUNCIL ex_CustomerCode_arr["10000769"] = "1" # GREEN STAR PARCELS - C/O SSSA ex_CustomerCode_arr["10000775"] = "1" # GROCON ex_CustomerCode_arr["10000776"] = "1" # GROGAN RICHARDS PTY LTD ex_CustomerCode_arr["10000823"] = "1" # HERITAGE EXPRESS ex_CustomerCode_arr["10000838"] = "1" # HOBSONS BAY MODEL RAILWAY CLUB INC ex_CustomerCode_arr["10000847"] = "1" # HONEYWELL LTD ex_CustomerCode_arr["10000852"] = "1" # HORSHAM RURAL CITY COUNCIL ex_CustomerCode_arr["10000857"] = "1" # HRD INTEGRATED SERVICES PTY LTD ex_CustomerCode_arr["10000862"] = "1" # HUME CITY COUNCIL ex_CustomerCode_arr["10000896"] = "1" # INTERNATIONAL TRANSPORT TRAINING AND DEV ex_CustomerCode_arr["10000900"] = "1" # INVESTA ASSET MANAGEMENT ex_CustomerCode_arr["10000910"] = "1" # M.R AND K.C WILLIAMS PTY LTD ex_CustomerCode_arr["10000911"] = "1" # JA DODD LTD ex_CustomerCode_arr["10000920"] = "1" # JAMISON AND CRAIG CONSULTANTS PTY LTD ex_CustomerCode_arr["10000927"] = "1" # JC DECAUX AUSTRALIA PTY LTD ex_CustomerCode_arr["10000932"] = "1" # JEMENA ex_CustomerCode_arr["10000932"] = "1" # JEMENA ASSET MANAGEMENT ex_CustomerCode_arr["10000932"] = "1" # JEMENA ASSET MANAGEMENT PTY LTD ex_CustomerCode_arr["10000933"] = "1" # JEMENA EAST ex_CustomerCode_arr["10000941"] = "1" # JOBSFORCE EMPLOYMENT SERVICES PTY LTD ex_CustomerCode_arr["10000945"] = "1" # JOHN HOLLAND CONSTRUCTION AND ENGINEERIN ex_CustomerCode_arr["10000946"] = "1" # JOHN HOLLAND GROUP PTY LTD ex_CustomerCode_arr["10000947"] = "1" # JOHN HOLLAND GROUP ex_CustomerCode_arr["10000947"] = "1" # JOHN HOLLAND PTY LTD ex_CustomerCode_arr["10000948"] = "1" # JOHN HOLLAND PTY LTD AND THIESS PTY LTD ex_CustomerCode_arr["10000949"] = "1" # JOHN HOLLAND PTY LTD AND MVM PTY LTD ex_CustomerCode_arr["10000950"] = "1" # JOHN HOLLAND PTY LTD ex_CustomerCode_arr["10000950"] = "1" # JOHN HOLLAND PTY LTD (RAIL DIVISION) ex_CustomerCode_arr["10000950"] = "1" # JOHN HOLLAND RAIL PTY LTD ex_CustomerCode_arr["10000959"] = "1" # K AND J TYRRELL PTY LTD ex_CustomerCode_arr["10000965"] = "1" # KAMCO ex_CustomerCode_arr["10001001"] = "1" # KNORR-BREMSE AUSTRALIA PTY LTD ex_CustomerCode_arr["10001003"] = "1" # KNOX CITY COUNCIL ex_CustomerCode_arr["10001012"] = "1" # LA STAZIONE CAFE ex_CustomerCode_arr["10001023"] = "1" # LAND MANAGEMENT SYSTEMS PTY LTD ex_CustomerCode_arr["10001030"] = "1" # LATROBE CITY COUNCIL ex_CustomerCode_arr["10001046"] = "1" # LEKKAS CONSTRUCTIONS PTY LTD ex_CustomerCode_arr["10001073"] = "1" # LORD OF THE FRIES PTY LTD ex_CustomerCode_arr["10001101"] = "1" # MAINCO MELBOURNE PTY LTD ex_CustomerCode_arr["10001109"] = "1" # MARIBYRNONG CITY COUNCIL ex_CustomerCode_arr["10001110"] = "1" # MARINA JURY ex_CustomerCode_arr["10001111"] = "1" # MARINE SAFETY VICTORIA ex_CustomerCode_arr["10001112"] = "1" # MARIOS CONSTRUCTION PTY LTD ex_CustomerCode_arr["10001135"] = "1" # MAUNSELL AUSTRALIA PTY LTD ex_CustomerCode_arr["10001144"] = "1" # MCCONNELL DOWELL CONSTRUCTORS (AUST) PTY ex_CustomerCode_arr["10001149"] = "1" # MCDONALD KEEN GROUP ex_CustomerCode_arr["10001163"] = "1" # MCLEOD RAIL PTY LTD ex_CustomerCode_arr["10001174"] = "1" # MELBOURNE CENTRAL AUTHORISED NEWSAGENCY ex_CustomerCode_arr["10001174"] = "1" # MELBOURNE CENTRAL NEWSAGENCY ex_CustomerCode_arr["10001175"] = "1" # MELBOURNE CENTRAL MAINTENANCE ex_CustomerCode_arr["10001182"] = "1" # MELBOURNE WATER CORPORATION ex_CustomerCode_arr["10001189"] = "1" # METLINK VICTORIA PTY LTD ex_CustomerCode_arr["10001190"] = "1" # METROPOLITAN FIRE AND EMERGENCY SERVICES ex_CustomerCode_arr["10001192"] = "1" # MFJ CONTRUCTIONS VIC PTY LTD ex_CustomerCode_arr["10001215"] = "1" # MINGARA SERVICES PTY LTD ex_CustomerCode_arr["10001228"] = "1" # MLA HOLDING PTY LTD ex_CustomerCode_arr["10001231"] = "1" # MOBIL REFINING ex_CustomerCode_arr["10001231"] = "1" # MOBIL REFINING AUSTRALIA PTY LTD ex_CustomerCode_arr["10001238"] = "1" # MOMENTUM RAIL NSW PTY LTD ex_CustomerCode_arr["10001240"] = "1" # MONASH CITY COUNCIL ex_CustomerCode_arr["10001260"] = "1" # MOTOROLA SOLUTIONS AUSTRALIA PROPRIETARY LIMITED ex_CustomerCode_arr["10001297"] = "1" # MWH AUSTRALIA PTY LTD ex_CustomerCode_arr["10001303"] = "1" # NATIONAL INFRASTRUCTURE SERVICES ex_CustomerCode_arr["10001304"] = "1" # NATURES LINKS LANDSCAPE MGNT PTY LTD ex_CustomerCode_arr["10001309"] = "1" # NEGRI CONTRACTORS AUS PTY LTD ex_CustomerCode_arr["10001320"] = "1" # NEXTGEN NETWORKS PTY LTD ex_CustomerCode_arr["10001322"] = "1" # NHK PTY LTD ex_CustomerCode_arr["10001326"] = "1" # NILLUMBIK SHIRE COUNCIL ex_CustomerCode_arr["10001351"] = "1" # O DONNELL GRIFFIN ex_CustomerCode_arr["10001367"] = "1" # OOH!MEDIA PTY LTD ex_CustomerCode_arr["10001370"] = "1" # OPTUS MOBILE PTY LTD ex_CustomerCode_arr["10001372"] = "1" # OPTUS PTY LTD ex_CustomerCode_arr["10001379"] = "1" # OZBORE ex_CustomerCode_arr["10001405"] = "1" # PARSONS BRINCKERHOFF ex_CustomerCode_arr["10001405"] = "1" # PARSONS BRINCKERHOFF AUSTRALIA PTY LTD ex_CustomerCode_arr["10001409"] = "1" # PATRICK PORTLINK PTY LTD ex_CustomerCode_arr["10001412"] = "1" # PAZZAMS PTY LTD ex_CustomerCode_arr["10001455"] = "1" # POWER CABLES PTY LTD ex_CustomerCode_arr["10001457"] = "1" # POWERCOR AUSTRALIA ex_CustomerCode_arr["10001457"] = "1" # POWERCOR AUSTRALIA LTD ex_CustomerCode_arr["10001462"] = "1" # PRESTIGE PLUMBING ex_CustomerCode_arr["10001466"] = "1" # PROJECT SPECIALISTS ex_CustomerCode_arr["10001471"] = "1" # PUBLIC TRANSPORT TICKETING BODY ex_CustomerCode_arr["10001483"] = "1" # AURIZON OPERATIONS LIMITED ex_CustomerCode_arr["10001483"] = "1" # QR LTD ex_CustomerCode_arr["10001485"] = "1" # QUANTEC SOLUTIONS PTY LTD ex_CustomerCode_arr["10001486"] = "1" # QUEENSLAND RAIL ex_CustomerCode_arr["10001494"] = "1" # RAIL CORPORATION ex_CustomerCode_arr["10001494"] = "1" # RAIL CORPORATION NEW SOUTH WALES ex_CustomerCode_arr["10001495"] = "1" # RAIL INFRASTRUCTURE CORPORATION ex_CustomerCode_arr["10001496"] = "1" # RAIL RE-ZOLVE PTY LTD ex_CustomerCode_arr["10001497"] = "1" # RAIL SIGNALLING SERVICES ex_CustomerCode_arr["10001497"] = "1" # RAIL SIGNALLING SERVICES PTY LTD ex_CustomerCode_arr["10001506"] = "1" # RAYMOND CHAN PHARMACY ex_CustomerCode_arr["10001510"] = "1" # RED ENGINE GROUP PTY LTD ex_CustomerCode_arr["10001522"] = "1" # REGIONAL RAIL LINK PTY LTD ex_CustomerCode_arr["10001549"] = "1" # ROAD CORPORATION ex_CustomerCode_arr["10001549"] = "1" # ROADS CORPORATION ex_CustomerCode_arr["10001549"] = "1" # ROADS CORPORATIONS ex_CustomerCode_arr["10001549"] = "1" # VICROADS ex_CustomerCode_arr["10001549"] = "1" # VICROADS EATERN REGION ex_CustomerCode_arr["10001549"] = "1" # VICROADS METRO NORTH WEST REGION ex_CustomerCode_arr["10001549"] = "1" # VICROADS SOUTH WEST REGION ex_CustomerCode_arr["10001581"] = "1" # SAFEWORKING SOLUTIONS ex_CustomerCode_arr["10001581"] = "1" # SAFEWORKING SOLUTIONS PTY LTD ex_CustomerCode_arr["10001584"] = "1" # SALTA CONSTRUCTIONS PTY LTD ex_CustomerCode_arr["10001610"] = "1" # SCT LOGISTICS ex_CustomerCode_arr["10001619"] = "1" # SERVICE STREAM COMMUNICATIONS PTY LTD ex_CustomerCode_arr["10001620"] = "1" # SEVEN NETWORK LTD ex_CustomerCode_arr["10001621"] = "1" # SEVEN-O-SEVEN OPERATIONS INC ex_CustomerCode_arr["10001622"] = "1" # SEYMOUR RAILWAY HERITAGE CENTRE ex_CustomerCode_arr["10001637"] = "1" # SHILA ILANGO ex_CustomerCode_arr["10001641"] = "1" # SIEMENS LTD ex_CustomerCode_arr["10001649"] = "1" # SILK TELECOM PTY LTD ex_CustomerCode_arr["10001653"] = "1" # SINCLAIR KNIGHT MERZ ex_CustomerCode_arr["10001653"] = "1" # SINCLAIR KNIGHT MERZ PTY LTD ex_CustomerCode_arr["10001659"] = "1" # SMARTE CARTE AUSTRALIA PTY LTD ex_CustomerCode_arr["10001660"] = "1" # SMEC URBAN CONSULTING GROUP ex_CustomerCode_arr["10001677"] = "1" # SOUTH EAST WATER LTD ex_CustomerCode_arr["10001679"] = "1" # SOUTH GIPPSLAND SHIRE COUNCIL ex_CustomerCode_arr["10001684"] = "1" # SOUTHERN AND SILVERTON RAILWAY PTY LTD ex_CustomerCode_arr["10001690"] = "1" # SOUTHERN IMPROVEMENT ALLIANCE ex_CustomerCode_arr["10001693"] = "1" # SOUTHERN SHORTHAUL RAILROAD PTY LTD ex_CustomerCode_arr["10001697"] = "1" # SPECIALIZED CONTAINER TRANSPORT ex_CustomerCode_arr["10001699"] = "1" # SPENO RAIL MAINTENANCE AUST PTY LTD ex_CustomerCode_arr["10001700"] = "1" # SPI ELECTRICITY PTY LTD ex_CustomerCode_arr["10001702"] = "1" # SPI NETWORKS PTY LTD ex_CustomerCode_arr["10001708"] = "1" # SRS SWANSTON ex_CustomerCode_arr["10001719"] = "1" # STATEWIDE COMMUNICATION PTY LTD ex_CustomerCode_arr["10001724"] = "1" # STEAMRAIL VICTORIA INC ex_CustomerCode_arr["10001744"] = "1" # STOWE AUSTRALIA ex_CustomerCode_arr["10001750"] = "1" # SUGAR STATION PTY LTD ex_CustomerCode_arr["10001783"] = "1" # TECH SIGNS PTY LTD ex_CustomerCode_arr["10001784"] = "1" # TELSTRA CORPORATION ex_CustomerCode_arr["10001784"] = "1" # TELSTRA CORPORATION LTD ex_CustomerCode_arr["10001786"] = "1" # TENIX AUSTRALIA PTY LTD ex_CustomerCode_arr["10001786"] = "1" # TENIX MAINTENANCE SERVICES PTY LTD ex_CustomerCode_arr["10001788"] = "1" # THE AUSSIE GRILL ex_CustomerCode_arr["10001791"] = "1" # THE MIDDLE BRIGHTON RAILWAY CAFE AND BAR ex_CustomerCode_arr["10001798"] = "1" # TRAVELLERS AID AUSTRALIA ex_CustomerCode_arr["10001801"] = "1" # THIESS AND UNITED GROUP INFRAST PTY LTD ex_CustomerCode_arr["10001801"] = "1" # THIESS DEGREMONT JOINT VENTURE ex_CustomerCode_arr["10001801"] = "1" # THIESS PTY LTD ex_CustomerCode_arr["10001822"] = "1" # TOTAL COMMUNICATIONS INFRASTRUCTURE ex_CustomerCode_arr["10001824"] = "1" # TOWER SUSHI ex_CustomerCode_arr["10001827"] = "1" # TRAC SNAX ex_CustomerCode_arr["10001831"] = "1" # METROLINK PTY LTD ex_CustomerCode_arr["10001831"] = "1" # TRANSDEV VIC AND TRANSFIELD METRO P L ex_CustomerCode_arr["10001832"] = "1" # TRANSDEVTSL PTY LTD ex_CustomerCode_arr["10001836"] = "1" # TRANSPORT ACCIDENT COMMISSION ex_CustomerCode_arr["10001854"] = "1" # U3A DAREBIN INC ex_CustomerCode_arr["10001863"] = "1" # UGL INFRASTRUCTURE PTY LTD ex_CustomerCode_arr["10001863"] = "1" # UNITED GROUP INFRASTRUCTURE PTY LTD ex_CustomerCode_arr["10001864"] = "1" # UNITED GROUP MELBOURNE TRANSPORT LTD ex_CustomerCode_arr["10001865"] = "1" # UNITED GROUP RAIL PTY LTD ex_CustomerCode_arr["10001869"] = "1" # UTILITY ASSET MANAGEMENT ex_CustomerCode_arr["10001876"] = "1" # VEMCO PTY LTD ex_CustomerCode_arr["10001877"] = "1" # VEMTEC PTY LTD ex_CustomerCode_arr["10001878"] = "1" # VEOLIA TRANSPORT AUST PTY LTD ex_CustomerCode_arr["10001878"] = "1" # VEOLIA TRANSPORT AUSTRALIASIA ex_CustomerCode_arr["10001879"] = "1" # VERNET PTY LTD ex_CustomerCode_arr["10001883"] = "1" # VICFORESTS ex_CustomerCode_arr["10001891"] = "1" # VICTORIAN RAILWAYS INSTITUTE INC ex_CustomerCode_arr["10001895"] = "1" # VISIONSTREAM PTY LTD ex_CustomerCode_arr["10001900"] = "1" # VM ROMANO CONSTRUCTION GROUP ex_CustomerCode_arr["10001901"] = "1" # VODAFONE NETWORK PTY LTD ex_CustomerCode_arr["10001920"] = "1" # RURAL CITY OF WANGARATTA ex_CustomerCode_arr["10001948"] = "1" # WEST GATE FREEWAY ALLIANCE PROCUREMENT ex_CustomerCode_arr["10001957"] = "1" # INVENSYS RAIL ex_CustomerCode_arr["10001957"] = "1" # INVENSYS RAIL PTY LTD ex_CustomerCode_arr["10001970"] = "1" # WIDEBAND NETWORKS PTY LTD ex_CustomerCode_arr["10001985"] = "1" # WINSLOW CONSTRUCTIONS ex_CustomerCode_arr["10001989"] = "1" # WIRELESS SOLUTIONS - ADVANCED SERVICES ex_CustomerCode_arr["10002001"] = "1" # WORLEYPARSONS ENGINEERING PTY LTD ex_CustomerCode_arr["10002014"] = "1" # YARRA TRAMS ex_CustomerCode_arr["10002021"] = "1" # YES OPTUS ex_CustomerCode_arr["10002081"] = "1" # CENITEX ex_CustomerCode_arr["10002082"] = "1" # MONASH UNIVERSITY ex_CustomerCode_arr["10002083"] = "1" # LEIGHTONS CONTRACTORS ex_CustomerCode_arr["10002085"] = "1" # SKILLS VICTORIA ex_CustomerCode_arr["10002087"] = "1" # KDR VICTORIA PTY LTD ex_CustomerCode_arr["10002097"] = "1" # STERLING GROUP CONSULTANTS PTY LTD ex_CustomerCode_arr["10002098"] = "1" # JOHN WEINBER ex_CustomerCode_arr["10002099"] = "1" # ARTS VICTORIA ex_CustomerCode_arr["10002100"] = "1" # TRACK AUSTRALIA PTY LTD ex_CustomerCode_arr["10002108"] = "1" # SINCLAIR KNIGHT MERZ ex_CustomerCode_arr["10002109"] = "1" # VIC SUPER ex_CustomerCode_arr["10002110"] = "1" # SALLY ANNE LEIGH ex_CustomerCode_arr["10002112"] = "1" # NEWSLINK PTY LTD ex_CustomerCode_arr["10002113"] = "1" # CAROLINE DOWELL ex_CustomerCode_arr["10002118"] = "1" # BUTLER EXCAVATIONS ex_CustomerCode_arr["10002122"] = "1" # VICROADS IMPROVEMENT PROJECTS ex_CustomerCode_arr["10002123"] = "1" # RAIL TRAM AND BUS UNION ex_CustomerCode_arr["10002125"] = "1" # AUSTRALAND HOLDINGS ex_CustomerCode_arr["10002129"] = "1" # HEALEY EXCAVATIONS ex_CustomerCode_arr["10002129"] = "1" # HEALEY EXCAVATIONS PTY LTD ex_CustomerCode_arr["10002170"] = "1" # BOVIS LEND LEASE PTY LTD ex_CustomerCode_arr["10002184"] = "1" # DELFIN PAKENHAM VALLEY PTY LTD ex_CustomerCode_arr["10002185"] = "1" # BMD CONSTRUCTIONS PTY LTD ex_CustomerCode_arr["10002195"] = "1" # FILMS AND CASTING TEMPLE PTY LTD ex_CustomerCode_arr["10002217"] = "1" # BOX HILL INSTITUTE OF TAFE ex_CustomerCode_arr["10002219"] = "1" # ASIAN PACIFIC BUILDING CORPORATION ex_CustomerCode_arr["10002230"] = "1" # POWERCOR NETWORK SERVICES PTY LTD ex_CustomerCode_arr["10002235"] = "1" # NORTHERN MELBOURNE INSTITUTE OF TAFE ex_CustomerCode_arr["10002237"] = "1" # HOLMESGLEN INSTITUTE OF TAFE ex_CustomerCode_arr["10002238"] = "1" # WILLIAM ANGLISS INSTITUTE ex_CustomerCode_arr["10002239"] = "1" # CHISHOLM INSTITUTE OF TAFE ex_CustomerCode_arr["10002242"] = "1" # DEPARTMENT OF PLANNING AND COMMUNITY DEVELOPMENT ex_CustomerCode_arr["10002245"] = "1" # BROWN AND TOMKINSON ex_CustomerCode_arr["10002249"] = "1" # NORMAN DISNEY AND YOUNG ex_CustomerCode_arr["10002251"] = "1" # KANGAN INSTITUTE OF TAFE ex_CustomerCode_arr["10002256"] = "1" # OLE JV ex_CustomerCode_arr["10002267"] = "1" # ADVANCE TAFE ex_CustomerCode_arr["10002268"] = "1" # GOULBURN OVENS INSTITUTE OF TAFE ex_CustomerCode_arr["10002269"] = "1" # WODONGA INSTITUTE OF TAFE ex_CustomerCode_arr["10002270"] = "1" # SUNRAYSIA INSTITUTE OF TAFE ex_CustomerCode_arr["10002271"] = "1" # SOUTH WEST INSTITUTE OF TAFE ex_CustomerCode_arr["10002274"] = "1" # MELBOURNE RADIO OPERATIONS ex_CustomerCode_arr["10002275"] = "1" # ROBSON AUTO ELECTRICAL ex_CustomerCode_arr["10002278"] = "1" # SUNBURY ALLIANCE ex_CustomerCode_arr["10002283"] = "1" # BROOKFIELD MULTIPLEX CONSTRUCTIONS P/L ex_CustomerCode_arr["10002283"] = "1" # BROOKFIELD MULTIPLEX LIMITED ex_CustomerCode_arr["10002291"] = "1" # WUNDA PROJECTS AUSTRALIA PARTNERSHIP ex_CustomerCode_arr["10002305"] = "1" # AUSTRALIAN RAILWAY HISTORICAL SOCIETY ex_CustomerCode_arr["10002306"] = "1" # SP AUSNET LILYDALE ex_CustomerCode_arr["10002310"] = "1" # DEPARTMENT OF TRANSPORT NSW ex_CustomerCode_arr["10002328"] = "1" # APT MANAGEMENT SERVICES ex_CustomerCode_arr["10002336"] = "1" # NOKIA SIEMENS NETWORKS ex_CustomerCode_arr["10002336"] = "1" # NOKIA SIEMENS NETWORKS AUSTRALIA PTY LTD ex_CustomerCode_arr["10002339"] = "1" # CARDNO GROGAN RICHARDS ex_CustomerCode_arr["10002346"] = "1" # CNT CORP PTY LTD ex_CustomerCode_arr["10002379"] = "1" # DEPARTMENT OF HEALTH ex_CustomerCode_arr["10002388"] = "1" # ENGENCO LIMITED ex_CustomerCode_arr["10002389"] = "1" # O DONNELL G AND LAING O ROURKE ELECTRIFICATION JOI ex_CustomerCode_arr["10002407"] = "1" # GTE TRACK SPRAY ex_CustomerCode_arr["10002409"] = "1" # A A HOLDINGS PTY ex_CustomerCode_arr["10002445"] = "1" # CENTRE FOR EXCELLENCE IN RAIL TRAINING (CERT) ex_CustomerCode_arr["10002446"] = "1" # HACER GROUP PTY LTD ex_CustomerCode_arr["10002449"] = "1" # VICTORIAN COMMISSION FOR GAMBLING AND LIQUOR REGU ex_CustomerCode_arr["10002472"] = "1" # SPOTLESS FACILITY SERVICES PTY LTD ex_CustomerCode_arr["10002480"] = "1" # AUSTRALIAN LOCOLEASE ex_CustomerCode_arr["10002483"] = "1" # TPDN TRADINGS PTY LTD ex_CustomerCode_arr["10002505"] = "1" # RAIL TRAINING INTERNATIONAL ex_CustomerCode_arr["10002506"] = "1" # JAYDO CONSTRUCTION PTY LTD ex_CustomerCode_arr["10002507"] = "1" # PUBLIC TRANSPORT VICTORIA ex_CustomerCode_arr["10002526"] = "1" # ALSTOM LIMITED ex_CustomerCode_arr["10002543"] = "1" # CIVILEX VICTORIA PTY LTD ex_CustomerCode_arr["10002548"] = "1" # INTEGRATE RAIL JOINT VENTURE ex_CustomerCode_arr["10002551"] = "1" # CONSTRUCTION ENGINEERING AUST PTY LTD ex_CustomerCode_arr["10002565"] = "1" # AUSTRALIA AND NEW ZEALAND BANKING GROUP LTD ex_CustomerCode_arr["10002566"] = "1" # AODAN PTY LTD ex_CustomerCode_arr["10002573"] = "1" # NICOLA HOLLAND ex_CustomerCode_arr["10002578"] = "1" # TELIS KERAMARIS ex_CustomerCode_arr["10002588"] = "1" # COLEMAN RAIL PTY LTD ex_CustomerCode_arr["10002590"] = "1" # THIESS BALFOUR BEATTY JOINT VENTURE ex_CustomerCode_arr["10002604"] = "1" # PICO GROUP PTY LTD ex_CustomerCode_arr["10002606"] = "1" # LA STAZIONE CAFE ex_CustomerCode_arr["10002607"] = "1" # SYDAC PTY LTD ex_CustomerCode_arr["10002625"] = "1" # UGL RAIL SERVICES LIMITED ex_CustomerCode_arr["10002647"] = "1" # SOAG PRODUCTIONS PTY LTD ex_CustomerCode_arr["10002652"] = "1" # LEND LEASE INFRASTRUCTURE SERVICES ex_CustomerCode_arr["10002654"] = "1" # MBBM INVESTMENTS PTY ex_CustomerCode_arr["10002664"] = "1" # VODAFONE HUTCHISON AUSTRALIA PTY LTD ex_CustomerCode_arr["10002672"] = "1" # JENNA ASHLEE WHITEHEAD ex_CustomerCode_arr["10002676"] = "1" # IZZYS COFFEE LOUNGE ex_CustomerCode_arr["10002689"] = "1" # DUNLOP & PITSON EARTHMOVING PTY LTD ex_CustomerCode_arr["10002690"] = "1" # ASSETCO MANGEMENT PTY LTD ex_CustomerCode_arr["AHP1"] = "1" # ex_CustomerCode_arr["ATS"] = "1" # ex_CustomerCode_arr["CSD"] = "1" # ex_CustomerCode_arr["HRD"] = "1" # ex_CustomerCode_arr["HUB"] = "1" # ex_CustomerCode_arr["ID"] = "1" # ex_CustomerCode_arr["MBD"] = "1" # ex_CustomerCode_arr["MD"] = "1" # ex_CustomerCode_arr["MTN"] = "1" # ex_CustomerCode_arr["OOS"] = "1" # ex_CustomerCode_arr["PSB"] = "1" # ex_CustomerCode_arr["PSC"] = "1" # ex_CustomerCode_arr["PST"] = "1" # ex_CustomerCode_arr["PTC"] = "1" # ex_CustomerCode_arr["S9923922"] = "1" # OPTUS NETWORKS PTY LIMITED ex_CustomerCode_arr["S9924784"] = "1" # VICTORIAN URBAN DEVELOPMENT AUTHORITY ex_CustomerCode_arr["TQM"] = "1" # ex_CustomerCode_arr["V0605004"] = "1" # West Coast Railways ex_CustomerCode_arr["V0605006"] = "1" # SOUTHERN CROSS STATION AUTHORITY ex_CustomerCode_arr["V6050008"] = "1" # State Rail Authority ex_CustomerCode_arr["V6050022"] = "1" # ABB Transportation ex_CustomerCode_arr["V6050056"] = "1" # Shell Refinery Australia Ltd ex_CustomerCode_arr["V6050078"] = "1" # IBM GSA ex_CustomerCode_arr["V6050083"] = "1" # Hillside Trains ex_CustomerCode_arr["V6050084"] = "1" # Bayside Trains ex_CustomerCode_arr["V6050092"] = "1" # DOCKLANDS AUTHORITY ex_CustomerCode_arr["V6050093"] = "1" # AAPT LIMITED ex_CustomerCode_arr["V6050095"] = "1" # JOHN HOLLAND PTY LTD ex_CustomerCode_arr["V6050096"] = "1" # VICROADS ex_CustomerCode_arr["V6050097"] = "1" # YARRA TRAMS ex_CustomerCode_arr["V6050101"] = "1" # FREIGHT AUSTRALIA ex_CustomerCode_arr["V6050403"] = "1" # ATTWOOD AMBER ex_CustomerCode_arr["V6050404"] = "1" # METROLINK ex_CustomerCode_arr["V6050405"] = "1" # REVENUE CLEARING HOUSE ex_CustomerCode_arr["V6050434"] = "1" # TRANSFIELD MAINTENANCE PTY LTD ex_CustomerCode_arr["V6050437"] = "1" # VIC TRIP ex_CustomerCode_arr["V6050438"] = "1" # SKILLED GROUP LIMITED ex_CustomerCode_arr["V6050445"] = "1" # CGEA TRANSPORT MELBOURNE PTY LTD ex_CustomerCode_arr["V6050446"] = "1" # THIESS INFRACO (BAYSIDE) PTY LTD ex_CustomerCode_arr["V6050447"] = "1" # THIESS INFRACO (SWANSTON) PTY LTD ex_CustomerCode_arr["V6050448"] = "1" # NX AUSTRALIA (V/LINE PASSENGER) PTY LTD ex_CustomerCode_arr["V6050449"] = "1" # NX (BAYSIDE) PTY LTD ex_CustomerCode_arr["V6050457"] = "1" # WAINWRIGHT ADELAIDE ex_CustomerCode_arr["V6050461"] = "1" # TICKETEK VICTORIA ex_CustomerCode_arr["V6050474"] = "1" # NX AUSTRALIA (SWANSTON) PTY LTD ex_CustomerCode_arr["V6050484"] = "1" # AUSTRALIA SOUTHERN RAILROAD PTY LTD ex_CustomerCode_arr["V6050485"] = "1" # ELDERS AUSTRALIA LTD ex_CustomerCode_arr["V6050488"] = "1" # ICM PROPERTY SERVICES PTY LTD ex_CustomerCode_arr["V6050489"] = "1" # VAGIAS PETER ex_CustomerCode_arr["V6050490"] = "1" # BECKWITH LAURIE ex_CustomerCode_arr["V6050491"] = "1" # AUSTRAC OPERATIONS PTY LTD ex_CustomerCode_arr["V6050495"] = "1" # HOLYMAN TRANSPORT ex_CustomerCode_arr["V6050496"] = "1" # SHERIDAN CONSULTANCY SERVICE ex_CustomerCode_arr["V6050502"] = "1" # ARGUS TELECOMS ex_CustomerCode_arr["V6050505"] = "1" # STAGG D P ex_CustomerCode_arr["V6050507"] = "1" # ARENA S ex_CustomerCode_arr["V6050508"] = "1" # BARRESI M ex_CustomerCode_arr["V6050509"] = "1" # MICHEL ANNA ex_CustomerCode_arr["V6050514"] = "1" # MCMAHON SERVICES ex_CustomerCode_arr["V6050515"] = "1" # QLINE GRID ex_CustomerCode_arr["V6050516"] = "1" # RAILTEK AUSTRALIA PTY LTD ex_CustomerCode_arr["V6050517"] = "1" # WABTEC AUSTRALIA ex_CustomerCode_arr["V6050522"] = "1" # JOHN WERTHEIMER CONSULTANTS ex_CustomerCode_arr["V6050530"] = "1" # COUNTRY FIRE AUTHORITY ex_CustomerCode_arr["V6050533"] = "1" # SCHINDLERS LIFTS ex_CustomerCode_arr["V6050534"] = "1" # MVM RAIL PTY LTD ex_CustomerCode_arr["V6050541"] = "1" # MELBOURNE TRANSPORT ENTERPRISES ex_CustomerCode_arr["V6050543"] = "1" # RAIL TRAM & BUS UNION LOCO DIVISION ex_CustomerCode_arr["V6050544"] = "1" # PARLIAMENT STATION DELI ex_CustomerCode_arr["V6050545"] = "1" # DOCKLINKS DELI ex_CustomerCode_arr["V6050546"] = "1" # HYDER CONSULTING ex_CustomerCode_arr["V6050559"] = "1" # NATIONAL EXPRESS GROUP ex_CustomerCode_arr["V6050570"] = "1" # PUBLIC RECORD OFFICE VICTORIA ex_CustomerCode_arr["V6050571"] = "1" # DEPARTMENT OF HUMAN SERVICES ex_CustomerCode_arr["V6050585"] = "1" # VICTORIAN GOVERNMENT PROPERTY GROUP ex_CustomerCode_arr["V6050595"] = "1" # PIENETWORKS ex_CustomerCode_arr["V6050596"] = "1" # MEGADYNE PTY LTD ex_CustomerCode_arr["V6050597"] = "1" # CHRISTIE MR JUSTIN L ex_CustomerCode_arr["V6050598"] = "1" # SOUP PTY LTD ex_CustomerCode_arr["V6050602"] = "1" # NORTHPOWER DATA AGENCY ex_CustomerCode_arr["V6050613"] = "1" # UE COMM OPERATIONS PTY LTD ex_CustomerCode_arr["V6050616"] = "1" # NEWSLINK PTY LTD ex_CustomerCode_arr["V6050627"] = "1" # LATROBE SHIRE COUNCIL ex_CustomerCode_arr["V6050628"] = "1" # CONSULTRANS ex_CustomerCode_arr["V6050630"] = "1" # LACHLAN VALLEY RAIL FREIGHT ex_CustomerCode_arr["V6050645"] = "1" # NATIONAL LOGISTICS CO-ORDINATORS ex_CustomerCode_arr["V6050651"] = "1" # PRIME DATA ex_CustomerCode_arr["V6050654"] = "1" # HERITAGE VICTORIA ex_CustomerCode_arr["V6050668"] = "1" # URBAN MAINTENANCE SYSTEMS ex_CustomerCode_arr["V6050676"] = "1" # NATURALLY JUICY PTY LTD ex_CustomerCode_arr["V6050679"] = "1" # WESTPAC BANKING CORPORATION ex_CustomerCode_arr["V6050680"] = "1" # TURFMASTER ex_CustomerCode_arr["V6050681"] = "1" # UNITED ENERGY TELECOMS ex_CustomerCode_arr["V6050684"] = "1" # MARITIME CONTAINER SERVICES ex_CustomerCode_arr["V6050701"] = "1" # FRESH AND TASTY ex_CustomerCode_arr["V6050702"] = "1" # HIGH RIG CRANES ex_CustomerCode_arr["V6050713"] = "1" # NETWORK DESIGN & CONSTRUCTION ex_CustomerCode_arr["V6050714"] = "1" # THIESS/RSA JOINT VENTURE ex_CustomerCode_arr["V6050716"] = "1" # TYCO INTEGRATED SYSTEMS ex_CustomerCode_arr["V6050722"] = "1" # DAWSON MR KEITH ex_CustomerCode_arr["V6050723"] = "1" # TANDY TRANSPORT PTY LTD ex_CustomerCode_arr["V6050734"] = "1" # DEPARTMENT OF EDUCATION EMPLOYMENT & TRA ex_CustomerCode_arr["V6050735"] = "1" # NATIONAL AUSTRALIAN PIPELINES PTY LTD ex_CustomerCode_arr["V6050738"] = "1" # GE TRANSPORTATION PTY LTD ex_CustomerCode_arr["V6050741"] = "1" # BOVIS LEND LEASE ex_CustomerCode_arr["V6050742"] = "1" # GREEN POINT CAFE ex_CustomerCode_arr["V6050751"] = "1" # GEOTECHNICAL ENGINEERING ex_CustomerCode_arr["V6050762"] = "1" # ESLER & ASSOCIATES ex_CustomerCode_arr["V6050763"] = "1" # SCOTT WILSON IRWIN JOHNSTON PTY LTD ex_CustomerCode_arr["V6050764"] = "1" # VICTORIA POLICE ex_CustomerCode_arr["V6050765"] = "1" # AGILITY TEAM BUILD PTY LTD ex_CustomerCode_arr["V6050779"] = "1" # DOWNER CONNECT ex_CustomerCode_arr["V6050798"] = "1" # JONES LANG LA SALLE ex_CustomerCode_arr["V6050799"] = "1" # DY TIAPCO J ex_CustomerCode_arr["V6050816"] = "1" # AUSTRALIAN SOUTHERN RAILROAD ex_CustomerCode_arr["V6050821"] = "1" # CIVILUTIONS PTY LTD ex_CustomerCode_arr["V6050828"] = "1" # TCI ex_CustomerCode_arr["V6050836"] = "1" # AITKEN & HILL PTY LTD ex_CustomerCode_arr["V6050852"] = "1" # UNITED KG ex_CustomerCode_arr["V6050854"] = "1" # EMPIRE RUBBER (COMPONENTS) ex_CustomerCode_arr["V6050855"] = "1" # STERLING GROUP CONSULTANTS PTY LTD ex_CustomerCode_arr["V6050858"] = "1" # ONELINK TRANSIT SYSTEMS PTY LTD ex_CustomerCode_arr["V6050863"] = "1" # HUTCHISON TELECOMS ex_CustomerCode_arr["V6050868"] = "1" # SIMS METAL ex_CustomerCode_arr["V6050873"] = "1" # HUDSON COFFEE ex_CustomerCode_arr["V6050875"] = "1" # VODAFONE ex_CustomerCode_arr["V6050878"] = "1" # CUT AND FILL PTY LTD ex_CustomerCode_arr["V6050882"] = "1" # EDGE DE ANGLIS ex_CustomerCode_arr["V6050884"] = "1" # NEGA (SWANSTON TRAMS) PTY LTD ex_CustomerCode_arr["V6050885"] = "1" # NEGA (BAYSIDE TRAINS) PTY LTD ex_CustomerCode_arr["V6050886"] = "1" # NEGA (V/LINE PASSENGER) PTY LTD ex_CustomerCode_arr["V6050887"] = "1" # ABLE DEMOLITIONS ex_CustomerCode_arr["V6050889"] = "1" # LEVANT ENTERPRISES PTY LTD ex_CustomerCode_arr["V6050899"] = "1" # VICTORIAN RAIL SERVICES ex_CustomerCode_arr["V6050904"] = "1" # COLEMAN RAIL PTY LTD ex_CustomerCode_arr["V6050909"] = "1" # NATIONAL EXPRESS GROUP PTY LTD ex_CustomerCode_arr["V6050920"] = "1" # LEIGHTONS CONTRACTORS ex_CustomerCode_arr["V6050921"] = "1" # HARRIS OFFICE ENVIRONMENTS ex_CustomerCode_arr["V6050922"] = "1" # SKILLED TRAFFIC DIVISION ex_CustomerCode_arr["V6050923"] = "1" # DEPARTMENT OF TRANSPORT ex_CustomerCode_arr["V6050926"] = "1" # ALSTOM ENGINEERING SYSTEMS ex_CustomerCode_arr["V6050937"] = "1" # STCJV ex_CustomerCode_arr["V6050944"] = "1" # POWERCOR TELECOM ex_CustomerCode_arr["V6050949"] = "1" # BRINKLKEY JOHN ex_CustomerCode_arr["V6050950"] = "1" # HIGH TECH INDUSTRIAL SERVICES ex_CustomerCode_arr["V6050958"] = "1" # ORIGIN ENERGY ELECTRICITY LTD ex_CustomerCode_arr["V6050962"] = "1" # DEPT OF SUSTAINABILITY & ENVIRONMENT ex_CustomerCode_arr["V6050963"] = "1" # UNITED ENERGY ex_CustomerCode_arr["V6050980"] = "1" # NATIONAL GALLERY OF VICTORIA ex_CustomerCode_arr["V6050981"] = "1" # BLUE FLYER AUCTIONS ex_CustomerCode_arr["V6050982"] = "1" # WAG PIPELINE ex_CustomerCode_arr["V6050985"] = "1" # QBE MERCANTILE MUTUAL ex_CustomerCode_arr["V6050988"] = "1" # VICTORIAN RACING CLUB ex_CustomerCode_arr["V6051011"] = "1" # N.A.C. ex_CustomerCode_arr["V6051026"] = "1" # THE DINER ON DYNON ex_CustomerCode_arr["V6051027"] = "1" # ASIA PACIFIC TRANSPORT ex_CustomerCode_arr["V6051039"] = "1" # KAZ TECHNOLOGY SERVICES PTY LTD ex_CustomerCode_arr["V6051041"] = "1" # RAIL CORP ex_CustomerCode_arr["V6051045"] = "1" # KANE CONSTRUCTION ex_CustomerCode_arr["V6051047"] = "1" # ALSTOM TRANSPORT INFORMATION SOLUTIONS ex_CustomerCode_arr["V6051050"] = "1" # AS JAMES PTY LTD ex_CustomerCode_arr["V6051054"] = "1" # PORT OF MELBOURNE CORPORATION ex_CustomerCode_arr["V6051058"] = "1" # WILLIAMS-WORLEY RAIL ex_CustomerCode_arr["V6051061"] = "1" # TEMPO SERVICES ex_CustomerCode_arr["V6051062"] = "1" # DOXA SOCIAL CLUB ex_CustomerCode_arr["V6051073"] = "1" # SCHIAVELLO (VIC) PTY LTD ex_CustomerCode_arr["V6051104"] = "1" # MUSEUM VICTORIA ex_CustomerCode_arr["V6051106"] = "1" # T SQUARED ex_CustomerCode_arr["V6051108"] = "1" # FRH VICTORIA PTY LTD ex_CustomerCode_arr["V6051115"] = "1" # RICHARD KEPERT ex_CustomerCode_arr["V6051134"] = "1" # MCT CONSTRUCTIONS PTY LTD ex_CustomerCode_arr["V6051142"] = "1" # BAYCROWN PTY LTD ex_CustomerCode_arr["V6051147"] = "1" # WATSONS PTY LTD ex_CustomerCode_arr["V6051148"] = "1" # HLA ENVIROSCIENCES PTY LTD ex_CustomerCode_arr["V6051151"] = "1" # MUSEUM OF VICTORIA ex_CustomerCode_arr["V6051152"] = "1" # BARRY BROS SPECIALISED SERVICES ex_CustomerCode_arr["V6051167"] = "1" # CITY OF CASEY ex_CustomerCode_arr["V6051169"] = "1" # CONNEX MANAGEMENT AUSTRALIA ex_CustomerCode_arr["V6051170"] = "1" # MILES CIVIL DESIGN PTY LTD ex_CustomerCode_arr["V6051177"] = "1" # R & R MCCLURE EXCAVATIONS ex_CustomerCode_arr["V6051178"] = "1" # BECTON PROPERTY GROUP ex_CustomerCode_arr["V6051194"] = "1" # DIG RITE EXCAVATIONS VIC P/L ex_CustomerCode_arr["V6051195"] = "1" # ALSTOM TRANSPORT AUSTRALIA ex_CustomerCode_arr["V6051202"] = "1" # ALINTA MANAGEMENT SERVICES ex_CustomerCode_arr["V6051204"] = "1" # AUSTRALIAN CENTRE FOR MOVING IMAGE ex_CustomerCode_arr["V6051207"] = "1" # JESSE JAXON PTY LTD ex_CustomerCode_arr["V6051227"] = "1" # THE BIG GARAGE ex_CustomerCode_arr["V6051228"] = "1" # ENVIRONMENT PROTECTION AUTHORITY VIC ex_CustomerCode_arr["V6051238"] = "1" # CSC CIVIL CONSTRUCTION ex_CustomerCode_arr["V6051246"] = "1" # CLEAN DOMAIN ex_CustomerCode_arr["V6051258"] = "1" # BAIGENTS PTY LTD ex_CustomerCode_arr["V6051260"] = "1" # ANDRETTO PTY LTD ex_CustomerCode_arr["V6051261"] = "1" # STORNOWAY PROJECTS PTY LTD ex_CustomerCode_arr["V6051284"] = "1" # TENIX T SQUARED ex_CustomerCode_arr["V6051296"] = "1" # KM & CA MARSLEN PTY LTD ex_CustomerCode_arr["V6051297"] = "1" # BOON LOGISTICS ex_CustomerCode_arr["V6051309"] = "1" # THIESS PTY LTD ex_CustomerCode_arr["V6051310"] = "1" # LEDERMANS AUTHORISED NEWSAGENCY ex_CustomerCode_arr["V6051384"] = "1" # YVONNE PAPALIA ex_CustomerCode_arr["V6051391"] = "1" # STRUCTURAL SYSTEMS (SOUTHERN) PTY LTD ex_CustomerCode_arr["V6051417"] = "1" # CROWN MELBOURNE LIMITED ex_CustomerCode_arr["V6051472"] = "1" # ASCIANO PTY LTD ex_CustomerCode_arr["V6051519"] = "1" # CHANNEL 7 ex_CustomerCode_arr["V6051533"] = "1" # CAHILL NIALL ex_CustomerCode_arr["V6051558"] = "1" # CARWOODE PTY LTD ex_CustomerCode_arr["V6051566"] = "1" # DEPARTMENT OF EDUCATION AND EARLY CHILDH ex_CustomerCode_arr["V6051596"] = "1" # JEMENA ELECTRICITY ex_CustomerCode_arr["V6051619"] = "1" # PRIMUS TELECOMMUNICATIONS (AUST) PTY LYD ex_CustomerCode_arr["V6051621"] = "1" # NEIGHBOURHOOD CABLE ex_CustomerCode_arr["V6051624"] = "1" # GEELONG CITY COUNCIL ex_CustomerCode_arr["V6051630"] = "1" # DELPHIN LEND LEASE ex_CustomerCode_arr["V605175"] = "1" # HRD INTEGRATED SERVICES PTY LTD ex_CustomerCode_arr["V7074016"] = "1" # T/O0x27S TUCKER ex_CustomerCode_arr["V7074024"] = "1" # A GONINON & CO ex_CustomerCode_arr["V7074026"] = "1" # EMBASSY TAXI SERVICE ex_CustomerCode_arr["V7074037"] = "1" # IAN COOK CATERING ex_CustomerCode_arr["V7074038"] = "1" # ADVANCED FOOD SYSTEMS ex_CustomerCode_arr["V7074072"] = "1" # SWANSTON TRAMS CORPORATION ex_CustomerCode_arr["V7074089"] = "1" # EMERALD GLEN CONSTRUCTIONS ex_CustomerCode_arr["V7074090"] = "1" # TRAIN DRIVERS SOCIAL CLUB ex_CustomerCode_arr["V7074111"] = "1" # MELBOURNE MOOMBA FESTIVAL ex_CustomerCode_arr["V7074112"] = "1" # TICKET MASTER BASS ex_CustomerCode_arr["V7074134"] = "1" # ABB JONES & RICKARD ex_CustomerCode_arr["VEH MTCE"] = "1" # ex_CustomerCode_arr["VFD"] = "1" # ex_CustomerCode_arr["v6050933"] = "1" # NDC ex_CustomerCode_arr["v6050947"] = "1" # COMPUTERTRANS ex_CustomerCode_arr["v6051038"] = "1" # CHIAN MANAGMENT PTY LTD ex_CustomerCode_arr["v6051052"] = "1" # RURAL CITY OF WANGARATTA ex_CustomerCode_arr["v6051059"] = "1" # CENTRAL PASS OFFICE ex_CustomerCode_arr["v6051063"] = "1" # RIGWELD PTY LTD # ----------------------------- ## Include Customer List... # #do_CustomerCode_arr["10000118"] = "1" # Australian Rail Track Corporation Ltd # #do_CustomerCode_arr["10000847|"] = "1" # Honeywell Ltd # #do_CustomerCode_arr["10000894"] = "1" # Interail Australia # ## Metro Trains Melbourne Pty Ltd #do_CustomerCode_arr["10000437"] = "1" # METRO TRAINS MELBOURNE PTY LTD #do_CustomerCode_arr["10002086"] = "1" # METRO TRAINS MELBOURNE PTY LTD # ## Pacific National Pty Ltd #do_CustomerCode_arr["10001385"] = "1" # PACIFIC NATIONAL PTY LTD #do_CustomerCode_arr["V6050010"] = "1" # FREIGHTCORP|PACIFIC NATIONAL ( ATT: VINCE CALLAHAN) # ## Public Transport Victoria #do_CustomerCode_arr["V6050067"] = "1" # Public Transport Corporation # ## Qube Logistics #do_CustomerCode_arr["10001382"] = "1" # QUBE LOGISTICS #do_CustomerCode_arr["10001683"] = "1" # SOUTH SPUR RAIL SERVICES PTY LTD #do_CustomerCode_arr["10002511"] = "1" # QUBE LOGISTICS VIC PTY LTD # # ## Rail Technical Support Grp Aust Pty Ltd #do_CustomerCode_arr["10001498"] = "1" # Rail Technical Support Grp Aust Pty Ltd #do_CustomerCode_arr["10001642"] = "1" # Rail Technical Support Grp Aust Pty Ltd #do_CustomerCode_arr["10001667"] = "1" # SMT Seat Transport Maintenance # ## Southern Cross Station Pty Ltd #do_CustomerCode_arr["10001688"] = "1" # SOUTHERN CROSS STATION PTY LTD #do_CustomerCode_arr["10001687"] = "1" # SOUTHERN CROSS STATION AUTHORITY # ## V/Line Pty Ltd #do_CustomerCode_arr["10001870"] = "1" # V/LINE PTY LTD #do_CustomerCode_arr["10000567"] = "1" # V/LINE MAINTENANCE PTY LTD #do_CustomerCode_arr["10002655"] = "1" # V/LINE MAINTENANCE PTY LTD # # ## Victorian Rail Institute Inc #do_CustomerCode_arr["1000189"] = "1" # VICTORIAN RAILWAYS INSTITUTE INC # #do_CustomerCode_arr["VRT"] = "1" # VRT VicTrack # ----------------------------- ld_tcustomer(tbsCustomerfile) print ""> outfile } { print $0 f = 0 dt_recordno = trim($(++f)) dc_surname = trim($(++f)) dc_firstname = trim($(++f)) dt_extension = trim($(++f)) dc_division = trim($(++f)) dc_location = trim($(++f)) dc_section = trim($(++f)) dc_title = trim($(++f)) dc_mobile = trim($(++f)) dt_TEC = trim($(++f)) dc_telephone = trim($(++f)) dc_faxno = trim($(++f)) dc_voicemail = trim($(++f)) dc_jobno = trim($(++f)) dt_site = trim($(++f)) dt_extgroupunique = trim($(++f)) gn_grname1 = trim($(++f)) gn_grname2 = trim($(++f)) gne_grname3 = trim($(++f)) gg_parentgroupid = trim($(++f)) dc_empid = trim($(++f)) dc_email = trim($(++f)) dc_date_updated = trim($(++f)) Picture = trim($(++f)) Document = trim($(++f)) dm_msg1 = $(++f) dm_msg2 = $(++f) dm_msg3 = $(++f) dm_msg4 = $(++f) dm_msg5 = $(++f) dm_msg6 = $(++f) dm_msg7 = $(++f) dm_msg8 = $(++f) dm_msg9 = $(++f) CustomerDesc = ShipTo_to_ShipToDesc_arr[dc_division] CustomerCode = ShipTo_to_ShipToCode_arr[dc_division] ## skip if not in Customer list #if ( do_CustomerCode_arr[CustomerCode] == "" ) # next # skip if in exclude Customer list if ( ex_CustomerCode_arr[CustomerCode] == "1" ) { print "exclude CustomerCode=[" CustomerCode "]" next } # skip if in exclude Surname list if ( ex_Surname_arr[dc_surname] == "1" ) { print "exclude Surname=[" dc_surname "]" next } if ( dc_surname == ".ASSIGNED" || dc_surname == ".SILENT" ) { print "handle special Surname=[" dc_surname "]" Name = dc_title if ( Name != "" && dc_firstname != "" ) Name = Name " " Name = Name dc_firstname if ( dc_firstname == "" ) { if ( Name != "" && dc_location != "" ) Name = Name " " Name = Name dc_location } Organisation = CustomerDesc Position = dc_title Location = dc_section Address = dc_location # extension rec if ( dt_extension != "0" ) { PhoneType = "Extension" PhoneNumber = dt_extension outrec() } # mobile rec if ( dc_mobile != "" ) { PhoneType = "Mobile" PhoneNumber = dc_mobile outrec() } } else { Name = dc_firstname if ( Name != "" && dc_surname != "" ) Name = Name " " Name = Name dc_surname Organisation = CustomerDesc Position = dc_title Location = dc_section Address = dc_location # extension rec if ( dt_extension != "0" ) { PhoneType = "Extension" PhoneNumber = dt_extension outrec() } # mobile rec if ( dc_mobile != "" ) { PhoneType = "Mobile" PhoneNumber = dc_mobile outrec() } } } function outrec() { outp = "" #outp = outp Name "|" #outp = outp Organisation "|" #outp = outp Position "|" #outp = outp Location "|" #outp = outp Address "|" #outp = outp PhoneType "|" #outp = outp PhoneNumber "|" outp = outp " \n" outp = outp xmlfld("Name", Name) outp = outp xmlfld("Organisation", Organisation) outp = outp xmlfld("Position", Position) outp = outp xmlfld("Location", Location) outp = outp xmlfld("Address", Address) outp = outp xmlfld("PhoneType", PhoneType) outp = outp xmlfld("PhoneNumber", PhoneNumber) outp = outp " " print outp > outfile } function xmlfld(fldname, fldvalue) { return " <" fldname " value=\"" quotexmlval(fldvalue) "\" \/>\n" } END { print "" > outfile } ' <"$tmpfile1" >"$logfile" 2>&1 #( ################################################################ ## csv data #sed -e 's/|$//;s/,/\;/g;s/\|/,/g;s/ */ /g;s/\"/\\\"/g;s/ *\,/\,/g' "$tmpfile2" # #) > "$XMLOUTFILE" # create xml outpout file cat "$tmpfile2" >"$XMLOUTFILE" ############################################################### if [ "$XMLOUTFILE" != "-" ]; then chown catcom "$XMLOUTFILE" chown catcom "$XMLOUTFILE" chmod 644 "$XMLOUTFILE" fi #cp "$tmpfile1" /tmp/1 #cp "$tmpfile2" /tmp/2 rm -f "$tmpfile1" rm -f "$tmpfile2" rm -f "$tmpfile3" ############################### exit 0