6 Replies Latest reply on Mar 3, 2017 3:13 AM by Deepak Gupta

Solidworks Toolbox Components List

Prasanna Ashok Mar 2, 2017 6:19 AM

Hi,

Our team is basically into Machine design and we use multiple toolbox component on day to day basis.

Fastener inserted in the assembly will be called out in the drawing using a unique number which our customer has generated in their database.

So every time when we create assembly drawing, there is a requirement for us to check in their database for that unique number.

So we have decided to create our own database for all tool box component (for all the sizes).

Requirement:

Is there any way where i can create a excel list with all tool box components file name + for all the sizes available. (DIN, ISO, ANSI, METRIC - these four standards are required).

I just need the description of the tool box component is a excel. Something like below.

For all sizes, all available length, File name is required.

Thread length can be ignored.

Please let me know if anyone can help on this.

Regards,

Prasanna.A

Re: Solidworks Toolbox Components List

Matt Martens Mar 2, 2017 7:49 AM (in response to Prasanna Ashok)

You can use the toolbox settings utility for this.
Like Show 3 Likes(3)

Actions
- Re: Solidworks Toolbox Components List
  
  Prasanna Ashok Mar 2, 2017 7:56 PM (in response to Matt Martens)
  
  Hi Matt,
  
  Thank you. I will look into this.
  
  Regards,
  Prasanna.A
  
  Like Show 0 Likes(0)
  
  Actions
Re: Solidworks Toolbox Components List

Dennis Dohogne Mar 2, 2017 8:49 AM (in response to Prasanna Ashok)

You will need to go to the Toolbox settings as Matt has mentioned. For each of your standards you will need to export a TB spreadsheet. Read the Toolbox Help on how to do this. From there you can use Excel functions, such as VOOKUP, to find the customer part number in their spreadsheet and add those values to the TB spreadsheet. Then you import that spreadsheet back into TB and TB will now have the customer part number associated with the parts.

I do not see how you can ignore the length of the fastener since length is a very distinctive component of each fastener.
Like Show 1 Likes(1)

Actions
- Re: Solidworks Toolbox Components List
  
  Prasanna Ashok Mar 2, 2017 7:56 PM (in response to Dennis Dohogne)
  
  Hi Dennis,
  
  Thanks for the inputs.
  
  Customer remote number does not include the thread length. For eg, when they create remoter number for M4 screw of length 8mm, description reads as ISO 4762 M4 X 8
  
  Nowhere the thread length is mentioned. But by solidworks default it shows as ISO 4762 M4 X 8 ---8N
  I'm just ignoring the thread length and not the fastener length.
  
  Is that ok?Deepak Gupta
  
  Regards,
  Prasanna.A
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Solidworks Toolbox Components List
    
    Deepak Gupta Mar 3, 2017 3:13 AM (in response to Prasanna Ashok)
    
    These should be OK since these are full length threads.
    
    Like Show 0 Likes(0)
    
    Actions
Re: Solidworks Toolbox Components List

Deepak Gupta Mar 2, 2017 12:05 PM (in response to Prasanna Ashok)

How you can ignore the lengths as you've different number for the two lengths of same thread size
Like Show 2 Likes(2)

Actions

Go to original post