Wire harness process design system

By identifying and managing node attributes in XML files, a data table structure is created, and a complex wire harness process data module is integrated. This solves the problem of scattered data in wire harness factories, achieves efficient and standardized process data management, and improves design and production efficiency.

CN118965478APending Publication Date: 2024-11-15NANJING QUANXIN CABLE TECH
View PDF 0 Cites 1 Cited by

Patent Information

Application Number
CN202411038226.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-31
Publication Date
2024-11-15

AI Technical Summary

Technical Problem

In the existing technology, wire harness manufacturers face problems such as data being scattered, unsearchable, non-standardized, and low in utilization when processing complex wire harness process data, resulting in low work efficiency for designers. Furthermore, they lack systematic data management and efficient data processing methods.

Method used

A wire harness process design system is adopted. By identifying and traversing the node attributes and structure in the XML file, a data table structure is created. The system integrates a complex wire harness process data management module with the ACCESS database, including cable model management and contact process parameter management, and automatically generates process cards to achieve data standardization and convenient management.

Benefits of technology

It improves the richness and accuracy of wire harness process data, enhances design and production efficiency, achieves data standardization and reuse, reduces manual editing, and improves the security and ease of searching of process data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118965478A_ABST
    Figure CN118965478A_ABST
Patent Text Reader

Abstract

The invention discloses a wire harness process design system, which is based on an ACCESS database of Microsoft Office, is matched with a wire harness process design software system developed by an SQL SERVER database, is used for converting and processing a whole set of process data packets used for client wire harness design input and output production, and is integrated with typical process file editing and technical state management modules and the like. Through standard, efficient and economical data processing software and method, different forms of wire harness design input data are processed, and a standard, reliable and edit-free process card is output.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention relates to the field of electrical wiring harness manufacturing, such as process design of complex wiring harnesses for aircraft, vehicles, etc., and in particular to a wiring harness process design system. Background Art

[0002] For the complex wire harness processing industry, the principle and appearance design of wire harness products are mostly completed by the design unit of the main engine factory, and transmitted to the wire harness factory in different forms of design input, including Excel, Word, PDF, Auto CAD, Capital Xml and other file formats. The production lines of each wire harness factory use various forms of process specifications or process cards, such as Excel, Word files, etc. Facing different customers, even if it is the same wire harness factory, the process data processing and management methods are not the same. There is a lot of manual document editing and data processing, many processing links, monotonous output file format, and high error rate.

[0003] Most wiring harness factories do not design the principles and appearance of complex wiring harnesses, nor do they use expensive wiring harness design software, such as Capital and other professional software. CAPP software commonly used in the mechanical processing and electronic assembly industries is also not good at handling the process design of complex wiring harness products. The lack of systematic wiring harness process data management will lead to the scattered, unqueryable, non-standardized and low data utilization of wiring harness factory process data, resulting in low work efficiency of designers. Summary of the invention

[0004] In view of the problems existing in the prior art, the present invention provides a wire harness process design system which processes different forms of wire harness design input data through standard, efficient and economical data processing software and methods, and outputs standardized, reliable and edit-free process cards.

[0005] The purpose of the present invention is achieved through the following technical solutions.

[0006] A wire harness process design system, by traversing an Xml file, identifies the node attributes and node structure related to the wire harness process data, creates a data table structure of the wire harness number, connector, tail accessory, connector accessory, conductor, multi-core wire, point position and dead joint; by traversing each node in a targeted manner, reads the process data and writes it into a data table as basic data.

[0007] It is equipped with many types of process data and modules related to the processing of integrated complex wiring harness process data, including cable model and printing parameter management, contact process parameter management, processing tool management, process picture standardization and management, connector hole map management, connector assembly process management, contact crimping code typical process report and typical process editing and management.

[0008] Based on the data table obtained after conversion of the Xml file, after data processing, the process data for production including offline card, conduction relationship card, assembly card, electrical test card and electrical test code are obtained. The electrical test card can delete dead joints, and each process card associates various types of basic processing parameters according to the material model.

[0009] A typical process editing module is provided, which includes: connector structure process editing and general typical process editing. The connector structure code is associated with each general typical process code; the general typical process editing parameterizes the operation steps, tools, parameters and pictures, and through report design, realizes content editing in the software and automatically generates a typical process PDF format file.

[0010] By traversing each Xml file, locating and traversing the Xml data nodes including harnesscontainer, connector, backshell, termination, cavitydetail, pin, terminal, cavityseal, cavitycomponent, wire, wireend, multicore, splice, extranodecomp, identifying the attributes of each node and its child node name, summarizing them into an array of field names in each data table, and creating tXmlHarn, tXmlEquip, tXmlBackshell, tXmlEquipExtraComp, tXmlWire, tXmlMulticore, tXmlPin, and tXmlSplice data table structures.

[0011] Traverse the original Xml files of the whole wiring harness, convert them into Xml data tables, and append them to the database data tables; specifically, traverse the required Xml files, find the connector node, grab each attribute of the connector node, write it into the tXmlEquip data table, and loop to read and write the next connector node.

[0012] Find the backshell child node of the connector node, traverse the backshell properties, and write to the tXmlBackshell data table; find the termination child node of the backshell, traverse the termination node properties and its cavitydetail child node, and write to the tXmlPin data table; find the pin child node of the connector, traverse the pin node properties and its cavitydetail child node, traverse the terminal and cavityseal child nodes of cavitydetail and their properties, traverse the cavitycomponent child node of pin and its properties, and write to the tXmlPin data table; find the wire child node of connectivity, traverse the wire properties, traverse the wireend child node of wire and its properties, and write to the tXmlWire data table. According to the table, traverse the next wire node; find the multicore child node of connectivity, traverse all the properties of multicore, write into the tXmlMulticore data table, and traverse the next multicore node; find the splice child node of connectivity, traverse all the properties of splice, write into the tXmlSplice data table, and traverse the next splice node; find the / / extranodecomp node, find the properties of the parent node node, traverse all the properties of extranodecomp, write into the tXmlEquipExtraComp data table, and traverse the next extranodecomp node; capture the Xml process data and write it into the above-mentioned data tables in the database to form a wiring harness list, connector table, tail attachment table, accessory table, conductor table, multi-core wire table, contact table, and dead joint table for subsequent processing.

[0013] Compared with the prior art, the advantages of the present invention are: 1. The present invention can make full use of the customer's original process data output by Capital wire harness design software, improve the richness of wire harness manufacturing process data and the accuracy and convenience of data processing, and improve the design work efficiency.

[0014] 2. The present invention integrates various basic material process data and data management involved in complex wire harness manufacturing, improves the standardization and reuse of process data, makes data search more convenient, improves process data security, and improves design work efficiency.

[0015] 3. The present invention integrates a process data package for wire harness production, including process cards and equipment script code files, which improves the accuracy of process data, the richness of process cards, and improves design work efficiency and production efficiency.

[0016] 4. The present invention integrates typical process file editing and generation, parameterizes process steps and process data, and eliminates typesetting, thereby improving the management level of typical process data and improving design work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 Design a schematic diagram of the file data processing process for Xml;

[0018] Figure 2 It is the data flow diagram of the software system;

[0019] Figure 3 This is a schematic diagram of the offline card query principle;

[0020] Figure 4 It is a schematic diagram of the principle of conducting relationship card query;

[0021] Figure 5 Query the principle diagram for the connector material card;

[0022] Figure 6 It is a schematic diagram of the relationship between connector structural parameters and various process data;

[0023] Figure 7 This is a flowchart for processing the dead joint conduction relationship. DETAILED DESCRIPTION

[0024] The present invention is described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0025] A wire harness process design system, a wire harness process design software system developed based on Microsoft Office's ACCESS database and SQLSERVER database, is used to convert and process customer wire harness design input, output a complete set of process data packages for production, and integrate typical process file editing and technical status management modules. The ACCESS database is used to identify and extract the XML format output file data of the customer's wire harness design software Capital. By traversing the XML file, the node attributes and node structure related to the wire harness process data are identified, and the wire harness number, connector, tail accessory, connector accessory, conductor, multi-core wire, point position and dead joint data table structure are created. By traversing each node in a targeted manner, the process data is read and written into the data table as the basic data.

[0026] Use ACCESS database to integrate basic process management modules of wire harnesses, including cable specification parameters, connector specifications, connector hole position maps, material specifications and descriptions, connector assembly processes, contact specifications, and contact process data; integrate numerous process data types and modules related to complex wire harness process data processing, including cable model and printing parameter management, contact process parameter management, processing tool management, process image standardization and management, connector hole position map management, connector assembly process management, contact crimping code typical process report and typical process editing and management, etc.

[0027] Use ACCESS database to process customer harness design data, convert and output production cable cutting cards, conduction relationship cards, connector material cards, electrical test cards, test cable connection lists and automatic test script codes; based on the data table obtained after Xml file conversion, after data processing, obtain production process data such as offline cards, conduction relationship cards, assembly cards, electrical test cards and electrical test codes. The electrical test card can delete dead joints. Each process card associates various types of basic processing parameters according to the material model.

[0028] The method of using ACCESS database to edit typical process files for wire harness processing can edit the contents of each chapter of the file, edit the operation steps and process pictures, and automatically output the entire typical process file with pictures and texts, without manual typesetting; the typical process editing module includes: connector structure process editing and general typical process editing. The connector structure code is associated with each general typical process code. The general typical process editing parameterizes the operation steps, tools, parameters and pictures, and realizes content editing in the software through report design, without typesetting, and automatically generates a typical process PDF format file.

[0029] By traversing each Xml file, locating and traversing the Xml data nodes harnesscontainer, connector, backshell, termination, cavitydetail, pin, terminal, cavityseal, cavitycomponent, wire, wireend, multicore, splice, extranodecomp, etc., identifying the attributes of each node and its child node name, summarizing them into an array of field names in each data table, and creating tXmlHarn, tXmlEquip, tXmlBackshell, tXmlEquipExtraComp, tXmlWire, tXmlMulticore, tXmlPin, and tXmlSplice data table structures.

[0030] like Figure 1As shown, this software system traverses the original files in the Xml format of the whole machine harness, converts them into Xml data tables, and appends them to the data tables of the database. Specifically, traverse the required Xml files, find the connector node, grab each attribute of the connector node, write it into the tXmlEquip data table, and loop to read and write the next connector node. Find the backshell child node of the connector node, traverse the backshell attributes, and write it into the tXmlBackshell data table. Find the termination child node of the backshell, traverse the termination node attributes and its cavitydetail child node, and write it into the tXmlPin data table. Find the pin child node of the connector, traverse the pin node attributes and its cavitydetail child node, traverse the terminal and cavityseal child nodes of cavitydetail and their attributes, traverse the cavitycomponent child node of the pin and its attributes, and write it into the tXmlPin data table.

[0031] Find the wire child node of connectivity, traverse the properties of the wire, traverse the wireend child node of the wire and its properties, write to the tXmlWire data table, and traverse the next wire node.

[0032] Find the multicore child node of connectivity, traverse all the properties of multicore, write them into the tXmlMulticore data table, and traverse the next multicore node.

[0033] Find the splice child node of connectivity, traverse all the properties of splice, write to the tXmlSplice data table, and traverse the next splice node.

[0034] Find the / / extranodecomp node, find the attributes of the parent node node, traverse all the attributes of extranodecomp, write to the tXmlEquipExtraComp data table, and traverse the next extranodecomp node.

[0035] The Xml process data is captured and written into the above data tables in the database to form a wiring harness list, connector table, tail attachment table, accessory table, conductor table, multi-core wire table, contact table, dead joint table, etc. for subsequent processing.

[0036] like Figure 2As shown in the figure, this software system integrates various process data and technical status management modules required for complex wiring harness process design. The process data is divided into material attributes and parameters, contact process data, connector process data, test cable data, product material data, and product conduction relationship data. This software system manages various types of process data in a modular manner, realizing data standardization, data connection and reuse.

[0037] like Figure 3 As shown, qXmlWireCableList is a wire table query. Based on the tXmlWire table, the connector position and code information of the tXmlPin table are queried through the pin_id1 and pin_id2 fields, and the multi-core wire model of tXmlMultiCore is queried through mulitwire.

[0038] like Figure 4 As shown, qXmlConnectivity is a conduction relationship query. Based on the tXmlPin table, it queries the wire number, line type, connector position, connector code, cable outer diameter, and adapter solder ring model through id and name.

[0039] like Figure 5 As shown, qXmlEquipExtraComp is a connector material query. tXmlEquipExtraComp queries the connector position, connector code and other information of the tXmlEquip table through connector_id, and then combines it with the tXmlEquip table to obtain the connector material data.

[0040] like Figure 6 As shown, the conduction relationship table qXmlConnectivity queries the connector process table tConnector according to the connector model, and then queries the corresponding test docking cable data in the tTestAdaptor table, queries the test cable address table tCktILine data corresponding to the integrated tester, and queries the typical process file codes in the connector structure table tConstruction. The conduction relationship table calculates the docking cable list, test address mapping table and test code used by the integrated tester through the basic definition of the test docking cable.

[0041] The data of typical processes are located in tables tGPIDescription and tGPIContent. tGPIDescription is used for typical process paragraph content, and tGPIContent is used for the operation steps of typical process files, including step descriptions, tools, parameters, and picture numbers.

[0042] The conduction relationship table queries the contact data and crimping process data in the table tFinishCode through the contact model.

[0043] like Figure 7 As shown, copy the conduction relationship to the temporary table tSplice-Temp1, query the first conduction relationship data between the dead joint and the connector to qSpliceReplace1, use the connector point in the first conduction relationship to replace the dead joint, replace both the source end and the end, delete the invalid conduction data with the same ending after replacement, and obtain the conduction relationship data qXmlManualTest with the dead joint deleted, which is used as manual electrical test or automatic test data.

[0044] Finally, the data of each process card mentioned above is output in report format, completing the process data processing from the Xml file customer input to the production process card package.

Claims

1. A wire harness process design system, characterized in that By traversing the Xml file, identifying the node attributes and node structure related to the harness process data, creating the harness number, connector, tail accessories, connector accessories, wire, multi-core wire, point position and dead joint data table structure; By traversing each node in a targeted manner, the process data is read and written into the data table as the basic data.

2. A wire harness process design system according to claim 1, characterized in that It is equipped with many types of process data and modules related to the processing of integrated complex wiring harness process data, including cable model and printing parameter management, contact process parameter management, processing tool management, process picture standardization and management, connector hole position map management, connector assembly process management, contact crimping code typical process report and typical process editing and management.

3. A wire harness process design system according to claim 1, characterized in that Based on the data table obtained after conversion of the Xml file, after data processing, the process data for production including offline card, conduction relationship card, assembly card, electrical test card and electrical test code are obtained. The electrical test card can delete dead joints, and each process card associates various types of basic processing parameters according to the material model.

4. A wire harness process design system according to claim 1, characterized in that A typical process editing module is provided, which includes: connector structure process editing and general typical process editing. The connector structure code is associated with each general typical process code; the general typical process editing parameterizes the operation steps, tools, parameters and pictures, and through report design, realizes content editing in the software and automatically generates a typical process PDF format file.

5. A wire harness process design system according to claim 1, characterized in that By traversing each Xml file, locating and traversing the Xml data nodes including harnesscontainer, connector, backshell, termination, cavitydetail, pin, terminal, cavityseal, cavitycomponent, wire, wireend, multicore, splice, extranodecomp, identifying the attributes of each node and its child node name, summarizing them into an array of field names in each data table, and creating tXmlHarn, tXmlEquip, tXmlBackshell, tXmlEquipExtraComp, tXmlWire, tXmlMulticore, tXmlPin, and tXmlSplice data table structures.

6. A wire harness process design system according to claim 5, characterized in that Traverse the original Xml files of the whole wiring harness, convert them into Xml data tables, and append them to the database data tables; specifically, traverse the required Xml files, find the connector node, grab each attribute of the connector node, write it into the tXmlEquip data table, and loop to read and write the next connector node.

7. A wire harness process design system according to claim 6, characterized in that Find the backshell child node of the connector node, traverse the backshell properties, and write to the tXmlBackshell data table; find the termination child node of the backshell, traverse the termination node properties and its cavitydetail child node, and write to the tXmlPin data table; find the pin child node of the connector, traverse the pin node properties and its cavitydetail child node, traverse the terminal and cavityseal child nodes of cavitydetail and their properties, traverse the cavitycomponent child node of pin and its properties, and write to the tXmlPin data table; find the wire child node of connectivity, traverse the wire properties, traverse the wireend child node of wire and its properties, and write to the tXmlWire data table. According to the table, traverse the next wire node; find the multicore child node of connectivity, traverse all the properties of multicore, write into the tXmlMulticore data table, and traverse the next multicore node; find the splice child node of connectivity, traverse all the properties of splice, write into the tXmlSplice data table, and traverse the next splice node; find the / / extranodecomp node, find the properties of the parent node node, traverse all the properties of extranodecomp, write into the tXmlEquipExtraComp data table, and traverse the next extranodecomp node; capture the Xml process data and write it into the above-mentioned data tables in the database to form a wiring harness list, connector table, tail attachment table, accessory table, conductor table, multi-core wire table, contact table, and dead joint table for subsequent processing.

Citation Information

Cited By

  • A lithium-rich manganese-based carbonate precursor, its preparation method, and its cathode material

    CN122725379A