Methods and apparatus for importing device data into a database system used in a process plant

• US 7,152,072 B2
• Filed: 01/08/2003
• Issued: 12/19/2006
• Est. Priority Date: 01/08/2003
• Status: Active Grant

• Current Assignee: Fisher-Rosemount Systems Incorporated (Emerson Electric Company)
• Original Assignee: Fisher-Rosemount Systems Incorporated (Emerson Electric Company)
• Inventors: Snyder, Eric, Wilson, Sean, Dobrowski, Pat, Hong, Nghy
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US10/338,392
• Publication Number:
  US 20040133598A1
• Time in Patent Office: 1,441 Days
• Field of Search: 707/7, 707/100, 707/101, 707/102, 707/103.R, 707/104.1, 707/200, 707/205
• US Class Current: 1/1
• CPC Class Codes: G05B 2219/31135 Fieldbus
• CPC Class Codes: G05B 2219/31323 Database for CIM
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y02P 90/02 Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system and a methodology creates a mapping of a set of import parameters specifying a device in a first set of import data to a set of output parameters specifying the device in a first database. Such a mapping includes receiving the set of import parameters from an import file containing the first set of import data in a plurality of import records, each import record containing a plurality of import values, each import value corresponding to an import parameter from the set of import parameters; receiving the set of output parameters from the first database; and creating the mapping of the set of import parameters to the set of output parameters. The system and methodology described in here allows users to import data about various types of devices into a device database on a systematic and efficient method. Such a system and methodology also allows a user to maintain a complete database including all devices used within a process plant.

Claims

1. A method of mapping a set of import parameters specifying a device in a first set of import data to a set of output parameters specifying the device in an asset management system database, the method comprising:

receiving the set of import parameters from an import file containing the first set of import data in a plurality of import records, each import record containing a plurality of import values, each import value corresponding to an import parameter from the set of import parameters;

receiving the set of output parameters from the asset management system database;

creating a first mapping of the set of import parameters to the set of output parameters;

generating a mapping file containing the first mapping;

generating an output file using the mapping file, where the output file contains a first set of output data containing a first set of output records, each output record containing a plurality of output values, each output value corresponding to an output parameter from the set of output parameters; and

merging the first set of output data from the output file into the asset management system database;

wherein receiving the set of import parameters comprises;

receiving from a user a first set of device information including a name of a manufacturer of the device, a name of a model of the device, and a value representing a revision of the device;

based on the first set of device information, opening the import file containing the set of import parameters; and

receiving the set of import parameters from the import file.

2. The method of claim 1, further comprising receiving definitions of access variables, commands and operating procedures related to the device.

3. The method of claim 1, wherein receiving the set of output parameters comprises:

opening a template file containing the set of output parameters based on the first set of device information; and

receiving the set of output parameters from the template file.

4. The method of claim 3, wherein creating the first mapping of the set of import parameters to the set of output parameters comprises:

displaying a first listing of the set of import parameters;

displaying a second listing of the set of output parameters;

selecting a first import parameter from the first listing;

selecting a first output parameter from the second listing; and

mapping the first import parameter to the first output parameter.

5. The method of claim 4, wherein the first listing and the second listing are provided in a first window on a computer output device.

6. The method of claim 5, wherein the first listing is provided on a first grid containing a first column containing a first plurality of cells, at least one of the first plurality of cells containing an import parameter from the set of import parameters, and wherein the second listing is provided on a second grid containing a second column with a second plurality of cells, at least one of the second plurality of cells containing an output parameter from the set of output parameters, a third column containing a third plurality of cells, at least one of the third plurality of cells containing a data type of an output parameter from the set of output parameters, and a fourth column containing a fourth plurality of cells, at least one of the fourth plurality of cells containing an import parameter from the set of import parameters.

7. The method of claim 6 further comprising:

receiving a name of a second import parameter from a user, where the second import parameter is not in the first listing of the set of import parameters;

adding the second import parameter to the set of import parameters; and

displaying the second import parameter in a cell in the first column in the first window.

8. The method of claim 6, further comprising:

selecting a first cell from the first column containing a third import parameter from the set of import parameters;

receiving an instruction from a user to delete the third import parameter;

removing the third import parameter from the set of import parameters; and

deleting the first cell from the first column.

9. The method of claim 6, further comprising:

listing the first set of import data in a second window on the computer output device, where the second window contains a third grid containing a fifth plurality of cells where at least one of the fifth plurality of cells contain an import value from the plurality of import values;

selecting a first cell from the fifth plurality of cells, where the first cell contains a first import value of a first import record corresponding to a fourth import parameter from the set of import parameters;

changing the value of the first cell from the first import value to a second import value; and

assigning the second import value to the fourth import parameter in the first import record.

10. The method of claim 9, wherein changing the value of the first cell comprises:

copying the second import value from a second cell from the fifth plurality of cells; and

pasting the second import value into the first cell.

11. The method of claim 9, wherein changing the value of the first cell comprises:

copying the second import value from a third cell of the fifth plurality of cells, where the third cell lies at the top of a fifth column containing the first cell in the third grid; and

pasting the second import value into each cell lying between the third cell and the first cell in the fifth column.

12. The method of claim 9, wherein changing the value of the first cell comprises:

copying a third import value from a fourth cell of the fifth plurality of cells, where the fourth cell lies at the top of a sixth column in the third grid containing the first cell;

increasing the third import value by a predetermined number to get the second import value; and

pasting the second import value into the first cell.

13. The method of claim 6, wherein selecting the first import parameter and selecting the first output parameter comprises:

double-clicking on a cell in the second column containing the first output parameter;

opening a first input template to receive the first import parameter;

providing a third listing of import parameters from the set of import parameters on the first input template; and

receiving an input from a user selecting the first import parameter from the third listing of import parameters.

14. The method of claim 6, wherein selecting the first import parameter and selecting the first output parameter comprises:

double-clicking on a cell in the first column containing the first import parameter;

changing a cursor on the first window to a drag-drop pointer; and

clicking on a cell in the second column containing the first output parameter.

15. The method of claim 6, further comprising:

based on the first set of device information, opening an enumeration file containing a first set of enumerated values corresponding to the first output parameter.

16. The method of claim 15, further comprising:

providing a first list of import values corresponding to the first import parameter in the first set of data;

selecting a first import value from the first list of import values;

providing a second list of enumerated values from the first set of enumerated values corresponding to the first output parameter;

selecting a first enumerated value from the first list of enumerated values; and

creating an enumeration mapping of the first import value to the first enumerated value.

17. The method of claim 16, further comprising:

selecting the first output parameter from the second column;

presenting a second template to receive a first set of output parameter characteristics for the first output parameter, where the first set of output parameter characteristics includes at least one of;

(1) a type of the first output parameter, (2) a maximum length of the first output parameter, (3) a first explicit set of characters that may be included in a value of the first output parameter, (4) a second explicit set of characters that are excluded from a value of the first output parameter, (5) a default value of the first output parameter, and (6) an enumerated list of acceptable values of the first output parameter; and

receiving from a user a value representing at least one of the characteristics of the first set of output parameter characteristics.

18. The method of claim 12 further comprising creating a second mapping of a second output parameter to a first explicit value.

19. The method of claim 18 wherein creating the second mapping comprises:

providing a first input field on the first input template to receive the first explicit value;

receiving the first explicit value from a user in the first input field; and

creating the second mapping of the second output parameter to the first explicit value.

20. The method of claim 19, further comprising:

receiving a first replacement key from a user in the first input field;

converting the first replacement key to a second explicit value; and

mapping the second explicit value to the second output parameter.

21. The method of claim 20, wherein the first replacement key is selected as one of:

(1) a date key, (2) a time key, (3) a name of application key, (4) a manufacturer'"'"'s name key, (5) a path key, and (6) a device name key.

22. The method of claim 6, further comprising:

listing the first set of output data in a third window on the computer output device, where the third window contains a fourth grid containing a sixth plurality of cells where at least some of the sixth plurality of cells contain output values from the plurality of output values;

selecting a fifth cell from the sixth plurality of cells, where the fifth cell contains a first output value of a first output record corresponding to a second output parameter from the set of output parameters;

changing the value of the fifth cell from the first output value to a second output value; and

assigning the second output value to the second output parameter in the first output record.

23. A computer system that maps a set of import parameters specifying a device in a first set of import data in an import file to a set of output parameters specifying the device in an asset management system database, wherein the first set of import data contains a plurality of import records, each import record containing a plurality of import values, each import value corresponding to an import parameter from the set of import parameters, the computer system comprising:

a computer readable medium;

a processing unit;

a first routine stored on the computer readable medium and adapted to run on the processing unit to receive the set of import parameters;

a second routine stored on the computer readable medium and adapted to run on the processing unit to receive the set of output parameters;

a third routine stored on the computer readable medium and adapted to run on the processing unit to create a first mapping of the set of import parameters to the set of output parameters;

a fourth routine stored on the computer readable medium and adapted to generate a mapping file containing the first mapping;

a fifth routine stored on the computer readable medium and adapted to generate an output file using the mapping file, where the output file contains a first set of output data containing a first set of output records, each output record containing a plurality of output values, each output value corresponding to an output parameter from the set of output parameters;

a further fifth routine stored on the computer readable medium and adapted to merge the first set of output data from the output file into the asset management system database;

wherein the first routine further comprises;

a sixth routine stored on the computer readable medium and adapted to receive from a user a first set of device identifying information including a name of a manufacturer of the device, a name of a model of the device and a value representing a revision of the device;

a seventh routine stored on the computer readable medium and adapted to open the import file containing the set of import parameters based on the first set of device identifying information; and

an eighth routine stored on the computer readable medium and adapted to receive the set of import parameters from the import file.

24. The computer system of claim 23 wherein the first routine further comprises:

a ninth routine stored on the computer readable medium and adapted to open a template file containing the set of output parameters based on the first set of device identifying information; and

a tenth routine stored on the computer readable medium and adapted to receive the set of output parameters from the template file.

25. The computer system of claim 24 wherein the third routine further comprises:

an eleventh routine stored on the computer readable medium and adapted to display a first listing of the set of import parameters;

a twelfth routine stored on the computer readable medium and adapted to display a second listing of the set of output parameters;

a thirteenth routine stored on the computer readable medium and adapted to select a first import parameter from the first listing;

a fourteenth routine stored on the computer readable medium and adapted to select a first output parameter from the second listing; and

a fifteenth routine stored on the computer readable medium and adapted to map the first import parameter to the first output parameter.

26. The computer system of claim 25 wherein the first listing and the second listing are provided in a first window on a computer output device.

27. The computer system of claim 26 wherein the first listing is provided on a first grid containing a first column containing a first plurality of cells, at least one of the first plurality of cells containing an import parameter from the set of import parameters, and wherein the second listing is provided on a second grid containing a second column with a second plurality of cells, at least one of the second plurality of cells containing an output parameter from the set of output parameters, a third column containing a third plurality of cells, at least one of the third plurality of cells containing a data type of an output parameter from the set of output parameters, and a fourth column containing a fourth plurality of cells, at least one of the fourth plurality of cells containing an import parameter from the set of import parameters.

28. The computer system of claim 27, further comprising:

a sixteenth routine stored on the computer readable medium and adapted to open an enumeration file based on the first set of device identifying information, containing a first set of enumerated values corresponding to the first output parameter.

29. The computer system of claim 28, further comprising:

a seventeenth routine stored on the computer readable medium and adapted to provide a first list of import values corresponding to the first import parameter in the first set of data;

an eighteenth routine stored on the computer readable medium and adapted to select a first import value from the first list of import values;

a nineteenth routine stored on the computer readable medium and adapted to provide a second list of enumerated values from the first set of enumerated values corresponding to the first output parameter;

a twentieth routine stored on the computer readable medium and adapted to select a first enumerated value from the first list of enumerated values; and

a twenty-first routine stored on the computer readable medium and adapted to create an enumeration mapping of the first import value to the first enumerated value.

30. The computer system of claim 29, further comprising:

a twenty-second routine stored on the computer readable medium and adapted to select the first output parameter from the second column;

a twenty-third routine stored on the computer readable medium and adapted to present a second template to receive a first set of output parameter characteristics for the first output parameter, where the first set of output parameter characteristics includes at least one of;

(1) a type of the first output parameter, (2) a maximum length of the first output parameter, (3) a first explicit set of characters that may be included in a value of the first output parameter, (4) a second explicit set of characters that are excluded from a value of the first output parameter, (5) a default value of the first output parameter, and (6) an enumerated list of acceptable values of the first output parameter; and

a twenty-third routine stored on the computer readable medium and adapted to receive from a user a value representing at least one of the characteristics of the first set of output parameter characteristics.