Methods and apparatus for importing device data into a database system used in a process plant
원문보기
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06F-017/30
G06F-012/00
출원번호
US-0338392
(2003-01-08)
발명자
/ 주소
Dobrowski,Pat
Wilson,Sean
Hong,Nghy
Snyder,Eric
출원인 / 주소
Fisher Rosemount Systems Inc.
대리인 / 주소
Marshall, Gerstein &
인용정보
피인용 횟수 :
12인용 특허 :
150
초록▼
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 firs
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.
대표청구항▼
What is claimed is: 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 conta
What is claimed is: 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.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (150)
Oh Hyun-Kyung,KRX ; Seo Kyeung-Hak,KRX, Address generating and mapping device of video capture system.
Agrawal Mukul (Plymouth MN) Orrock James E. (Eden Prairie MN) Patiath Pradip K. (Brooklyn Park MN) Rachor Lloyd A. (Brooklyn Park MN), Advanced equipment control system.
Holley Steven R. (Phoenix AZ) Cunningham David C. (Carefree AZ) Kral Kevin D. (Streamwood IL), Apparatus and method for minimizing limit cycle using complementary filtering techniques.
Boehling Warren A. ; Foskett Alan Morton ; Wheeler Alan Reid, Automatically configurable multi-purpose distributed control processor card for an industrial control system.
Bhat Naveen V. (Houston TX) Braden William B. (Houston TX) Heckendoorn Kent E. (Houston TX) Graettinger Timothy J. (Bethel Park PA) Federowicz Alexander J. (Pittsburgh PA) Dubose Paul A. (Chapel Hill, Control system using an adaptive neural network for target and path optimization for a multivariable, nonlinear process.
Rylander Karen S. (Minneapolis MN) Fant Karl M. (Minneapolis MN) Egli Werner H. (Maple Grove MN), Data projection system with compensation for nonplanar screen.
Kern Robert Frederic ; Kern Ronald Maynard ; Micka William Frank ; Sovik Mark Anthony, Data storage system with outboard physical data transfer operation utilizing data path distinct from host.
Aggers John R. (Apple Valley MN) Brindle Ralph C. (Minnetonka MN) Kidder Kenneth B. (Coon Rapids MN) Ullestad David C. (Brooklyn Park MN), Distributed environmental/load control system.
Call William L. ; Clawson Laurence A. ; Connolly Paul S. ; Freimark Ronald J. ; Gustin Jay W. ; Hodge Michael L. ; McGaugh Paul ; Moore Donald W. ; Rachlin Elliott H. ; Ramsdell Steven C., Emulator for visual display object files and method of operation thereof.
Cohen-Levy Leon (New York NY), File directory structure generator and retrevial tool with document locator module mapping the directory structure of fi.
Miller Steven C. ; Riotto Jamie ; Tornes James E. ; Werner Ross G., Guaranteed bandwidth allocation method in a computer system for input/output data transfers.
Lake Harold ; Prentice David P. ; Greenup John ; Piper Charles ; Korowitz Simon, Industrial field controlling device with controller and expansion modules.
Bob Spriggs ; Bob Hayashida ; Ken Ceglia ; Diana Seymour ; Mike Peden ; Paul Richetta ; Matt Anderson ; Rich Bennington ; Daryl Frogget ; Scott Roby ; Mark Jensen, Industrial plant asset management system: apparatus and method.
Nasr Hatem N. (Edina MN) Sadjadi Firooz A. (St. Anthony MN) Bazakos Michael E. (Bloomington MN) Amehdi Hossien (Edina MN), Knowledge and model based adaptive signal processor.
Killpatrick Joseph E. (Minneapolis MN) Berndt Dale F. (Plymouth MN) Fritze Keith R. (Long Lake MN) Cary Gregory E. (Mounds View MN), Laser gyro dither strippr gain correction method and apparatus.
Wolrich, Gilbert; Bernstein, Debra; Cutter, Daniel; Dolan, Christopher; Adiletta, Matthew J., Mapping requests from a processing unit that uses memory-mapped input-output space.
Henninger Derek P. (Cupertino CA) Jensen Richard H. (Redwood City CA) Keene Christopher T. (San Francisco CA), Method and apparatus for automatic generation of object oriented code for mapping relational data to objects.
Keeler James D. ; Hartman Eric J. ; O'Hara Steven A. ; Kempf Jill L. ; Godbole Devendra B., Method and apparatus for preprocessing input data to a neural network.
Fong Avery ; Motoyama Tetsuro ; Bhatnagar Anurag, Method and apparatus for providing a graphical user interface for creating and editing a mapping of a first structural description to a second structural description.
Bonoyer John J. ; Flanagan Todd J., Method and apparatus for self-calibration of a coordinated control system for an electric power generating station.
Piche Stephen ; Keeler James David ; Hartman Eric ; Johnson William D. ; Gerules Mark ; Liano Kadir, Method for steady-state identification based upon identified dynamics.
Malloy ; deceased John R. (late of Drexel Hill PA by Virginia M. Malloy ; executrix) Olsen Arthur M. (Pennsburg PA), Method of digital process variable transmitter calibration and a process variable transmitter system utilizing the same.
Lu Zhuxin J. (Glendale AZ) MacArthur J. Ward (Scottsdale AZ) Horn Brian C. (Phoenix AZ), Method of multivariable predictive control utilizing range control.
Lu Zhuxin J. (19513 N. 73rd La. Glendale AZ 85308), Method of optimal scaling of variables in a multivariable predictive controller utilizing range control.
La Chance Ralph Edward ; Sardell Richard ; Landry Donald Francis ; Waibel Helmut, Methods and systems for providing electronic documentation to users of industrial process control systems.
Degeneff Robert C. (Niskayuna NY) Gutierrez Moises R. (Troy NY), Methods for generating models of non-linear systems and components and for evaluating parameters in relation to such non.
Michael Andrew Montgomery ; Lloyd Howard Strine ; Susanne Kristina Marie Howard ; Leor Amikam ; Neil MacLean ; Mark Alan Hastings, Modular object-based architecture for extensible master station software.
Britt Herbert I. (Cambridge MA) Joshi Amol P. (Marlboro MA) Mahalec Vladimir (Sudbury MA) Piela Peter C. (Brighton MA) Venkataraman Swaminathan (Waltham MA), Plant simulation and optimization software apparatus and method using dual execution models.
Hallee Donald O. (North Easton MA) Lake Harold (Sharon MA) Johansson Kenneth L. (North Grafton MA) Graves Thomas B. (Norton MA), Process control system with improved fault isolation.
Borchers Hans-Werner,DEX ; Otte Ralf,DEX ; Speh Rainer,DEX ; Weisang Claus,DEX, Process diagnosis system and method for the diagnosis of processes and states in an technical process.
Cheney M. Charles ; Korowitz Simon ; Slechta William M. ; Tobol Nathan H., Protection against communications crosstalk in a factory process control system.
MacArthur J. Ward (Minneapolis MN) Wahlstedt David A. (Minneapolis MN) Woessner Michael A. (Minneapolis MN) Foslien Wendy K. (Minneapolis MN), Receding horizon based adaptive control having means for minimizing operating costs.
Steinman Jethro F. ; Kanji M. Gulam ; Chehadeh Yahia C. ; Himmer Richard P. ; Rosa-Bian John J., System and methods for achieving heterogeneous data flow between algorithm blocks in a distributed control system.
Kessel William C. (Watertown MA) Laclaire John L. (Cambridge MA) Lui Andrew L. (West Newton MA) Locke Michael H. (Lakeville MA) Britt Herbert I. (Cambridge MA), System for displaying different subsets of screen views, entering different amount of information, and determining corre.
Bland Dennis L. (Phoenix AZ) Kast John R. (Phoenix AZ), System for making data available to an outside software package by utilizing a data file which contains source and desti.
Boehling Warren A. ; Peck ; III Stephen Albert ; Wheeler Alan Reid, System for replacing control processor by operating processor in partially disabled mode for tracking control outputs.
Bland Dennis L. ; Koontz Sean C. ; Fox Gary L. ; Strilich James A., Systems and methods for providing dynamic data referencing in a generic data exchange environment.
Dettinger, Richard Dean; Johnson, Peter John; Stevens, Richard Joseph; Tong, Ikhua; Will, Eric, Application portability and extensibility through database schema and query abstraction.
Jones, Bryan M.; Bellville, Keith R.; Balentine, James R.; Scott, Cindy A.; Fellows, Hubbard F., Dynamic user interface for configuring and managing a process control system.
Jones, Bryan M.; Bellville, Keith R.; Balentine, James R.; Schleiss, Trevor D.; Fellows, Hubbard F., Efficient design and configuration of elements in a process control system.
Cragun, Brian J.; Rice, Julia E.; Schwarz, Peter M.; Swope, William C.; Tran, Hoa T., Heterogeneous multi-level extendable indexing for general purpose annotation systems.
Cragun, Brian J.; Rice, Julia E.; Schwarz, Peter M.; Swope, William C.; Tran, Hoa T., Heterogeneous multi-level extendable indexing for general purpose annotation systems.
Sugumaran, Harikrishnan, Method, system, and program for translating and interfacing between data pools and product information management (PIM) systems.
Sugumaran, Harikrishnan, Method, system, and program for translating and interfacing between data pools and product information management (PIM) systems.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.