CN112686013A - Cable number head compiling system and method - Google Patents
Cable number head compiling system and method Download PDFInfo
- Publication number
- CN112686013A CN112686013A CN202011536504.7A CN202011536504A CN112686013A CN 112686013 A CN112686013 A CN 112686013A CN 202011536504 A CN202011536504 A CN 202011536504A CN 112686013 A CN112686013 A CN 112686013A
- Authority
- CN
- China
- Prior art keywords
- cable
- software
- data
- clicking
- installation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 17
- 230000008676 import Effects 0.000 claims abstract description 16
- 238000013461 design Methods 0.000 claims abstract description 9
- 238000012545 processing Methods 0.000 claims abstract description 5
- 238000009434 installation Methods 0.000 claims description 24
- 238000007639 printing Methods 0.000 claims description 12
- 238000010586 diagram Methods 0.000 claims description 3
- 238000010017 direct printing Methods 0.000 claims description 3
- 239000000284 extract Substances 0.000 claims description 3
- 238000012986 modification Methods 0.000 claims description 3
- 230000004048 modification Effects 0.000 claims description 3
- 238000010276 construction Methods 0.000 abstract description 3
- 230000009286 beneficial effect Effects 0.000 abstract description 2
- 238000002360 preparation method Methods 0.000 abstract description 2
- 238000012423 maintenance Methods 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a cable number head compiling system and a method thereof, which comprises data import, data processing, data display and data export. The invention has the beneficial effects that: the secondary cable inventory that provides at the design institute is the template, utilizes the computer to handle a large amount of miscellaneous data, greatly improves work efficiency, reduces working strength, utilizes computer software's intelligent associative function to simplified the preparation work before the construction, through practice proves, not only can effectually improve the quality of writing, accelerated the speed of writing moreover by a wide margin.
Description
Technical Field
The invention relates to a cable number head compiling method, in particular to a cable number head compiling system and a cable number head compiling method, and belongs to the technical field of cable information arrangement.
Background
The cable number head is a protection pipe for marking a cable core in the secondary cable wiring construction of the transformer substation engineering, is an important description of the functions of the cable core on a real object, and plays an important role in the operation and maintenance of the transformer substation. The conventional labeler has several disadvantages: the cable number head compiling system and the cable number head compiling method are provided based on the fact that a keyboard is difficult to operate, manual input amount is large, and storage is inconvenient.
Disclosure of Invention
The invention aims to provide a cable number head writing system and a method thereof for solving the problems.
The invention realizes the purpose through the following technical scheme: a cable number head compiling system and a method thereof comprise the following steps:
step one, data import, namely importing an excel-format cable inventory into software;
step two, data processing, namely extracting the required information in the cable inventory to a database of software, automatically classifying the extracted data in the database, and filling the information in the database in a template by using the software;
step three, data display, namely displaying the imported cable inventory file and checking whether the import is correct;
and step four, exporting data, and directly using the data for printing after the software is written.
As a still further scheme of the invention: in the first step, the used software provides a cable registration and a wiring diagram for a design institute as a data source, the computer automatically extracts the information of the cable number and the cable core number from the cable registration, and manually inputs the circuit number information by the wiring bluediagram association, and finally the information is combined into a cable number header document which can be directly used for printing.
As a still further scheme of the invention: in the first step, after the cable list is imported into the software, possible loop number combinations can be intelligently associated.
As a still further scheme of the invention: in the second step, the extracted data information comprises a cable number, a cable core number and a cable core loop number.
As a still further scheme of the invention: in the second step, the data is processed by editing the loop number, and the rules of the cable number head loop number are added, deleted, modified, inquired and the like.
As a still further scheme of the invention: and in the third step, the cable inventory file displays data in a read-only mode.
A cable number head writing system comprises an operation method of:
A. and (4) installing software, operating 'cable number head writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading an installation use agreement and selecting 'I accept terms in the license agreement' to enter an installation program, or exiting the installation program. Clicking the next step, clicking the next step after the user name and the unit are filled, selecting the installation type, defaulting to ' complete installation ', clicking the next step ', clicking ' installation ', entering a software installation interface, waiting for the installation to be completed, and clicking ' completion ' after the installation is completed;
B. the software is opened and operated, and the cable number head compiling software is found under a folder of the cable number head compiling software in an installation path, exe' can operate the software by double clicking or directly click the cable number head compiling software shortcut on a desktop;
C. after clicking an import button, conducting inventory import on the electronic version cable of the design institute to software, selecting a cable inventory file to be written in a file list, selecting a worksheet to be operated, then clicking the import inventory, and automatically extracting required data into a database by the software;
D. the method comprises the steps of clicking the cable registration information displayed in a dialog box, editing, and displaying a printing mode of the cable, wherein the cable number and the core number can be obtained according to the registration information, the loop number needs to be input by contrast with a drawing, an intelligent association function is designed, and relevant rules such as B630, C630, N600 and the like can be automatically associated after the A630 or other regular loop numbers are input into the first loop number. Thereby maximally improving the input efficiency. After editing is finished, the generated number head is clicked, and then a number head document for direct printing can be generated;
E. and checking the cable head edition file in a read-only mode. So as to prevent the misoperation from leading to the modification of the file;
F. and exporting the data produced by editing and directly using the data for printing.
The invention has the beneficial effects that: the cable number head compiling system and the method thereof are reasonable in design, a secondary cable list provided by a design institute is used as a template, a computer is used for processing a large amount of complicated data, the working efficiency is greatly improved, the working intensity is reduced, the intelligent association function of computer software is used, the preparation work before construction is simplified, and practice proves that the compiling quality can be effectively improved, and the compiling speed is greatly accelerated.
Drawings
FIG. 1 is a schematic flow chart of the system of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a cable number writing system includes the following steps:
step one, data import, namely importing an excel-format cable inventory into software;
step two, data processing, namely extracting the required information in the cable inventory to a database of software, automatically classifying the extracted data in the database, and filling the information in the database in a template by using the software;
step three, data display, namely displaying the imported cable inventory file and checking whether the import is correct;
and step four, exporting data, and directly using the data for printing after the software is written.
In the embodiment of the invention, in the first step, the used software is a data source of a cable registration and a wiring diagram provided by a design institute, the computer automatically extracts the information of the cable number and the cable core number from the cable registration, manually inputs the circuit number information by the wiring bluediagram association, and finally combines the information into a cable number header document which can be directly used for printing.
In the embodiment of the invention, in the first step, after the cable inventory is imported into the software, the possible loop number combinations can be intelligently associated, so that the output process is simplified.
In the embodiment of the present invention, in the second step, the extracted data information includes a cable number, a cable core number, and a cable core loop number, so that the numbered cable number header information is completely labeled.
In the second step of the present invention, the data is processed by editing the loop number, and the rules of the loop number of the cable head are added, deleted, modified, and queried.
In the third step of the present invention, the cable registration file is data-displayed in the read-only mode to prevent the file from being modified due to the misoperation.
An operation method of a cable number head writing system comprises the following steps:
A. and (4) installing software, operating 'cable number head writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading an installation use agreement and selecting 'I accept terms in the license agreement' to enter an installation program, or exiting the installation program. Clicking the next step, clicking the next step after the user name and the unit are filled, selecting the installation type, defaulting to ' complete installation ', clicking the next step ', clicking ' installation ', entering a software installation interface, waiting for the installation to be completed, and clicking ' completion ' after the installation is completed;
B. the software is opened and operated, and the cable number head compiling software is found under a folder of the cable number head compiling software in an installation path, exe' can operate the software by double clicking or directly click the cable number head compiling software shortcut on a desktop;
C. after clicking an import button, conducting inventory import on the electronic version cable of the design institute to software, selecting a cable inventory file to be written in a file list, selecting a worksheet to be operated, then clicking the import inventory, and automatically extracting required data into a database by the software;
D. the method comprises the steps of clicking the cable registration information displayed in a dialog box, editing, and displaying a printing mode of the cable, wherein the cable number and the core number can be obtained according to the registration information, the loop number needs to be input by contrast with a drawing, an intelligent association function is designed, and relevant rules such as B630, C630, N600 and the like can be automatically associated after the A630 or other regular loop numbers are input into the first loop number. Thereby maximally improving the input efficiency. After editing is finished, the generated number head is clicked, and then a number head document for direct printing can be generated;
E. and checking the cable head edition file in a read-only mode. So as to prevent the misoperation from leading to the modification of the file;
F. and exporting the data produced by editing and directly using the data for printing.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned.
Furthermore, it should be understood that although the present description refers to embodiments, not every embodiment may contain only a single embodiment, and such description is for clarity only, and those skilled in the art should integrate the description, and the embodiments may be combined as appropriate to form other embodiments understood by those skilled in the art.
Claims (7)
1. A cable number head writing system is characterized by comprising the following steps:
step one, data import, namely importing an excel-format cable inventory into software;
step two, data processing, namely extracting the required information in the cable inventory to a database of software, automatically classifying the extracted data in the database, and filling the information in the database in a template by using the software;
step three, data display, namely displaying the imported cable inventory file and checking whether the import is correct;
and step four, exporting data, and directly using the data for printing after the software is written.
2. The cable number writing system of claim 1, wherein: in the first step, the used software provides a cable registration and a wiring diagram for a design institute as a data source, the computer automatically extracts the information of the cable number and the cable core number from the cable registration, and manually inputs the circuit number information by the wiring bluediagram association, and finally the information is combined into a cable number header document which can be directly used for printing.
3. A cable header authoring system according to claim 1 or 2, wherein: in the first step, after the cable list is imported into the software, possible loop number combinations can be intelligently associated.
4. The cable number writing system of claim 1, wherein: in the second step, the extracted data information comprises a cable number, a cable core number and a cable core loop number.
5. The cable number writing system of claim 1, wherein: in the second step, the data is processed by editing the loop number, and the rules of the loop number of the cable head are added, deleted, modified and inquired.
6. The cable number writing system of claim 1, wherein: and in the third step, the cable inventory file displays data in a read-only mode.
7. An operation method of the cable number head writing system according to claim 1, wherein the operation method comprises:
A. and (4) installing software, operating 'cable number head writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading an installation use agreement and selecting 'I accept terms in the license agreement' to enter an installation program, or exiting the installation program. Clicking the next step, clicking the next step after the user name and the unit are filled, selecting the installation type, defaulting to ' complete installation ', clicking the next step ', clicking ' installation ', entering a software installation interface, waiting for the installation to be completed, and clicking ' completion ' after the installation is completed;
B. the software is opened and operated, and the cable number head compiling software is found under a folder of the cable number head compiling software in an installation path, exe' can operate the software by double clicking or directly click the cable number head compiling software shortcut on a desktop;
C. after clicking an import button, conducting inventory import on the electronic version cable of the design institute to software, selecting a cable inventory file to be written in a file list, selecting a worksheet to be operated, then clicking the import inventory, and automatically extracting required data into a database by the software;
D. the method comprises the steps that cable inventory information displayed in a dialog box is clicked to edit, a printing mode of a cable can appear, wherein the number of the cable and the core number can be obtained according to the inventory information, the loop number needs to be input by contrast with a drawing, an intelligent association function is designed, when A630 or other regular loop numbers are input into a first loop number, rules of B630, C630 and N600 can be automatically associated, so that the input efficiency is improved to the maximum extent, and after the editing is finished, a generated number head is clicked, and a number head document for direct printing can be generated;
E. and checking the cable head edition file in a read-only mode. So as to prevent the misoperation from leading to the modification of the file;
F. and exporting the data produced by editing and directly using the data for printing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011536504.7A CN112686013A (en) | 2020-12-23 | 2020-12-23 | Cable number head compiling system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011536504.7A CN112686013A (en) | 2020-12-23 | 2020-12-23 | Cable number head compiling system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112686013A true CN112686013A (en) | 2021-04-20 |
Family
ID=75451014
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011536504.7A Pending CN112686013A (en) | 2020-12-23 | 2020-12-23 | Cable number head compiling system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112686013A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113268966A (en) * | 2021-06-11 | 2021-08-17 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376171A (en) * | 2014-11-17 | 2015-02-25 | 陕西合信诚铭软件科技有限公司 | Automatic design method and system for terminal block drawing and cable detailed list |
| CN110782047A (en) * | 2019-10-25 | 2020-02-11 | 小波科技有限公司 | Intelligent label system |
| CN111400899A (en) * | 2020-03-13 | 2020-07-10 | 广州轨道交通建设监理有限公司 | Processing method, system and storage medium for cable laying modeling |
-
2020
- 2020-12-23 CN CN202011536504.7A patent/CN112686013A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376171A (en) * | 2014-11-17 | 2015-02-25 | 陕西合信诚铭软件科技有限公司 | Automatic design method and system for terminal block drawing and cable detailed list |
| CN110782047A (en) * | 2019-10-25 | 2020-02-11 | 小波科技有限公司 | Intelligent label system |
| CN111400899A (en) * | 2020-03-13 | 2020-07-10 | 广州轨道交通建设监理有限公司 | Processing method, system and storage medium for cable laying modeling |
Non-Patent Citations (1)
| Title |
|---|
| 吴绮荣: "一种新型的电缆牌制作流程", pages 1 - 3, Retrieved from the Internet <URL:https://www.doc88.com/p-574882987184.html> * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113268966A (en) * | 2021-06-11 | 2021-08-17 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
| CN113268966B (en) * | 2021-06-11 | 2023-01-10 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110852065A (en) | Document auditing method, device, system, equipment and storage medium | |
| CN109933796B (en) | Method and device for extracting key information of bulletin text | |
| CN113918138A (en) | Flow processing method and device and computer system | |
| CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
| US20070179642A1 (en) | System and method for interactive process management | |
| CN111784801B (en) | Automatic drawing method and system for parking space plan of completion monomer building | |
| CN111144116B (en) | Document knowledge structured extraction method and device | |
| CN102915476A (en) | Visual business process design method | |
| CN112686013A (en) | Cable number head compiling system and method | |
| CN110400101A (en) | Industry reports analysis system and method | |
| CN109086985B (en) | Professional test information management system for spacecraft assembly | |
| CN110675121A (en) | Method for collecting picture type file material | |
| CN114756789A (en) | Visual large-screen generating system | |
| CN114090611A (en) | Method and device for generating cable inventory by terminal wiring table and electronic equipment | |
| CN110413659B (en) | General shopping ticket data accurate extraction method | |
| CN115602277A (en) | Medical electronic medical record labeling method, device, system and storage medium | |
| CN112052652B (en) | Automatic generation method and device for electronic courseware script | |
| CN111708572B (en) | Automatic control flow chart generation method based on Clang program structure | |
| CN114118098A (en) | Contract review method, equipment and storage medium based on element extraction | |
| CN114139521A (en) | Online visualization template file based generation method | |
| CN112686014A (en) | Cable number plate compiling system and method | |
| Minggao et al. | Research on the Application of LLM in Power Finance Middle Platform | |
| CN118036731A (en) | Semi-automatic labeling method and device for building process knowledge graph | |
| CN118467721A (en) | Knowledge graph-based visualization and text association method | |
| CN114036916A (en) | Variable production operation report processing method and system based on configuration |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |