Das Administrationsmodul ermöglicht es dem Anwender das Einfügen von bestimmten Katalogen, Bauteilfamilien oder einzelnen Bauteilen zu verbieten.

The administration module allows the user to forbid insertion of specific catalogs, parts families or single part.

Requirements

1. A valid license for the external data link module,
2. TraceParts installed,
3. Microsoft Access 2000 or higher, to edit the database (only required to set the authorizations - see below).

Description of the administration module

Using this module, the user can:

• Authorize or forbid the use of one or more manufacturer catalog,
• Authorize or forbid the use of one or more standard catalog,
• Within a catalog, authorize or forbid the use of one or more parts,
• Within a given part, authorize or forbid the use of one or more instances of the part.

• This database is always installed with TraceParts.
• Its default location is: c:\program files\Trace Software\Trace Parts\Custom\TRACEPARTS.
Information related to the authorizations can also be stored in a standalone database designed by the user (we will come back to this point later)

Note: Forbidden catalogs, parts or instances will not be hidden. The user will still see them in TraceParts, but he will get an error message when trying to insert them.

Each time the user clicks the "Insert component" button in TraceParts:

• TraceParts go to TPCustomInfos.mdb,
• TraceParts checks if any information related to the selected part are available in the TPCI_Authorizations table,
• If the part (or the instance of the selected part, or the catalog) is allowed, TraceParts inserts the part in the CAD program,
• If the part (or the instance of the selected part, or the catalog) is forbidden, TraceParts displays an error message to warn the user.

Use

1. Activate the administration feature (on first use only):

As a default, TraceParts does not use the administration module and therefore, all instances of all parts, of all standards or manufacturers catalogs are authorized and can be inserted.

To activate the administration feature:

1. Close TraceParts if running,
2. Open TPCustomInfos.mdb with Microsoft Access,
3. Open "TPCI_Properties" table,
4. In the line which field "SYMBOL" value is set to "TPCI_Authorizations.Enabled", change the value of field "VALUE" to "1" as shown below:



2. Define the place to store the authorization information.

This place can be:
• A table in TPCustomInfos.mdb - That is the default location.

Or

• A table in another database than TPCustomInfos.mdb

To store the authorization information INSIDE "TPCustomInfos.mdb":
1. Close TraceParts if running,
2. Open TPCustomInfos.mdb with Microsoft Access,
3. Open "TPCI_Properties" table,
4. In the line which field "SYMBOL" is set to "TPCI_Authorizations.UseExternalDb", change the value of the field "VALUE" to 0 (zero) - Like in the above picture.

To store the authorization information OUTSIDE "TPCustomInfos.mdb" (in another database):
1. Close TraceParts if running,
2. Open TPCustomInfos.mdb with Microsoft Access,
3. Open "TPCI_Properties" table,
4. In the line which field "SYMBOL" is set to "TPCI_Authorizations.UseExternalDb", change the value of the field "VALUE" to 1.

Warning
When using another database to store the authorization information, the field "VALUE" of the line which field "SYMBOL" is set to "TPCI_Authorizations.DatabaseID" must be set to a correct value.
The "correct value" is the ID of the database to use, defined in table "TPCI_Databases" of TPCustomInfos.mdb.
As an example, with the "TPCI_Properties" table shown below, the authorization information will be stored in a database which ID is #1.



And if we look at table "TPCI_Databases" in TPCustomInfos.mdb, we can see that database ID #1 is named "MyAuthorizations.mdb".


Please contact us for more information.

 

3. Define the authorization information.

IMPORTANT
Whatever the selected place to store the authorization information is, these information must be in a table named "TPCI_Authorization". This table must have the same structure as the "TPCI_Authorization" table of TPCustomInfos.mdb database.

"TPCI_Authorization" database.

Below, is an example of how "TPCI_Authorization" table could look like:




This table is made of 3 fields, here are their descriptions:
Type and Object

"Type" value	Description	"Object" stands for..
1	Authorization of a part family	.. the PartNumber of the family to authorize
2	Authorization of an instance of a part family	.. the value of "instance_id" parameter of the instance of the part family to authorize
3	Authorization of manufacturer	..the Manufacturer symbol (eg: NORELEM..) to authorize
4	Authorization of standard	..the acronym of the standard (eg: ISO, DIN..) to authorize

Status

Value	Description
0	Object not authorized
1	Authorized object

On the example shown above:
• The part family (type=1) "04-01022005-089749" (=object) is not authorized (status=0)
• The instance (type=2) "69-15022006-021546BVF30FOCDLD613XB3BDOQOLHC" (=object) is authorized (status=1)
• The manufacturer (type=3) "NORELEM" (=Object) is not authorized (status=0)
• The standard (type=4) "DIN" (=Object) is not authorized (status=0)

FAQ

1. Are the manufacturer name and manufacturer symbol the same?
2. Where can the manufacturer symbol be found?
3. Where can the standard acronym be found?
4. Where can the PartNumber of a part be found?
5. What is the "instance_id" and how can it be found?
6. Is it possible to authorize all parts of a catalog except some?
7. Is it possible to unauthorize a catalog except some of its parts?


1. Are the manufacturer name and manufacturer symbol the same?
No they are not (althougth they can sometimes be identical)

2. Where can the manufacturer symbol be found?
Easiest way to find manufacturer symbol is to have a look in the registry, under "My computer\HKEY_LOCAL_MACHINE\SOFTWARE\Trace Software\Trace Parts\Packages\Parts" entry.

3. Where can the standard acronym be found?
The acronyms to use are the normalized acronyms of the standards. E.g.: ISO for..ISO, DIN for DIN...etc.
If any doubt, as with manufacturers symbols, acronyms to use can be found in the registry (under "My computer\HKEY_LOCAL_MACHINE\SOFTWARE\Trace Software\Trace Parts\Packages\Parts")

4. Where can the PartNumber of a part be found?
The only way to find the PartNumber of a part is to run TraceParts in "debug" mode.

To do so:
1. Log as administrator,
2. Go to start menu/Run,
3. In the "Run" dialog box that will open, enter regedit in the "Open" field and click "ok"
4. In the registry editor, go to "My computer\HKEY_LOCAL_MACHINE\SOFTWARE\Trace Software\Trace Parts"
5. In the right hand side of the registry editor, double click "Default" string. Change its value to "debug" (without quotation marks)
6. Close registry editor
7. Run TraceParts, the PartNumber of each part is now displayed just below the picture of the parts.


To stop debug mode, just set back the value of "Default" string to its previous value (null).


5. What is the "instance_id" and how can it be found?
Each part inside TraceParts is a parametric model. By changing the values of the different parameters of a part, several different parts can be drawn. Each of these parts is an instance of part, and each instance has a unique ID, that is the "instance_id".

Currently, there is no easy way to know the instance_ID of an instance - this feature is still under development.

6. Is it possible to authorize all parts of a catalog except some?
Indeed. Just authorize the catalog, then list the Partnumber(s) of the part(s) to unauthorize.

7. Is it possible to unauthorize a catalog except some of its parts?
Yes. Just unauthorize the catalog, then list the Partnumber(s) of its part(s) to authorize.
4. Run TraceParts.

That is it. Assuming TPCustomInfos.mdb is properly set, and is located at the right place (in c:\program files\Trace Software\Trace Parts\Custom\TraceParts as default), just run TraceParts.
Each time "insert button" will be clicked, TraceParts will check if the part is authorized or not according to "TPCI_Authorization".