An efficient way to add multiple handle options

[SimonT]

We are just about to replace our entire handle range … so I now have to find a way to quickly add the new handle options into all our DC drawers and doors.

It’s not too time consuming to replace the handle collection that I already have nested in all the doors and drawers, but unless I want all the users to click deep into the doors to access the handle choices, I’ve now got over 50 options to type in to the parent level attributes … which is going to take a very long time, especially as the output of the options is quite complex (screenshot attached)

Please someone tell me I’m missing a trick?!

[pcmoor]

you can copy the drop down option list from one component to another, or generate the required code from excel
first download and install Aerilius’ attribute inspector, then look for

_ahandleopt_options

should be the list and values with some markup delimiters similar to

DC - Is there a way to copy/paste an attribute, or is there a hack to copy all the List items to another attribute list

F.e as an sample case to make it clear what I need. I’am creating a concrete foundation with insulation like EPS. I want to make it so that the user can set the thickness of the front insulation, the under ( between dirt and beam ) insulation, the back side ( inner ) insulation and so on. This means I have to make 3 or more lists where the user can choose from the different thickness and pressure ( like EPS100, EPS150 or EPS 250 e.t.c ). That means I will be two hours typing with unless someon…

excel data to sketchup Ruby or DC lists

[pcmoor]

should you require the excel vba method, then private message your email address and I will send you a copy

[SimonT]

Thanks pcmoor. I’d like to be able to do methods!
I’ll private message you for the excel method - but how do you copy a drop down option list from one component to another? I can’t believe I didn’t know how to do that?! The hours I’ve wasted!

[pcmoor]

the end part of the video, shows the copy method, the first part is the excel data formatting

first make a simple one option dropdown, option 1 value 1 in the component to receive the full list dropdown
this should show
&1=1&

now select the component to copy from
highlight (select) the data, control C (or apple equivalent, opt?), then select the recipient, then select the &1=1&, control V, paste. Avoid using enter, just click outside or deselect. Then deselect the component then reselect, should now have the new option list