Home > Community > Forums > PCB Design > Allegro PCB Editor Report like Condensed BOM report

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: *

 Allegro PCB Editor Report like Condensed BOM report 

Last post Mon, Apr 14 2014 12:37 PM by flash. 12 replies.
Started by ahmetozsoy 09 Nov 2009 04:01 AM. Topic has 12 replies and 3204 views
Page 1 of 1 (13 items)
Sort Posts:
  • Mon, Nov 9 2009 4:01 AM

    • ahmetozsoy
    • Top 200 Contributor
    • Joined on Mon, Jul 14 2008
    • ANKARA, 00-TR
    • Posts 38
    • Points 735
    Allegro PCB Editor Report like Condensed BOM report Reply

    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

    • Post Points: 20
  • Tue, Nov 10 2009 6:28 PM

    Re: Allegro PCB Editor Report like Condensed BOM report Reply

     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.

    • Post Points: 20
  • Wed, Nov 11 2009 1:46 AM

    • ahmetozsoy
    • Top 200 Contributor
    • Joined on Mon, Jul 14 2008
    • ANKARA, 00-TR
    • Posts 38
    • Points 735
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    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

    • Post Points: 20
  • Wed, Oct 2 2013 8:54 AM

    • flash
    • Not Ranked
    • Joined on Thu, Jul 17 2008
    • Rochester, MN
    • Posts 6
    • Points 100
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    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?

     

    • Post Points: 20
  • Wed, Oct 2 2013 12:38 PM

    • mcatramb91
    • Top 75 Contributor
    • Joined on Thu, Jan 3 2013
    • Chelmsford, MA
    • Posts 95
    • Points 4,920
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    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

    • Post Points: 35
  • Wed, Oct 2 2013 2:10 PM

    • flash
    • Not Ranked
    • Joined on Thu, Jul 17 2008
    • Rochester, MN
    • Posts 6
    • Points 100
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    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.

    • Post Points: 20
  • Wed, Oct 2 2013 3:15 PM

    • mcatramb91
    • Top 75 Contributor
    • Joined on Thu, Jan 3 2013
    • Chelmsford, MA
    • Posts 95
    • Points 4,920
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    Thanks for all the compliments, I really appreciate it.

    I apologize, but I think I am missing something.  If I run the Bill of Material Report (Condensed) from Tools > Reports or Tools > Quick Reports I do get a Quantity column.  I can then add the PART_NUMBER line and it comes out in the report as well.   If I move the REFDES_SORT and REFDES Lines to the top of the list in BOM_REP.TXT then the first column is Quantity and the second column is Ref Des. (See attached image)

    Unfortunately, you will not be able to condense it any further because, as Support indicated, there is a behind the scenes script that is running to the format the output so all the fields are required for it to work, but you could add extra fields.

     


    • Post Points: 35
  • Thu, Oct 3 2013 9:48 AM

    • oldmouldy
    • Top 10 Contributor
    • Joined on Tue, Jul 15 2008
    • Woking, Surrey
    • Posts 1,371
    • Points 23,350
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    I think that it is the bom_rep.txt that needs to be changed, "hacking" bom_rep_view.txt seems to do little. The report file must retain the name of bom_rep.txt to get called as the "condensed bom extract control". The default configuration will find the local version and use that instead of the default installation version. If the default textpath of ".", current directory, has been removed from the User Preferences, one of the textpath locations will need to be used instead to get the txt file found. Looking at the menus, the "Reports" looks to invoke "reports" which is, in turn, coded internally, this must take the "BOM (Condensed)" report selection and wrap it into the (post) processing to get the "condensed" report version.

    (Also changing the field order in the regular BOM report control file has no effect on the field positions in the report, so there looks to be "something" in the (post) processing of the "condensed" version that handles this)

    • Post Points: 20
  • Thu, Oct 3 2013 9:58 AM

    • mcatramb91
    • Top 75 Contributor
    • Joined on Thu, Jan 3 2013
    • Chelmsford, MA
    • Posts 95
    • Points 4,920
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    Thanks oldmoudly - You are right!  I specified the wrong file in my previous posts, it is bom_rep.txt that could be updated NOT bom_rep_view.txt.  Sorry about that.

    • Post Points: 5
  • Thu, Oct 3 2013 12:28 PM

    • flash
    • Not Ranked
    • Joined on Thu, Jul 17 2008
    • Rochester, MN
    • Posts 6
    • Points 100
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    It looks like we will have to figure out post processing the custom file we generate outside of Cadence for now. Thanks for the feeback everyone.

    • Post Points: 20
  • Thu, Oct 3 2013 1:07 PM

    • oldmouldy
    • Top 10 Contributor
    • Joined on Tue, Jul 15 2008
    • Woking, Surrey
    • Posts 1,371
    • Points 23,350
    Re: Allegro PCB Editor Report like Condensed BOM report Reply
    If you want to provide the details of the Component properties that you want to extract and how you want them reported, I will see if I can make something in SKILL that will work. If you provide the details, don't hold your breath while I get it done!
    • Post Points: 20
  • Thu, Oct 3 2013 1:43 PM

    • flash
    • Not Ranked
    • Joined on Thu, Jul 17 2008
    • Rochester, MN
    • Posts 6
    • Points 100
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    Thanks oldmouldy,

    If we can't figure it out, I'll get in touch with you. Thank you for offering to help us.

    • Post Points: 5
  • Mon, Apr 14 2014 12:37 PM

    • flash
    • Not Ranked
    • Joined on Thu, Jul 17 2008
    • Rochester, MN
    • Posts 6
    • Points 100
    Re: Allegro PCB Editor Report like Condensed BOM report Reply

    Mike,

    I've been doing other work for quite a while and was not able to focus on this issue until today. I followed your advice and was able to generate the condensed BOM with our user defined properties. Thank you for your concise explanation and guidance.  We just need to decide on a common location as you suggested so all users can access the file(s) without copying them. Thank you again, you saved us a lot of time and frustration.

     

    • Post Points: 5
Page 1 of 1 (13 items)
Sort Posts:
Started by ahmetozsoy at 09 Nov 2009 04:01 AM. Topic has 12 replies.