[Plugin] ComponentReporter++ v1.2

TIG

You can simply open it is Excel and sum the Column ?
However currently the units have 'mm' etc so you'd need to change those...
I've recast it to miss those off.
To =SUM a column you can add a final line of formulae...
See what I've done to the code... I actually summed ALL 'number columns' BUT you will probably want to sum just some...TIG-exportDCs2csv.rb

notekm

TIG.exportDCs2csv
Error: #<ArgumentError: C:/PROGRA~1/Google/GOOGLE~1/Plugins/TIG-exportDCs2csv.rb:50:in to_l': Cannot convert "0.6299212598425197" to Length> C:/PROGRA~1/Google/GOOGLE~1/Plugins/TIG-exportDCs2csv.rb:50 C:/PROGRA~1/Google/GOOGLE~1/Plugins/TIG-exportDCs2csv.rb:50:in exportDCs2csv'
C:/PROGRA~1/Google/GOOGLE~1/Plugins/TIG-exportDCs2csv.rb:47:in each' C:/PROGRA~1/Google/GOOGLE~1/Plugins/TIG-exportDCs2csv.rb:47:in exportDCs2csv'
(eval):50

TIG

I have NOT changed the way the ...lenx.to_l etc works in line#50 - I added some code after that to remove 'mm' and '~' but nothing else; it's failing on the .to_l ?
Are you muddling ',' and '.' as decimal separators perhaps ?
If you copy/paste this into the Ruby Console it works too:
"0.6299212598425197".to_l
Works for me on your sample SKP.
Have you changed the DCs in your test SKP ?

notekm

hi, I did not change, I just copied a component in the scene.
this task.
1.Select all the components in the scene
2. select the components of a key (such as "DSP")
2a. (can take the key values from a separate file?)
3. display or save the file in the list of components (screen of what I would like to see)

screen of what I would like to see

Scene

irwanwr

so many versions in one page? is this free and not to difficult to learn for beginners?
if i may ask. which one is good for beginners to download, please?

TIG

@irwanwr said:

so many versions in one page? is this free and not to difficult to learn for beginners?
if i may ask. which one is good for beginners to download, please?

Get the first one [at start] - the others are to show how to make a simple DC attribute reader/reporter...

TIG

@notekm said:

hi, I did not change, I just copied a component in the scene.
this task.
1.Select all the components in the scene
2. select the components of a key (such as "DSP")
2a. (can take the key values from a separate file?)
3. display or save the file in the list of components (screen of what I would like to see)

The XY [in mm] need to come from the two largest values of the 'panel' - because sometimes the Z is NOT the minimum [=thickness]. OR you could report all three XYZ and you then simply ignore the smallest one [thickness] ??
Counting the number of a a specific DC and reporting it is possible:
number = instance.definition.instances.length.
I now see that the 'DSP' is the area [in m2] of 'chipboard' used in that panel.
I'm not sure what the 'Kromka' is - probably linear 'm' of edging ?
You need to adjust the way the values of these 2 are handled - so NO .to_l step since that turns the value [assumed to be in inches] into a length in current units [mm] - perhaps leave them as the float that they are, made into a string [.to_s] ?
Totaling up specific columns is demonstrated in the example code I've given you - adjust it to sum just those you want.
The CSV format can be linked [or save_as] into a XLS file where you format it as you like...

irwanwr

thank you very much TIG.
for Extrusion Tool Set, i've learnt and succeed using the EEbyRail
it works great as if a wizard made it
thank you

unearthed

Hi TIG, thanks for the great plugin, now I can count my plants easily and sum plant areas easily.

But would it be possible to add the ability to get length of curves (arcs and splines) and lines from components?

Often I have many hedges in my designs, and if I could get their length, I could send this out with the report to Excel and then divide hedge length by plants per metre. I accept I will probably have to have a curve length for the hedge in a separate component but that's fine, although maybe it could just be as a nested instance.

TIG

This tool was really written as a demonstration of how you can extract information from the model into CSV files etc.
As you probably already know selected lines/curves report their total length in the Entity Info dialog.
It's easy enough to sum the lengths of edges and report it out.
If you give a 'little more flesh to your bones' I can perhaps guide you on how to do this...

unearthed

Well here's a very typical hedge arrangement, although 100's of metres in many pieces is also quite common.

I've also put the hedge centrelines as a nested component within each component, although if there's a way of avoiding that I'm all ears.
Would it be easier to export the values of dimensions to the .csv?

hedge.lengths.skp

TIG

IF you want to use the nested component containing the linear info then you can readily add extra code into another column in the CSV. OR make a separate CSV report on linear info.
Here's how to do it separately.
The tool runs***, its code finds all components in the model with instances having a name containing 'hedge' and thereby their nested component giving the linear info drawn as a line or curve.
It takes all edges in this nested component and totals their length.
It writes a CSV listing the instance-name [e.g. 'c.hedge'], instance's-layer, definition-name, linear total [in meters]
Sorted in order, with a header line and a total of the minear-meterage.
Copy/paste this whole set of code into a new file [Notepad.exe] that you make in the Plugins folder named ' TIG-hedgelengths.rb'

require 'sketchup.rb'
module TIG
 ###
 unless file_loaded?(File.basename(__FILE__))
   UI.menu("Plugins").add_item("Hedges Length CSV"){self.hedgelengths()}
 end
 file_loaded(File.basename(__FILE__))
 ###
 def self.hedgelengths()
  model=Sketchup.active_model
  if model.path.empty?
    dir=Dir.pwd
	tit="Untitled"
  else
    dir=File.dirname(model.path)
	tit=model.title
  end
  ###
  rows=[]
  model.definitions.each{|d|
    next if d.group? or d.image?
	d.instances.each{|i|
	  txt=""
	  if i.name=~/[Hh]edge/
		txt << i.name+","
		txt << i.layer.name+","
		txt << d.name+","
		lin=0
		d.entities.each{|c|
		  if c.class==Sketchup;;ComponentInstance
		    c.definition.entities.each{|e|
			  if e.class==Sketchup;;Edge
			    lin+=e.length
			  end
			}
		  end
		}
		txt << sprintf("%.3f", lin.to_m) ### 3d.p.
	  end
	  rows << txt
	}
  }
  rows.dup.each{|e| rows.delete(e) if e.empty? }
  rows.sort!
  ## add total
  rows=["INST-NAME,INST-LAYER,DEFN,LIN.METERS"]+rows
  tot=rows.length.to_s
  rows << "\n,,TOTAL,=SUM(D2;D#{tot})"
  ###
  csv=File.join(dir, tit+"_HedgesLength.csv").tr("\\","/")
  ###
  begin
     file=File.open(csv,"w")
  rescue### trap if open
     UI.messagebox("Report;\n\n  "+csv+"\n\nCannot be written - it's probably already open.\nClose it and try making the Report again...\n\nExiting...")
	 return nil
  end
  ###
  rows.each{|row| file.puts(row) }
  file.close
  ###
  UI.messagebox("Report;\n"+csv+"\nWritten.")
  UI.openURL("file;///"+csv)
  ###
 end
end

***Usage: either type TIG.hedgelengths in the Ruby Console... OR more easily use the Plugins menu item...

unearthed

Thanks TIG, that's simply amazing Elegant and simple.

Now thanks to your plugins I've got the basis for a complete plant counter (areas, individual plants and hedges and shelterbelts - Sketchup has just become a LOT more useful), thanks again.

output from TIG-hedge.lengths.rb

samyell77

Hi Tig,
Great plugin - thanks. Ive used this on several jobs now and wonder if you can help me to make a few tweaks. I've been trying to use this to count components in a selection. I know that the plugin exports 3 csv documents and was wondering if you can help me to tailor the script to get the count Im after - Im afraid Im a total noob to Ruby but am more than happy to have a play with it if you can offer a little advice.

Id like to be able to generate a count for eithera whole model or for a selection within the model. I know that the script already generates a count for a selection but I'd like to be able to summarize items with the same name -giving me a total number.

I also wonder if its possible to only display the component name and the count and none of the other information (guid, description, material etc). Im trying to reduce the amount of work I need to do to tidy up the csv files that are generated.

Ive been playing with this whenever I get some spare time but would love a little advice.

Any help much appreciated.

Thanks

Sam

TIG

Here's v1.2 made MAC compatible... http://sketchucation.com/forums/viewtopic.php?p=147658#p147658

sidpickle

Thanks TIG seems to work OK. I'll have a play with it.

Ted Robbens

quarch

Unfortunately I am having errors in counts for nested components...
example...
3 component 1 in model
1 component 2 inside component 1...

Report returns 3 counts of 1 and 1 count of 2 in stead of 3 counts of 1 and 3 counts of 2

Counts in instances report are correct.

TIG

@quarch said:

Unfortunately I am having errors in counts for nested components...
example...
3 component 1 in model
1 component 2 inside component 1...
Report returns 3 counts of 1 and 1 count of 2 in stead of 3 counts of 1 and 3 counts of 2
Counts in instances report are correct.
There ARE 3 instances of compo1.
There IS 1 instance of compo2.
You might 'see' 3 of compo2, but these are actually three representations on the same object.
The different reporting formats are a way of covering various bases...

If you want it to somehow report things differently, then rework the code as you wish...
It is 'open source' after all...

Omarian

TIG,

This is similar to a problem I am having. I want to call up the running length of walls at base (where Y axis would be zero, and which would exclude door openings)or ceiling (which would give total lengths for molding etc). Is it possible to convert the above reporting script into a DCfunction in much the same way as you had created the DCvolume function? You may need specific functions that would take only the sum of lengths of the edges of the outer or inner faces of the wall at the base(ie excluding doors) and at the ceiling (which would include door openings).

TIG

It wouldn't be so easy...

BUT you can write any custom function you like to add to a DC...

So let's say you want the perimeter of all faces that have a normal==Z_AXIS.reverse [facing down - i,e, the bottom of a ceiling slab] inside a DC you do something like:

require('sketchup')
require('dynamiccomponents.rb')
if defined?($dc_observers)
  # Open Dynamic Component Functions (V1) class, only if DC extension is active
class DCFunctionsV1
 protected
 # return the perimeter (in inches) of face.normal==Z_AXIS.reverse
 if not DCFunctionsV1.method_defined?(;perimeter)
  def perimeter(a) # Usage as DC function; =perimeter()
	se = @source_entity
	if se.is_a?(Sketchup;;Group)
		allfaces = se.entities.grep(Sketchup;;Face)
	else #component-instance
		allfaces = se.definition.entities.grep(Sketchup;;Face)
	end
	faces=[]
	allfaces.each{|face| faces << face if face.normal==Z_AXIS.reverse }
	tr = se.transformation
	xs = tr.xscale #***
	ys = tr.yscale #***
	peri = 0.0
	faces.each{|face|
		tlen = 0.0
		face.outer_loop.edges.each{|e|
			elen = e.length # this is an unscaled length
			slen = elen*(1) #*** adjust for any X/Y scaling in (1) if needed ?
			tlen += slen
		}
		peri += tlen
	}
    return peri
  end
 end 
end#class
end#if

This takes no notice of any scaling applied to the DC object, reporting the original perimeter...