Saturday, November 22, 2014

Backup Parts Database

From Parts main form select Tools > Backup Parts or Configuration > Backup Parts . . .



When the Parts Frontend is Opened a Daily Backup is created in the selected Backup folder if Create Daily Backups is enabled and a Daily Backup has not been preformed for the day.

or

When the Parts Frontend is Closed a Daily Backup is created in the selected Backup folder if Create Daily Backups is enabled and a Daily Backup has not been preformed for the day.

Selecting Run Backup with Create Daily Backups enabled will send existing same day Daily Backup files to Windows Recycle Bin.

Related Links: 

The Bloated Size Database Alert can be modified in the Config Table or User.ini File.

click on image to view











Tips: 

For corrupted or locked Access databases, close all Parts Frontend Connections and all Altium sessions that are connected to the database, then Compact the Access database.

Microsoft Access was designed for LAN. 
MySQL was designed for LAN and WAN.

Using a Cloud Hosted MySQL Database is Recommended for Remote Multi-User Libraries.

Contact Parts to request technical support or a Free online demonstration.

That's It !

Sunday, October 12, 2014

Lifecycle

The Lifecycle parameter is an optional feature in the Parts database.

Parts is configured with the Lifecycles shown below.












New;Checked;Released;Production;Deprecated;End of Life;Obsolete

Users can add or edit lifecycles by editing the configuration file.

click on image to view





The default LifeCycle is New when the record is created.

The Deprecated, End of Life and Obsolete life cycles can be used to discourage users from placing components in a design.

Tip: 

Include the life cycle parameter in your BOM and review with your team or customer which parts in the design have the greatest risks.

Risks:

Parts which have new symbols or footprints are the highest risks parts.


Checked parts are new parts which have been checked against the datasheet, preferably by a second set of eyes.


Released parts are parts that have been released to customers.


That's It.

Trim and Clean

Automatic 'Trim and Clean' is used to scrub the data in the Parts table.

Leading and trailing spaces, CR, LF and TAB characters are removed from the data.
Non-Breaking Space (NBSP) characters are replaced with standard ASCII spaces.

These characters may be embedded in data that users cut and paste from web pages.

Multiple space characters are reduced to a single space.

Notes: 

When the Save Command button selected the current record is Trimmed and Cleaned.

Trim and Clean is applied when data is imported using Parts Tools > Import Excel.

That's It !