Can you link Component drop down lists to external data?


#1

What I am wanting to do is this.

We have several dynamic models for designing furniture. We use Space design to export predefined component attributes to a CSV sheet which can be read by our ERP system. This in turn creates the parts, BOM’s and Router steps and calculates labour and materials in the system. This works great. The problem is that in order for the ERP system to create the BOM’s, the attributes in the dynamic components for the raw materials must match exactly the names of the raw materials in the ERP system. In order to do this at present we create drop down lists in the model and enter in all the material names.

The issue with this is keeping this up to date across multiple models with an ever changing range of raw materials. Is there some way we can link these drop down lists to a CSV sheet so that we only have to update the one CSV sheet and all models will have access to the same Raw material names?


#2

Have a look at attribute inspector by Eneroth, you can edit the attributes of multiple components at the same time. While this still need several steps, you will develop a sense of how DC are set up and eventually get you to the next step, which is developing your own ruby script for your workflow


#3

I would actually recommend Attribute Inspector by Aerilius. It lets you edit attribute of multiple components all at once.


#4

Oeps!


#5

Thanks for that - giving this a try. Do you know anyone who may be interested in developing his kind of a script for us? I haven’t done anything with Ruby scripts and have my hand full just developing the models to interact with our ERP side of things,


#6

Maybe this is what you are looking for ? Haven’t tried it myself, though :

https://extensions.sketchup.com/en/content/su2xl-0

or try to contact the author : @Wisext


#7

Looks interesting but i need to export and import custom attribute which exist inside my dynamic models. For example we may have a raw material attribute which has a list of 20 options to choose from. I need to export these lists and be able to update and re import them into a number of different models. I will try and contact the author as this one is getting close.


#8

Hi Ken,

Did you receive my email about your request? It’s possible that it was blocked by a filter…
I have a little time in the next days to try to develop what you ask.
Could you send me a .csv file with an exemplary dynamic component and the raw material list?

Olivier.


#9

Hello Oliver- I did send it. I will try and resend…

Kind Regards

Ken Simpkin | Research and Development | IT Managagement
ken@compacfurniture.co.nzmailto:ken@compacfurniture.co.nz

[cid:image006.jpg@01D11D5A.D6E63BD0]http://www.platform10.co.nz/[cid:image007.jpg@01D11D5A.D6E63BD0]http://www.compacfurniture.co.nz/

PO Box 393 Dargaville 0340 New Zealand | 0800 710 1010 | www.platform10.co.nzhttp://www.platform10.co.nz/
Legal Disclaimer: This email may contain confidential information. If you are not the intended recipient, you must not
disclose or use the information contained in it. If you have received this email in error, please notify us immediately by
return email and delete the document.


#10

Hello Olivier,

Please find attached an example model. This is a fairly simple one. An example of an option list for a dynamic component is in the screen shots below. This is a very simple list with 3 options but usually we would have list of 20 or 30 options. If there was some way of exporting selected option lists to a excel sheet like the attached then reimporting the lists into other models that would be the ideal solution.

I have attached a spread sheet how I think it will need to be formatted.

Appreciate your comments.

[/uploads/default/original/3X/b/1/b12b27a6b4e031dea64fad88399fb80a5b19188e.png]

In the editor it look like this:

[/uploads/default/original/3X/5/8/58ed2abfa488030fbbdffbfce04edb148ece6570.png]

Kind Regards

Ken Simpkin | Research and Development | IT Managagement
ken@compacfurniture.co.nzmailto:ken@compacfurniture.co.nz

[cid:image006.jpg@01D11D5A.D6E63BD0]http://www.platform10.co.nz/[cid:image007.jpg@01D11D5A.D6E63BD0]http://www.compacfurniture.co.nz/

PO Box 393 Dargaville 0340 New Zealand | 0800 710 1010 | www.platform10.co.nzhttp://www.platform10.co.nz/
Legal Disclaimer: This email may contain confidential information. If you are not the intended recipient, you must not
disclose or use the information contained in it. If you have received this email in error, please notify us immediately by
return email and delete the document.


#11

Ok. I resent it. Did you receive this?

Kind regards

Ken Simpkin
Compac Furniture


#12

I sent sent you a message from my info@wisext.com address.
If you haven’t received yet, I will use another email address…

Olivier L.


#13

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.