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

A system for facilitating the analysis of ALIT data, the system comprising:

• a network;
• a storage device in communication with said network, wherein said storage device includes an ALIT database;
• a user system in communication with said network;
• and
• a host system in communication with said network, said host system including application software to implement a method comprising:
• receiving an electronic version of ALIT test results via the network;
• parsing said ALIT test results to extract error data;
• inserting said error data into said ALIT database, wherein said ALIT database includes one record for each exception located in said error data and each said record includes a wire center attribute, an exception date attribute, a facility number attribute, a cable attribute, a pair attribute, and 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;
• calculating a number of exceptions per wire center occurring on a selected summary date in response to receiving a summary request via the network from the user system, said summary request including said selected summary date, wherein input to said calculating is said selected summary date and said ALIT database;
• transmitting to said user system via the network the number of exceptions per wire center occurring on said summary date in response to said calculating;
• transmitting to said user system via the network records located in said ALIT database that include a selected wire center and a selected detail date in response to receiving from said user system a wire center detail request including said selected wire center and said selected detail date;
• and
• updating said ALIT database with repair package information in response to receiving via said network an add repair package request, wherein said 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.

A computer program product for vehicle diagnostic record mapping, the computer program product comprising:

• a storage medium readable by a processing circuit and storing instructions for execution by the processing circuit for performing a method comprising:
• receiving an electronic version of ALIT test results;
• parsing said ALIT test results to extract error data;
• inserting said error data into an ALIT database, wherein said ALIT database includes one record for each exception located in said error data and each said record includes a wire center attribute, an exception date attribute, a facility number attribute, a cable attribute, a pair attribute, and 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;
• calculating a number of exceptions per wire center occurring on a selected summary date in response to receiving a summary request from a user including said selected summary date, wherein input to said calculating is said selected summary date and said ALIT database;
• transmitting to said user the number of exceptions per wire center occurring on said summary date in response to said calculating;
• transmitting to said user records located in said ALIT database that include a selected wire center and a selected detail date in response to receiving from said user a wire center detail request including said selected wire center and said selected detail date;
• and
• updating said ALIT database with repair package information in response to receiving an add repair package request, wherein said 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.