AnsweredAssumed Answered

Solidworks Toolbox Components List

Question asked by Prasanna Ashok on Mar 1, 2017
Latest reply on Mar 3, 2017 by Deepak Gupta

Like • Show 0 Likes0
Comment • 6

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

1 person has this question

Outcomes

Matt Martens Mar 2, 2017 7:49 AM

You can use the toolbox settings utility for this.

Actions

Prasanna Ashok @ Matt Martens on Mar 2, 2017 7:56 PM

Hi Matt,

Thank you. I will look into this.

Regards,

Prasanna.A

Actions

Dennis Dohogne Mar 2, 2017 8:49 AM

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.

Actions

Prasanna Ashok @ Dennis Dohogne on Mar 2, 2017 7:56 PM

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

Actions

Deepak Gupta @ Prasanna Ashok on Mar 3, 2017 3:13 AM

These should be OK since these are full length threads.

Actions

Deepak Gupta Mar 2, 2017 12:05 PM

How you can ignore the lengths as you've different number for the two lengths of same thread size

Actions

6 Replies

Matt Martens Mar 2, 2017 7:49 AM
Mark Correct
Correct Answer
You can use the toolbox settings utility for this.
Like • Show 3 Likes3
Actions
- Prasanna Ashok @ Matt Martens on Mar 2, 2017 7:56 PM
  Mark Correct
  Correct Answer
  Hi Matt,
  
  Thank you. I will look into this.
  
  Regards,
  Prasanna.A
  Like • Show 0 Likes0
  Actions
Dennis Dohogne Mar 2, 2017 8:49 AM
Mark Correct
Correct Answer
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 Like1
Actions
- Prasanna Ashok @ Dennis Dohogne on Mar 2, 2017 7:56 PM
  Mark Correct
  Correct Answer
  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 Likes0
  Actions
  - Deepak Gupta @ Prasanna Ashok on Mar 3, 2017 3:13 AM
    Mark Correct
    Correct Answer
    These should be OK since these are full length threads.
    Like • Show 0 Likes0
    Actions
Deepak Gupta Mar 2, 2017 12:05 PM
Mark Correct
Correct Answer
How you can ignore the lengths as you've different number for the two lengths of same thread size
Like • Show 2 Likes2
Actions

Solidworks Toolbox Components List

Outcomes

Related Content

Recommended Content