BEC.SHAPIN@USC-ECL.ARPA (Ted Shapin) (12/14/85)
"Green Sheets" previously provided by MA BELL are history. We are keeping our own inventory info now on approx 5000 lines manually on books called CODS. We keep line/port location, cable pair, call pick-up group, location, bldg, dept, activity history, equipment & cost, key system or ECTS assignment, etc. We would like to find an inventory program, preferably for an IBM-PC that would let us keep the inventory and reconcile our equipment with our telephone bills. Is anyone doing this type of thing? Are commercial packages available? The few we have seen are wrapped around elaborate purchase order, tele call detail or directory schemes requiring more input than we care to manage. Bob Villarreal -------
telecom@ucbvax.UUCP (12/23/85)
Seems like everyone is doing this now. We have a program that we wrote in Informix to manage telephone equipment. Internally, we call it Telephone Inventory Tracking System (TITS). This one can be used to whatever degree of complexity needed. We even have one application that uses hand-held data entry terminals. The State of Georgia is one of our clients. I suggest you use a good DBMS and program it yourself, -especially if its a relatively simple application. Ron Thompson AT&T Information Systems Customer Programming (404) 982-4217 Atlanta, Georgia Services Center ..{ihnp4,akgua}!cpsc53!rt (Opinions expressed are mine alone.)
telecom@ucbvax.UUCP (12/26/85)
> "Green Sheets" previously provided by MA BELL are history. We are keeping > . > . > . > We would like to find an inventory program, preferably for an IBM-PC that would > let us keep the inventory and reconcile our equipment with our telephone bills. > . > . > . Have you given any thought to using one of the available data base management systems for the IBM-PC (such as dBaseIII or R:Base 5000). It may take an investment of your time to learn to use the programs, but it would allow you to do exactly what you want. Don Henson Infosys Consulting