Configure the Parts application
The Parts librarian can easily configure and distribute the Parts Frontend.
Use the Frontend application to create and save the configured application.
Then Zip up and distribute the configured Parts_Frontend to your users.
Zip up the Parts_Frontend file and place the Zipped file in a shared network drive folder.
Instruct users to copy the zip file and extract the Part_Frontend file in a folder on their local C:\ drive.
Notes:
If users have Access 2010 or higher installed on their machine they can run the Parts_Frontend.accde.
If the users do NOT have Access 2010 or higher on their computer they can install the free Microsoft Access runtime and run the Parts Frontend.
Steps for Upgrading to the latest version of the Part Frontend:
Save a copy of your existing Parts Frontend in the event you want to roll back to the older version.
Download and Drop the latest Parts_Frontend in the same folder where your previous version of the Frontend was installed.
Place the Zipped and Configured Parts_Frontend file in a shared network drive folder.
To keep the users on the same version of the Parts Frontend, instruct users to copy and extract the zipped Parts_Frontend file to a folder on their local C:\ drive.
Related Link: Moving and Sharing Parts
That's it !
Friday, July 24, 2015
Sunday, June 28, 2015
Export to Excel
To Export the Entire Parts Database > Select Tools > Export
Checking Acquire Models will copy Symbol and Footprint files.
The Acquired Models folder will be created in the same folder as the Exported data.
To Export Filtered Records > Select Filter > Export.
Tip:
To Prevent overwriting the ID Field (Primary Key) you may want to delete the ID column in the exported Excel workbook if you are planning to merge or append the exported data with another Parts compatible database.
That's it !
Saturday, June 13, 2015
Import Excel
Excel data can be imported to restore or add and update the Parts database.
Bill of Materials can be imported.
Select Import to append and update records in the Parts Database.
The above description was built by concatenating fields (parameters):
Part Type, SubType, Value, Tolerance, Voltage Dielectric and Package Case
Use Preferred Names
This option can be used to create consistent Supplier and Mfr Names uisng data found in the mfrs_links and suppliers_link tables,
Make Library Paths
This option can be used to create Library Paths by prefixing Library Refs with Footprints\ or Symbols\ when a BOM is imported and the Library Ref parameter is included. Parts will attempt to build the Library Path if this option is enabled.
Required fields are determined by properties that are set in the Backend database.
New part numbers are appended and all records with matching IDs are updated.
Tips:
The Import data updates all records in the Parts table where the IDs in the Source data match the IDs in the Destination table.
The Import command can used to append and update the Destination table from the imported data.
Map parameters in the Source and Destination tables.
Select Import to append and update records in the Parts Database.
Import Options:
Selected Import Options are applied to the Imported Table.
Get All Sheets in the Workbook.
When enabled this Option retrives all sheets in the selected Excel Workbook.
If the Option is not enabled then only the first sheet found in the Excel work is opened.
Build Part Descriptions
This option will build a Part Descriptions for Capacitors, Resistors and Inductors if the Part Description is blank (empty) in the imported datasheet.
Example:
CAP CER 0.1uF ±10% 10V X5R 0402 (1005 Metric)
This option will build a Part Descriptions for Capacitors, Resistors and Inductors if the Part Description is blank (empty) in the imported datasheet.
Example:
CAP CER 0.1uF ±10% 10V X5R 0402 (1005 Metric)
The above description was built by concatenating fields (parameters):
Part Type, SubType, Value, Tolerance, Voltage Dielectric and Package Case
Use Preferred Names
This option can be used to create consistent Supplier and Mfr Names uisng data found in the mfrs_links and suppliers_link tables,
Make Library Paths
This option can be used to create Library Paths by prefixing Library Refs with Footprints\ or Symbols\ when a BOM is imported and the Library Ref parameter is included. Parts will attempt to build the Library Path if this option is enabled.
Paths are only created for records that have an empty (blank) Library Path and if Library files exist in the Footprints or Symbols folders.
Tip:
Tip:
Use Altium's Library Splitter Wizard to push library files to the Footprints and Symbols folders.
Update Time Stamps
This option can be used to modify the Updated_By and Updated_Date fields.
Notes:
When the Destination is the 'Parts' table and the ID column is not included in the Imported data ID numbers will be automatically generated using next available ID numbers.
Update Time Stamps
This option can be used to modify the Updated_By and Updated_Date fields.
Notes:
When the Destination is the 'Parts' table and the ID column is not included in the Imported data ID numbers will be automatically generated using next available ID numbers.
The Imported ID field must NOT contain a combination of blanks and ID values.
Required fields are determined by properties that are set in the Backend database.
New part numbers are appended and all records with matching IDs are updated.
Tips:
The Import data updates all records in the Parts table where the IDs in the Source data match the IDs in the Destination table.
Records in the source data are appended to the destination table where the IDs are not matched (new records).
Data in the Destination table will be overwritten with data from the Source table where the IDs are matched.
Use Compare if you want to review the changes and updates prior to importing the data.
That's It !
Data in the Destination table will be overwritten with data from the Source table where the IDs are matched.
Use Compare if you want to review the changes and updates prior to importing the data.
That's It !
Subscribe to:
Posts (Atom)