Component properties

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):

Search a smt resistor 10K with 3D model
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:

Eigenschaften2 e.png
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:

Eigenschaften2a e.png
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...

Eigenschaften3 e.png

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

Eigenschaften4 e.png

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

Eigenschaften5 e.png

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

Eigenschaften6 e.png

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. 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:
Furthermore you can forward a search for a component using its name to the search field of a 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.

Forward order number to shop M2 means: Use right mouse key.
Image: Based on the search NE555 and the match NE555D (green)...

Forward order number to shop
Image: ...TARGET finds the order number 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

Eigenschaften7 e.png

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 package 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.

Eigenschaften8 e.png

Reload properties from a CSV file

Please find this function in component browser menu "Extra/Reload properties from a CSV file"

Such a CSV file uses the colon as a divider and expects the following line structure:



It is always attempted at first to use a USER component with this name. If not available, a TARGET component is used. The manufacturer including the semicolon can also be omitted. If the name exists more than once, an error message is displayed Several property value pairs are separated with the vertical bar (tube). If the part is a USER component, then the system also tries to set the property as a part parameter. Otherwise, a user-defined property is always created or changed. The value DELETE! effects that the property is deleted completely.

A line beginning with // is a comment line. Please note that the encoding of the CSV text file must be ANSI, not e. g. UTF-8!

Create components from a CSV file

Please find this function in component browser menu "Extra/Create components from a CSV file"

As a text file the CSV must be structured as follows:

NE555_1;NE555D;Texas Instruments;Prop1=Hello|Prop2=ladies and|Prop3=gentlemen!
NE555_2;NE555D;Texas Instruments;Prop1=This|Prop2=is a new|Prop3=feature

Lines with // at the beginning are comments. First comes the name of the part to be generated (NewName). Then comes the name of the source part from which it is to be derived (SourceName). The manufacturer's name (Manufacturer) can also remain empty if the source component can be uniquely identified without the manufacturer, but the semicolon must still appear. The 3 entries are each completed with a semicolon. Then parameters and properties can come. The property and the value are separated by a =, the different properties are separated by a vertical bar (tube).

If the new component is to have a manufacturer or a different one, the parameters Manufacturer=XYZ can be put to the end of the list.

If a "new" component already exists, only the properties are refreshed. Please note that the encoding of the CSV text file must be ANSI, not e. g. UTF-8! If umlauts and special characters are incorrect, please change the source code accordingly!

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:

E PropNE555.jpg

The dialogue "Edit properties" you will find...

After click on it in the schematic the following dialogue appears:

E Eigenschaften.jpg

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.

E EigRoHS.jpg

Reload Component Properties

Schematic Menu Components / "Reload Component Properties"

E Bauteil Eig austausch.jpg

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.

E EigenNachl7.jpg

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):

E EigenNachl1.jpg

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".

E EigenNachl3.jpg

Now use the button ButtonProperties.jpg. The dialogue "Change properties" opens...

E EigenNachl4.jpg

...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.

E EigenNachl5.jpg

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....

E EigenNachl6.jpg

...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.

E EigenNachl7.jpg

After pressing the button "Start" you get a message...

E EigenNachl8.jpg

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:

E EigenNachl10.jpg

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..."

E EigenNachl11.jpg

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.

E EigenNachl7.jpg

List of component properties (example)

Component property Value
3DMODEL 3D-model for a package
AIRWIRECOLOR Supplemental colour for airwires
ALLOW_HOLE_IN_SMD Project test: Allows drill hole in a SMD-pad
ARTICLE_SELECTRONIC OrderNo.: Selectrontic
BAUTEIL_FUNKTION Bauteilbeschreibung deutsch
BILL_OF_MATERIAL Value "NO" excludes the component from the bill of material (BOM)
COMPARISON_TYPE Comparison type for components
COMPONENT_FUNCTION Component description english
COMPONENT_HEIGHT Component height concerning the package(idf-Export)
COMPONENT_HISTORY Component history
COMPONENT_NAME Component name english
COMPONENT_VALUE Component value
COMPONENTGROUP Component group
COMPONENTTYPE Component type
DATASHEET Datasheet link
FONCTION_DU_COMPOSANT Component description french
GENINFO Interne information concerning the package assistant
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
NO_3D_EXTRUSION This component has no 3D model
NOM_DU_COMPOSANT component name french
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
PICK_AND_PLACE Value "NO" excludes the component from the pick&place list
PROPOSED_PACKAGE Name of proposed package
PROPOSED_PACKAGE_LIB library for proposed package
SCALED Component can be scaled at the import
SUPPLIER Old component order information
USED_PACKAGE Used proposed package
USED_PACKAGE_LIB Used library for proposed package
SIM_MODEL_NEEDED Components which do not have a simulation model get a "No"