Method, system and computer program product for facilitating the analysis of automatic line insulation testing data

Abstract

A method for analyzing automatic line insulation testing data comprising receiving an electronic version of ALIT test results and parsing the ALIT test results to extract error data. The error data is inserted into an ALIT database. The ALIT database includes one record for each exception located in the error data and each record includes: a wire center attribute, an exception date attribute, a facility number attribute, a cable attribute, a pair attribute, a repair package attribute, a maintenance analyst name attribute, a trouble message attribute, a telephone number attribute, a tea attribute and a test result attribute. The number of exceptions per wire center occurring on a selected summary date is calculated in response to receiving a summary request from a user. The summary request includes the selected summary date and input to the calculating is the selected summary date and the ALIT database. The number of exceptions per wire center occurring on the summary date is transmitted to the user in response to the calculating. User records located in the ALIT database that include a selected wire center and a selected detail date are transmitted to the user in response to receiving from the user a wire center detail request. The wire center detail request includes the selected wire center and the selected detail date. The ALIT database is updated with repair package information in response to receiving an add repair package request. The add repair package request includes a wire center, a facility, a cable, an exception date, a repair package number, a low pair and a high pair.