1. Home
  2. Solidworks CAD Design software
  3. Importing BOM into MRP

Importing BOM into MRP

I'm coding a SQL-based MRP system and am not intimately familiar with Solidworks. My design group is using SW 2005 and wants to submit a hierarchical BOM directly into the MRP system. I've seen examples of their Excel and "indented BOM" formats which look workable, but it would be nicer if I could get some kind of structured text format, perhaps XML-based. What options are available to extract the BOM info in a way that preserves as much of the original structure as possible while being portably-parsable by an external application?

I've done similar things in the past using AutoCAD's DXF and PCAD's PDIF. Is a similar interchange format available for SW that can supply the raw data?

Reply to
Kenneth Porter
Loading thread data ...

A BOM can be generated directly from SW using the API. There are some solutions around that do this. You might also look at the API support area on the SW website.

Reply to
P.

Ken,

The SW API allows you to extract the BOM in just about any format you want. It would be quite simple to extract the data you are looking for and then format to XML. I do this frequently. As suggested you can look at the SW API page for extraction techniques. XML formatting can be done by numerous methods. If you need some sample VB extraction I have some you can have and tweak.

Guy

Reply to
Guy Edkins

"Guy Edkins" wrote in news:L6jDd.32477$tG3.18437@trnddc02:

Thanks, that'd be great! Starting from a working example is always easier than building from the ground up.

Reply to
Kenneth Porter

Ken,

Send me a little more detailed info on what you want to do and how you would like it to work and I will see what I can dig up.

Guy

Reply to
Guy Edkins

PolyTech Forum website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.