Home > Community > Blogs > PCB Design > what s good about capture cis relational tables spb16 3 has a few new enhancements
 
Login with a Cadence account.
Not a member yet?
Create a permanent login account to make interactions with Cadence more conveniennt.

Register | Membership benefits
Get email delivery of the PCB Design blog (individual posts).
 

Email

* Required Fields

Recipients email * (separate multiple addresses with commas)

Your name *

Your email *

Message *

Contact Us

* Required Fields
First Name *

Last Name *

Email *

Company / Institution *

Comments: *

What's Good About Capture CIS Relational Tables? SPB16.3 Has a Few New Enhancements!

Comments(4)Filed under: Capture CIS, Component Information Portal (CIP), OrCAD Capture, OrCAD, Librarians, Schematic, Capture-CIS, SPB 16.3, Allegro 16.3, Allegro Design Entry, Design Entry CIS, PCB Capture, SPB16.3, Library, design, data management, design data management, relational tables

If you have defined relational fields in your Allegro Design Entry CIS configuration, you can now include the relation fields in your CIS Bill Materials. When you include relational data in your reports, you can also decide how you want this data displayed. So you can choose to display the relational data horizontally (in the same row) or vertically (one line item per related data).

A completely different perspective would be to leverage EMA’s Component Information Portal™ (CIP) for design engineers using Cadence® OrCAD® Capture CIS. There was an announcement this week about another large component supplier connecting into the CIP system - Mouser Electronics Integrated into CIP for Cadence® OrCAD® Capture CIS.

Read on for more details…

Relational Database support for CIS was introduced in the SPB16.2 version of Capture. The SPB16.3 version of  Capture CIS provides users an option to include relation fields in the CIS bill of materials.


Generating a CIS Bill Materials


1. From the Part Manager’s Reports menu, choose CIS Bill of Materials - Standard. The Standard Bill of Materials dialog box displays:



 
2. In the Template Name text box, type in a name for the template, or select one from the drop-down list.

3. Select a part property you want in the bill of materials and click the Add button. The part property moves to the Output Format list. Click on the List Relation Data Fields so that report properties will contain the properties from the relational table.

4. Once you click on the check box list Relation Data you will be able to add all the vendor table properties in the output format. For example in this case VENDOR:Part Number,VENDOR:vendor etc. gets added to the output format. In this case VENDOR is the table name in the database while Part Number is the column name in the vendor table.

5.In some cases in the Vendor table you can have the same part from two vendors. So in order to show both options you need to check  Relation Data displayed:



 
6.  By default, the report will display vertically the relation table content , clicking the check box Horizontal Output will change the format:



 
In the design all the resistors have two vendor tables thus in the BOM you will have 2 row/columns containing the data. In case the vendor table has more than 2 vendors, you will need to increase the size of the Max_rows accordingly.

Here’s a screenshot showing the vertical report for the BOM:



 

Here’s a screenshot showing the horizontal check box ON:



 

 

Please share your experiences with this new SPB16.3 capability.

Jerry "GenPart" Grzenia

Comments(4)

By Ahmet Nazim OZSOY on April 17, 2011
I wish these reports ( especially exporting to excel) will be available in DE HDL tool also.

By Jerry GenPart on April 18, 2011
Hi Ahmet -
Well - the BOMHDL utility (in DEHDL) does output a BOM in Excel format.
Jerry

By ahmetozsoy on April 20, 2011
Has it? It has: text export, html export and comma(or else) seperated text export format. And html format is not as good as Allegro html format. DE HDL must be IMPROVED.

By Jerry GenPart on April 20, 2011
Hi Ahmet -
Agreed - the direct Excel output from CIS is better than DEHDL. I was trying to provide a possible option (the .csv file that can be read by Excel) in DEHDL that some designers might not know exists. Look for some improvements in DEHDL in the future in this specific area.
Jerry

Leave a Comment


Name
E-mail (will not be published)
Comment
 I have read and agree to the Terms of use and Community Guidelines.
Community Guidelines
The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.