Can I generate a report without a hidden object?

[Cabarsa]

Can I generate a report without a hidden object or hidden layer appearing?

I have a dynamic component, which has 3 objects in it, only one appearing on the screen, but in the report 3 =/
Tried to turn off layer, hide, always appears in report = /

[MikeWayzovski]

Alas, this is not possible, (yet?)
You need to filter the csv yourself
Adding an xtra attribute might ease things up

[pcmoor]

You could use custom attributes that do not add a value if hidden

count visible.skp (107.4 KB)

edit to sum count

[Cabarsa]

It’s cool, but it doesn’t work, it still appears in the report but with a blank line or with the quantities.

[pcmoor]

You could simplify the DCs using a ruby script that deletes the hidden subs, if you find you need to alter one of the DCs later then replace the instance with its definition, it will reactivate with its current settings.

def remove_hidden(instance)
    children = instance.definition.entities.select { |e| e.respond_to?(:definition) }
    children.each { |c| remove_hidden(c)

 c.erase! if c.hidden?   }
    end
    remove_hidden(Sketchup.active_model.selection.first)

This is one of Julia Eneroth’s solutions-

Select all sub-components in a selection

This is quite easy to do but in most cases a bad idea. The user will not expect entities outside of the active drawing context to be selected. In my view this should only be done in the extreme case when the whole point of the plugin is to be able to select outside the current drawing context. If the purpose of the plugin is something else it’s better to find another solution. # Select an instance and run snippet to select all child instances. def select_children(instance) children = instance…

this would remove the hidden subs of selected item(s) and could be attached to a button created in Aerilius’ toolbar editor (extension warehouse)

[Cabarsa]

thank you, it would be very complex.
Would you change a Nesting Levels Component through a condition? if it is hidden change to another level, so I can generate a report from one level above.

[rwamoore]

Not sure exactly what you are trying to do here, but maybe the answer is in excel not SketchUp? I always have a top line that catches the unnecessary/extra info generated by report in SketchUp. I do this by sorting the items in the report by my own ListName attribute. If the item is hidden the ListName returns a blank value, so any attributes for hidden items end up compiled in this first line of the report. I wrote a small VBA script to import a SketchUp .csv export into excel that cleans up the import and deletes that line of excess stuff from the report. Maybe something like this could work for you?

Good Luck!

[Cabarsa]

Hi rwamoore
I have 1 object Component Nesting Levels 2
I want to change Component Nesting Levels from 2 to 3 if an object is hidden.

VBA script: never used, how does it work?

[rwamoore]

So VBA is like Ruby script but for Excel. you can actually just record a series of manual actions and assign them to a button. Click and the series of actions is executed. What is the purpose of the level drop, the desired outcome? Maybe there is another way to get there…?

[rwamoore]

These two railings are the same DC with a bunch of hidden subs, different pickets and glass types. All of the hidden parts are summed in the first line of the report, if you ignore the top line the rest of the report is only visible component parts.

Once I save that report as a .csv file I use the VBA script to bring it into Excel and clean it up, add pricing and put into an invoice template or whatever.

[Cabarsa]

@rwamoore

So VBA is like Ruby script but for Excel. you can actually just record a series of manual actions and assign them to a button. Click and the series of actions is executed. What is the purpose of the level drop, the desired outcome? Maybe there is another way to get there…?

seems complex to me = /

The purpose is for a hidden object not to appear in the report.
I want a way to do it without having to edit the table
If I change it level with one condition, I can generate the report from another level without it appearing.

[rwamoore]

I don’t know if what you are trying to do is possible, best solution I have for you is last post above, just ignore the top line… Good Luck!

[pcmoor]

@Cabarsa

thank you, it would be very complex.
Would you change a Nesting Levels Component through a condition? if it is hidden change to another level, so I can generate a report from one level above.

You could create custom attributes and report it in the parent, level 2 in the report.

count visible 2.skp (136.4 KB)

[Cabarsa]

wowwwwwwww!!! Perfect! ?Thks