×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Getting Info from SW Files

Getting Info from SW Files

Getting Info from SW Files

(OP)
Is there a way to get info from SW files with Access/Excel/VB/PDM Works/etc or an application that can be bought to access info.

Basically looking at "automating" the process of getting part numbers (drawings) and their matl requirements, etc into the procurement system and making it a more seamless task.

Thanks for the input,
Mike

RE: Getting Info from SW Files

Depending on how much $ you want to spend...
First check out the solidworks site under partners, gold partners.  This will allow you to review several vendors with integrated solutions.
After that, a simple google or ixquick search with solidworks and erp will show you them and other lower cost solutions.

TTraser
Engineer (LSD)
WWW.KWAUTOMOTIVE.COM

RE: Getting Info from SW Files

(OP)
Thanks for the response.

I take it that means that, to your knowledge, there is no way to do any "home cookin'" with Access/Excel/VB/PDM Works/etc ?

Thanks again,
Mike

RE: Getting Info from SW Files

Sure there are lots of ways to "home cook".  One is to put this information as custom properties in you models, create a BOM of your assembly with this information in the columns and export the file.

RE: Getting Info from SW Files

(OP)
That's pretty much what I do now, but with all the power of SW I it seems kind of klunky.  I was hoping I could automate it more.  Not even entirely sure what I would like to do, that kind of depends on what, if anything, could be accessed and in what way.

Thanks for the input

RE: Getting Info from SW Files

Check out DSOfile.  It is a DLL from Microsoft that lets you access file properties from Visual Basic.  It is not specific to SolidWorks, but works with SolidWorks files.

A previous thread related to DSOfile is: thread559-151211.

Eric

RE: Getting Info from SW Files

(OP)
Great ... looks like the kind of info for me; enough to be dangerous.  I'll se how much I can mess up in my files.

Thanks all for the input,
Mike

RE: Getting Info from SW Files

As I said there are many ways to "home cook" a solution.  DSOfile only works for non-configuration information that is stored in the custom tab.  SolidWorks offers another program to get to the configuration specific information but I do not have that information handy right now (you can always write to API help to get this).  Another method, is to traverse the assembly to get the subpart information.  There are several examples in API help that should you how to do some of this.

Could you explain just how automated you would like to get?

SA

RE: Getting Info from SW Files

(OP)
Good to know.  Not entirely sure yet on teh level of automation.  I am fairly new at my company and the MRP and internal logistic procedures are still being developed, so I am not sure how all that is going to end up and how SW can be best integrated.  I just hate wasting all the potential productivity that SW has waiting to be tapped.  Sorry I cant be more specific.  I'm just trying to get up to speed with the inner workings of working with SW data so that I have that toolset and can use it when we have a better direction.

Thanks for the help, i'll check out the info you ref

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources