Exporting BOM

[Anonymous]

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

[jorge_garcia · Accepted solution]

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,

[Anonymous]

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

[rachaelATWH4]

---

@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

[Anonymous]

Thank you as always for your help.

[Anonymous]

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.

[jorge_garcia]

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,

[tristanluther28]

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

[jorge_garcia]

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,

[skupinBE26G]

Hi @jorge_garcia , 

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

Regards, 
Herbert

[jorge_garcia]

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,