Component properties
Contents
Component properties and SQLite Database (from V15)
Component properties are treated a bit different within the SQLite database rather than V14 and before, but it is not too difficult to understand. Say you had found a matching part in the database and now like to view/modify it's properties. Let's take a 10K resistor with smt package, a simulation model and a 3D model (found by the use of the parametric search):
Image: Serch a a smt resistor 10K with 3D model
In green you see matching search results. Several packages could be chosen, we decide for a 0603. Now click with the right mouse key (M2) upon the line (green) of the desired component. A context menu opens:
Image: Right mousekey opens context menu
Within this context menu you have opportunity to "Edit component properties...". Use this option now. You will find the same option in the database menu Component:
Image: The same option in data base menu Component
In the opening dialog at first we select the tab "Name, manufacturer", data sheet and description". The opening dialog has the same caption.
Name, manufacturer, data sheet and description...
All fields can be manipulated according to your wishes at every time. The sub tabs DE, EN and FR stand for name and/or description in German, English or French language. If you save the part, it gets "yours". That means as soon as it gets found again it shows the black flag "User" at the end of the green line in the list of the search results. We continue with tab Type and parameters:
Type and Parameters
The line "Component type" identifies this part as component type "Resistor". Using the button "Change" a different component type can be chosen. Within the lower part of the dialog you see all parameters this component type might have. You can enter, modify or delete entries according to your wishes at any time. Additional parameter kinds can be generated in database menu "Extra/Edit component types". See article: Add new parameters to a component type. Now let's have a look at tab User defined properties:
User defined properties
Probably you might see this dialog empty, because in our example no user defined properties have been entered yet. If you have converted parts having user defined properties from older libraries, you will find them here. Enter your desired property to the blue field to the left and enter the value which it shall achieve besides to the right. You can use the drop down list. Later you might search for this property or let it be listed within the BoM. At the same time this individual property now appears in the drop down list of predefined properties so that it easily can be chosen with other parts. Now let's have a look at tab Order numbers...:
Order numbers
Have an overview on distributors having exactly this part in their line card as well as the order numbers which currently are known to TARGET 3001!. In this case it's BÜRKLIN, DISTRELEC, ELFA, FARNELL, RS-COMPONENTS, SCHUKAT, SCHURICHT. If you highlight a distributor and click the link "Show shop" you will reach exactly this part in the distributor's web shop. Here you get all information the distributor offers: data sheet, price, availability... Dat base menu Extra allows to create or edit distributors.
New in V17:
More than that you have the chance to forward a search for a component using its name to the search field of a certain distributor's web shop. Say we have searched in TARGET 3001! for a NE555. To the right hand side in the Ordernumbers dialog you find the entry "Find order numbers". In this drop down list now select one of your desired distributors e.g. ARROW.
M2 means: Use right mouse key.
Image: Based on the search NE555 and the match NE555D (green)...
Image: ...TARGET finds the order number e.g. in the ARROW web shop. This is a dual screen image. to the left you see TARGET, right you're in your web browser having the ARROW web shop automatically opened.
Last but not least let's take look at Package and extras:
Package and extras
The middle part shows the entry "Prefix". For a resistor the prefix is "R" for example. To the right you see some checkboxes. When ticked, it means:
Scalable: This part contains only image elements (e.g. a logo). It shall be marked as variable in size. As soon as the object solely has a pin, this function is idle.
Add to BOM: Marks that this component can be part of a Bill of Material (BOM). For example with a logo which actually is handled as a logo too this would not make sense because you would not bring it to a BOM.
Discontinued, Obsolete: The component is not produced resp. sold anymore.
Simulation model required: Sometimes the assignment of a simulation model with some components (e.g. connectors) does not make sense. Therefore a TARGET 3001!-warning "Simulation model missing" would not make sense too. To avoid it tick the box.
The entry History refers to the development of this part in time response. Enter your comments here.
We were aware of this component having a 0603 package. If you want to assign a different package to this part, you can do it in this dialog. A click on button "Change Package" (top right) opens an appropriate browser to change for alternatives including a 3D view.
Component properties in V14 and before
The following explications refer to V14 and before!
Every component in TARGET 3001! can have an endless (!) list of properties. Any property you might think of can simply be added to the list:
The dialogue "Edit properties" you will find...
- by the Context menu entry "Edit properties"
- by the Context menu in the Library Browser (press button
) - by double click (M11) upon the handle of a component and using the button
in the flashing dialogue
After click on it in the schematic the following dialogue appears:
This is where the user-definied properties of components and signals are administrated. You are able to add new properties by clicking on the last entry. A new empty entry will be imported. You can enter any property and any value. If you want to delete or relocate entries, please activate the radio button "Change order" on the right hand side of the dialogue. Use "Cut" / "Copy" / "Paste". There is also the possibility to download an existing 3D-model for a package and to recharge the properties. The button "RoHS-Info" enlarges the list of properties with aspects concerning RoHS.
Reload Component Properties
Schematic Menu Components / "Reload Component Properties"
In the dialogue download component properties only the properties of the components in the schematic are replaced. At first you choose a component type and the components from the list for which the properties shall be replaced. In the right area you choose the new component from a component library. Below you activate the appropriate radio button for the component information. This function might be very helpful when you want to exchange and replace properties of components in the whole schematic.
Load properties from database
Properties (eg. distributor's information) can be loaded "en bloc" from a database to TARGET 3001! components. Precondition is: the component must be identifiable. What you need is a list in spreadsheet form or text, cells divided by tabs. In TARGET 3001! please press function key [F2] for opening the Library Browser. Use section "Library" and click M2 on a library which shall receive additional properties.
Select from a flashing context menu entry: "Load component properties from database". Let's say the components of your Library all would have the property "Order-number". By means of the ordernumber the components can be identified individually.
So use the ordernumber as an ID for an individual assignment of other properties, e.g. new prices. Use "Menu Components" for the assignment of new additional properties:
Please make sure that the database shows the column "Order-number" as well as the column "New Prices".
You can do this for components in a library and also for components within a project. You need a CSV or TXT file, fields separated with TAB keys. Also you need an non-ambiguous ID in the existing component values to exactly address the right component for the new properties. If several components have the same ID, they get the same values set.
A detailed example
Imagine you have particular component properties from a data base which you want to add to your TARGET 3001!-components. With TARGET 3001! you are able to charge component properties for components of a certain project or for components of a certain library. In this example you can see a chart made by a common spreadsheet (fields devided by tabs):
Classes of properties have to be in the first line, not in the first column. For adding a set of properties to certain component it must be identifiable by a one of the properties of the above list. We choose the attribute "TARGET-COMPONENT-ID". Any form of identification of this chart is possible it just has to be explicit.
We start with downloading properties of components from a project. Open the schematic and choose one of the concerning components:
Double click M11 on the handle cross of the component opens the dialogue "Change Symbols".
Now use the button 
. The dialogue "Change properties" opens...
...which shows the current component properties. We identify the selected component, a resistor with 470K, for the data transfer by adding the line "TARGET-COMPONENT-ID". For this you just click the line and write. To the right you enter the value, in this case 320, as you can see from the list.
By this entry TARGET 3001! knows that the properties for the componet according to the list are supposed to be charged with TARGET-COMPONENT-ID 320. Choose "Component properties from database" from Menu Components....
...the following dialogue opens. On the one hand now you have to define which attribute you want the components to be identified with (in our case accordant to column A, TARGET-COMPONENT-ID). On the other hand you must define the path, which leads to the chart.
After pressing the button "Start" you get a message...
that TARGET3001! has updated a component, of course the one we just had identified. Opening now the property list of the components we see that all properties have been enclosed:
If you want to add properties from datasets to your components in libraries, please choose the desired library from the library-browser (function key [F2]). Now press M2. Choose the issue "Load component properties from data base..."
The following dialogue opens and the same steps are to be done. It is important that every component of the library has a corresponding identification from the underlying data base.
List of component properties (example)
| Component property | Value |
|---|---|
| 3DMODEL | 3D-model for a package |
| AirWireColor | Supplemental colour for airwires |
| ANCHOR | |
| Article_Buerklin | OrderNo.: Bürklin |
| Article_Conrad | OrderNo.: Conrad |
| Article_DigiKey | OrderNo.: DigiKey |
| Article_Elfa | OrderNo.: Elfa |
| Article_Farnell | OrderNo.: Farnell |
| Article_Reichelt | OrderNo.: Reichelt |
| Article_RSComponents | OrderNo.: RS-Components |
| Article_Schukat | OrderNo.: Schukat |
| Article_Schuricht | OrderNo.: Schuricht |
| Article_Selectronic | OrderNo.: Selectrontic |
| Article_Spoerle | OrderNo.: Spörle |
| BAUTEIL_BIB | |
| BAUTEIL_FUNKTION | Bauteilbeschreibung deutsch |
| BIB_COMPONENT | |
| BILL_OF_MATERIAL | Value "NO" excludes the component from the bill of material (BOM) |
| BLOCKID | |
| CABLE_COLOR | |
| CABLE_CROSS_SECTION | |
| CABLE_QUALITY | |
| CELL_OUTOF | |
| CELL_RIPPED_UP | |
| CELL_VALUE | |
| CELLGEN_VALUE | |
| CELLID | |
| COMPARISON_TYPE | Comparison type for components |
| COMPATIBILITY | |
| COMPONENT_FUNCTION | Component description english |
| COMPONENT_HEIGHT | Component height concerning the package(idf-Export) |
| COMPONENT_HISTORY | Component history |
| COMPONENT_ID | Component ID |
| COMPONENT_NAME | Component name english |
| COMPONENT_VALUE | Component value |
| COMPONENTGROUP | Component group |
| COMPONENTTYPE | Component type |
| COPPER_INSIDE | |
| CORE | |
| CORRESPONDING_TO | |
| DATASHEET | Datasheet link |
| EXECUTE | |
| FONCTION_DU_COMPOSANT | Component description french |
| GENINFO | Interne information concerning the package assistant |
| GROUNDGRID | |
| HARNESS | |
| ID_TRIANGLE_MISSING | |
| IS_CLAMP | |
| IS_COPY_NO | |
| IS_COPY_OF | |
| IS_MEASURE | |
| ISFREE | Standard component for the online library |
| LAST_MODIFIED | Date of the last mofification of the component |
| LAST_MODIFIED_BY | Customer number from the last editor of the component |
| LAST_MODIFIED_PACKAGE | Date of the last modification of the package |
| MANUFACTURER | Component manufacturer |
| Max_Current | |
| Max_Power | |
| Max_Voltage | |
| MULTILINE | |
| NO_3D_EXTRUSION | This component has no 3D model |
| NOM_DU_COMPOSANT | component name french |
| ORIGINAL_NAME | |
| ORDER_NAME | This property overwrites the component type name which is assigned to the part the way it comes from the database, if applicable. |
| PACKAGE_LOCKED | Block package against switching |
| PADNAME | |
| PICK_AND_PLACE | Value "NO" excludes the component from the pick&place list |
| PICTURE | |
| PROPOSED_PACKAGE | Name of proposed package |
| PROPOSED_PACKAGE_LIB | library for proposed package |
| SCALED | Component can be scaled at the import |
| SPICE-MODEL | |
| SUBCELL# | |
| SUPPLIER | Old component order information |
| Tolerance | |
| USED_PACKAGE | Used proposed package |
| USED_PACKAGE_LIB | Used library for proposed package |
| WRONG_CELL | |
| WRONG_CELL_VALUE | |
| SIM_MODEL_NEEDED | Components which do not have a simulation model get a "No" |
| SIMELEM | |
| TESTPOINT |