topic Re: Exporting BOM in EAGLE Forum

Exporting BOM

Anonymous — Tue, 29 May 2018 15:14:28 GMT

Hello!

When I go to export a BOM from an Eagle Schematic, I normally export as a .csv. However Eagle typically will use semicolons (;) instead of commas to delimit the file. Excel normally uses commas to delimit .csv files. Is it possible to change the export delimiter from Eagle?

Thanks,

Chas

Re: Exporting BOM

jorge_garcia — Tue, 29 May 2018 19:33:59 GMT

Hello @Anonymous,

I hope you're doing well. Yes you can change it, go to the EAGLE control panel > Expand the User Language Programs tree. The first ULP there is the bom.ulp, go ahead and double click it. This will open the ULP in EAGLE's built-in text edtior, go to line 51(it's just past the initial comments in the file). You'll see a variable called Separator by default it's value is set to ;, just changed it to a comma and save it.

Now it will use the proper delimiter.

Let me know if there's anything else I can do for you.

Best Regards,

Re: Exporting BOM

Anonymous — Tue, 10 Sep 2019 08:28:43 GMT

go to line 51(it's just past the initial comments in the file). You'll see a variable called Separator by default it's value is set to ;, just changed it to a comma and save it.

I also need it for exporting to Excel format.

but I can not catch what's that means.

what is line 51?

I couldn't find anything for this

Please help me out!

Thanks

Re: Exporting BOM

rachaelATWH4 — Tue, 10 Sep 2019 08:42:10 GMT

@Anonymous wrote:
go to line 51(it's just past the initial comments in the file). You'll see a variable called Separator by default it's value is set to ;, just changed it to a comma and save it.
I also need it for exporting to Excel format.
but I can not catch what's that means.
what is line 51?

When you edit Bom.ulp in a text editor, line 51 is the line of code which specifies the default separator. You can change that from ';' to ',' to make it default to a comma.

Best Regards,

Rachael

Re: Exporting BOM

Anonymous — Wed, 11 Sep 2019 03:40:27 GMT

Thank you as always for your help.

Re: Exporting BOM

Anonymous — Mon, 13 Jul 2020 07:51:36 GMT

I found the ulp under installation folder examples, but modifications won't affect cam processor output. Which bom.ulp should I modify?

If I run the ulp manually the output is correct.

Re: Exporting BOM

jorge_garcia — Mon, 13 Jul 2020 21:27:52 GMT

Hi @Anonymous,

I hope you're doing well. I'll confirm with the development team but I have a feeling that the CAM processor uses an internal version of the bom.ulp moving forward your best option is to run the bom.ulp manually or open the generated bom file and run a search and replace to switch out the ; for ,

Let me know if there's anything else I can do for you.

Best Regards,

Re: Exporting BOM

tristanluther28 — Fri, 18 Mar 2022 23:17:59 GMT

Hi @jorge_garcia ,

I know this is an old thread but I am running into the same issue when generating BoMs with the CAM Processor. It would be very nice for the bom.ulp edits to be reflected on the CAM Processor. This could allow users to specify a custom BoM to be generated with the rest as the gerbers! Save me a few clicks, un-zip and re-zip.

Is there a way for me to add this as a feature request for the team?

Thanks

Re: Exporting BOM

jorge_garcia — Mon, 21 Mar 2022 16:39:52 GMT

Hi @tristanluther28 ,

Thank you for the suggestion, I've noted it as a feature request for the team. I agree being able to customize what ULPs we run would be helpful in the CAM processor configuration.

Let me know if there's anything else I can do for you.

Best Regards,

Betreff: Exporting BOM

skupinBE26G — Mon, 30 Dec 2024 13:47:54 GMT

Hi @jorge_garcia ,

is the feature released yet? I would like to integrate our special ulp to the cam processor.

Regards,
Herbert

Re: Exporting BOM

jorge_garcia — Mon, 06 Jan 2025 23:47:49 GMT

Hello @skupinBE26G,

I hope you're doing well. Unfortunately, that has still not been implemented.

Let me know if there's anything else I can do for you.

Best Regards,