Automatic generation method, device and storage medium of cable production information

Abstract

The present invention discloses a method, device and storage medium for automatically generating cable production information, the method comprising the following steps: obtaining parameter information of a cable in an electrical schematic diagram; generating retrieval information according to the parameter information; matching cable information corresponding to the cable in a cable database according to the retrieval information; matching cable drawing information in a drawing database and generating bill of materials information. The method quickly generates cable drawings and bill of materials information, and the derived cable drawings and bill of materials information are used to guide the production of cables, and save the work of statistics and measurements one by one, directly batch processing, and quickly completing wiring work according to a table, reducing the proficiency requirements of personnel related to each work; and promoting the development of standardization, so that previous work can be accumulated and the subsequent production quality is continuously improved.

Description

Technical Field

[0001] The present invention relates to the technical field of cable design, and in particular to a method, device and storage medium for automatically generating cable information. Background Art

[0002] In the process of cable design, it is necessary to complete the drawing of equipment cables based on the specific connection relationship of each electrical equipment component in the electrical schematic diagram, as well as the actual usage scenario and usage requirements. There are some difficulties in this work. On the one hand, engineers need to have a thorough understanding of every detail, and need to carefully and patiently obtain the relevant information required for cable drawing production from the drawings. There is a lot of information, which requires a certain amount of experience and patience. On the other hand, since there are many cables in each electrical schematic diagram, it is a lot of work to check each cable one by one, which is easy to make mistakes. Production designers need to check and verify repeatedly to ensure the accuracy of a large number of drawings.

[0003] Furthermore, these steps need to be repeated for each production, which means that each production consumes a lot of time and cost.

[0004] The above difficulties restrict the production speed, making the design and production of cables require a longer time and higher costs. Summary of the invention

[0005] In order to solve the problem in the prior art that cable design takes a long time and is prone to errors, the purpose of the present invention is to provide a method, device and storage medium for automatically generating cable production information.

[0006] To achieve the above-mentioned object of the invention, an embodiment of the present invention provides a method for automatically generating cable production information, comprising the following steps:

[0007] Get the parameter information of the cable in the electrical schematic diagram;

[0008] Generate search information according to the parameter information;

[0009] According to the search information, matching the cable information corresponding to the cable in the cable database;

[0010] If the corresponding cable information is matched in the cable database, the cable drawing information is matched in the drawing database according to the cable information;

[0011] Based on all the cable information, bill of materials information is generated, and the cable production information includes the bill of materials information and the cable drawing information.

[0012] As a further improvement of the present invention, the parameter information includes device information and / or terminal information of devices connected at both ends of the cable;

[0013] The search information includes the device information and / or the terminal information.

[0014] As a further improvement of the present invention, the step of "generating search information according to the parameter information" includes:

[0015] According to the parameter information, obtaining supplementary information corresponding to the cable;

[0016] The retrieval information is generated by combining the parameter information and the supplementary information.

[0017] As a further improvement of the present invention, the supplementary information includes motion component type information and / or encoder type information of the device.

[0018] As a further improvement of the present invention, the parameter information also includes length information of the cable.

[0019] As a further improvement of the present invention, the cable information includes cable model information;

[0020] The step of "generating bill of materials information according to all the cable information" includes:

[0021] Generate the cable information of the same cable model information in the same table;

[0022] The table corresponding to the cable model information is made to correspond to the cable drawing information.

[0023] As a further improvement of the present invention, the steps are also included:

[0024] If the corresponding cable information is not matched in the cable database, single-line list information is generated using parameter information corresponding to the unmatched cable.

[0025] As a further improvement of the present invention, the method further includes the step of respectively entering the unmatched cables into the cable database and the drawing database.

[0026] As a further improvement of the present invention, the cable database includes at least one of source device model information, source device group information, source terminal information, target device model information, target device group information, and target terminal information corresponding to the cable, and also includes cable model information and / or drawing name information corresponding to the drawing database;

[0027] The cable drawing information includes wire material processing requirement information and equipment material list information.

[0028] To achieve one of the above-mentioned purposes of the invention, an embodiment of the present invention provides an automatic generation device for cable production information, characterized in that it includes:

[0029] A first acquisition module is used to acquire parameter information of cables in an electrical schematic diagram;

[0030] A first generating module, used to generate search information according to the parameter information;

[0031] A first matching module, used for matching cable information corresponding to the cable in a cable database according to the search information;

[0032] A second matching module is used to match the cable drawing information in the drawing database according to the cable information when the corresponding cable information is matched in the cable database;

[0033] The second generating module is used to generate bill of materials information according to all the cable information, and the cable production information includes the bill of materials information and the cable drawing information.

[0034] To achieve one of the above-mentioned purposes of the invention, an embodiment of the present invention provides an electronic device, including:

[0035] A storage module storing a computer program;

[0036] The processing module can implement the steps in the above-mentioned method for automatically generating cable production information when executing the computer program.

[0037] To achieve one of the above-mentioned purposes of the invention, an embodiment of the present invention provides a readable storage medium storing a computer program, which can implement the steps in the above-mentioned method for automatically generating cable production information when executed by a processing module.

[0038] Compared with the prior art, the present invention has the following beneficial effects: by using the automatic generation method of cable production information, cable drawings and bills of materials can be quickly generated, and the derived cable drawings and bills of materials are used to guide the production of cables, and save the work of counting and measuring one by one, directly batch processing, and quickly complete the wiring work according to the table, thereby reducing the proficiency requirements of relevant personnel in each work; especially importantly, the use of this method can promote the development of standardization, standardize more commonly used cable information, thereby establishing a more complete cable logic table, and the development of standardization further promotes the generation of more complete cable drawings and bills of materials, and the two promote each other, so that previous work is accumulated and the subsequent production quality is continuously improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] Figure 1 is a flow chart of a method for automatically generating cable production information according to an embodiment of the present invention;

[0040] Figure 2is a schematic diagram of supplementary information according to an embodiment of the present invention;

[0041] Figure 3 is a schematic diagram of a cable database according to an embodiment of the present invention;

[0042] Figure 4 is a schematic diagram of part of cable production information according to an embodiment of the present invention;

[0043] Figure 5 It is a structural block diagram of a device for automatically generating cable production information according to an embodiment of the present invention. DETAILED DESCRIPTION

[0044] The present invention will be described in detail below in conjunction with the specific embodiments shown in the accompanying drawings. However, these embodiments do not limit the present invention, and any structural, methodological, or functional changes made by a person skilled in the art based on these embodiments are all within the scope of protection of the present invention.

[0045] An embodiment of the present invention provides a method, device and storage medium for automatically generating cable production information, which can quickly generate cable drawings and bills of materials. The exported cable drawings and bills of materials are used to guide cable production.

[0046] The automatic generation method of cable production information of this embodiment is based on the electrical schematic diagram, retrieves internal data in the drawing, matches it in the established cable database and drawing database, and automatically generates information of each cable. Conversely, the same cable that has not been matched for many times can be determined as a common cable, which can be standardized and established in the cable database and drawing database. The cable database and drawing database are further improved to facilitate the subsequent export of cable production information.

[0047] The acquisition of the internal data of the electrical schematic diagram and the matching in the drawing database can be obtained through computer-aided manufacturing software such as SolidWorks, and the matching in the cable database can be queried through Excel software.

[0048] Figure 1 This is a flowchart of a method for automatically generating cable production information according to an embodiment of the present application. Although the present application provides method operation steps as described in the following embodiment or flowchart, based on routine or no creative labor, there are steps in the method where there is no necessary causal relationship logically, and the execution order of these steps is not limited to the execution order provided in the embodiment of the present application.

[0049] The specific method for automatically generating cable production information includes the following steps:

[0050] Step S1: Obtain parameter information of cables in the electrical schematic diagram.

[0051] The parameter information can be obtained by the above method in a SQL internal query in computer-aided manufacturing software such as SolidWorks. The parameter information can be used to determine the type of cable required in the cable production information, and the parameter information includes device information and / or terminal information of the devices connected at both ends of the cable.

[0052] In some cases, such as when two devices are connected via a certain cable, the specific type of the cable can be determined based on the devices connected at both ends of the cable. In other cases, such as when multiple terminals of a certain device can be connected to another device, the specific type of the cable can be determined based on the terminal information of at least one device and the device information or terminal information of the other device.

[0053] In addition, the parameter information may also include the length information of the cable, and the length required in the cable production information may be determined based on the length information.

[0054] Step S2: Generate search information according to the parameter information.

[0055] The parameter information may include many kinds of information, and the search information may be part of the information used to extract key features, and the search information includes the device information and / or the terminal information.

[0056] Step S2 also includes the steps of:

[0057] According to the parameter information, obtaining supplementary information corresponding to the cable;

[0058] The retrieval information is generated by combining the parameter information and the supplementary information.

[0059] Supplementary information is a supplement to the conditions that affect the use of cables. Not all electrical schematics can identify specific cables, so it is necessary to add this supplementary information to determine more specific conditions of use. That is to say, based on some electrical schematics, further supplementary information is obtained. Supplementary information can include the type of motion components and / or encoder type information of the device, such as Figure 2 shown.

[0060] The motion component type information of the equipment may include tank chain, clean chain, or direct connection. Different motion component type information corresponds to different cable production information. If this item is not supplemented, it can be assumed that all cables are direct connections, and cables passing through tank chains or clean lines can be supplemented separately. For different cables of the same equipment, they can also be merged according to the motion component type information without multiple confirmations, for example, all cables connected to a certain equipment are direct connections.

[0061] There is another type of supplementary information, which is for the cables connecting the motors. Since there are many types of motors, including standard and non-standard models, it is difficult to determine the cables based on the motor type, especially non-standard models, and it is even more difficult to form an automatic generation method for standardized cable production information.

[0062] In the electrical schematic diagram, although the cable is connected to the motor, in order to avoid the problem of difficulty in determining the cable type based on the motor, in this embodiment, the cable is determined based on the encoder, such as Figure 2 and Figure 3 As shown, the supplementary information includes the information of the encoder. The cable drawings represented by different encoder usage situations will be different. The encoder type information will not be recorded in the electrical schematic diagram. It is generally selected according to the usage of the motor in each project. Therefore, the supplementary information can include the supplementary encoder type information to facilitate the selection of cables in the usage scenario of connecting the motor.

[0063] Step S3: According to the search information, matching the cable information corresponding to the cable in the cable database.

[0064] The cable database is used to display the judgment conditions for cable retrieval drawings. The cable database contains multiple conditional contents. Ideally, all cables can be combined with search information according to various conditions, and the corresponding cable information can be accurately locked in the cable database, and then the processing drawing type can be further matched later.

[0065] The cable database is a long-term summary and standardization of projects. It summarizes the application scenarios of various commonly used cables in projects. Combined with the understanding of the link relationship of the electrical schematic diagram, the corresponding cable can be judged by the connection relationship between devices and usage. In other words, the cable database matches the usage scenario with the connection relationship in the electrical schematic diagram.

[0066] like Figure 3 As shown, the cable database includes at least one of the source device model information, source device group information, source terminal information, target device model information, target device group information, and target terminal information corresponding to the cable, and also includes cable model information and / or drawing name information corresponding to the drawing database; in addition, it can also include the above-mentioned length information, the motion component type information and encoder type information in the supplementary information, and the cable model information.

[0067] Based on the selection of parameter information in the two scenarios in the above step S1, the correspondence between source device model information, source device group information, source terminal information, target device model information, target device group information, target terminal information and the cable can be clarified.

[0068] Step S4: If the corresponding cable information is matched in the cable database, the cable drawing information is matched in the drawing database according to the cable information.

[0069] The drawing database contains standard cables used in previous equipment. How to select connectors for each device and how to define the cable connection method are listed on the drawings. The cable drawing information includes wire processing requirements and equipment material list information. The equipment material list information includes the drawing description, model and material number information.

[0070] In addition, step S4 also includes: if the corresponding cable information is not matched in the cable database, generating single-line list information with the parameter information corresponding to the unmatched cable.

[0071] Single-line list information refers to cables that have not yet appeared in the cable database and drawing database. Single-line list information is the information of non-standard cables in cable production information, which is convenient for personnel to separately produce and check non-standard cables in electrical schematics.

[0072] Step S4 also includes: entering the unmatched cables into the cable database and the drawing database respectively.

[0073] For example, there are 10 cables in an electrical schematic, 9 of which can be matched in the cable database, and the remaining 1 is not matched. If it is determined that this cable can also become a standard cable, its data information can be added to the cable database, and its drawing information can be added to the drawing database. In this way, the cable database and the drawing database will be enriched. Based on this method, feedback can be obtained after each run. In other words, each production accumulates a richer database for the next production, so that production efficiency continues to improve.

[0074] Step S5: Generate bill of materials information based on all the cable information, and the cable production information includes the bill of materials information and the cable drawing information.

[0075] The bill of materials information includes the information of all cables and can be presented in a table. The bill of materials information can be used to easily understand the production requirements of all cables.

[0076] Cable production information includes tables and drawings of these standard cables, as well as the above-mentioned single-line list information. The drawings contain information such as cable production methods and material numbers. The tables match the descriptions of variable information such as line numbers on the drawings. The exported cable production information can be used to guide production on how to make cables.

[0077] In addition, step S5 further includes:

[0078] Generate the cable information of the same cable model information in the same table;

[0079] The table corresponding to the cable model information is made to correspond to the cable drawing information.

[0080] like Figure 4 As shown, the figure includes cable model information, cable drawing information and tables, among which HYC-JT-PLC-CABLE is the cable model information of the cable, the diagram part of the wire and the list of materials in the lower right corner are the cable drawing information of the cable, and the content of the reference table is a table.

[0081] The bill of materials information presents different cable information of the same manufacturing method in a table. Through internal query, the same type of cable information is combined into the same table. According to a certain format description, all processing information of the same type of cable in the electrical schematic can be clearly represented, making the bill of materials information clearer and more specific. When using the same cable drawing information, the different cable information in the table can clearly indicate the usage requirements of cables of the same model but different specifications.

[0082] Compared with the prior art, this embodiment has the following beneficial effects:

[0083] By using the automatic generation method of cable production information, cable drawings and bills of materials can be quickly generated. The exported cable drawings and bills of materials are used to guide cable production, and save the work of counting and measuring one by one. Direct batch processing and wiring work can be completed quickly according to the table, reducing the proficiency requirements of relevant personnel in each work. More importantly, the use of this method can promote the development of standardization, standardize more commonly used cable information, and thus establish a more complete cable logic table. The development of standardization further promotes the generation of more complete cable drawings and bills of materials. The two promote each other, so that previous work can be accumulated and the subsequent production quality will continue to improve.

[0084] In one embodiment, Figure 5 FIG. 1 is a block diagram of a device for automatically generating cable production information according to an embodiment of the present invention, the device comprising:

[0085] A first acquisition module is used to acquire parameter information of cables in an electrical schematic diagram;

[0086] A first generating module, used to generate search information according to the parameter information;

[0087] A first matching module, used for matching cable information corresponding to the cable in a cable database according to the search information;

[0088] A second matching module is used to match the cable drawing information in the drawing database according to the cable information when the corresponding cable information is matched in the cable database;

[0089] The second generating module is used to generate bill of materials information according to all the cable information, and the cable production information includes the bill of materials information and the cable drawing information.

[0090] In one embodiment, the device further comprises a second acquisition module, which is used to acquire supplementary information corresponding to the cable according to the parameter information;

[0091] The first generating module generates the search information by combining the parameter information and the supplementary information.

[0092] In one embodiment, the supplementary information includes motion component type information and / or encoder type information of the device.

[0093] In one embodiment, the second generating module is used to generate the cable information of the same cable model information in the same table;

[0094] The second generating module is used to correspond the table corresponding to the cable model information and the cable drawing information.

[0095] In one embodiment, the second matching module is used to generate single-line list information using parameter information corresponding to the unmatched cable when the corresponding cable information is not matched in the cable database.

[0096] The automatic generation device of the cable production information may also include computing devices such as computers, notebooks, PDAs, and cloud servers. Those skilled in the art will appreciate that the schematic diagram is merely an example of the automatic generation device of the cable production information, and does not constitute a limitation on the terminal device of the automatic generation device of the cable production information, and may include more or fewer components than shown in the diagram, or a combination of certain components, or different components, for example, the automatic generation device of the cable production information may also include input and output devices, network access devices, buses, etc.

[0097] It should be noted that for details not disclosed in the device for automatically generating cable production information in the embodiment of the present invention, please refer to the details disclosed in the method for automatically generating cable production information in the embodiment of the present invention.

[0098] In addition to the above modules, the automatic generation device of cable production information also includes a processing module, a storage module, and a computer program stored in the storage module and executable on the processing module, such as the program of the automatic generation method of cable production information. When the processing module executes the computer program, the steps of the above-mentioned automatic generation method of cable production information are implemented, such as Figure 1 Steps shown.

[0099] Effect: By using the automatic generation device for cable production information, cable drawings and bills of materials can be quickly generated. The exported cable drawings and bills of materials are used to guide cable production, and save the work of counting and measuring one by one. Direct batch processing and wiring work can be completed quickly according to the table, reducing the proficiency requirements of relevant personnel in each work; what is particularly important is that the use of this device can promote standardization development, standardize more commonly used cable information, thereby establishing a more complete cable logic table, and the development of standardization further promotes the generation of more complete cable drawings and bills of materials. The two promote each other, so that previous work can be accumulated and the subsequent production quality will continue to improve.

[0100] In addition, the present invention also proposes an electronic device, which includes a storage module and a processing module. When the processing module executes the computer program, it can implement the steps in the above-mentioned method for automatically generating cable production information, that is, implement the steps in any one of the technical solutions in the above-mentioned method for automatically generating cable production information.

[0101] The electronic device may be a part integrated into a device for automatically generating cable production information, or a local terminal device, or a part of a cloud server.

[0102] The processing module can be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor, etc. The processing module is the control center of the automatic generation device of the cable production information, and uses various interfaces and lines to connect the various parts of the automatic generation device of the entire cable production information.

[0103] The storage module can be used to store the computer program and / or module, and the processing module realizes various functions of the automatic generation device of cable production information by running or executing the computer program and / or module stored in the storage module and calling the data stored in the storage module. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, an application required for at least one function (such as a sound playback function, an image playback function, etc.); the data storage area can store data created according to the use of the mobile phone, such as audio data, a phone book, etc. In addition, the memory can include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (SecureDigital, SD) card, a flash card (Flash Card), at least one disk storage device, a flash memory device, or other volatile solid-state storage devices.

[0104] Exemplarily, the computer program may be divided into one or more modules / units, which are stored in the storage module and executed by the processing module to complete the present invention. The one or more modules / units may be a series of computer program instruction segments capable of completing specific functions, which are used to describe the execution process of the computer program in the automatic generation method of cable production information.

[0105] Furthermore, an embodiment of the present invention provides a readable storage medium storing a computer program, which, when executed by a processing module, can implement the steps in the above-mentioned method for automatically generating cable production information, that is, implement the steps in any one of the technical solutions in the above-mentioned method for automatically generating cable production information.

[0106] If the module integrated in the automatic generation method of cable production information is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing related hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of each of the above-mentioned method embodiments can be implemented.

[0107] The computer program includes computer program code, which may be in source code form, object code form, executable file or some intermediate form, etc. The computer readable medium may include: any entity or device capable of carrying the computer program code, recording medium, disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium, etc. It should be noted that the content contained in the computer readable medium may be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer readable media do not include electric carrier signals and telecommunication signals.

[0108] It should be understood that although this specification is described according to implementation modes, not every implementation mode contains only one independent technical solution. This description of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions in each implementation mode may also be appropriately combined to form other implementation modes that can be understood by those skilled in the art.

[0109] The series of detailed descriptions listed above are only specific descriptions of feasible implementation methods of the present invention. They are not intended to limit the scope of protection of the present invention. Any equivalent implementation methods or changes that do not deviate from the technical spirit of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for automatically generating cable production information, characterized in that: The steps include: Acquire parameter information of a cable in an electrical schematic diagram, wherein the parameter information includes device information and / or terminal information of devices connected at both ends of the cable; Generate retrieval information according to the parameter information, wherein the retrieval information includes the device information and / or the terminal information; According to the search information, the cable information corresponding to the cable is matched in a cable database, wherein the cable database includes at least one of source device model information, source device group information, and source terminal information corresponding to the cable, and at least one of target device model information, target device group information, and target terminal information, and the matching of the cable information corresponding to the cable in the cable database includes: judging the cable information according to device information of devices connected at both ends of the cable, or terminal information of at least one device, and device information of another device; If the corresponding cable information is matched in the cable database, the cable drawing information is matched in the drawing database according to the cable information; Based on all the cable information, bill of materials information is generated, and the cable production information includes the bill of materials information and the cable drawing information.

2. The method for automatically generating cable production information according to claim 1, characterized in that: The step of "generating search information according to the parameter information" includes: According to the parameter information, obtaining supplementary information corresponding to the cable; The retrieval information is generated by combining the parameter information and the supplementary information.

3. The method for automatically generating cable production information according to claim 2, characterized in that: The supplementary information includes motion component type information and / or encoder type information of the device.

4. The method for automatically generating cable production information according to claim 1, characterized in that: The cable information includes cable model information; The step of "generating bill of materials information according to all the cable information" includes: Generate the cable information of the same cable model information in the same table; The table corresponding to the cable model information is made to correspond to the cable drawing information.

5. The method for automatically generating cable production information according to claim 1, characterized in that: Also includes the steps: If the corresponding cable information is not matched in the cable database, single-line list information is generated using parameter information corresponding to the unmatched cable.

6. The method for automatically generating cable production information according to claim 5, characterized in that: The method also includes the step of respectively entering the unmatched cables into the cable database and the drawing database.

7. The method for automatically generating cable production information according to claim 1, characterized in that: The cable database also includes cable model information and / or drawing name information corresponding to the drawing database; The cable drawing information includes wire material processing requirement information and equipment material list information.

8. An automatic generation device for cable production information, characterized in that: include: A first acquisition module, used to acquire parameter information of a cable in an electrical schematic diagram, wherein the parameter information includes device information and / or terminal information of devices connected at both ends of the cable; A first generating module, configured to generate search information according to the parameter information, wherein the search information includes the device information and / or the terminal information; A first matching module is used to match the cable information corresponding to the cable in a cable database according to the search information, wherein the cable database includes at least one of source device model information, source device group information, and source terminal information corresponding to the cable, and at least one of target device model information, target device group information, and target terminal information, and the matching of the cable information corresponding to the cable in the cable database includes: judging the cable information according to device information of devices connected at both ends of the cable, or terminal information of at least one device, and device information of another device; A second matching module is used to match the cable drawing information in the drawing database according to the cable information when the corresponding cable information is matched in the cable database; The second generating module is used to generate bill of materials information according to all the cable information, and the cable production information includes the bill of materials information and the cable drawing information.

9. An electronic device, characterized in that: include: A storage module storing a computer program; The processing module can implement the steps in the method for automatically generating cable production information as described in any one of claims 1 to 7 when executing the computer program.

10. A readable storage medium storing a computer program, characterized in that: When the computer program is executed by the processing module, the steps in the method for automatically generating cable production information as described in any one of claims 1 to 7 can be implemented.

Images