Automated script generation to update databases

• US 20030027561A1
• Filed: 07/27/2001
• Published: 02/06/2003
• Est. Priority Date: 07/27/2001
• Status: Active Grant

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Original Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Inventors: Iyer, Gopal N.
• Granted Patent: US 6,909,890 B2
• Time in Patent Office: Days
• US Class Current: 455/418
• CPC Class Codes: H04W 24/02 Arrangements for optimising operational condition

Abstract

An automated script generation method to update databases in a cellular system is disclosed. Using an update application program, a user inputs a field of a cellular site information database that is to be modified. An update skeleton script is generated including all of the line commands necessary to update the field. The skeleton script is a file containing line commands to be executed. The skeleton script does not include device values or field values. An input file is generated by the user including the device that is to be changed and what the value of the identified field is to be changed to. The skeleton script is populated with the data from the input file to create a finalized script. The finalized script is run by a command handler application program to update the database.

Claims

1. A computer-implemented method for updating a cellular site information database comprising cell site data, the method comprising the steps of:

receiving a field input wherein the field input identifies a field type in the cellular site information database that is to be modified;

generating a skeleton script, wherein the skeleton script comprises a plurality of line commands to modify the field type identified by the field input;

receiving at least one device value and at least one field value identifying the cell site data to be modified;

populating the skeleton script with the at least one device value and the at least one field value to generate a script; and

executing the script to update the cellular site information database.

2. The method of claim 1 wherein the field input is input by a user.

3. The method of claim 1 wherein the cellular site information database is an Ericsson database.

4. The method of claim 1 wherein the step of generating the skeleton script comprises searching a lookup table to find a skeleton script associated with the field type.

5. The method of claim 1 wherein the step of receiving at least one device value and at least one field value comprises receiving an input file comprising the at least one device value and the at least one field value.

6. The method of claim 1 wherein the device value identifies the device that is to be changed and the field value identifies what the value of the field type for the device is to be changed to.

7. The method of claim 1 wherein the step of executing the script to update the cellular site information database comprises running the command handler application program to update the cellular site information database.

8. The method of claim 7 wherein the command handler application is operated in conjunction with a cellular site operating system.

9. The method of claim 8 wherein the cell site operating system is an Ericsson Operation &

Support System (OSS).

10. A computer-readable medium comprising computer-readable instructions which, when executed, are operable to perform the steps of claim 1.

11. A computer-implemented method for updating a form of a cellular site information database of a cellular system, the method comprising the steps of:

receiving a field input wherein the field input identifies a field type in the form that is to be modified;

locating a skeleton script, wherein the skeleton script comprises a plurality of line commands to modify the field type identified by the field input;

receiving at least one device value and at least one field value, wherein the device value identifies a device and the field value identifies a value for the field type for a form associated with the device;

populating the skeleton script with the at least one device value and the at least one field value to generate a script; and

executing the script to update the cellular site information database.

12. The method of claim 11 wherein the step of executing the script to update the cellular site database comprises modifying an existing value of the field type in the form to be modified to be equal to the field value.

13. The method of claim 12 wherein the form to be modified comprises a form associated with the device identified by the device value.

14. A computer-readable medium comprising computer-readable instructions which, when executed, are operable to perform the steps of claim 11.