YouTube Video User Defined Fields
Close all connections to the Database (Parts Backend) !
A database should not be re-designed while users are connected to the database.
If users are connected to Parts Database ask them to close their Parts Frontend applications and Altium connections while you modify the Parts Database.
For MySQL use MySQL Workbench to add fields to the Backend Database. Then in the Parts Frontend Select Configuration > User Defined Fields, enter the user defined fields and select Apply in the Configuration form.
Example to add a field Named Package_Size to the Parts database.
Close the form and select the Apply button in the Configuration dialog to create the fields.
Unbound fields are fields that are not linked to the main form.
To remove unbound fields use Tools > Clean Parts > Delete Unbound Fields. Or edit the Parts Backend database.
Notes:
Configurations can be saved to and loaded from a local or shared network drive.
Do NOT delete the User-defined records. Leave the VariableValue column blank or enter a field name to add a new field.
Each user has a User.ini file (user preferences) which is stored in the same folder as the Parts Frontend on the user's machine.
Close all connections to the Database (Parts Backend) !
A database should not be re-designed while users are connected to the database.
If users are connected to Parts Database ask them to close their Parts Frontend applications and Altium connections while you modify the Parts Database.
For MySQL use MySQL Workbench to add fields to the Backend Database. Then in the Parts Frontend Select Configuration > User Defined Fields, enter the user defined fields and select Apply in the Configuration form.
For MySQL User Defined Fields can be added using the Pats Frontend if the user named in the connection string has been given privileges and permissions to alter the MySQL database.
If the named user does NOT have permissions and privileges an ADO Error Handler message will pop up if the user attempts to alter (add fields) to the database.
For Access databases you can Select Configuration > User Defined Fields, enter the user defined fields and select Apply in the Configuration form.
Example to add a field Named Package_Size to the Parts database.
Close the form and select the Apply button in the Configuration dialog to create the fields.
Unbound fields are fields that are not linked to the main form.
To remove unbound fields use Tools > Clean Parts > Delete Unbound Fields. Or edit the Parts Backend database.
Notes:
Configurations can be saved to and loaded from a local or shared network drive.
Do NOT delete the User-defined records. Leave the VariableValue column blank or enter a field name to add a new field.
Each user has a User.ini file (user preferences) which is stored in the same folder as the Parts Frontend on the user's machine.
Part Status in legacy versions used . . .
New;Checked;Released;Production;Deprecated;End of Life;Obsolete;
The latest version of Parts uses Dynamic user defined Part Status.
Dynamic values are created by simply entering test in the Part Status field.
