Printed Circuit Board Assembly & PCB Design SMT Electronics Assembly Manufacturing Forum

Printed Circuit Board Assembly & PCB Design Forum

SMT electronics assembly manufacturing forum.


Merging BoM and XY Data

Views: 1665

#82055

Merging BoM and XY Data | 22 February, 2019

Is there a need for a simple application to merge a bill of material with the xy placement data into a single (or top/bottom) files for machine programming? ie. add a part number column to the xy data, including "N/A" for parts not found in the BoM? I have had a customer approach me with this requirement, but want to know if this is a one off need or - if I build it, will it actually be useful to anyone?

Thanks, Bruce

reply »

#82059

Merging BoM and XY Data | 24 February, 2019

Look on this forum for a link to SMTMaestro which does just that. Fab3000 is almost there with its BOM tools and has a bunch of handy features, its just that they have not considered this use case instead focusing on recreating the centroid from gerber data and then merging in the BOM.

I'm sure I'm not the only one who has written a tool for this, however mine is very rough with no error handling and currently requires the input data to be preformatted into a specific form.

reply »

#82072

Merging BoM and XY Data | 27 February, 2019

Hi Bruce,

We have developed some solutions exactly you need (such as QPlace and QPlan). You can read about our solution on our website: http://www.proventustech.com. If you want more information, you can send me an email: alexeis@proventustech.com.

Best Regards, Alexei

reply »

#82076

Merging BoM and XY Data | 27 February, 2019

SMT Maestro is the easiest to use by far, unfortunately it seems to have been wiped from the web.

Here's a link that should work though... https://drive.google.com/open?id=1Ztj-AUou6oiZiIRkJinBWuaVorWYvP2_

reply »

#82080

Merging BoM and XY Data | 27 February, 2019

Thanks for the link Phil. I am trying it out. Here is a quick demo of SMTMerge. https://youtu.be/nHe3-8kVHk4

Cheers, Bruce

reply »

#82081

Merging BoM and XY Data | 27 February, 2019

Thanks for the info. I was having trouble finding SMTMaestro until Phil posted a link. I guess it is a little dated. Here is a quick demo of SMTMerge. https://youtu.be/nHe3-8kVHk4

Cheers, Bruce

reply »

#82082

Merging BoM and XY Data | 27 February, 2019

#82085

Merging BoM and XY Data | 28 February, 2019

Bruce I think this is a useful tool. I think this sector needs a collection of tools like this out there priced sensibly, with that price displayed up front on the website & a mostly functional demo version readily downloadable. I find the insistence of many to make the price of something hidden until you request it very frustrating.

reply »

#82178

Merging BoM and XY Data | 19 March, 2019

Hi there. Sorry I haven't responded sooner. The video I posted was a very preliminary trial that I developed as an option to my BoMCompare application. BoMCompare is a tool that can compare Bills or Materials of various file formats (xlsx, csv, txt, etc.) as well as various content formats (eg. Reference Designators all in one cell, in multiple cell/rows, separated by commas, or spaces, etc.) and quickly generates a report showing the differences between two boms. Typically Rev A vs Rev B or Customer BoM vs BoM entered into the MRP (post entry verification). It can also compare a BoM vs the SMT machine program output to ensure all parts are captured, etc. Base price is $1,595.00; with SMT Compare option is $1,795.00; SMTMerge option will probably be $1,995.00 (depending on interest). Let me know if you would like more info.

reply »

#82983

Merging BoM and XY Data | 10 July, 2019

The merge software looks good but still not always getting the results i want - The following website can carry out a BOM to centroid xy placement data merge - http://www.surfacemountprocess.com/centroid-file-generation-service.html

reply »

Electronics Experts Needed - Contract Jobs - We have Electronics Auditor positions available now!

Manufacturing Software

Fast PCB Assembly