• Skip to main content
  • Skip to search
  • Skip to footer
Cadence Home
  • This search text may be transcribed, used, stored, or accessed by our third-party service providers per our Cookie Policy and Privacy Policy.

  1. Community Forums
  2. PCB Design
  3. Allegro PCB Editor Report like Condensed BOM report

Stats

  • Locked Locked
  • Replies 40
  • Subscribers 168
  • Views 39869
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Allegro PCB Editor Report like Condensed BOM report

ahmetozsoy
ahmetozsoy over 16 years ago

Hi,

Allegro Editor ( 16.2)  generates Bill of Material Report(Condensed). The report columns are SYM_NAME,COMP_DEVICE_TYPE,COMP_VALUE,COMP_TOL,COMP_CLASS, QUANTITY and REFDES.

This simplified report gives the quantities and used component REFDES in same line.

For ex.

SYM_NAME   COMP_DEVICE_TYPE                                                                                        COMP_VALUE .... REFDES

0402               CAP_SMD-GRM155R71C103KA88D-0402,10NF_50V,GRM155R71C103KA88D        10NF_50V    .....   C3,C5.....

What I want to do is to genarate a report like this simplified one but with PART_NUMBER not COMP_DEVICE_TYPE. Because COMP_DEVICE_TYPE is always long and does inculde extra information other than PART_NUMBER, I wish to use only the PART_NUMBER intsead of COMP_DEVICE_TYPE.

I have checked every option and could not find a simplified report like this one. QUANTITY doesn't exist in generating reports. I want to see the quantity in one line only. So my report can be like this

SYM_NAME   PART_NUMBER                    COMP_VALUE .... REFDES

0402               GRM155R71C103KA88D        10NF_50V    .....   C3,C5.....

Thank you for your helps.

Ahmet OZSOY

  • Cancel
  • EvanShultz
    EvanShultz over 16 years ago

     Hi Ahmet,

    If you can use/learn SKILL, it is not too difficult at all. Go to the Allegro SKILL library in Cadence Online Support and check out rep_bom_ignore.il. You can use that program as a template to create your own custom reports. If you already know SKILL, it will be trivial.

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
  • ahmetozsoy
    ahmetozsoy over 16 years ago

    Hi Evan,

    Thanks for your suggestion.I have examined the skill code, which is so far for me right now. I have tried few of them and this skill code is worked but I want to ask if there is QUANTITY property in database? In condensed BOM there is a field QUANTITY and all the components go into one line. On other report generations there is no option for this. I wish I have defined my problem correctly. Anyway I am gonna work with this skill code and begin to learn skill as soon as possible.

    Thank you for replying.

    Regards

    Ahmet

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
  • flash
    flash over 12 years ago

    Ahmet, 

    We are trying to figure out how to generate a condensed BOM with different fields and have run into the same problems and same questions. Were you able to figure out how to use Skill code to generate the report you wanted?

     

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
  • mcatramb91
    mcatramb91 over 12 years ago

    Not sure if Ahmet figured out an easy way to do this but one very easy way to add the PART_NUMBER field to the standard BOM is by making a slight tweak to BOM_REP.TXT then place it in the same folder as the Allegro database.

    The Master file for BOM_REP.TXT can be found in ( %CDSROOT%\share\pcb\text\views ).  Save a local copy and add the PART_NUMBER line to any line after the COMP_BOM_IGNORE line but do not remove any other lines because the report will not work.   Once the modified BOM_REP.TXT file is in the same folder as the Allegro Database you can run the standard Bill of Materials Report (Condensed) and you should get what you are looking for.

    Here is an example of a modification: (PART_NUMBER will be added as the first column in the report - the order of the columns are based on the line order in the file)

    #
    COMPONENT
    #
    COMP_BOM_IGNORE = ''
    #
    # Extract: package, refdes, device_type,
    #      value, tolerance, comp_class
    #
    PART_NUMBER
    SYM_NAME
    COMP_DEVICE_TYPE
    COMP_VALUE
    COMP_TOL
    COMP_CLASS
    REFDES_SORT
    REFDES
    #

    You could place the modified copy of this file in you library then modified the TEXTPATH Allegro Env Variable path to find it so you don't have to keep on copying it all over the place.  Below is an example of an entry in your %HOME%/pcbenv/env file - it is VERY important to include the $TEXTPATH as the last entry in the setting. (C:/LIBRARY/EXTRACT_VIEWS is a made up path and can really be anywhere but making it a location in your library probably makes sense so everyone can use it.)

    set TEXTPATH = C:/LIBRARY/EXTRACT_VIEWS $TEXTPATH

    Hope this helps,
    Mike Catrambone

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
  • flash
    flash over 12 years ago

    Hi Mike, Thank you for your response. You and I have met at several of the CDNLive! meetings over the years. I've always admired your depth of knowledge, and willingness to help other users.

    We would like a Condensed BOM report with custom properties and order defined, but we haven't been able to figure out how to get the Quantity field into the report just as Ahmed's post stated.

    We are able to create a custom BOM report (we can add, remove, change order etc.) for the properties of interest just as your example shows.

    This is how we want to see the QUANTITY and REFDES fields our customized Condensed BOM. If you run the canned Condensed BOM this is how they are listed.

     

    QUANTITY     REFDES

    1                      C1

    2                      C2;C3;C4 

    I opened, (and closed), a Case with Cadence Support. They directed me to the Skill Code Library, Skill Code documentation etc. They said the Condensed BOM is part of the basic code and not a simple .txt file like the bom_rep.txt or bom_rep_view.txt. (these both gave me the same results, I don't see any differences in them).

    They said the Condensed BOM uses extracta commands in conjunction with Skill or Perl code and they are not supposed to help users write or debug Skill so we are trying to figure this out.

     Any other information you can offer would be appreciated. I will post back when we have a solution.

    • Cancel
    • Vote Up 0 Vote Down
    • Cancel
>
Cadence 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.

© 2025 Cadence Design Systems, Inc. All Rights Reserved.

  • Terms of Use
  • Privacy
  • Cookie Policy
  • US Trademarks
  • Do Not Sell or Share My Personal Information