HarnesSys User Manual For Import Libraries
Contents
1. Vendo seisis e LD Part Specificati 16 art Specification Part DESCTIP HI ON ssteissi sess esaee eee a i LO Mating Connector 18 Shell 19 E E 0 2 5 STEN PPN 1 9 Contact Conecto esineisiin aaia aiaa 20 Contaci Seeerei SPT VOPR Termination Cod 27 ermination 608 Al P t N b f T i i C 2 ternate Part Numbers for Termination Codes 9 Combined Termination Cod 29 ombined Term2. 38 Figure 9 Single Import Dialog sseesseeeseeseseeesreserserssrsresstestsersstesttstesstestsstenseestestensetstesriestesreseeesee 40 Import Libraries Page 6 Revision D_1 Import Libraries User Manual General Introduction This user guide describes the instruction for importation of the Part Wire Termination code Box Signal Libraries from a legacy system into the HarnesSys The user guide is applicable to HarnesSys version r18a 06 and above Audience This manual is written for those HarnesSys users that are in charge of the importation of foreign wire harness information into a HarnesSys database project typically information system personnel database administrator and legacy system administrator It assumes a comprehensive grasp of the HarnesSys concepts basic familiarity with UNIX and ability to understand the nature and content of the information to be imported Scope This importer could be used for Part Spec Wire Spec Termination Code and Box Signal libraries Organization This document is organized in several major sections as follows Introduction to the Importer its goal scope and principles ik The Part Wire Termination code Box Signal file data structure and sample A presentation of the Importer user interf
3. Record type BOX SIGNAL ICD Table BOX_SIGNALS Keyword Type Must Remarks BOX PART NUMBER string YES Reference to the PART NUMBER of the box in the table PART SPEC CONNECTOR NAME string Reference to the CONNECTOR NAME of the table BOX INTERFACES CONTACT NAME string YES Should match CONTACT KEY CONTACT SEQ NUMBER number Sequence in which contact names are displayed SIGNAL NAME string DIRECTION number Possible values Meaning 1 OUT 2 IN 3 OUT IN 4 FROM 5 TO 6 FROM TO 7 XMT 8 RCV 9 TR EMI string From EMI RULES table GAUGE string Should match CONTACT KEY USAGE string Should match CONTACT KEY SPEC_STATUS string SPARE if the contact is spare or left null LONG_SIGNAL_NAME SIGNAL_TYPE_ANALOG_DIG ANALOG or DIGITAL VOLTAGE_NOM number VOLTAGE_MIN number VOLTAGE_MAX number VOLTAGE_UNITS string V or mV CURRENT_NOM number CURRENT_MIN number CURRENT_MAX number CURRENT_UNITS string A or mA FREQUENCY number FREQUENCY_MIN number FREQUENCY_MAX number FREQUENCY UNITS string Hz or kHz or MHz or GHz IMPEDANCE number IMPEDANCE UNITS string OHM NOTE string Import Libraries Page 32 Revision D 1 Import Libraries User Manual Sample BOX SIGNAL BOX PART NUMBER lt value gt CONNECTOR NAME lt value gt CONTACT NAME lt value gt CONTACT SEQ NUMBER lt value gt SIGNAL NAME lt value gt DIRECTION lt value gt EMI lt value gt GAUGE lt valu
4. Keywords are fixed strings of upper case characters The list 9 has one or more lines If a field does not contain data it may be omitted The program will issue an error message and the problematic part terminator wire spec contact key will be rejected Mandatory and Optional fields Some of the fields in the transaction file are mandatory must and some are optional Some fields are mandatory in certain context only A default value may be given to optional fields that are absent All this information is provided for each type of transaction type Import Libraries Page 8 Revision D_1 Import Libraries User Manual Field information For each specific transaction file document a table describes the keywords and their values Such a table has the following columns Description Keyword List A keyword whose field type is a list The authorized keywords in this list are then presented in the following rows of the table Keyword The field keyword upper case only Each keyword is declared within the context of its keyword list The field type within the transaction file e g number string Must If marked YES this keyword is mandatory in the transaction file record when its list is present Otherwise i e marked N No or cell left blank it is optional The mark N is placed to stress that the field is not mandatory Interpretation of Must is context dependent as explained in the note below Mandatory field
5. MAJOR lt value gt SUB lt value gt Import Libraries Page 19 Revision D_1 Import Libraries User Manual DEGREE lt value gt PIN_NAME lt value gt SEQ lt value gt LAST_IN_ROW2 lt value gt Contact Connection These records serve to declare the internal electrical connections within a part Record type CONTACT CONNECTION ICD Table CONTACT CONNECTION Keyword Type Must Remarks CONNECTION KEY number YES DEVICE TYPE string YES PIN IN string YES PIN OUT string YES WORK MODE string YES DC VALUE number DC UNITS string AC VALUE number AC UNITS string V DROP number TRIGGER VALUE number TRIGGER UNITS string SELF LOCK string ACTIVATE IN string ACTIVATE OUT string Sample CONTACT CONNECTION CONNECTION KEY lt value gt DEVICE TYPE lt value gt PIN IN lt value gt PIN OUT lt value gt WORK MODE lt value gt DC VALUE lt value gt DC UNITS lt value gt AC VALUE lt value gt AC UNITS lt value gt V DROP lt value gt TRIGGER VALUE lt value gt TRIGGER UNITS lt value gt SELF LOCK lt value gt ACTIVATE IN lt value gt ACTIVATE OUT lt value gt Import Libraries Page 20 Revision D_1 Import Libraries User Manual C Contacts These records serve to import sets of contacts called contact keys Record type CONTACTS ICD Tables MIL USAGE CONT_KEY_GROUPS CONT_KEY_GROUP_CONTACTS CO
6. 27 Revision D 1 Import Libraries User Manual Keyword Type Must Remarks MIN WIRE AWG string For lugs pins or socket types Per convention in the importer for pin or socket types this field is interpreted as the minimum wire gauge specific to this terminator in other words this terminator does not accommodate wires according to the table WRE ACCOMMODATION MAX WIRE AWG string For lugs pins or socket types specific to this terminator in other words this the table WIRE_ ACCOMMODATION MIN WIRE OUT D number For caps and solder sleeves MAX WIRE OUT D number For caps and solder sleeves NOTE string DESCRIPTION string LEAD AWG string For solder sleeves with lead WEIGHT number The combinations of valid types and subtypes for terminators are presented here Type Sub Type Description PIN Pin SOCKET Socket LUG SINGLE W Lug designed to accept a single wire LUG MULTI W Lug designed to accept more than one wire SPLICE BUTT Splice wires come from two opposite directions SPLICE STUB Splice all wires come from same direction CAP Cap and Stow SLDSLV LEADLESS Solder sleeve leadless SLDSLV WITHBRD Solder sleeve with braid SLDSLV WITHLEAD Solder sleeve with lead SOLDER Soldering process SEALPL Sealing Plug without pin OTHER Term code that is not one of the above listed types Figure 4 Valid
7. CONTACT_NAME string YES A single contact e g A or insert arrangement formula e g A ZA 1 0 Q 1 10 BB CONTACT_TYPE string PIN or SOCKET relevant when CONTACT STYLE PLUG WIRE_BARREL number The field may be filled automatically during terminators match for plugs WIRE_PART NUMBER string The field may be filled automatically during terminators match for plugs USAGE string From CODE_DETAIL table where code USAGE Possible Values Meaning PWR POWER CX COAX TX TRIAX TW TWINAX FB FIBRE OPTIC QDRX QUADRAX TC AL Alumel TC CN Constantan TC CR Chromel TC CU Copper TC FE Iron NUMBER_OF_WIRES number MANUAL_TERM_CODE string MIN CMA number Relevant for STUD only MAX CMA number Relevant for STUD only MIN WIRE AWG string Relevant for STUD only MAX WIRE AWG string Relevant for STUD only STANDARD CONTACT string Is the contact provided together with the part or not Possible Values Meaning Import Libraries Page 22 Revision D_1 Import Libraries User Manual Keyword Type Must Remarks Y contact supplied with part N contact is not supplied w part per default Y if contact style is set to PLUG otherwise N Sample for manual method CONTACTS CONTACT KEY NAME lt value gt CONTACT_STYLE lt value gt INSTALLATION_TYPE lt value gt PIN ARRANGE NAME lt value gt
8. D_1 Import Libraries User Manual User Interface Invocation The import program is initiated from the harness ansi menu At the operating system prompt enter harness ansi Figure 6 Invocation of harness ansi operations Then the system displays the following menu Ansi terminal Options 1 file_convert 2 csr_convert 3 importer 4 drawing_generator 5 flag_legend_check 6 Exit or Select option number Figure 7 harness ansi Options By selecting option 3 the HarnesSys Importer function is chosen Importer Main Menu The Importer main menu looks like this Importer to HarnesSys 1 Import one single transaction file at a time 2 Define a scenario sequence of import operations 3 Run a scenario Q Quit Select option gt gt gt Figure 8 HarnesSys Importer Main Menu Import Libraries Page 38 Revision D_1 Import Libraries User Manual Option 1 Import one single transaction file at a time This option imports transaction import files one by one For most cases the user interaction is presented below Variations are described afterwards Menu prompts Enter Project 3 letters gt gt gt 1 Import Documents 2 Import Part Occurrences 3 Tabular Schematics operations 4 Import Free Pins 5 Import Manufacturing Data 6 Import ETA Test Bundle 7 Import Circuit Analyzer 8 Import Retrofit Condition Notes 9 Import Box Signals Part Wire Spec Librarie
9. MIL_SER lt value gt Import Libraries Page 30 Revision D 1 Import Libraries User Manual Box Interfaces These records serve to define box interfaces 1 6 those interface elements to which external parts and wires can be connected There is one record per interface element connector stud terminal board or pig tail of the box specification Record type BOX INTERFACES ICD Table BOX INTERFACES Keyword Type Must Remarks BOX PART NUMBER string YES Box part number CONNECTOR NAME string YES Generic name for interface element not designator from part occurrence e g 11 or J2 RECEPT CONN PART NUMBER string Box Interface element P N MATING CONN PART NUMBER string Mating P N CONTACT TYPE string Possible values _ Meaning CONNECTOR _ Connector STUD Stud TB TB PIGTAIL Wire pigtail MATING string Generic name for mating identification not designator from part occurrence e g Pl or P2 Sample BOX_INTERFACES BOX_PART_NUMBER lt value gt CONNECTOR_NAME lt value gt RECEPT CONN PART NUMBER lt value gt MATING CONN PART NUMBER lt value gt lt value gt lt value gt CONTACT TYPE MATING Import Libraries Page 31 Revision D 1 Import Libraries User Manual Box Signals These records serve to define signals of an interface element of a box specification
10. in the VENDOR table Sample ALTERN_TERM_PN PART NUMBER lt value gt ALTERN PART NUMBER lt value gt VENDOR_CODE lt value gt Combined Termination Codes These records serve to import components of combined terminators Record type COMBO_TERM_PN ICD Table COMBINED_TERM CODE COMP Import Libraries Page 29 Revision D_1 Import Libraries User Manual Must Remarks i of several terminator components COMPONENT_TERM_P_N SEQ LINE NUMBER number The order in which the components will be displayed for the combined terminator LOCATION IN COAX TRIAX string Possible values Sample COMBO_TERM_PN PART_NUMBER lt value gt COMPONENT_TERM_P_N lt value gt SEQ LINE NUMBER lt value gt LOCATION IN COAX TRIAX lt value gt MIL Usage These records serve to define associations between connector standards and part specifications terminators contact keys Record type MIL USAGE ICD Table MIL USAGE Keyword Type Must Remarks OBJECT_ID string YES Value of existing CONTACT KEY NAME in table CONT_KEY_GROUPS or Value of existing PART_NUMBER of a Terminator in table TERM_CODES or Value of existing PART_NUMBER for Part Specification in table PART_SPEC OBJECT TYPE string YES CONTACT or TERM or SPEC MIL_STND string YES MIL_SER string Sample MIL_USAGE OBJECT_ID lt value gt OBJECT_TYPE lt value gt MIL_STND lt value gt
11. types and sub types of terminators Sample TERM_CODES TERM_CODE lt value gt PART_NUMBER lt value gt TYPE lt value gt SUBTYPE lt value gt VENDOR_CODE lt value gt AWG lt value gt WIRE_BARREL lt value gt Import Libraries Page 28 Revision D_1 Per convention in the importer for pin or socket types this field is interpreted as the maximum wire gauge terminator does not accommodate wires according to Import Libraries User Manual WIRE PART NUMBER lt value gt WIRE PART NUMBER lt value gt WIRE PART NUMBER lt value gt USAGE lt value gt ENVIRON COND lt value gt COLOR lt value gt WIRE METAL lt value gt MIN CMA lt value gt MAX CMA lt value gt MIN N OF WIRES lt value gt MAX N OF WIRES lt value gt STUD lt value gt MIN WIRE AWG lt value gt MAX WIRE AWG lt value gt MIN WIRE OUT D lt value gt MAX WIRE OUT_D lt value gt NOTE lt value gt DESCRIPTION lt value gt LEAD AWG lt value gt WEIGHT lt value gt Alternate Part Numbers for Termination Codes These records serve to import alternate part numbers for terminators Record type ALTERN TERM PN ICD Table ALTERN TERM PART NUM Must Remarks PART NUMBER string The terminator P N for which an alternate is declared here ALTERN PART NUMBER The alternate P N for the above terminator P N VENDOR CODE Reference to the Vendor code
12. ACT_NAME string YES A single contact e g A or insert arrangement formula e g A ZA 1 0 Q 1 10 BB NUMBER_OF_WIRES number MIN CMA number Relevant for STUD only MAX CMA number Relevant for STUD only MIN WIRE AWG string Relevant for STUD only MAX WIRE AWG string Relevant for STUD only STANDARD CONTACT string Is the contact provided together with the part or not Possible Values Meaning Y contact supplied with part N contact is not supplied w part per default Y if contact style is set to PLUG otherwise N Sample for the automatic method CONTACTS CONTACT KEY NAME lt value gt CONTACT STYLE lt value gt INSTALLATION TYPE lt value gt PIN ARRANGE NAME lt value gt MIL STND lt value gt MIL SER lt value gt CONTACT NAME lt value gt AWG lt value gt First insert arrangement STANDARD CONTACT lt value gt Import Libraries Page 24 Revision D_1 Import Libraries User Manual CONTACT_NAME lt value gt AWG lt value gt Second insert arrangement STANDARD CONTACT lt value gt Example for the automatic method AS a pre requisite to automatic assignment let us assume that termination codes were previously imported via the following lines TERM_CODE TERM_CODE PIN_1 PART NUMBER PIN_1_ PN TYPE PIN AWG 20 WIRE BARREL 20 USAGE PWR MIL_USAGE MIL_STND 38999 MIL_SER OBJECT_ID PIN_1 OBJECT TYPE TERM M
13. CRIPTION e ERROR MESSAGE CODES The following library tables usually hold such a small amount of information that it is as simple to fill them with HarnesSYS interactively e AREA CODE e BRAID EMI RULES Some library tables were used in the past to support the old terminator functionality It is now strongly recommended to use the new terminator functionality which uses a different set of tables supported by this importer When using the new terminator functionality just ignore the following tables BINCODE BINCODE AWG BINCODE RATING BINCODE TOOL BINGROUP CONTACT PINBINCODE TOOL Import Libraries Page 11 Revision D 1 Import Libraries User Manual 5 The following tables are not used now BUS EXPERT_WIRES2LUG PART_SPEC_SYMBOL PART_SPEC_SYMBOL_CONTACT POWER_SOURCE RATING 6 The following tables have no import mechanism so far GLOB PIN ARRANGE MAP GLOB PIN ARRANGE MIL STND GLOB PIN ARRANGE PIC MFG PROCESS PART SPEC LOAD PART SPEC ASSEMBLY TERM CODE MULT USAGES e TOOLS For more details about the HarnesSYS database tables please refer the latest ICD manual Precedence Rules In order to avoid inconsistent data conflicts the Connector Standards MIL_STDS records must be imported in a separate file prior to any other imports If during import of entities that refer to the Connector Standards wire specs terminators contact keys the program detects a MIL_USAGE reference to a connector
14. EY SLEEVE CODE lt value gt TMS SLEEVE CODE lt value gt MARKABLE WIRE lt value gt USAGE lt value gt WIRE STYLE lt value gt SHIELD LAYERS lt value gt CONDUCTORS NUM lt value gt PLATING lt value gt OUTER INSULATION lt value gt H CABLE lt value gt WIRE DIAMETER lt value gt IMPEDANCE lt value gt BASIC WIRE PART NUMBER lt value gt Import Libraries Page 36 Revision D 1 Import Libraries User Manual Wire Spec Color These records serve to import colors and usages of basic wires of a cable Record type WIRE SPEC COLOR ICD Table WIRE SPEC COLOR Keyword Type Must Remarks PART NUMBER string YES WIRE SPEC PART NUMBER WIRE _SPEC_COLOR PART NUMBER COLOR string YES USAGE string From CODE_DETAIL table where CODE USAGE and VALUE like TC Sample WIRE_SPEC_COLOR PART NUMBER lt value gt COLOR lt value gt USAGE lt value gt CABLE These records serve to import the components of a hybrid cable Record type CABLE ICD Table CABLE Keyword Type Must Remarks CABLE NUMBER string YES WIRE SPEC PART NUMBER CABLE CABLE_ NUMBER PART NUMBER string YES QTY number WIRE IDENT string SEQUENCE number Sample CABLE CABLE NUMBER lt value gt PART NUMBER lt value gt QTY lt value gt WIRE_IDENT lt value gt SEQUENCE lt value gt Import Libraries Page 37 Revision
15. IL_USAGE MIL_STND 38999 MIL_SER I OBJECT_ID PIN 1 OBJECT TYPE TERM TERM CODE TERM CODE PIN 2 PART_NUMBER PIN_2 P N TYPE PIN AWG 22 WIRE_BARREL 22 USAGE PWR MIL_USAGE MIL_STND 38999 MIL_SER I OBJECT_ID PIN 1 OBJECT TYPE TERM MIL_USAGE MIL_STND 38999 MIL_SER II OBJECT_ID PIN_1 OBJECT TYPE TERM TERM_CODE TERM_CODE SCT_1 PART_NUMBER SOCKET_1_P_N Import Libraries Page 25 Revision D 1 Import Libraries User Manual TYPE SOCKET AWG 20 WIRE_BARREL 22 USAGE PWR MIL_USAGE MIL_STND 38999 MIL_SER I OBJECT_ID SCT_1 OBJECT_TYPE TERM Notice the one to many relationships on the above records Now we can declare the contacts and their mil usages CONTACTS CONTACT KEY NAME CK1 CONTACT STYLE PLUG INSTALLATION TYPE CRIMP AWG 20 CONTACT_NAME A D AWG 22 CONTACT NAME 1 10 MIL USAGE MIL STND 38999 MIL SER I OBJECT_ID 1 1 OBJECT TYPE CONTACT Notes 1 The range of the mil usage defined for a contact key i e its mil standards and series must be fully included within the range of the mil usage defined for each of the termination codes 2 The gauge AWG of the terminators and of the contacts must be identical Import Libraries Page 26 Revision D 1 Import Libraries User Manual Termination Codes These records serve to import termin
16. Import Libraries User Manual HarnesSys User Manual For Import Libraries Revision D_1 04 November 2010 Import Libraries Page 1 Revision D_1 Import Libraries User Manual Notices The information contained in this manual is believed to be accurate and reliable However Israel Aerospace Industries Ltd IAI assumes no responsibility for any errors omissions or inaccuracies whatsoever Information in this document is subject to change without notice and does not represent a commitment on the part of Israel Aircraft Industries Ltd IAD The software and or database described in this document are furnished under a license and or agreement The software and or database may be used or copied only in accordance with the terms of such license and or agreement It is against the law to copy the software on any medium except as specifically allowed in the license and or nondisclosure agreement The purchaser may make one copy of the software for backup purposes No part of this document and or data base may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying recording or information storage and retrieval systems for any purpose other than the purchaser s personal use without the express written permission of IAI 2010 Israel Aerospace Industries Ltd All rights reserved Import Libraries Page 2 Revision D 1 Import Libraries User Manual TM Harnes Sys User M
17. MIL STND lt value gt MIL SER lt value gt CONTACT NAME lt value gt AWG lt value gt WIRE BARREL lt value gt WIRE PART NUMBER lt value gt USAGE lt value gt First insert arrangement NUMBER_OF_WIRES lt value gt MANUAL TERM CODE lt value gt MIN CMA lt value gt MAX CMA lt value gt MIN WIRE AWG lt value gt MAX WIRE AWG lt value gt STANDARD CONTACT lt value gt CONTACT NAME lt value gt AWG lt value gt WIRE BARREL lt value gt WIRE PART NUMBER lt value gt UB AGE sees Second insert arrangement NUMBER OF WIRES lt value gt MANUAL TERM CODE lt value gt MIN CMA lt value gt MAX CMA lt value gt MIN WIRE AWG lt value gt MAX WIRE AWG lt value gt STANDARD CONTACT lt value gt Import Libraries Page 23 Revision D 1 Import Libraries User Manual Automatic method In the case where termination codes for these contacts are deducted automatically the record information is as follows Keyword Type Must Remarks CONTACT KEY NAME string YES CONTACT STYLE string YES PLUG STUD or OTHER INSTALLATION TYPE string CRIMP SOLDER or OTHER PIN ARRANGE NAME string Refers to the correspondent pin arrangement identifier which describes the plug chart structure MIL STND string In case of single association MIL SER string In case of single association AWG string YES CONT
18. NT_KEY_GROUP_OPTIONS Starting from release HarnesSYS r18a 06 there are two alternatives for insert arrangements e The field CONTACT_NAME contains single contacts e The field CONTACT_NAME declares an insert arrangement formula The formula is automatically converted by the importer into a list of separate contacts The formula may contain commas and parentheses following the same rules of the interactive form Each comma and each parentheses must be preceded by the symbol in order to distinguish them from the delimiters of this file Starting from release HarnesSYS r18a 06 there are two alternatives for terminations e Manual termination codes import the contact keys with the termination codes known on the legacy system e Automatic termination codes import the contact keys without termination codes In this case HarnesSYS will try to associate existing termination codes already in the database for example previously imported by keyword TERM_CODES to the contacts of the contact key Together with the termination codes the wire barrel or the wire part number the usage and the contact type are copied to the table CONT_KEY_GROUP_OPTIONS This option is available only for PLUG contact style in the context of a known MIL_USAGE The benefits of the automatic method are 1 to support conversion of contact keys for legacy systems that do not associate termination codes to contact keys and 2 to spare from the user the need to declare the
19. ODE in the VENDOR table SPEC LCD string If the value is not provided then the current date is used INTERNAL NUMBER _ string DWG NUMBER string WEIGHT INDEX string Possible Values Meaning E Estimated Ds Data Source C Calculated W Weighed WEIGHT number COOLING number COOL_TYPE string PART_TYPE string Possible Values Meaning B ModBlock BCK Backshell BOX Box BS Bus Bar CB Circuit Breaker J Receptacle JCX Coax Receptacle JTX Triax Receptacle PP Plug PCX Coax Plug PTX Triax Plug RL Relay without diode RLD Relay with diode RLP Relay with press to test UND Undefined BASE PLUG PROG NO string Reference to the MAJOR field in the PPN table ACDC string VOLT number LOAD number HZ number CONTACT KEY string Reference to the CONTACT KEY NAME field in the CONT KEY GROUPS table Import Libraries Page 16 Revision D 1 Import Libraries User Manual Keyword Type Must Remarks CONTACT_TYPE string PIN or SOCKET CONNECTION_KEY number Reference to the CONNECTION_KEY field in the CONTACT_CONNECTION table SHELL SIZE string Reference to the SHELL_ SIZE field in the SHELL table TEST string Possible Values Meaning as in GUD TEST TEST MILITARY MILITARY CIVIL CIVIL SUPRSED SUPERSEDE GRN_EQP GROUND EQP TETRA_ETCH string PART_CODE string MIL_STND string In case of single association goes to MIL_USAGE MIL_SER string In case of single association go
20. PPON ON NDP PN SOE 5 Introduction ion non VN E SRR 2 RPI S sayin en OP TREE POUR S COPE NPR ne PIP RR IO PIP PRP I Ors nization BODO PRON SOE jh red EV ees RIN OPAPP BR NR PPP PS PRR PO E E RPO CONVEN 018 ERS Importer eT i 71 lt 11 Precedence RUlES 12 Import Sequence 0 13 Connector Standards 0 1 4 andardS sess ee ene UC P t Lib i 15 ar 1 raries 0
21. RANDS number See note 1 AWG number See note 1 CMA number If missing will be populated from GAUGE CMA table See note 1 MATERIAL string See note 1 INSULATION string See note 1 WIRE FORM string ROUND or RIBBON CHAR_CODE string See note 1 HOOK_UP string See note 1 SLEEV_COLOR number From COLOR table 0 BLK 1 BRN 2 RED 3 ORG 4 YEL 5 GRN 7 VLT 8 01 9 WHT KINGSLEY_MARKS number KINGSLEY SLEEVE CODE string From MARKING SYSTEM table where system KINGSLEY TMS_SLEEVE_CODE string From MARKING_SYSTEM table where system TMS MARKABLE WIRE string Yor N USAGE string From CODE_DETAIL table where code USAGE and value not like TC or TC See also note 1 WIRE STYLE string YES See details in the table below SHIELD_LAYERS number CONDUCTORS_NUM number Equal to number of basic colors OUTER_INSULATION string H_CABLE string WIRE DIAMETER number for standard cables this value is the outer diameter of each of the individual wires that are part of the cable expressed in length units See note 1 IMPEDANCE number from r16a 00 version in Ohm for triax and coax wires See note 1 BASIC WIRE PART NUMBER string When WIRE STYLE STANDARD i e for standard cables this field refers to the Part number of an existing wire specification whose WIRE STYLE STANDARD WIRE T PLATING string See note 1 Import Libraries Page 35 Revision D 1 Import Libraries
22. ROUP string ABBREVIATION string CONNECTION KEY REQUIRED integer 1 YES 0 or NULL NO Sample DESC DESCRIPTION lt value gt PGROUP lt value gt ABBREVIATION lt value gt CONNECTION KEY REQUIRED lt value gt Mating Connector These records serve to declare pairs of mating part numbers defined as part specifications Record type MATING ICD Table MATING_CONNECTOR Keyword Type Must Remarks PARTI string YES First part number PART2 string YES Second part number Sample MATING Import Libraries Page 18 Revision D_1 Import Libraries User Manual PARTI lt value gt PART2 lt value gt Shell These records serve to import the data relevant to the shell of connectors Record type SHELL ICD Table SHELL Keyword Type Must Remarks SHELL SIZE string YES STRAIGHT RECEPTACLE string ANGLED RECEPTACLE string STRAIGHT PLUG string ANGLED PLUG string Sample SHELL SHELL SIZE lt value gt STRAIGHT RECEPTACLE lt value gt ANGLED RECEPTACLE lt value gt STRAIGHT PLUG lt value gt ANGLED_PLUG lt value gt PPN These records serve to import the plug programming number Record type PPN ICD Table PPN Keyword Type Must Remarks MAJOR string YES SUB string DEGREE number PIN NAME string YES SEQ number LAST IN ROW string Sample PPN
23. User Manual Here are the various values for the mandatory field WIRE_STYLE Value Name GUI Description STANDARD Standard Cable for all single wires and standard cables e g twisted coax shielded or triax CABLE Hybrid Cable for hybrid cables IN HYBRID ONLY Use in hybrid cable only for single wires and cables that can be used as components of hybrid cable only STANDARD WIRE Wire for single wires r16a 00 version Figure 5 Values for field WIRE_STYLE Note 1 In the case of a standard cable referring to the specification of its basic wires it is recommended not to provide any value for this field The importer program will copy the proper value from the basic wire specification to the empty field In the case where a value is nevertheless provided for this field then it is mandatory that the provided value be equal to the value of the correspondent field of the basic wire specification Sample WIRE_SPEC PART NUMBER lt value gt DIAMETER lt value gt SPEC_WEIGHT lt value gt SPEC_RESIST lt value gt CIRCLE lt value gt WIRE_DESC lt value gt VENDOR_CODE lt value gt STRANDS lt value gt AWG lt value gt CMA lt value gt MATERIAL lt value gt INSULATION lt value gt WIRE FORM lt value gt CHAR CODE lt value gt HOOK UP lt value gt SLEEV COLOR lt value gt KINGSLEY MARKS lt value gt TMS MARKS lt value gt KINGSL
24. ace with the tracking tools Disclaimer The goal of the import is to allow the reuse of the legacy data in HarnesSys as if HarnesSys had originally created it However full reuse depends on the completeness and exactitude of the import data in the HarnesSys perspective Partial import may only allow for partial reusability Import Libraries Page 7 Revision D_1 Import Libraries User Manual Conventions Character Set Characters shall belong to the 7 bit ASCII character set including A Z upper case and a z lower case English letters 0 9 digits the space character and a series of punctuation characters and control characters Special Characters Special characters are N RET YET Fesin etc Before a Special character enter the sign For example for ABC 123 456 type ABCA 123A 456 for ABC DFG type ABCMDFG Syntax The file syntax is made to be human readable free format and self explanatory The syntax is free format in the sense that it may include any number of space or tabs characters between field values and that the information can span over several consecutive lines Leading and trailing space characters are ignored 6 Typically a record is made of one or more lines and ends with a semicolon character A record starts by a record type keyword followed by an equal sign followed by a left parenthesis followed by list of one or more lists of KEYWORD value assignments separated by commas
25. anual For Import Libraries Revision D_1 04 November 2010 Prepared By Esther Itzhak ee ed Revised By po 04 NOV 2010 Checked By A Bashkin eee Approved By S Shiff ns Import Libraries Page 3 Revision D_1 Import Libraries User Manual Records of Changes and Revisions Change Revision HarnesSYS Date Description Release Issued 1 R17a 00 07 May 2007 Original Manual R18a 00 25 Sep 2008 Clarifications R18a 06 04 Feb 2009 Major update New options on contact keys New or enhanced description of the library importer approach the precedence rules and the tracking tools Extended information on the valid values for each field R19a 00 16 Dec 2009 New keyword for contacts STANDARD_CONTACT R19a 19 04 Nov 2010 Contact key refers to pin arrangement Update list of library tables not in scope uthors E Yitzhak J P Stroweis J P Stroweis J P Stroweis J P Stroweis Import Libraries Page 4 Revision D 1 Import Libraries User Manual Table of Contents Table of Contents List OL 1 80168 ON 0 NNN POON NPN ORI PPP ORONO eo ee NI
26. ation codes Record type TERM CODES ICD Tables TERM CODES TERM_GAUGELESS_WIRES TERM_MAN_AWG MATERIALS ENV_CONDITIONS Keyword Type Must Remarks TERM_CODE string YES Unique PART_NUMBER string YES Unique TYPE string YES For valid types see table below SUBTYPE string For valid sub types see table below VENDOR_CODE string Reference to the Vendor code in the VENDOR table AWG string For pins sockets and sealing plugs WIRE_BARREL number For pins and sockets WIRE PART NUMBER string Populates field GAUGELESS_WIRE_PN in table TERM_GAUGELESS_WIRES Several Wire Part Numbers may be associated with the same terminator MAX N OF WIRES number STUD string USAGE string From CODE DETAIL table where code USAGE Possible Values Meaning PWR POWER CX COAX TX TRIAX TW TWINAX FB FIBRE OPTIC QDRX QUADRAX TC AL Alumel TC CN Constantan TC CR Chromel TC CU Copper TC FE Iron ENVIRON_COND string Environment condition is added to the table ENV_CONDITIONS if it does not exist yet COLOR string WIRE METAL string Material is added to the table MATERIALS if it does not exist yet MIN_CMA number For splices and lugs MAX CMA number For splices and lugs MIN N OF WIRES number For all splices number of wires on the first side For BUTT splices only number of wires on the second side For lugs Import Libraries Page
27. ces Weight per unit of length g m kg km Lb 1000ft Resistance per unit of Ohms km length Ohm km Ohms mi Ohms 1000ft Resistance Impedance Ohms in HarnesSYS mohm 0 001 Ohms Mohm 1000000 Ohms Temperature C Celsius degrees F Fahrenheit degrees Import Libraries Figure 2 Units of Measurements Page 10 Revision D_1 Import Libraries User Manual Importer Scope Library tables are those database tables designated to serve as a central data source Libraries do not contain any specific electrical information about documents wires or parts used in a given vehicle project They are referenced by the documents wires or parts of the project It is recommended to populate them before the first documents wires or parts are created but this is not a must This tool supports the import of most of the libraries from Legacy systems that are used in an electrical project If a given functionality does not exist in your Legacy system you may decide not to populate this group table during conversion Missing library data can be added at a later stage Please note that the import utility does not cover all the libraries I The following library tables are pre populated during at create project time but it is possible to modify them interactively e GAUGE_CMA e WIRE ACCOMODATION The following library tables are pre populated during at create project time and they should not be modified by the customer e ERROR_DES
28. e gt USAGE lt value gt SPEC STATUS lt value gt LONG SIGNAL NAME lt value gt SIGNAL TYPE ANALOG DIG lt value gt VOLTAGE NOM lt value gt VOLTAGE MIN lt value gt VOLTAGE MAX lt value gt VOLTAGE UNITS lt value gt CURRENT NOM lt value gt CURRENT MIN lt value gt CURRENT MAX lt value gt CURRENT UNITS lt value gt FREQUENCY lt value gt FREQUENCY UNITS lt value gt IMPEDANCE lt value gt NOTE lt value gt FREQUENCY MIN lt value gt FREQUENCY MAX lt value gt IMPEDANCE UNITS lt value gt Import Libraries Page 33 Revision D 1 Import Libraries User Manual Wire Libraries The following tables support the libraries of wires VENDOR see in the part libraries section WIRE_SPEC CABLE WIRE_SPEC_COLOR DN Wire Specification These records serve to define specifications of wires Record type WIRE SPEC ICD Table WIRE SPEC The detail of the keywords is in next page Import Libraries Page 34 Revision D 1 Import Libraries User Manual Keyword Type Must Remarks PART_NUMBER string YES DIAMETER number Outer diameter of the whole wire cable in length units including the jacket SPEC_WEIGHT number SPEC_RESIST number See note 1 CIRCLE string WIRE DESC string VENDOR CODE string Reference to the Vendor code in the VENDOR table ST
29. es to MIL_USAGE TEMPERATURE_FROM number TEMPERATURE_TO number PART_LENGTH number PART_WIDTH number PART_HEIGHT number POWER_OUTPUT number ICD_VCD string WEIGHT_UNIT string WEIGHT default or WEIGHT LENGTH Sample PART SPEC PART_NUMBER DESCRIPTION VENDOR_CODE SPEC_LCD INTERNAL_NUMBER DWG_NUMBER WEIGHT_INDEX WEIGHT COOLING COOL_TYPE PART_TYPE BASE PLUG PROG NO ACDC VOLT LOAD HZ CONTACT KEY CONTACT TYPE CONNECTION KEY SHELL SIZE TEST Import Libraries lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt lt value gt Page 17 Revision D 1 Import Libraries User Manual TETRA_ETCH lt value gt PART CODE lt value gt MIL_STND lt value gt MIL_SER lt value gt TEMPERATURE FROM lt value gt TEMPERATURE_TO lt value gt PART_LENGTH lt value gt PART_WIDTH lt value gt PART_HEIGHT lt value gt POWER_OUTPUT lt value gt ICD_VCD lt value gt WEIGHT_UNIT lt value gt Part Description These records serve to import the description and the group of a part Record type DESC ICD Table PART DESCRIPTION Keyword Type Must Remarks DESCRIPTION string YES PG
30. ges to the database Enter C to COMMIT or S to STOP Next import the import it is possible to proceed to next Actions import task for the same project 1 Import Documents lt CR gt back to the main 2 Import Part Occurrences menu 3 Tabular Schematics operations 4 Import Free Pins 5 Import Manufacturing Data 6 Import ETA Test Bundle 7 Import Circuit Analyzer 8 Import Retrofit Condition Notes 9 Import Box Signals Part Wire Spec Libraries Select option lt CR gt exit gt gt gt Figure 9 Single Import Dialog Note The library import operations are not supported in the Scenario mode Tracking the Importer Actions In order to review what happened during the execution of a given library import operation HarnesSYS generates several files that allow the user to track the effect of the import These files are all saved in the private directory of the user They include 1 A log file named Import Lib log that holds the history of the interaction during the session 2 A message file named Import_Lib msg that summarizes the encountered warnings and errors and the quantity of proceeded elements 3 A SQL script file named import results YYYYmmDDHHMMSS sql This time stamped script can be run just after changes are committed It will query the database about the entities that were imported or updated The exact way to invoke this script is detailed in the last lines of the msg fi
31. h their connector CONTACTS standards MIL_USAGE when OBJECT_TYPE CONTACT 5 Part Description DESC 6 Shell SHELL 7 PPN PPN 8 Connection Ke CONTACT CONNECTION ie Part Specifications with their PART_SPEC related connector standards MIL_USAGE when OBJECT_TYPE SPEC 10 Mating Part Numbers MATING 11 Wire Specifications WIRE_SPEC 12 Wire Specification Colors WIRE SPEC COLOR 13 Wire Specification Cable CABLE 14 Box Interfaces BOX INTERFACES 15 Box Signals BOX SIGNAL Import Libraries Figure 3 Suggested Import Sequence Page 13 Revision D 1 Import Libraries User Manual Connector Standards MIL Standards These records define the connector standards Record type MIL STDS ICD Table MIL_STDS Keyword Type Must Remarks MIL_STND string YES MIL standard MIL_SER string MIL series SUBST_MIL_STND string SUBST_MIL_SER string NEW_DES_SUBST_DATE date GLOBAL_SUBST_DATE date NOTE string Note is used for specific series DESCRIPTION string Description is used to describe all series of specific connector standard Sample MIL_STDS MIL_STND lt value gt MIL_SER lt value gt SUBST_MIL_STND lt value gt SUBST_MIL_SER lt value gt NEW_DES_SUBST_DATE lt value gt GLOBAL_SUBST_DATE lt value gt NOTE lt value gt DESCRIPTION lt value gt Import Libraries Page 14 Revision D_1 Import Librar
32. ies User Manual Part Libraries The following tables support the libraries of parts VENDOR PART_SPEC PART_DESCRIPTION MATING_CONNECTOR SHELL PPN BOX_INTERFACES CONTACT_CONNECTION MIL USAGE 10 CONT KEY GROUPS 11 CONT KEY GROUP CONTACTS 12 CONT KEY GROUP OPTIONS CHNAAKRWNS Vendor These records serve to import vendor data Vendor data is references by part specifications and wire specifications Record type VENDOR ICD Table VENDOR Keyword Type Must Remarks VENDOR_CODE string YES NAME string YES PHONE string FAX string TELEX string Sample VENDOR VENDOR CODE lt value gt NAME lt value gt PHONE lt value gt FAX lt value gt TELEX lt value gt Import Libraries Page 15 Revision D_1 Import Libraries User Manual Part Specification These records serve to import the specifications of electrical parts It aggregates intrinsic part properties with references to specific properties located in several tables vendors connections contacts shells descriptions PPNs Record type PART SPEC ICD Table PART SPEC Keyword Type Must Remarks PART NUMBER string YES DESCRIPTION string YES If this value does not pre exist in the DESCRIPTION table then it will be added there VENDOR CODE string Reference to VENDOR C
33. ination Codes MIL MA 0210 Box Interfaces 31 Box Signal 32 ox Signals W i Lib i 34 Ire I raries 0 Wire Specificati 34 ire Specification Wire Spec Col 37 ire Spec Color User Interface 0 38 1 70 9 1 DD Importer Main Ment 0001 T ki th I t A ti 40 rac Ing e mpor er c 1 011 5 9 2522500225559 5092552590229 0505025 5028 0000 555 osi PPR PNP ossis Import Libraries Page 5 Revision D_1 Import Libraries User Manual List of Tables Figure 1 Keyword information in t
34. le The result of the query is saved in a file named import_results_YYYYmmDDHHMMSS Ist with the same time stamp and also located in the private directory Import Libraries Page 40 Revision D_1 Import Libraries User Manual Import Libraries Page 41 Revision D 1
35. ransaction file specifications 9 Figure 2 Units of 1069501611161115 10 Figure 3 Suggested Import Seguente isss DAAE E EAEE 13 Figure 4 Valid types and sub types of terminators 28 Figure 5 Values for field WIRE STYLE 2222221122211222122221 36 Figure 6 Invocation of harness ansi operations 38 Figure 7 harness ansi 01 00118 5 22251222424212401141224422542222214224222142222442142222424222202204222249 2942424444222222 38 Figure 8 HarnesSys Importer Main Menu 2
36. s Select option lt CR gt exit gt gt gt Enter Import File Name lt CR gt to exit gt gt gt Do you want to overwrite the existing data y n n Project Import task on PART_WIRE_SPEC_DATA Transaction file YYY Document name From line beginning of file To line dede end of file Debug assistance OFF Action Import Transaction file O K y n y Import Libraries Page 39 7 The aircraft database project Entry is not case sensitive Choose a number 9 Choose lt CR gt to cancel the pending operation and return to the Importer main menu The menu dialog is as below The import file name accept relative or full directory path lt CR gt back to the main menu The menu dialog is as below means to add the new values to the existing library Y Means to delete the existing values in the library and import the values from the Import file The user keyboard entries here ABC are summarized for confirmation Enter y to confirm the options amp launch the import Enter n to step back to the importer main menu Default is y Next lines will appear if you entered Y You will get messages about the inserted data Revision D_1 Import Libraries User Manual Please check errors messages file lt user gt harness lt project gt private Import_Lib msg Do you want to commit the chan
37. s are written in bold characters in the description tables and in the samples Remarks Additional useful information including default value if any location of default value in project defaults if any is this field governed by format control expected character length location of default string length in project defaults if any ICD Table Principal target Oracle table as defined in the Interface Control Document ICD The input value may be placed into several tables Figure 1 Keyword information in transaction file specifications Import Libraries Page 9 Revision D 1 Import Libraries User Manual Units of Measurements HarnesSys stores all data using a fixed set of units mm g and C degrees which are translated to the required values during the report generation The import file will contain measurements with or without units e Ifthe value comes with its units then they should be written as one string without blank e g 25g 0 3m1i e Ifthe units are not specified then HarnesSys will understand that the measurement is provided is in MKS system as stored in the Data Base The following units are allowed in the import data files Measurement Unit Comment Length m meters cm Centimeters mm Millimeters in Inches ft Feet mi Miles um Micrometers i e 0 001mm nm Nanometers i e 0 000001mm Weight kg Kilograms g grams Ib Pounds OZ Oun
38. se associations interactively after contact keys are imported The drawback of this method is that the automatic assignment of termination codes done according to standards and gauge may not be unambiguous since several candidate termination codes may answer the criteria in which case the importer messages The benefit of the manual method is to reproduce in HarnesSYS exactly the conditions from the legacy system In this case the importer does not verify the termination codes In order to populate automatically the termination codes to be used on an insert arrangement of a given contact key the importer needs the contacts definition as well as the mil_usage of this contact key Therefore it is recommended to declare CONTACTS and MIL_USAGE keywords in the same import file See the example below Import Libraries Page 21 Revision D 1 Import Libraries User Manual Manual method In the case where termination codes for these contacts are imported manually from a legacy system the record information is as follows Keyword Type Must Remarks CONTACT KEY NAME string YES CONTACT_STYLE string YES PLUG STUD or OTHER INSTALLATION_TYPE string CRIMP SOLDER or OTHER PIN ARRANGE NAME string Refers to the correspondent pin arrangement identifier which describes the plug chart structure MIL STND string In case of single association MIL SER string In case of single association AWG string YES
39. standard series which is not listed in the Connector Standards the program will issue an error message and the problematic part terminator wire spec contact key will be rejected Then the rest of the library entities can be imported as one single file or as a series of files In the case of a single file it will include all the library entities except the Connector Standards The system will automatically sort the entities in this file to properly import everything In the case of a series of import files it is the responsibility of the users to submit the files in a coherent order to satisfy the references tables that are referenced shall be populated first e g VENDOR shall be imported prior to PART_SPEC because PART_SPEC contains references to VENDOR If a reference to a non existing data is found the item is rejected e g if there is a reference from a PART_SPEC to a non existing VENDOR then the given PART_SPEC is rejected and an error message is issued Import Libraries Page 12 Revision D_1 Import Libraries User Manual Import Sequence Find here an example of a global import sequence is ial Record Types 1 Connector Standards MIL_STDS must be in a separate file 2 Vendor VENDOR 3 Term Codes with their connector TERM_CODES standards and related alternative MIL USAGE when OBJECT TYPE TERM part numbers ALTERN_TERM_PN COMBO_TERM_PN 4 Contacts wit
Download Pdf Manuals
Related Search