[Plugin] ComponentReporter++ v1.2

nanolin

@tig said:

This original http://sketchucation.com/forums/viewtopic.php?p=373590#p373590
does some DC attribute data things...
This is a NEWER version...
(c) TIG 2013
Script:
TIG-exportDCs2csv[2].rb
Type into the Ruby Console:
TIG.exportDCs2csv2
OR use
Plugins menu > TIG.exportDCs2csv2
It Exports all Selected DCs' data into a file, as:
Name,LenX,LenY,LenZ,Material,Layer
It uses 'mm' for the XYZ units.
It is a 'CSV' [COMMA separated variable] file - made in the model's folder and named after the model thus:
ModelName.skp >> ModelNameDCs.csv
If a new model is unsaved the current directory receives this new file.
Edit sep="," if something other than separating comma is desired.
Make sep="\t" if a 'TSV' [TAB separated variable] file is desired and change ext="csv" to ext="tsv".
...

TIG

ud can have the report grouped plugin components, adding the name of the group in a new column?
thanks post your feedback

StygianStorm

Hi TIG - Love the plugin! I just recently stumbled on this page and it has been super useful tracking my work! I was wondering if you had the time to help me make a slight tweak? Basically, I want to tidy up the parentage report to display nested components in a more intuitive way similar to the sketchup outliner?. Hopefully the attached image makes sense: It shows only the counts of of instances, and also puts the them to the right of its parent component. This way, I can visually track the hierarchy.

If you have the time, I'd really appreciate the help given that I am not versed in ruby.

Thank you very much!

nghminh81

Hi TIG, Thank you so much for your powerful script. I'm using it to do my construction schedules. It helps me a lot. Could you please add a modification that allow me to get volume numbers for components? (my components are solid ready). I don't have much Ruby knowledge and was failed to do it my self.

TIG

@nghminh81 said:

Hi TIG, Thank you so much for your powerful script. I'm using it to do my construction schedules. It helps me a lot. Could you please add a modification that allow me to get volume numbers for components? (my components are solid ready). I don't have much Ruby knowledge and was failed to do it my self.
Edit the file with Notepad++...
Around line #149 you can see the 'area' code.
You need to add some similar 'volume' code near that, like this:

volume=0.0
volume=c.volume if c.volume > 0
# it's always in cu" - to make into something else use a conversion factor like this for cu metres;
volume=volume*0.000016387064
# convert it into a string
volume=volume.to_s.tr(",",".")### trap for comma as decimal point...
# edit line ~ # 166 [remember that it will have shifted down after you entered the new volume code !]
ilist.push([dname,iname,lname,cname,id,x,y,z,pname,area,areas].flatten!)
# to include volume...
ilist.push([dname,iname,lname,cname,id,x,y,z,pname,area,areas,volume].flatten!)
# edits the lines making the header text ~ # 178
file.puts("DEFN-NAME,PARENT[NAME<TYPE>],INST-NAME,LAYER,MATERIAL,ID,X,Y,Z,AREA,SUB-MAT-AREAS\n\n")if miner
file.puts("DEFN-NAME,INST-NAME,LAYER,MATERIAL,ID,X,Y,Z,AREA,SUB-MAT-AREAS\n\n")if not miner
# to read...
file.puts("DEFN-NAME,PARENT[NAME<TYPE>],INST-NAME,LAYER,MATERIAL,ID,X,Y,Z,AREA,SUB-MAT-AREAS,VOLUME\n\n")if miner
file.puts("DEFN-NAME,INST-NAME,LAYER,MATERIAL,ID,X,Y,Z,AREA,SUB-MAT-AREAS,VOLUME\n\n")if not miner
# now edit the code around lines ~ #
ilist.each{|c|
    xx=""; c[10..-1].each{|x|;xx=","+x.to_s}
    if miner
      file.puts(c[0]+","+c[8]+","+c[1]+","+c[2]+","+c[3]+","+c[4]+","+c[5]+","+c[6]+","+c[7]+","+c[9]+xx)
    else
      file.puts(c[0]+","+c[1]+","+c[2]+","+c[3]+","+c[4]+","+c[5]+","+c[6]+","+c[7]+","+c[9]+xx)
    end#if
}
# to read with the extra volume element ... +","+c[-1] ... 
# -1 says last element in array which we know in the newly added 'volume' string.
ilist.each{|c|
    xx=""; c[10..-1].each{|x|;xx=","+x.to_s}
    if miner
      file.puts(c[0]+","+c[8]+","+c[1]+","+c[2]+","+c[3]+","+c[4]+","+c[5]+","+c[6]+","+c[7]+","+c[9]+","+c[-1]+xx)
    else
      file.puts(c[0]+","+c[1]+","+c[2]+","+c[3]+","+c[4]+","+c[5]+","+c[6]+","+c[7]+","+c[9]+","+c[-1]+xx)
    end#if
}

Hope that helps...

nghminh81

Thanks TIG so much for spending time with my case. Your help make it works perfectly. I've learned many many of Ruby language with your code.

vmsremy66

Hello TIG
thank you for your time with this plugin.

do you think it is possible to list dynamic components and their LenX, LenY, LenZ that are inside another dynamic component?

vmsremy66

sorry....

TIG

This is somewhat more complex...
Why not post a similar request in the DC forum ?

maxim_

Hi TIG, thanks for the plugin!
Whether it is possible to copy the report in a clipboard? But only "Instances+Report"!
It is sometimes better than the CSV file.

oceanembers

Hi Tig, I'm trying to get this to work, reporting the components only if the dynamic attribute "report" is true. After a little experimentation, I think I should be changing line 135 to read

	    inlist.push(c) if ((c.typename=="ComponentInstance") && (c.attribute_dictionaries['report'] == 'TRUE'))

But that creates no results (I do have a DC in my model with the attribute 'report' set to 'TRUE')

Could you point out where I'm going wrong?

TIG

Should you not be looking at the c.definition rather than the instance ?
Also are you sure that's the attribute_dictionary name ?
Perhaps ' dynamic_attributes' ??
Try this Ruby Console snippet on a selected DC instance to see what I mean:
Sketchup.active_model.selection[0].definition.attribute_dictionaries.each{|d|puts;p d.name;puts;d.each_pair{|k,v|puts"#{k} = #{v}"}}

oceanembers

oh I see! I completely misunderstood attribute_dictionaries.

		dict = c.attribute_dictionaries['dynamic_attributes']
	    inlist.push(c) if ((c.typename=="ComponentInstance") && (dict['report'] == 1))

This works great, thanks Tig.

rubenamaroh

Hi TIG
About "ComponentReporter++.rb"
is theres some way the plugin including columns like Lenght X, Lenght y and Lenght Z of the box ?:
im new in rubys, sorry.

DEFN-NAME | COUNT | DESCRIPTION | X | Y | Z| GUID |

Any help i will apreciate.

TIG

@rubenamaroh said:

Hi TIG
About "ComponentReporter++.rb"
is theres some way the plugin including columns like Lenght X, Lenght y and Lenght Z of the box ?:
im new in rubys, sorry.

DEFN-NAME | COUNT | DESCRIPTION | X | Y | Z| GUID |

Any help i will apreciate.
Of course.
This is just an 'example' script.
Get the group/component-instance .bounds and get .width/height/depth [lenX/lenY/lenZ]
The add the extra columns into the CSV and include the three values .to_s etc...

rubenamaroh

@tig said:

@rubenamaroh said:

Hi TIG
About "ComponentReporter++.rb"
is theres some way the plugin including columns like Lenght X, Lenght y and Lenght Z of the box ?:
im new in rubys, sorry.

DEFN-NAME | COUNT | DESCRIPTION | X | Y | Z| GUID |

Any help i will apreciate.
Of course.
This is just an 'example' script.
Get the group/component-instance .bounds and get .width/height/depth [lenX/lenY/lenZ]
The add the extra columns into the CSV and include the three values .to_s etc...

Ok.
I will try to do it
I was trying to make a list of material of framing walls but did not have the length of the studs and ledgers, i'm more familiar with the language of AutoLISP for AutoCAD, so I'm starting to learn the language of the rubys, any suggestions to learn ruby?
thanks.

katalikammello

Is it possible to find and retrieve information from attributes in nested components?
ideally I would like to achieve a plugin like "TIG-exportDCs2csv[2].rb" that is able to Exports all Selected DCs' data into a file BUT FROM "NESTED" (or child) COMPONENTS AS WELL.
Anyone can help with this?

sjdorst

@Tig,

Can this plugin report current Attribute values AND formulas (if any) side by side?

If yes - Great!

If not, please consider this a suggested improvement, as well as a request for information - should you know of another plugin that provides this functionality.

Thanks in advance!

Steve

Ahmed0007

Hi, TIG Thanks for this plugin.
can I get this (Please see attached image) information in one and a simple excel sheet?
Thanks again.

TIG

This is old code.
It's for DCs only.
It was posted as an example, for you to edit as you wish.
To add a 'header' simply create the first line before the other rows.
Then adjust the units to report in feet and change the code to report the instance count rather than material...
So from line#40 change it to read like this:

    data=["Name#{sep}Width#{sep}Depth#{sep}Height#{sep}Quantity"]
    insts.each{|inst|
      defn=inst.definition
      name=defn.name.tr(sep, "_")
      lenx=defn.get_attribute("dynamic_attributes", "lenx", 0).to_f.to_feet.to_s
      leny=defn.get_attribute("dynamic_attributes", "leny", 0).to_f.to_feet.to_s
      lenz=defn.get_attribute("dynamic_attributes", "lenz", 0).to_f.to_feet.to_s
      quan=defn.instances.length.to_s
      dat = "#{name}#{sep}#{lenx}#{sep}#{leny}#{sep}#{lenz}#{sep}#{quan}"
      data << dat
    }

Ahmed0007

@tig said:

This is old code.
It's for DCs only.
It was posted as an example, for you to edit as you wish.
To add a 'header' simply create the first line before the other rows.
Then adjust the units to report in feet and change the code to report the instance count rather than material...
So from line#40 change it to read like this:

    data=["Name#{sep}Width#{sep}Depth#{sep}Height#{sep}Quantity"]
>     insts.each{|inst|
>       defn=inst.definition
>       name=defn.name.tr(sep, "_")
>       lenx=defn.get_attribute("dynamic_attributes", "lenx", 0).to_f.to_feet.to_s
>       leny=defn.get_attribute("dynamic_attributes", "leny", 0).to_f.to_feet.to_s
>       lenz=defn.get_attribute("dynamic_attributes", "lenz", 0).to_f.to_feet.to_s
>       quan=defn.instances.length.to_s
>       dat = "#{name}#{sep}#{lenx}#{sep}#{leny}#{sep}#{lenz}#{sep}#{quan}"
>       data << dat
>     }
>

Thanks a lot this worked perfectly fine.