Patent ID: 7636351

Claim:
A method for providing database management services for a telecommunications system, comprising: extracting a first set of raw data from a legacy system via a first routine of a network planning application, said first set of raw data relating to telecommunications transmission lines data; executing a keystroke emulator on said first set of raw data operable for further extracting details relating to said telecommunications transmission lines data; extracting a second set of raw data from said legacy system via a second routine of a network planning application, said second set of raw data relating to telecommunications equipment data; extracting a third set of raw data from said legacy system via a third routine of said network planning application, said third set of raw data relating to telecommunications wavelength division multiplexing data; utilizing a managed language application, transferring raw data resulting from said executing a keystroke emulator, said second set of raw data, and said third set of raw data to a first spreadsheet application macro, said first spreadsheet application macro operable for merging selected data; and generating a first spreadsheet file comprising data selected and combined by said first spreadsheet application macro; wherein said first spreadsheet file is a DETCAB worksheet comprising data relating to each physical and virtual fiber, said data including: fiber locations; a cable number; a fiber channel number; a WDM channel number; a restriction code, if applicable; a status code; a date a fiber is placed in service; and a sonet carrier identifier.