KR20060061017A - Method of generating and managing piping drawings in the plant - Google Patents

Abstract

The present invention relates to a method for creating and managing piping drawings in a plant in which a plant is connected to a database of a plant design system (PDS) to create and manage piping drawings by using an application in a plant. Reconfiguring and displaying a list of piping drawings for each design area by a user's designation by connecting the input / output device and the database; After completing the piping modeling, searching for and displaying a list of pipes input at the time of the pipe modeling when the bulk load command is displayed so as to select a desired pipe to be listed in the pipe drawing list; The process of creating a temporary file and generating a temporary file while automatically generating a pipe drawing by generating an input file with the information of the design area, drawing list setting, and selected piping when selecting a list to be worked on by a user. and; Displaying in real time a temporary file including a progress and errors or warnings generated during the pipe drawing generation; By including the process of indicating the completion of the creation of the pipe drawing when the pipe drawing is completed, it is convenient to input the drawing information and the generation of the drawing, convenient file management of the drawings existing on the server, PDS This saves PDS licenses, improves the quality of drawings by providing error and warning information in real time, and provides a clear view of the list and information stored in the database.

Description

{Method of Generating and Managing Piping Drawings in the Plant}             

1 is a flow chart showing a method for generating and managing piping drawings in a typical plant (Plant).

2 is a block diagram showing a configuration for generating and managing piping drawings in a plant according to an embodiment of the present invention.

3 is a flow chart showing a method for generating and managing piping drawings in a plant according to an embodiment of the present invention.

FIG. 4 is a flowchart illustrating a drawing list display process of FIG. 3. FIG.

FIG. 5 is a flowchart illustrating a pipe selection process in FIG. 3. FIG.

Explanation of symbols on the main parts of the drawings

21: input and output device 22: drawing generating device

23: Database Server

24: database

25: File Server

The present invention relates to a method for generating and managing piping drawings in a plant, and in particular, to create and manage piping drawings in a plant in which a plant is connected to a database of a plant design system (PDS) using an application to create and manage piping drawings. It is about a method.

Generally, PDS, a plant design tool, is used as a plant 3D modeling tool, and 'ISOGEN', an ISO drawing automatic module of PDS, is used to automatically generate an ISO drawing after piping modeling. .

Then, referring to the flowchart of FIG. 1, a pipe drawing generation and management method in a conventional plant is as follows.

First, the operation of registering new ISO drawing information is performed (step S11), that is, clicking Utilities in the main screen of ISOGEM, clicking Bulk Load Line ID, and then After clicking Piping Design Area to check the list of modeled pipes, select the desired pipe line from the pipe list and register the selected pipe line.

Then, additional information of the ISO drawing is input (step S12), that is, clicking Revise Drawing on the main screen of ISOGEM, clicking ISO Area List, and then clicking on the design area. After selecting the ISO drawing, the user data is clicked to input about 10 additional information.

Accordingly, a drawing is generated according to the registered piping line and the input additional information (step S13), that is, a batch job input file (Batch Job Input) is generated by clicking Create Batch Job on the main screen of ISOGEM. File) After entering the path and file name, click Create by Line ID to select the design area, then select the desired ISO drawing, and then go back to the main screen of ISOGEM. If you click Schedule Batch Job, an ISO drawing is automatically generated with the file path and file name. All the above operations are made through the PDS program.

Then, it is checked whether there is a generation error or warning regarding the generated ISO drawing (step S14), that is, an error information file generated during the operation of generating the ISO drawing is stored in a designated location, and thus the searcher Move to the path of the error information file by using the file and view the error information file using Notepad.

Then, the generated ISO drawing is checked (step S15), by moving the path to the ISO drawing file generated at the designated position according to the input file path by using the explorer to open the corresponding ISO drawing file. Read it.

As such, the pipe drawing generation and management method in the prior art plant is too complicated to produce an ISO drawing for a pipe that has already been modeled, and works by moving several forms. There was a problem that must be performed. In addition, error checking or reading of the result should be opened and checked while moving through the navigator during drawing creation, and information on each drawing is not provided as a summary form at a glance. There was an inconvenience to confirm.

In order to solve the problems or inconveniences described above, the present invention provides a method for creating and managing piping drawings in a plant to connect to the database of the PDS by using an application program to create and manage the piping drawings. There is a purpose.

In addition, the present invention is connected to the PDS Oracle Database using an application such as Excel VBA (Visual Basic Application) in the plant to drive a separate PDS drawing automatic creation module without going through the PDS program piping To create and manage drawings, the purpose is to.

In addition, the present invention is to generate and manage the ISO drawings by driving the PDS drawing automatic creation module created in the environment of the application, such as Excel (VBA) Visual Basic Application (PBA) in the plant, the input of ISO drawing information and ISO drawing It is easy to create, file management of ISO drawings existing on the server is convenient, and it is possible to save the PDS license without going through PDS.

In addition, the present invention connects to the PDS Oracle database created by the application such as Excel VBA in the plant to run the PDS drawing auto-creation module to generate and manage the ISO drawing, to inform the error and warning information in real time to improve the quality of the drawing Its purpose is to provide a clear view of the list and information of ISO drawings stored in the database.

According to an embodiment of the present invention, a method for generating and managing piping drawings in a plant according to an embodiment of the present invention provides a list of piping drawings for each design area by designation of a user by connecting an input / output device and a database using an application program in a plant. Reconstructing and displaying; After completing the piping modeling, searching for and displaying a list of pipes input at the time of the pipe modeling when the bulk load command is displayed so as to select a desired pipe to be listed in the pipe drawing list; The process of creating a temporary file and generating a temporary file while automatically generating a pipe drawing by generating an input file with the information of the design area, drawing list setting, and selected piping when selecting a list to be worked on by a user. and; Displaying in real time a temporary file including a progress and errors or warnings generated during the pipe drawing generation; Comprising a process of indicating the completion of the pipe drawing generation upon completion of the pipe drawing generation.

Preferably, the plumbing diagram list display process includes the steps of: connecting to the database using PDS project information defined in a setup sheet when the input / output device is executed by a user; Reading a design area and drawing list setting stored in the database to construct a drop-down list; Reading a list of drawings and detailed information existing in a design area designated by a user from the list of piping drawings from the database; Displaying the processing information through the input / output device after processing the list of drawings and detailed information; And recording the corrected information in the association table in the database when the user requests the information to be modified.

Further preferably, the pipe selection process includes reconstructing a pipe model list by reading pipe model information existing in a design area designated by a user from the database when executing a bulk load command by a user; Displaying the processing information through the input / output device after processing the pipe model list; Reconfiguring a pipe line list by reading line ID information corresponding to the specific pipe list when selecting a specific pipe list from the pipe model list; Displaying the processing information through the input / output device after processing the pipe line list; When selecting the desired pipe listed from the list of the pipe line, the information on the corresponding pipe is additionally recorded in the database, and the result and contents are characterized in that it comprises the step of displaying through the input and output devices.

Alternatively, in a plant according to an embodiment of the present invention, the method for generating and managing piping drawings may include updating or deleting the changed piping drawings list and information in the database when the displayed piping drawings list and information are changed or deleted. Characterized in that further comprises.

In addition, in the plant according to the embodiment of the present invention, the pipe drawing generation and management method reads the temporary file when the user checks the pipe drawing and displays the progress and error or warning for the selected pipe at the same time It is characterized in that it further comprises the process of opening the actual drawing while driving the microstation.

Alternatively, the method for generating and managing piping drawings in a plant according to an embodiment of the present invention may include information codes through the input / output device when expressing detailed drawings, other accessory information, or revision status not supported by a PDS in the piping drawings. It is characterized in that it further comprises the step of writing and additionally recording the detailed information.

Furthermore, in the plant according to the embodiment of the present invention, the pipe drawing generation and management method may be moved by using the file management menu through the input / output device to delete or move the pipe drawing to another folder, or to change the file name. Characterized in that the process further comprises a.

The present invention connects to the PDS Oracle database using an application program such as Excel to run the PDS drawing auto-creation module and manages ISO drawings. It combines a plurality of PDS tables on a database for generating an ISO drawing list, and The PDS drawing automatic generation module is driven without extracting the information, and the desired information is extracted from the temporary file generated as a by-product when the PDS drawing automatic generation module is driven and displayed in real time. Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

In the plant according to the embodiment of the present invention, a configuration for generating and managing piping drawings is illustrated in FIG. 2, the input / output device 21, the drawing generating device 22, the database server 23, and the database ( And a file server 25.

The input / output device 21 connects to the database server 23 using Excel VBA to drive the drawing generator 22 to generate and manage piping drawings, in particular, defined in a Setup Sheet. Requesting the database server 23 to connect to the database 24 using the PDS project information, modify the information, bulk load command, select a specific pipe list, or select a pipe to be listed. The processing information applied from the database server 23 is displayed on the screen. In addition, the input / output device 21 notifies the drawing generation device 22 of the selection of the ISO list that the user wants to work on, and the design area, the ISO drawing list setting information (that is, ISOSET information), and the selected piping information. An input file for driving the drawing generating device 22 is generated and applied to the drawing generating device 22, the temporary file of the file server 25 is continuously searched for, and the information is displayed. Displays the completion of drawing generation notified from (22), and automatically displays a drawing confirmation window when the progress window is closed by the user, and the status of the drawing generation already selected from the temporary file of the file server 25 by default. And error and warning messages are read and shown, and when the user selects the drawings while driving the micro-station (Micro-station) The display reads the actual drawing from the group file server 25.

The drawing generating device 22 is an ISO drawing automatic generation module of the PDS, 'ISOGEN', which checks the list of ISOs to be selected through the input / output device 21 and an input file applied through the input / output device 21. It automatically generates an ISO drawing to operate according to the operation, and transfers the drawing generation progress and error or warning messages generated during the automatic drawing operation to the file server 25 as a temporary file, the corresponding ISO drawing generation operation Upon completion, the input / output device 21 informs the input / output device 21 of the completion of drawing generation.

The database server 23 reads the pipe design area and ISOSET information in the database 24 according to the connection request applied from the input / output device 21 to form a drop down list, and the corresponding pipe design list. Read and process the list of ISO drawings and detailed information existing in the design area designated by the user, and apply them to the input / output device 21, and apply the corrected information to the database according to a modification request applied from the input / output device 21. The piping model list is reconstructed by reading from the database 24 the piping model information recorded in the association tables in the table 24 and existing in the design area designated by the user according to the bulk load command applied from the input / output device 21. After the processing is applied to the input and output device 21, the input and output device 21 After reading the line ID information corresponding to the specific pipe list selected through the reconstruction and processing of the pipe line list, and applied to the input and output device 21, the selected pipe through the input and output device 21 to check the corresponding pipe information Is further recorded in the database 24.

The database 24 is a PDS Oracle database, and stores piping design area and ISOSET information, and configures a table for each design area to store an ISO drawing list and detailed information in the table.

The file server 25 records and manages a temporary file applied from the drawing generating device 22, and progresses and errors during drawing generation recorded in the temporary file according to a request from the input / output device 21, A message such as a warning or an actual drawing is applied to the input / output device 21.

Referring to the flowchart of Figure 3 the method for generating and managing piping drawings in a plant according to an embodiment of the present invention as follows.

First, when the ISO drawing list display by each design area is displayed and the database update is performed when the list information is modified, that is, when the user executes the input / output device 21 using an application program such as Excel, it exists in the piping design area specified by the user. A list of ISO drawings is displayed, and another piping design area is selected, and a list of corresponding ISO drawings is reconfigured and displayed (step S31). In this case, the displayed list and various types of information use information stored in the PDS Oracle database 24. When the displayed list and information are changed through the input / output device 21, the list and information are simultaneously displayed. Update to (24).

It displays a list of piping models and adds a bulk load and a drawing list, that is, a bulk load to be listed in the ISO drawing list for the piping modeling after completing the piping modeling. In this case, when the user executes the bulk load command through the input / output device 21, the pipe list input at the time of modeling the piping system is automatically retrieved and displayed, and the desired list is listed in the ISO drawing list. This allows the pipe to be selected (step S32).

Thus, when the user selects a list of ISOs to be worked on, the drawing generation device 22 such as 'ISOGEN', which is an ISO drawing automatic generation module of the PDS, checks the selected list of ISOs to be worked on (step S33). One or multiple lists may be selected through the input / output device 21. For example, the list can be selected one by one with the mouse, or multiple lists can be selected by dragging with the mouse.

Thereafter, a user generates an input file for driving the drawing generating device 22 with the design area, ISOSET information, and the selected piping information through the input / output device 21 to the drawing generating device 22. Upon application, the drawing generating device 22 is driven according to the input file applied through the input / output device 21 to automatically generate the ISO drawing selected in the 33rd step S33 (step S34).

For example, if you right-click to activate the Pop Up menu and then click 'Run ISOGEN', PDS ISOGEN will run to automatically generate the ISO drawing you have already selected.

At this time, the drawing generation device 22 records the drawing generation progress and error or warning messages generated during the automatic drawing generation operation as a temporary file through the file server 25 and at the same time generates and changes the drawing. The information of the temporary file is continuously searched for and displayed continuously through the input / output device 21. When the corresponding ISO drawing generation operation is finished, the drawing generation device 22 is automatically stopped and the drawing is simultaneously executed. The generation completion is displayed through the input / output device 21 (step S35).

Accordingly, when the drawing generation is completed and the user closes the progress window through the I / O device 21, the I / O device 21 detects this and automatically displays a drawing confirmation window to generate a drawing already selected by default. It shows the progress status, error, warning, etc. during the operation, and also reads the actual drawing through the file server 25 while operating the microstation when double-clicking the lower drawing. (Open) (step S36).

At this time, the file server 25 searches for an error file corresponding to the selected drawing and displays the contents of the corresponding error file through the input / output device 21. When a fatal error occurs, the drawing generation is stopped. In this case, it is displayed through the input / output device 21. In addition, when a user wants to view a file, the user checks this to find the file and opens the file through the microstation.

Alternatively, in the case of all functions shown on the ISO drawing automatic generation procedure of the drawing generating device 22, the input / output device 21 may be used to click on the selected ISO drawing at any time after generating the drawing to display the progress status and result file of the selected ISO drawing. Allow them to read through

Alternatively, the ISO drawing list may be deleted through the input / output device 21. When the ISO drawing on the screen is deleted through the input / output device 21, the database server 23 may check the corresponding ISO drawing. It is immediately deleted from the database 24.

Alternatively, in the case where the detailed drawing, other accessory information, revision status, etc. which are not supported by the basic function of the PDS are intended to be represented in the ISO drawing, the information code is written through the input / output device 21 and the corresponding detailed information is added. In this case, the database server 23 records the corresponding information in the corresponding table, and the drawing generating device 22 displays the corresponding information through the input / output device 21 by generating the drawing by reflecting the corresponding information. Given.

Further, the input / output device 21 manages the created ISO drawings by using the 'file management' icon menu, that is, clicking the icon to delete or move the ISO drawings to another folder or file. Allows you to move while changing the name.

An ISO drawing list display process of the 31st process S31 will be described in more detail with reference to the flowchart of FIG. 4 as follows.

First, when the user executes the input / output device 21, the input / output device 21 requests the database server 23 to connect to the database 24 using the PDS project information defined in the setup sheet.

Accordingly, the database server 23 checks the connection request applied from the input / output device 21 (step S41), reads the piping design area and ISOSET information stored in the database 24, and drops a drop down list. To configure (step S42), for example, the corresponding Oracle database table numbers 111, 112 and 182 are used.

The database server 23 reads the ISO drawing list and detailed information existing in the design area designated by the user from the piping design list from the table in the database 24 (step S43). For example, the table number 112, Extract information from 113, 183, and 184.

Thereafter, the database server 23 processes the ISO drawing list and the detailed information read from the database 24, and then applies the processed information to the input / output device 21. Thus, the input / output device 21 ) Receives the processed information from the database server 23 and displays it on the screen (step S44).

At this time, when a user requests to modify some information through the input / output device 21 by looking at the displayed screen, the database server 23 simultaneously requests a modification request from the input / output device 21. After confirmation (step S45), the corrected information is recorded in the association tables in the database 24 (step S46).

The pipe selection process of the 32nd process S32 will be described in more detail with reference to the flowchart of FIG. 5 as follows.

When the user executes the bulk load command through the input / output device 21, the database server 23 confirms the bulk load command applied from the input / output device 21 (step S51). The piping model list is reconstructed by reading the piping model information existing in the area from the table in the database 24 (step S52), for example, using the PDS Oracle database table numbers 112 and 113.

The database server 23 then displays the processed information through the input / output device 21 after processing the reconstructed piping model list (step S53).

Accordingly, when the user selects a specific pipe list from the displayed pipe model list through the input / output device 21, the database server 23 checks the specific pipe list selected through the input / output device 21 ( Step S54), the information on the association table in the database 24 is read to read the line ID information of the specific pipe list (step S55), and the pipe line list is reconstructed according to the read line ID information (step S55). Step S56).

After processing the reconstructed pipe line list, the database server 23 displays the processed information through the input / output device 21 (step S57).

Accordingly, when the user selects the pipe that the user wants to list by viewing the displayed pipe line list through the input / output device 21, the database server 23 confirms the selected pipe through the input / output device 21. After that (step S58), the corresponding piping information is additionally recorded in a table (for example, PDS Oracle database table 185) in the database 24 (step S59), and the result and contents thereof are stored in the input / output device 21. The display is carried out (step S60).

As described above, according to the present invention, it is possible to view and modify information by connecting to the PDS Oracle database using an application such as Excel VBA in a plant, and to operate a separate PDS drawing automatic creation module without a PDS program for piping. By creating and managing drawings, input of ISO drawing information and creation of ISO drawings are convenient, file management of ISO drawings existing on the server is convenient, and PDS license can be saved without using PDS. Alert information can be reported in real time to improve the quality of the drawing, and the list and information of ISO drawings stored in the database can be seen at a glance.

Claims (7)

A process of reconfiguring and displaying a list of piping drawings for each design area by a user's designation by connecting an input / output device and a database using an application program in a plant; After completing the piping modeling, searching for and displaying a list of pipes input at the time of the pipe modeling when the bulk load command is displayed so as to select a desired pipe to be listed in the pipe drawing list; The process of creating a temporary file and generating a temporary file while automatically generating a pipe drawing by generating an input file with the information of the design area, drawing list setting, and selected piping when selecting a list to be worked on by a user. and; Displaying in real time a temporary file including a progress and errors or warnings generated during the pipe drawing generation; And generating a pipe drawing when the pipe drawing is completed. The method of claim 1, And changing or deleting the displayed pipe drawing list and information, further comprising updating or deleting the changed pipe drawing list and information in the database. The method of claim 1, The method further includes the step of opening the actual drawing while driving the microstation while displaying the progress and error or warning of the selected pipe by reading the temporary file when the user checks the piping drawing. To create and manage piping drawings in your plant. The method of claim 1, When the detailed drawing, other accessory information, or revision status not supported by the plant design system (PDS) is represented in the piping drawing, the method further includes a step of writing an information code through the input / output device and additionally recording the detailed information. Method for creating and managing piping drawings in the plant, characterized in that made. The method of claim 1, And moving the pipe drawing by deleting or moving to another folder, or by changing a file name by using a file management menu through the input / output device. The method of claim 1, The pipe drawing list display process may include: connecting to the database by using a PDS project information defined in a setup sheet when the input / output device is executed by a user; Reading a design area and drawing list setting stored in the database to construct a drop-down list; Reading a list of drawings and detailed information existing in a design area designated by a user from the list of piping drawings from the database; Displaying the processing information through the input / output device after processing the list of drawings and detailed information; And recording the corrected information in a related table in the database when a user requests a modification of information. The method of claim 1, The pipe selection process may include reconstructing a pipe model list by reading pipe model information existing in a design area designated by a user when executing a bulk load command by a user from the database; Displaying the processing information through the input / output device after processing the pipe model list; Reconfiguring a pipe line list by reading line ID information corresponding to the specific pipe list when selecting a specific pipe list from the pipe model list; Displaying the processing information through the input / output device after processing the pipe line list; Generating a piping drawing in the plant, characterized in that the additional information is recorded in the database when the desired piping is selected from the list of piping lines, and the result and the contents are displayed through the input / output device. How to manage.

Images