CN114706913A

CN114706913A - Data writing method, system, terminal device and computer readable storage medium

Info

Publication number: CN114706913A
Application number: CN202210325348.2A
Authority: CN
Inventors: 王佺
Original assignee: China Nuclear Power Engineering Co Ltd
Current assignee: China Nuclear Power Engineering Co Ltd
Priority date: 2022-03-29
Filing date: 2022-03-29
Publication date: 2022-07-05

Abstract

The present disclosure provides a data writing method, a system, a terminal device and a computer readable storage medium, to at least solve the problems that a large amount of redundant data information exists in data transmission and writing between different software at present and cannot be written into a designated object, and a data interface is lacked, and data needs to be artificially screened and written, wherein the method comprises: acquiring data to be transmitted; matching a transfer object for the data to be transferred; extracting related data information of the data to be transmitted from the transmission object; and writing the related data information into a corresponding file type of second software, wherein the corresponding file type is created in advance by the second software. The method and the device can realize efficient writing of data among different software, avoid unnecessary data redundancy, write the data into the designated object without manual operation, provide conditions for cooperative work among different software, and improve the efficiency of the cooperative work.

Description

Data writing method, system, terminal device and computer readable storage medium

Technical Field

The present disclosure relates to the field of data transmission technologies, and in particular, to a data writing method, a data writing system, a terminal device, and a computer-readable storage medium.

Background

In engineering design, especially for process flow design, the transfer and writing of drawing data between different software is usually involved. At present, a common data transmission method at home and abroad is imported through an open interface between software or an appointed file format, different software does not usually have a universal data interface, and the data transmission mode imported by the appointed file format has the following defects: the appointed file form is rich in a large amount of redundant data information, and relevant useful data information cannot be extracted from the file form; the imported file data cannot be transmitted to a specified object; the imported data needs to be manually screened; if no interface is opened in the software, and no unified import format exists, for example, the Engineering Base software, the Engineering software, and the Diagrams software are industrial design software opened by different companies, and no interface is opened between the Engineering Base software, and the Diagrams software, and only manual data screening or data writing can be performed manually, which consumes a lot of time.

Disclosure of Invention

The present disclosure provides a data writing method, a system, a terminal device and a computer readable storage medium, which at least solve the problems that a large amount of redundant data information exists in data transmission and writing between different software at present, the data cannot be written into a designated object, and a data interface is lacked, and data needs to be manually screened and written in.

In order to achieve the above object, the present disclosure provides a data writing method applied to a first software, including:

acquiring data to be transmitted;

matching a transfer object for the data to be transferred;

extracting related data information of the data to be transmitted from the transmission object; and the number of the first and second groups,

and writing the related data information into a corresponding file type of second software, wherein the corresponding file type is created in advance by the second software.

In one embodiment, the data to be transmitted is data generated in third software, the first software and the third software have a data comparison and update function interface,

acquiring data to be transmitted, comprising:

and after the third software generates the data to be transmitted, calling a data comparison and updating functional interface to acquire the data to be transmitted.

In one embodiment, matching a transfer object for the data to be transferred includes:

acquiring a transfer attribute object name; and matching the data to be transmitted with the transmission object based on the transmission attribute object name.

In one embodiment, after extracting the relevant data information of the data to be transferred from the transfer object and before writing the relevant data information into the corresponding file type of the second software, the method further includes:

transmitting the related data information to a database; and creating a data form in the database based on the relevant data information;

writing the related data information into a corresponding file type of second software, including:

and writing the related data information into a corresponding file type of the second software based on the data form created by the database.

In order to achieve the above object, the present disclosure also provides a data writing system applied to a first software, including:

an acquisition module configured to acquire data to be transferred;

the matching module is set to match a transmission object for the data to be transmitted;

the extraction module is arranged for extracting the related data information of the data to be transmitted in the transmission object; and the number of the first and second groups,

a writing module configured to write the relevant data information into a corresponding file type of a second software, wherein the corresponding file type is pre-created by the second software.

In an embodiment, the data to be transmitted is data generated in third software, a data comparison and update functional interface is provided between the first software and the third software, and the obtaining module is specifically configured to call the data comparison and update functional interface to obtain the data to be transmitted after the third software generates the data to be transmitted.

In one embodiment, the matching module comprises:

an acquisition unit configured to acquire a transfer attribute object name; and the matching unit is arranged to match the transfer object for the data to be transferred based on the transfer attribute object name.

In one embodiment, the system further comprises:

the transmission module is arranged for transmitting the relevant data information to a database after the extraction module extracts the relevant data information and before the writing module writes the relevant data information into the corresponding file type of the second software; and a creation module configured to create a data form in the database based on the relevant data information;

the writing module is specifically configured to write the relevant data information into a corresponding file type of the second software based on the data form created by the database.

In order to achieve the above object, the present disclosure also provides a terminal device, which includes a memory and a processor, where the memory stores a computer program, and when the processor runs the computer program stored in the memory, the processor executes the data writing method.

To achieve the above object, the present disclosure also provides a computer-readable storage medium having a computer program stored thereon, where when the computer program is executed by a processor, the processor executes the data writing method.

According to the data writing method, the data writing system, the terminal device and the computer readable storage medium, data to be transmitted are obtained, a transmission object is matched with the data to be transmitted, then relevant data information of the data to be transmitted is extracted from the transmission object, and finally the relevant data information is written into a corresponding file type of second software, wherein the corresponding file type is pre-established by the second software. The method and the device can realize efficient writing of data among different software, avoid unnecessary data redundancy, write the data into the designated object without manual operation, provide conditions for cooperative work among different software, and improve the efficiency of the cooperative work.

Additional features and advantages of the disclosure will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the disclosure. The objectives and other advantages of the disclosure may be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.

Drawings

The accompanying drawings are included to provide a further understanding of the disclosed embodiments and are incorporated in and constitute a part of this specification, illustrate embodiments of the disclosure and together with the example serve to explain the principles of the disclosure and not to limit the disclosure.

Fig. 1 is a schematic flow chart of a data writing method according to an embodiment of the disclosure;

FIG. 2 is an exemplary diagram of data to be transferred for Diagrams in an embodiment of the present disclosure;

FIG. 3 is an exemplary diagram of invoking Compare & Update functionality interface in an embodiment of the present disclosure;

FIG. 4 is an exemplary diagram of data to be transmitted of Diagrams into Engineering software in the embodiment of the present disclosure;

FIG. 5 is an exemplary diagram of the attribute names and their descriptions of data to be transmitted from the Engineering software to the Engineering Base software configuration in the embodiment of the present disclosure;

FIG. 6 is an exemplary diagram of a User-defined-name attribute of a hierarchy of Lexicon modules in an embodiment of the disclosure;

FIG. 7 is an exemplary diagram of creating file types in the Engineering Base software in an embodiment of the present disclosure;

FIG. 8 is an exemplary diagram of an Engineering Base software call API interface in an embodiment of the present disclosure;

FIG. 9 is an exemplary diagram of the result of writing the relevant data information in the Engineering software into the Engineering Base software in the embodiment of the present disclosure;

fig. 10 is a flowchart illustrating another data writing method according to an embodiment of the disclosure;

fig. 11 is a second schematic flowchart of another data writing method according to an embodiment of the disclosure;

fig. 12 is a schematic structural diagram of a data writing system according to an embodiment of the present disclosure;

fig. 13 is a schematic structural diagram of a terminal device according to an embodiment of the present disclosure.

Detailed Description

To make the objects, technical solutions and advantages of the embodiments of the present disclosure more apparent, specific embodiments of the present disclosure are described below in detail with reference to the accompanying drawings. It should be understood that the detailed description and specific examples, while indicating the present disclosure, are given by way of illustration and explanation only, not limitation.

It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the above-described drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order; also, the embodiments and features of the embodiments in the present disclosure may be arbitrarily combined with each other without conflict.

In which the terminology used in the embodiments of the disclosure is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. As used in the disclosed embodiments and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

In the following description, suffixes such as "module", "component", or "unit" used to denote elements are used only for the convenience of explanation of the present disclosure, and have no specific meaning in themselves. Thus, "module", "component" or "unit" may be used mixedly.

The data writing method is described by taking data transmission among Diagrams software, Engineering software and Engineering Base software as an example, and it can be understood that the Engineering Base software is electrical design professional software developed by AUCOTEC company in Germany and is an integrated electrical Engineering design platform taking an object as a guide and taking a central database as a core; the (AVEVA) Engineering software and the (AVEVA) Diagrams software are AVEVA company development industrial Design software, wherein the Diagrams is system diagram Design tool software on an AVEVA Design Platform integrated Design environment and supports the Design of a P & ID diagram, an HVAC system diagram and a cable schematic diagram; engineering is a multi-specialty software application that can ensure that an Engineering team processes a factory or marine project in coordination, while it can be fully integrated with the AVEVA integrated Engineering and design solution.

Because the Engineering Base software and the Engineering Base software do not have data interfaces, the related technology usually intelligently conducts import and other operations based on a specific file format when data transmission and writing are conducted among different software, and similar data transmission modes at least have the defects that imported file data cannot be transmitted to a specified object, the imported data needs to be manually screened and the like.

Having described the general principles of the present application, various non-limiting embodiments of the present application will now be described with reference to the accompanying drawings.

Referring to fig. 1, fig. 1 is a schematic flow chart of a data writing method applied to a first software according to an embodiment of the present disclosure, where the method includes steps S101 to S104.

In this embodiment, the first software is Engineering software, the second software is Engineering Base software, and the third software is diagnostics software.

In step S101, data to be transferred is acquired.

In this embodiment, the data to be transmitted is data generated in the Diagrams software, the Engineering software and the Diagrams software have a Compare and Update data Compare and Update functional interface therebetween, and the Engineering software calls the Compare and Update data functional interface to acquire the data to be transmitted after generating the data to be transmitted in the third software.

It should be understood that the Engineering software and the Diagrams software are different software developed by the same company, and a Compare & Update functional interface is provided between the Engineering software and the Diagrams software, and in some embodiments, in addition to the Engineering software and the Diagrams software, other different software can also implement automatic transmission of data to be transmitted as long as the different software has the Compare & Update functional interface, which is not limited in this embodiment.

In a preferred embodiment, when the Diagrams software needs to perform data transfer, firstly, a verification task is created in the Diagrams software, when a verification process of an Engineering object of the Diagrams (for example, 1010/1200, data to be transferred is shown in fig. 2) is finished (the verification process may include compiling, checking, reviewing, examining and approving), the Diagrams software and the Engineering software implement updating of the Diagrams data into the Engineering by calling a Compare & Update functional interface in the Engineering, a method of specifically calling the interface is shown in fig. 3, and a calling result is shown in fig. 4.

In step S102, a transfer object is matched for the data to be transferred.

In one embodiment, after receiving the transfer data of the Diagrams software, the Engineering software performs verification on the data, and matches the transfer object for the to-be-transferred data after verification is completed.

Specifically, step S102 includes the steps of:

After the verification is completed, the name of the object to be transferred is obtained in a Lexicon module in Engineering software through a PML. It will be appreciated that the Lexicon module is a module for custom component properties and custom component types, among others.

In step S103, relevant data information of the data to be transferred is extracted from the transfer object.

In one embodiment, the Engineering Base software finally creates form files, each form file corresponds to a form file name, the Engineering Base software can obtain the Attribute name and its Description content, thermal testandcontrol (as shown in fig. 5) of the data transfer from the form file name (for example, IND _ chemical Engineering project thermal detection and control task book) generated by the Engineering Base software in advance, to the data transfer configured by the administrator in advance (the administrator can configure the Attribute before the data transfer), according to the obtained value, thermal testandcontrol to the filled-in thermal testandcontrol in the User-defined-name Attribute of the Lexicon module hierarchy (as shown in fig. 6), if the same, extract the Attribute name (Attribute/Expression) and its Description information (Description information) in the template hierarchy, add the extracted content to the data collection and the data collection corresponding to the data collection, as shown in table 3:

TABLE 3- -content extracted by Lexicon Module

Then, the relative attribute contents are sequentially obtained from the selected engineering object 0101(2) -PG-03001 according to the obtained attribute name, further, a corresponding data table may be created in the database according to the obtained attribute name, description, and attribute contents, and data transmission is implemented based on the data table of the database, which is detailed in the embodiments described later and is not described herein again.

In step S104, the related data information is written into a corresponding file type of the second software, where the corresponding file type is created in advance by the second software.

In some embodiments, the user may also select the type and type of the incoming file in the Engineering Base software, and after the corresponding file type is created, the data writing can be completed. In a preferred embodiment, the related data information is stored in the database in the form of a data table, the Engineering Base software may create a file type (for example, device type) and a category (for example, motor) in advance according to the data table in the selected database, as shown in fig. 7, and after the Engineering Base software sets the type and the category, the Engineering Base software reads the data in the stored data table thermateandcontrol, as shown in table 4:

specifically, according to the set file type, the set file type and the set file type, and the like, data writing and creation are realized through an Engineering Base interface API. The concrete writing is shown in fig. 8, and the creation result is shown in fig. 9.

Compared with the prior art, the data redundancy and labor cost caused by data transmission and writing through the specific format file are high, or the defects that the data interface development between different software is high in cost and difficult to achieve are overcome.

Referring to fig. 10, fig. 10 is another data writing method provided by the embodiment of the present disclosure, based on the previous embodiment, the embodiment stores the extracted related data information in a database in a form of a data table, and then performs a writing operation on data, which is beneficial to data transmission when there are multiple data to be transmitted, so as to effectively improve data transmission efficiency, specifically, after the related data information of the data to be transmitted is extracted from the transmission object (step S103), and before the related data information is written into a corresponding file type of the second software (step S104), the method further includes step S201 and step S202, and step S104 is further divided into step S104 a.

In step S201, transmitting the relevant data information to a database; and, in step S202, creating a data form in the database based on the relevant data information.

In this embodiment, the data form format includes, for example, ThermalTestAndControl as a table name, an attribute name as a field name, a description as an annotation, and an attribute content as table content, which is specifically shown in table 4.

In S104a, the data form created based on the database writes the relevant data information into the corresponding file type of the second software.

Specifically, the Engineering Base software reads the stored relevant data information in the data table ThermalTestAndControl, and writes the relevant data information into the corresponding file type, that is, the writing of the Diagrams data into the Engineering Base software is completed. In some embodiments, there may be multiple writes of data to be transferred, and the second software need only select the data table in the database to which it needs to write.

To facilitate an understanding of the disclosed embodiments, as shown in FIG. 11, FIG. 11 illustrates the introduction of Diagrams data into Engineering and the introduction of Engineering data into Engineering Base, as follows:

1) the Diagrams data are transmitted to Engineering software:

step S1, S2, after the verification process of the Diagrams Engineering object (for example, 1010/1200, the transferred content is shown in fig. 2) is finished (the verification process is: compiling, proofreading, auditing, approving and approving), updating the Diagrams data into the Engineering is realized by calling the Compare & Update function interface (interface with functions of comparing and updating data) in the Engineering, the method for specifically calling the interface is shown in fig. 3, and the calling result is shown in fig. 4.

2) The Engineering data is transmitted to Engineering Base software:

step S3, obtaining data transfer description content ThermalTestAndControl (as shown in fig. 5) in the data transfer configured by the administrator according to the user-generated data form name (for example, IND _ chemical engineering project thermotechnical detection and control task book).

According to the obtained value ThermalTestAndControl to the filled-in ThermalTestControl matching in the User-defined-name Attribute of the Lexicon module hierarchy (as shown in figure 6), if the values are the same, the Attribute name (Attribute/Expression) and Description (Description) in the hierarchy template are extracted, and the extracted contents are added into the collection, wherein the data are shown in the table 3.

Corresponding attribute contents are sequentially acquired in the selected engineering object 0101(2) -PG-03001 according to the acquired attribute name, and a corresponding data table (contents with thermal test and control as a table name, an attribute name as a field name, a description as an annotation, and an attribute content as a table) is created in a database (Structured Query Language (SQL database)) according to the acquired attribute name, description, and attribute contents, as shown in table 4.

In step S4, a category (motor) and a type (device type) to be introduced are selected in the Engineering Base, as shown in fig. 7.

At step S5, after the type and category are set, the data of the data table ThermalTestAndControl just stored is read, as shown in table 4. According to the set type of the device and the type of the motor, data writing and creation are realized through an API (Application Program Interface) of the Engineering Base, specifically, the writing is shown in FIG. 8, and the creation result is shown in FIG. 9.

The method can be realized based on C # language and PML language development, is embedded in a source program of the integrated data platform, and then is compiled into a Dll file together, after the program runs, the automatic transmission of the Diagrams data into the Engineering can be realized, and the Engineering data is transmitted into the Engineering Base. Obviously, compared with the traditional file import, the data transmission mode of the embodiment has higher work efficiency and reduces the work time by times.

Based on the same technical concept, the embodiment of the present disclosure correspondingly provides a data writing system, as shown in fig. 12, applied to a first software, the system including:

an obtaining module 121 configured to obtain data to be transferred;

a matching module 122 configured to match a transfer object for the data to be transferred;

an extracting module 123 configured to extract data information related to the data to be transferred from the transfer object; and the number of the first and second groups,

a writing module 124 configured to write the relevant data information into a corresponding file type of the second software, wherein the corresponding file type is pre-created by the second software.

In an embodiment, the data to be transmitted is data generated in third software, a data comparison and update functional interface is provided between the first software and the third software, and the obtaining module 121 is specifically configured to call the data comparison and update functional interface to obtain the data to be transmitted after the third software generates the data to be transmitted.

In one embodiment, the matching module 122 includes:

In one embodiment, the system further comprises:

the transmission module is arranged for transmitting the relevant data information to a database after the extraction module extracts the relevant data information and before the writing module writes the relevant data information into the corresponding file type of the second software; and a creation module configured to create a data form based on the relevant data information in the database;

Based on the same technical concept, the embodiment of the present disclosure correspondingly provides a terminal device, as shown in fig. 13, the terminal device includes a memory 131 and a processor 132, the memory 131 stores a computer program, and when the processor 132 runs the computer program stored in the memory 131, the processor 132 executes the data writing method.

Based on the same technical concept, embodiments of the present disclosure correspondingly provide a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the processor executes the data writing method.

It will be understood by those of ordinary skill in the art that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the physical components may be implemented as software executed by a processor, such as a central processing unit, digital signal processor, or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art.

Finally, it should be noted that: the above embodiments are only used for illustrating the technical solutions of the present disclosure, and not for limiting the same; while the present disclosure has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art will understand that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications or substitutions do not depart from the scope of the embodiments of the present disclosure by the essence of the corresponding technical solutions.

Claims

1. A data writing method is applied to first software and comprises the following steps:

acquiring data to be transmitted;

matching a transfer object for the data to be transferred;

2. The method of claim 1, wherein the data to be transferred is data generated in a third software, the first software and the third software having a compare and update data functional interface therebetween,

acquiring data to be transmitted, comprising:

3. The method of claim 1, wherein matching a transfer object for the data to be transferred comprises:

4. The method of claim 1, further comprising, after extracting the relevant data information of the data to be transferred from the transfer object and before writing the relevant data information into the corresponding file type of the second software:

5. A data writing system, applied to first software, comprising:

an acquisition module configured to acquire data to be transferred;

the matching module is arranged for matching a transmission object for the data to be transmitted;

6. The system according to claim 5, wherein the data to be transferred is data generated in third software, the first software and the third software have a function interface for comparing and updating data therebetween, and the obtaining module is specifically configured to call the function interface for comparing and updating data to obtain the data to be transferred after the third software generates the data to be transferred.

7. The method of claim 5, wherein the matching module comprises:

8. The method of claim 5, further comprising:

9. A terminal device characterized by comprising a memory in which a computer program is stored and a processor that executes the data writing method according to any one of claims 1 to 4 when the processor executes the computer program stored in the memory.

10. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, executes the data writing method of any one of claims 1 to 4.