Page 1

TE Connectivity

HarnWare User ManualOverview
Non-standard parts that you use regularly can be held in the HarnWare User Parts Library.
The Library can be used for:1) Coded part numbers. Coded part numbering schemes are used for most TE Connectivity
products and military connectors. In such schemes different characters in the part number areused to describe various aspects of the part, such as dimensions, materials and finishes. The
number of individual part numbers that can be generated by such schemes is often very large.
The User Parts Library provides a means of handling such part numbering schemes in a waythat avoids the need to add all the individual part numbers into the database.
2) Sequential or non-coded part numbers. The User Parts Library also allows individual partnumbers to be stored in the database along with design parameters that describe each part.
This allows the user to search for a part number by entering all or a selection of the required
design parameters. For example, part style, size, material and finish.
3) Limited coded part numbering schemes. The approach used for sequential part numbers
can also be used for coded part numbering schemes where only certain combinations ofoptions are available and when it is feasible to enter the valid part numbers into the database.
The User Parts Library contains examples of all three styles of part numbering schemes:

TXS D-subminature connector adaptors is an example of a coded part numbering scheme.

Page 2

TE Connectivity

HarnWare User Manual

Cabletec Bonding Leads is an
example of a limited coded partnumbering scheme where only
certain permutations of part number
options are validAmplimite D Subminiature
Connectors is an example ofsequentially numbered.

Using the Library
The HarnWare User Parts Library form is accessed via the command button in the UserBalloon form. To construct a part number or to search for a part, select the part category andthe master from those listed in the two combo-boxes. As each master is selected, descriptions,images and hyperlinks to documents containing further information will appear in the form if
these have been defined in the User Parts Library database. The form can be enlarged toprovide more space for viewing this extra information.
As each master is selected in the combo-box the parameters used to describe the part areloaded into combo-boxes. As each combo-box or individual parameter is selected adescription, image and hyperlink information maybe displayed in the form. The master,parameter or part number to which the information relates is indicated by the label shown inbold. The hyperlink may reference a file on your local hard disc, a network drive or an internet
web site.
If individual part numbers for the master are contained in the database, the number matching
the selected parameters will be displayed and they will be listed in the part number combo-box.
Each of the parameter combo-boxes include a blank at the top of the list so that a parametercan be ignored when searching. When an entry is selected in the part number combo-box thesettings for all the parameters are selected in the parameter combo-boxes. A description,
image and hyperlink may also be displayed for the individual part number if the database
contains such references.
The user balloon form is accessed by opening a balloon shape in the Visio drawing or the
Design Wizard or via the HarnWare Window>Parts menu. A command button in this form gives
access to the HarnWare User Parts Library form

Page 3

TE Connectivity

HarnWare User Manual

The Clear All command button selects blanks for all the parameters. This can provide a more
useful starting point for a search than the defaults that are initially selected.
Where individual part numbers are not contained in the database, the parameter combo-boxes
are used to construct a part number. As each option is selected the part number is updated toreflect the chosen options. In addition to the listed values you may also enter other values oredit the constructed part number. Obviously you need to ensure the options selected and any
non-standard text entered form a valid combination and, therefore, a meaningful part number.
Clicking the OK command button causes the part number to be copied into the HarnWare
Balloon form. Any description, specification and remarks associated with the selected part
master are also copied into the Balloon form. If data is subsequently saved to the balloon shapein the drawing, the part number parameter settings are also saved. These maybe viewed in theDesign Wizard and they are also used to select the default part number parameters if the UserParts Library form is opened again for that Balloon shape.
Clicking the Cancel command button simply unloads the User Part Library form without saving
any data.

Database Structure
A copy of Microsoft Access 97, or later, is all that is required if you wish to add part numbers
and part numbering schemes into the User Parts Library.
The database is held in the User Parts Library folder under the C:\Documents and Settings\UserName\Application Data\Tyco Electronics\HarnWare. Where <User Name> is the local username. This folder can also be used for any image files and documents you wish to reference orhyperlink to, although the files can be on any other disc drive or Internet web site.

On opening the database in Microsoft Access you will see that it comprises four tables:

Page 4

TE Connectivity

HarnWare User Manual

The following is an example of entering a coded part numbering scheme into the User Parts
database using the EN4199-004 Bonding Leads datasheet shown below.

Page 5

TE Connectivity

HarnWare User Manual

For the following example the part to be added has 5 Part Number Fields
FieldIndex
2

FieldIndex
4

FieldIndex
1

FieldIndex3FieldIndex51) Masters This table contains records for each different part numbering scheme, or master. Themaster name is used to relate the records in all four tables and should, therefore, be carefully
chosen to be meaningful and unique. As you click on each field in this and the other tables, abrief description of the field is output in the Microsoft Access status bar. PartsListCode controls
where the part appears in parts lists. See ‘Part Codes for Parts Listing’ in the HarnWare help
system for details. The parts list description and Spec/Remarks are the texts copied into theHarnWare Balloon form for saving into the balloon shape and that are extracted by the Parts
Lister.
Open the default Masters Table

Page 6

TE Connectivity

HarnWare User Manual

Add text for new Category, Master and Description
Note: The Master column text must not be duplicated in other rows

123

Add link to any Documents, add file name for Picture, use drop down menu for Parts List
Code, Add text for Parts List Description, add text for Parts List Spec/Remarks.

4576?

Refer to Page 8 for balloon references

Page 78

TE Connectivity

HarnWare User Manual123546?

87

Refer to Page 7 for balloon references2) PartNumberFields This table contains records for each parameter used to construct the partnumber or to search for part numbers. The Prefix and Suffix fields are only used for constructing
part numbers and are not required for masters that have part numbers stored in the Specific Part
Numbers table. The Units and Tolerance fields are only relevant to numeric parameters formasters with records in the Specific Part Numbers table.

ABCPage 8D

TE Connectivity

HarnWare User Manual

C Title1

A Master

D Title2

BFieldIndex
1BFieldIndex
2B
FieldIndex
3B
FieldIndex
4B
FieldIndex
53) PartNumberFieldOptions This table contains records for each value of each parameter orthe default value for a parameter with a ValueList in the Part Number Fields table.
For this example from the datasheet

CrossSect
Sort x 5
Options

LengthSort x 12
Options

Terminal
Sort x 13
Options

Page 9

TE Connectivity

HarnWare User Manual

CrossSect
Sort x 5
Options

LengthSort x 12
Options

Terminal
Sort x 13
Options

Description foreach FieldName

Terminal
Sort x 13
Options

Description foreach FieldNamePage 10

TE Connectivity

HarnWare User Manual4) SpecificPartNumbers This table contains a record for each part number along with values foreach parameter used to describe the part. The parameters are held in the Field 1 to 15 which
relates to the Field Index values in the Part Number Fields table.
When adding data to the User Parts Library database it is important to ensure data is enteredconsistently and accurately. For example, master names must match in the four tables andFieldNames must match in the Part Number Fields and Part Number Field Options table.
Although non-standard parts are normally represented by a balloon shape in the drawing, any
shape can be used provided the basic structure matches that of a standard HarnWare balloon
shape. In particular the data1 field, custom properties and sub-shape with the data1 field setting
for the item number.

In this example there are 760 lines to be entered. This table is only used for sequential partnumbering and limited coded part numbering schemes. In cases where the SpecificPartNumbers
table needs to be loaded with a large amount of data that follows a reasonably well defined logic,
a small program will often be the much quicker and less error prone approach. A Visual Basic 6
program can be used to load the Cabletec Bonding Lead part numbers. This simple program willtake an hour or so to write and test. A similar program could have been written in Visual Basic
for Applications which is included in Microsoft Access and Visio. If you’re not proficient inprogramming it is likely that someone in your company would be able to generate such programsfor you or, if you prefer, we’d be happy to offer our help.”

Page 11

TE ConnectivityHarnWare User Manual

Disclaimer
All of the present information, including drawings, illustrations and graphic designs
reflects our present understanding and is to the best of our knowledge and belief correct
and reliable. Users, however, should independently evaluate the suitability of eachproduct for the designed application. Under no circumstances does this constitute anassurance of any particular quality or performance. Such an assurance is only provided
in the context of our product specifications or explicit contractual arrangements. Our
liability for these products is set forth in our standard terms and conditions.

Page 12