topic Re: Interactive BOM For Eagle in EAGLE Forum

Interactive BOM For Eagle

sdalling — Tue, 25 Sep 2018 17:38:25 GMT

I ported the Interactive BOM plugin for KiCAD to EagleCAD. A demo of the plugin working for KiCAD is here. I'm currently looking at getting some feedback on my port to EagleCAD.

To use the plugin, run the ibom.ulp within your board file. This will result in a 'pcbdata.json' file being generated. It will be placed in the same folder as your pcb file.

Copy this file to be in the same folder as the following files

1) ibom.html

2) index.css

3) index.js

Then double click on ibom.html to start the application. This will open your web browser with interact BOM being the focused window.

Its a little rough around the edges in some places, but im working on fixing those (support for rectangle types, bounding box on selected parts sizing). If there are issues feel free to leave comments here or to report errors on my fork of the project on github.

Re: Interactive BOM For Eagle

C.Nicks — Tue, 25 Sep 2018 18:09:39 GMT

Hello,
Thanks for posting this. I've never used the KiCad plugin, but so far this is looking like a very handy tool. I've included a little feedback from first impressions. I especially like the interactive viewer and dark mode.

First run notes:
- pcb data file is placed in project folder if project is open.
- Value field is showing the package footprint and the footprint is showing the reference designator (see screenshot).

Suggestions:
- Add folder picker for output location
- Add options for addition fields, similar to the checkboxes (example, I use MFPN for part number selection)
- Add exclude attribute option to exclude certain parts (documentation frames, notes, mounting locations, etc)
I use an attribute called BOM and if the value is set to EXCLUDE it keeps it out of my usual outputs.

Re: Interactive BOM For Eagle

rachaelATWH4 — Wed, 26 Sep 2018 14:50:02 GMT

Hiya,

Nice work! I was impressed with that plugin when I first saw the KiCAD version announced on an EEVBlog thread. I've just tried your EAGLE port and it's definitely a useful tool with a lot of promise

I'm in agreement with @C.Nicks in his suggestions. Having the ability to customize the attributes it shows would be extremely beneficial, as well as the ability to exclude certain items from the BOM.

One more thing I thought would be excellent would be if you could select a consolidated BOM view which grouped identical parts (maybe on a specified column(s)) and give a total quantity for each and then give the ability to export that to csv, ods, xlsx, etc.

A couple of bugs I noticed, neither of the filter boxes at the top seem to be working for me. I'm running it on chrome on macOS.

Best Regards,

Rachael

Re: Interactive BOM For Eagle

rachaelATWH4 — Wed, 26 Sep 2018 15:02:20 GMT

Also I just noticed that the value field seems to be filled with the device name rather than it's value and the footprint field is replicating the reference designator.

Best Regards,

Rachael

Re: Interactive BOM For Eagle

sdalling — Wed, 26 Sep 2018 15:34:49 GMT

Thank you for the feedback. I am in the process of fixing the bugs that you and @C.Nicks have found. right now the filtering and the value/footprint are fixed. I's adding in the user specified fields now.

Ill let everyone know when they are complete.

Re: Interactive BOM For Eagle

sdalling — Thu, 27 Sep 2018 02:40:51 GMT

I have updated Interactive BOM to version V1.1. All of the files are in a zip file in Github. The steps to use it are the same as before.

A summary of the changes

I have added a file picker for where the output file should go.
Fixed all fields so they display the correct data
Added setting for displaying combined or non combined parts by value

I have a few questions that I want to get peoples opinions on.

For removing entries (as per @C.Nicks), would it make more sense to do this at the Eagle ULP level or at the application level? I am thinking of doing this at the application level and the user specifies in the app settings menu an attribute that to filter the BOM.
Does having the revision in the middle of the GUI make sense? Should this be a board attribute?
Having a lot of configurations on the settings tab can become troublesome since they need to be reentered every time. A solution to this would be to have an external config file where a user can put in there defaults. Would adding another file be asking to much from the user?

Re: Interactive BOM For Eagle

sdalling — Fri, 28 Sep 2018 00:06:37 GMT

I have addressed all of the comments of both @C.Nicks and @rachaelATWH4 except for exporting the BOM to an external file. I am calling the release V1.4, and can be found in the Release folder on Github.

If anyone as they use it find bugs or has suggestions for future development let me know and I will add it to the TODO list.

Re: Interactive BOM For Eagle

iquacker — Sat, 29 Sep 2018 15:31:17 GMT

This is a great app! Thanks for making it!

When I showed it to my prototype assembler, the first thing she asked is if she could click on a footprint on the board and have it show up on the BOM. One reason she wants it is because our boards are usually very tight. For this and for IP reasons, we never place part names on the silkscreen layer. Hmmm...

Possible in the future?

Regards -

Re: Interactive BOM For Eagle

sdalling — Sun, 30 Sep 2018 03:40:12 GMT

This would actually be pretty cool. I will add the the back and forth ability to the TODO list.

Re: Interactive BOM For Eagle

sdalling — Sun, 07 Oct 2018 08:49:47 GMT

@iquacker, I implemented the clicking on parts in the schematic to highlight them in the schematic and BOM.

It is release V1.6.

Let me know what you think and if there are any other changes you come up with or problems/issues you discover.

Re: Interactive BOM For Eagle

iquacker — Sun, 07 Oct 2018 16:49:17 GMT

This is great! Thanks!

I tried my best to fool it or crash it. No issues found.

One more feature suggestion that might be a bit much to ask for:

Can you get the BOM to group by value? E.g. all parts with the same value on the same line? Then if you click that line, all those parts light up at the same time. And of course, vice versa. If you have the BOM arranged this way and click on any of the parts in a group, they all light up.

Possible?

Best regards -

Re: Interactive BOM For Eagle

sdalling — Sun, 07 Oct 2018 17:50:33 GMT

@iquacker, for sorting by value should be within the software. To enable click on the gear icon in the top right. Then check the box for "Combine By Value". This should then combine all elements that are the same value in the BOM, and highlight all of them on the board when selected.

Re: Interactive BOM For Eagle

iquacker — Sun, 07 Oct 2018 18:37:16 GMT

Ha! Perfect!

Re: Interactive BOM For Eagle

C.Nicks — Wed, 10 Oct 2018 17:34:22 GMT

Hey @sdalling
That you for all of the updates to this. I'm just now getting around to testing it out again as I have a good use for it while assembly some new test boards.
There is an issue with 1.6. Nothing is being displayed. I'm running MacOS 10.14 and Eagle 9.2.

Re: Interactive BOM For Eagle

sdalling — Thu, 11 Oct 2018 04:33:31 GMT

@C.Nicks, I was looking at this tonight. I was able to get the behavior you described when the newer version of IBOM.html is used with an old version of the ibom.ulp.

I should of specified that the new version needs to use the updated ULP in my release notes.

If switching does no work, what browser are you using?

Re: Interactive BOM For Eagle

C.Nicks — Thu, 11 Oct 2018 18:03:20 GMT

Everything was unpacked form the latest 1.6 version.

Re: Interactive BOM For Eagle

aholtzma — Mon, 18 Mar 2019 14:54:19 GMT

FYI if you use BOM-EX and its associated DNP and BOM attributes, I've added support for these these to InteractiveBOM (available in github).

There is also a companion python script to annotate "Customer Ref" part numbers from your parts database. This is necessary because Eagle itself doesn't know anything about the part database.

Re: Interactive BOM For Eagle

JamesLE32J — Tue, 19 Mar 2019 09:04:44 GMT

Hi @sdalling, thanks very much for your work on this.

I have an issue where it's not rendering my board correctly and also not displaying some of the silkscreen text. See image.

I'm using V1.6 on Eagle V9.3.1

A couple of improvements for work flow would be

Being able to edit the attribute fields.
Reordering the attribute headings.
Having the ability to export the BoM would also be highly beneficial.

Thanks and well done 🙂

Re: Interactive BOM For Eagle

sdalling — Tue, 19 Mar 2019 15:30:28 GMT

This does look like an issue. There are a few things that if you can provide will make troubleshooting this a lot easier.

Board file that caused the issue or minimum example that can create the issue
Associated PCB pcbdata.json file

Looking at the image I do not know what text is being displayed incorrectly. Could you expand upon this a little bit.

Ill add the following to Github as feature requests so that I can track them.

Being able to edit the attribute fields.
Reordering the attribute headings.
Having the ability to export the BOM would also be highly beneficial.

If you could answer a few questions that would help me out making sure that I fully understand what you are asking. For 1, you want to be able to edit the attributes for a part within iBOM, and have those changes reflected in the JSON file? For 2, the user should be able to reorganize the headings however they want within iBOM?

If you would rather send this as a private PM, that is fine or you can respond to this thread.

Re: Interactive BOM For Eagle

JamesLE32J — Wed, 20 Mar 2019 08:35:40 GMT

I have attached a board file with a basic outline shape (can't give you the whole board so I hope that's OK?) and also a modified pcbdata.json file.

It seems to be some text on the tPlace layer but it has displayed others. See the image below where I have left the tPlace layer on. I've circled a couple of bits of text that is missing from the json file.

1 - Yes. Edit the attributes in iBoM and have them reflected in the json file.

2 - Yes. Arrange the headers as we'd like within iBoM.

My thinking is that when you are able to export to .csv, txt, then these changes can be exported too which would allow formatting in to our own BoMs easier.