Method and system for multilateral validation of wire harness design outputs
09836573 · 2017-12-05
Assignee
Inventors
- Keyur Gupte (Maharashtra, IN)
- Pratap Thorat (Maharashtra, IN)
- Renu Raheja (Maharashtra, IN)
- Tejaswini Kothawade (Maharashtra, IN)
- P V Kaulgud (Maharashtra, IN)
- Shailesh Newase (Maharashtra, IN)
Cpc classification
G06F30/18
PHYSICS
G06F2111/20
PHYSICS
International classification
Abstract
System and Method for multilateral Validation of Wire Harness Design Outputs wherein said method comprises of validating with respect to one another and with respect to component database, the background data files (BDF). Such BDFs are generated by software platforms for creating two dimensional circuit schematic and two dimensional & three dimensional wire harness outputs and are not friendly for use by humans. The system as per said method is a computer program, capable of plugging-in on product Life Cycle management Software suites. The system and method makes validation possible by comparing BDF instead of conventional validation of comparing the technical contents by skilled designers, thus saves need of skilled designers, besides saving time and improving quality of Wire harness Design Outputs.
Claims
1. A method (500) for a multilateral validation of wire harness design outputs, comprising steps of: a. an alphanumeric validation of a first two dimensional output with respect to a component database (100); b. an alphanumeric validation of a second two dimensional output with respect to the component database (100); c. an alphanumeric validation between the first two dimensional output and the second two dimensional output; d. an intrinsic validation within a three dimensional output; e. an alphanumeric validation of the three dimensional output with respect to the component database (100); and f. an alphanumeric validation of the validated second two dimensional output with respect to the three dimensional output, said multilateral validation uses a BDF (Background Data file) (310) of said first two dimensional output, a BDF (210) of said second two dimensional output, a BDF (410) of said three dimensional output, said multilateral validation generates a plurality of output reports (680, 690) of mismatches (629) which include repeats (626) and miss-outs (627), component counts (628, 632), and provides for Output Validation (645), in prescribed formats; wherein said first two dimensional output is a circuit schematic design (300), and said second two dimensional output is a wiring harness drawing (200); and wherein said three dimensional output is a routing and packaging assembly (400).
2. The method (500) for the multilateral validation of wire harness design outputs as claimed in claim 1, wherein said alphanumeric validation is for a common information contained in the BDF (310) of the first two dimensional output, the BDF (210) of the second two dimensional output, the BDF (410) of the three dimensional output.
3. The method (500) for the multilateral validation of wire harness design outputs as claimed in claim 1, wherein said Circuit Schematic design (300) having the BDF (310) is validated with respect to the Component Database (100), taking the Component Database (100) as reference.
4. The method (500) for the multilateral validation of wire harness design outputs as claimed in claim 1, wherein said Wire harness Drawing (200) having the BDF (210) is validated with respect to the Circuit Schematic design (300) having the BDF (310) and where neither of the BDFs (210) of the wire harness Drawing (200) nor the BDF (310) of the Circuit Schematic Design (300) is considered as reference.
5. The method (500) for the multilateral validation of wire harness design outputs as claimed in claim 1, wherein the routing & packaging assembly (400) having the BDF (410) is intrinsically validated within a three-dimensional software suite.
6. The method (500) for the multilateral validation of wire harness design outputs as claimed in claim 1, wherein the Wire Harness drawing (200) having the BDF (210) is validated with respect to the routing and packaging (400) having the BDF (410).
7. The method (500) for the multilateral validation of wire harness design outputs as claimed in claim 1, wherein said alphanumeric validation is for a plurality of attributes (110) of a plurality of components (630).
8. The method (500) for the multilateral validation of wire harness design outputs as claimed in claim 1, wherein said Output validation (645) is of reported mismatches attended.
9. A system (600) for multilateral validation of wire harness design outputs, in the form of a computer program residing on a computer processor, the computer processor being part of a computer system, comprising of: one or more non transitory computer readable storage media having computer-executable instructions of a product life cycle management, abbreviated as a PLM (700) embodied thereon, wherein the computer program, plugged in the PLM (700), when invoked, causes, as per user interface selection, execution of the multilateral validation between a first two dimensional output to a second two dimensional output and the multilateral validation of a validated second two dimensional output to a three dimensional output, with respect to one another and with respect to a component database (100) in the form of: (a) an alphanumeric validation of a BDF(Background Data file) (210) of a two dimensional wire harness drawing (200), with respect to a BDF (310) of a two dimensional circuit schematic design (300) and a Component Database (100); (b) an intrinsic validation of a three dimensional Routing & Packaging assembly (400); and (c) an alphanumeric validation of a BDF (210) of a two dimensional wire Harness drawing (200) with respect to BDF (410) of a three dimensional routing & Packaging assembly (400); the alphanumeric validations is for a plurality of component (630), the multilateral validation executable in batches or interactively, the multilateral validation being a custom-built validation, unilateral and or bilateral, generates a plurality of output reports (680, 690), mismatch (629) includes miss-outs (627) and repeats (626), counts (628, 632) and provides for Output validation (645); wherein said first two dimensional output is a circuit schematic design (300), and said second two dimensional output is a wiring harness drawing (200); and wherein said three dimensional output is a routing and packaging assembly (400).
10. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said alphanumeric validation of the BDF (210) of the Wire harness Drawing (200), the BDF (310) of the Circuit Schematic Design (300), of the BDF (410) of the Routing and Packaging assembly(400) is for a plurality of attributes (110) of the plurality of component (630).
11. The system for the multilateral validation of wire harness design outputs as claimed in claim 10, wherein alphanumeric validation of the BDF (210) of the Wire harness Drawing (200), the BDF (310) of the Circuit Schematic Design (300), and the BDF (410) of the Routing and Packaging assembly (400) is a combination check (642C) of a plurality of attributes (110).
12. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said intrinsic validation is for a mass property (652) and an incomplete connection (655) in the three dimensional routing and packaging assembly (400).
13. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said plurality of Output reports (680, 690) for the alphanumeric validation of the BDF (210) of the Wire harness Drawing (200), the BDF (310) of the Circuit Schematic Design (300), and the BDF (410) of the Routing and Packaging assembly (400) for a plurality of wire (631) gives a mismatch in count (632), a mismatch in size (633), a mismatch in TO information (634), a mismatch in FROM information (635), a wire (631) absent in the BDF (310) of the Circuit Schematic Design (300) but present in the BDF (210) of the Wire harness Drawing (200), the wire (631) with a missing instance name (112).
14. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said plurality of Output reports (680, 690) for the alphanumeric validation of the plurality of component (630) other than a plurality of wire (631) gives the miss-out (627), the repeat (626), as the mismatch (629).
15. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein any or all validation checks are user selectable.
16. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said plurality of Output reports (690) for the intrinsic validation is of an incomplete connection (655) and gives count of an unconnected wire or a component (630) other than a plurality of wire (631).
17. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said plurality of Output reports (690) for the intrinsic validation is of a Mass property (652) and gives a value of the Mass property (652) as zero or non-zero.
18. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said plurality of Output reports (680, 690) is at an identified memory location.
19. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said Output validation (645) is of a reported mismatch (629) attended.
20. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said Output validation (645) is version wise based on an option code.
21. The system for the multilateral validation of wire harness design outputs as claimed in claim 9, wherein said BDF (210) of the Wire harness Drawing is in a DSI format as a WH DSI (220) and wherein said BDF (310) of the Circuit Schematic Design (300) is in a DSI format as a CKT DSI (320).
Description
DESCRIPTION OF DRAWINGS
(1)
(2)
(3)
(4)
(5)
(6)
(7)
(8)
(9)
(10)
(11)
(12)
(13)
(14)
(15)
(16)
(17)
(18)
(19)
(20)
(21)
(22)
(23)
(24)
(25)
(26)
(27)
(28)
(29)
(30)
(31)
(32)
DETAILED DESCRIPTION OF THE INVENTION
(33) In the foregoing description, following terms mean as follows—
(34) Wire harness—a bunch of wires, whether conventional or optical or any other kind, capable of carrying electrical power and or signals, and the bunch may also include fluid tubes, capable of carrying any fluid; the ends of wires and tubes may be prepared so as to be directly connectable to intended device. In other words, the term “wire harness” is not restricted to electrical wires only.
(35) Wire—Conventional wire or optical wire or any other kind of physical conductor, also non-conductor and or hollow/solid tubes.
(36) Components—All materials required and used in a wire harness is termed as components. Components non-exhaustively include wire, connector, clip, terminal, splice, grommet.
(37) Component database, also called CDS—Component database, also termed as CDS, is a data file containing identification parameters, termed as attributes, of all the components which are required in the manufacture of a wire harness. Such a Component database is usually proprietary of organizations. Attributes illustratively described in present invention are
(38) (a) Part number—unique alphanumeric identification assigned to every component viz. Wire, Connector, Terminal, Grommet, tie, clip, splice, etc.
(39) (b) Instance name—unique alphanumeric identification assigned to every component for each specific use in a wire harness.
(40) Every component has a unique part number but has multiple instance name, each corresponding to a specific use. For example, in a vehicle, a particular connector may be used for both left head lamp as well as right head lamp in a wire harness. The part number shall be the same for both instances of use, while the instance name shall be different.
(41) Component database at times also contains identification numbers of sub-suppliers, and any other attribute which the owner organisation requires for efficient manufacturing related processing.
(42) Routing & Packaging Assembly, Also Called 3D CAD—
(43) Routing and packaging assembly, also called 3D CAD, is a three dimensional model of a wire harness output with dimensional details. Thus, it is a three dimensional output. Such three dimensional model provides space requirement related information related to an equipment, for example, a vehicle, where the manufactured wire harness is required to be installed. The three dimensional model contains bill of material of all components used therein. This is a mechanical computer aided design and is therefore also termed as MCAD. For the purpose of describing present innovation, reference is made to a known three-dimensional modelling computer aided design software suite CATIA V5 from Dassault Systems.
(44) Circuit Schematic Design—
(45) Circuit Schematic Design is a Logical Connectivity diagram created on a software platform, which represents the connectivity of devices to one another. For the purpose of describing the present invention, reference is made to Vesys Design, Capital Logic of Mentor Graphics; used for creating Circuit Schematic Diagram.
(46) Wiring Harness Drawing—
(47) Wiring Harness Drawing is a two-dimensional drawing created on a software platform for Wiring Harness Manufacturing. Wiring Harness Drawing represents the Form board Layout of Wiring Harness to be manufactured. For the purpose of describing the present invention, reference is made to VeSys Harness, Capital Harness XC of Mentor Graphics.
(48) Circuit Schematic Design and Wiring Harness Drawing are referred to as electrical computer aided designs (ECAD). Both of them are two dimensional outputs. The Circuit Schematic Design is referred to as a first two dimensional output and the Wiring harness Drawing is referred to as a second two dimensional output.
(49) Background Data File—
(50) Background data file, abbreviated as BDF, is an alphanumeric data file corresponding to contents of two dimensional Circuit Schematic design and two dimensional wire harness drawing. Files with “.DSI” extension, where DSI means “Design System Interface”, “.XML” extension, where XML stands for “Extensible Mark-up Language” are non-exhaustive illustrations of such alphanumeric data files. Such files get created in the background as the known software suites are used to generate Circuit Schematic Design, Wire harness drawing and other such output, generable from specific software suite. Such file formats are used for transferring data across various software. Such files are NOT friendly for direct use by humans.
(51) BDF of three dimensional model is also accessible from the MCAD file by application program interface, by which the BDF is taken from the downloaded Routing & Packaging Assembly.
(52) Circuit DSI, Also Called CKT DSI—
(53) A circuit DSI, also referred to as CKT DSI, is a kind of a BDF that contains all the extracted data from Circuit Schematic which needs to be validated. XML file format is also alternatively used. A Circuit DSI file corresponds to an electrical computer aided design and is therefore also termed an ECAD.
(54) Wiring Harness DSI, Also WH DSI—
(55) A wiring harness DSI, also referred to as WH DSI file is a kind of a BDF that contains all the extracted data from Wiring Harness Drawing which needs to be validated. XML file format is also alternatively used. It is also termed as an ECAD.
(56) Option Code—
(57) Option code is a code assigned to a specific feature in a wire harness. Illustratively, a specific device in equipment, say a vehicle, shall have a group of wires. Such devices are generally optional or specific to a particular version of the equipment. Codes, like −N, −Q, assigned to identify such a specific feature is Option Code.
(58) The two dimensional outputs and three dimensional outputs referred to in this invention are essentially developed using different known software platforms/suites and are also commonly referred to as computer aided designs.
(59) The invention shall now be described with the help of drawings and illustrations, which should be construed merely for description and not for limiting the invention. One skilled in the art will understand that the present invention may have additional embodiments, or that the present invention may be practiced without several of the details described in the following description.
(60) The present invention is a system and method for multilateral validation of wire harness design outputs, comprising the steps of: a. alphanumeric validation of a first two dimensional output with respect to a component database (100); b. alphanumeric validation of a second two dimensional output with respect to the component database (100); c. alphanumeric validation between the first two dimensional output and the second two dimensional output; d. intrinsic validation within a three dimensional output; e. alphanumeric validation of the three dimensional output with respect to the component database (100); and f. alphanumeric validation of a validated second two dimensional output with respect to the three dimensional output,
(61) The mismatches found consequent to validations, which include repeats and miss-outs, are reported as output reports in prescribed format as errors.
(62) A two dimensional output and a three dimensional output is generally generated on altogether different and unconnected software platforms. Furthermore, designers need altogether different skill sets to work on a two dimensional software platform or a three dimensional software platform and in all likelihood are two different persons. A two dimensional as well as a three dimensional computer aided design output is not comparable statistically and is only suited for visual checks with thorough content understanding. Validation of such outputs requires skill more or less of the same order as that of the designer. Present invention recognises that corresponding to ECAD as well as MCAD outputs, here, a two dimensional wire harness drawing, a two dimensional circuit design, as well as a three dimensional Routing & Packaging assembly, the present software suites correspondingly create a BDF containing details of non-graphical matter. The present invention makes use of them for alphanumeric comparison and alphanumeric validation.
(63) A method as per present invention is to compare and validate such alphanumeric data, interpret and create actionable report.
(64) As pictorially shown in
(65) (1) a wiring harness drawing (200),
(66) (2) a circuit schematic design (300) and
(67) (3) a routing and packaging assembly (400)
(68) which are designed independently, having common information, and such common information needs to match exactly.
(69) The common information non-exhaustively comprises of Inputs decided by designer, example—length of wires, selection of components, number of components Attributes (110) from Component Database (100)
(70) The common information is contained in a plurality of BDFs (210, 310, 410). The wiring harness drawing (200) has a BDF (210), the circuit schematic design (300) has a BDF (310) and the Routing and Packaging Assembly (400) has a BDF (410). Attributes (110) from Component database (100) are contained in the circuit schematic (300), wire harness drawing (200) as well as in the routing and packaging (400). Wire length information from routing & packaging (400) is validated in the circuit schematic (300).
(71) A plurality of mismatch and thus error crops in due to different personnel creating and due to the fact that in reality each output has hundreds of attributes (110) and wire harness related information, like length, size and kind of wires.
(72) As shown in
(73) The outcome of the method as per present invention is the error free BDF (210) of wire harness drawing (200), here WH DSI (220), and consequently the wire harness drawing (200), which is eventually used for manufacture of wire harness.
(74) As is easily relatable by the definitions given before, WH DSI (220) is a specific form of BDF (210) of the Wire Harness Diagram (200), the “DSI” being a file extension of a kind. Likewise, CKT DSI (320) is a specific form of BDF (310) of the Circuit Schematic Design (300), the “DSI” being a file extension of a kind.
(75) A system for a multilateral validation of wire harness design outputs, as per the method (500) of present invention is in the form of a computer program residing on a computer processor, the computer processor being part of a computer system, comprising of one or more computer readable storage media having computer-executable instructions of a product life cycle management, abbreviated as a PLM (700) embodied thereon, wherein the computer program, plugged in the PLM, when invoked, causes, as per user interface selection, execution of validation as described below. The validation has innumerable numbers of possible combinations, depending on contents and attributes (110) of the component database (100), which varies from organisation to organisation. The validation is, thus, a custom-built validation, unilateral and or bilateral. The system (600) generates a plurality of Output reports—mismatch reports which includes miss-outs and repeats, count reports; and facilitates validation of Output reports.
(76) As shown in
(77) The system (600) is named “EQWIC” (610) for describing present invention and therefore “EQWIC” (610) means the system (600) as per present invention throughout this description and in accompanying drawings. “EQWIC” (610) is operable on a computer processor. The computer processor causes the “EQWIC” (610) to execute the validation as per method of present invention.
(78) The “EQWIC” (610) is in the form of a “plug-in” which can be installed in any known Product Life Cycle Management (PLM) tool (700). For the purpose of describing here, the illustration is done using “TEAMCENTER”, which is a known Siemens PLM Software.
(79) A hypothetical and oversimplified illustrative wire harness is created to explain the inventive steps of the method (500) and the system (600) named “EQWIC” (610).
(80) Person skilled in the art can appreciate the intense technical contents of
(81) While a lot of contents are common amongst these two dimensional and three dimensional outputs, it is impossible to identify them without complete understanding of the electrical and mechanical aspects of these two dimensional and three dimensional outputs. On the other hand, the content of
(82) As shown by a higher level flow diagram in
(83) (1) Two dimensional to two dimensional, abbreviated as 2D-2D (620)
(84) (2) Two dimensional to three dimensional, abbreviated as 2D-3D (650)
(85) A set of Output reports (680, 690) are generated from each validation.
(86) On selecting the option of 2D-2D (620) validation, the “EQWIC” (610) prompts for following user inputs as shown in
(87) As shown in
(88) As shown in
(89) As shown in
(90) Following is reported as Output report (680), as shown in
(91) For wires, following are also reported as shown in
(92) 2D-3D validation involves the BDF (410) of the Routing & packaging assembly (400), Wire Harness DSI (220) of the Wire Harness Diagram (200) and Component database (100); and is performed on validated Wire Harness DSI (220), that is, after performing and duly correcting the Wire Harness DSI (220) as per Output reports (680) of 2D-2D validation.
(93) As shown by flow diagram in
(94) Downloading (625) pertains to the Routing & Packaging Assembly (400).
(95)
(96) 1. Connector check (638C)
(97) 2. Combination check (642C)
(98) 3. Clip check (641C)
(99) 4. Unidentified parts check (643C)
(100) 5. Incomplete Connection check (655C)
(101) 6. Grommet check (639C)
(102) 7. Splice check (640C)
(103) 8. Wire check (631C)
(104) 9. No of wires routed (632C)
(105) 10. Mass property check (652C)
(106) Combination (642) implies more than one attribute (110). Apropos, Combination Check (642C) is an illustration of custom-built validation, wherein more than one attributes is checked as a combination and mismatch, which includes miss-out and repeat, is reported as Output (690). Combination check (642C) is applied as per specific requirement for any or all component (630), either independently or as part of any check.
(107) Any or all of the validation/check can be selected by user selection, as illustrated by
(108)
(109)
(110)
(111)
(112)
(113) Incomplete connection check (655C) is a feature known and commonly available in known three dimensional software suit. The plug-in “EQWIC” (610) optionally invokes Incomplete Connection check (655C) by prompting for selection of this validation requirement and eliminates the possibility of oversight of a designer not performing and thus not applying Incomplete Connection validation, though available.
(114)
(115) Essentially, the “EQWIC” (610) plug-in causes
(116) a) Reading of part number in Routing & Packaging assembly (400); and reading of corresponding part number (111) in Component Database (100)—see (639a) b) Looking for “Grommet” (639) in Component Database (100)—see (641b) c) Increment the count of when “Grommet” (639) is found d) Report Grommet Count (690).
(117)
(118)
(119)
(120) Incomplete Connection Check (655C) and Mass property Check (652C) are generally available in the three dimensional software suites. These checks are incorporated in the present invention so as to have a robust system providing comprehensive validation. Mass proper check (652C) and Incomplete connection check (655C) are therefore grouped as intrinsic validation.
(121)
(122) The plug-in provides for a version wise Output Validation, using option code (646). Version wise output validation means that the user selects a version of the equipment and enters the update.
(123) The term multilateral validation includes alphanumeric validation and intrinsic validation and at times mentioned interchangeably with validation, whether unilateral or bilateral.
(124) The method and system as per present invention replaces human intelligence, hitherto needed to cross validate intensely complex engineering outputs; by BDFs, which a human CANNOT read efficiently. Also, the method and system produces error free validation, which is not guaranteed by natural, nor artificial intelligence.
(125) The system as per present invention is ancillary to complex PLMs, two-dimensional and three-dimensional software suites, which are hugely complex software suites supplementing human capabilities, which our plug-in further complements by providing a validation link between them by using BDFs generated by them.
(126) Our inventive system for multilateral validation of wire harness design outputs, which is a “plug-in” on a PLM, is installable on specific hardware and or workstations which support industrial PLM tools, example—workstation with 64 bit operating system, NVIDIA Quadro 4000 2 GB GFX Special, and upwards.