Can You Constrain Or Choose The Output Of "Generate Report"?

[fcborik]

Hello,

My name is Frank and I am a relatively new sketchup user. I am designing residential electrical components as symbols that are "smart" dynamic components (i.e., have voltage and current ratings, power consumption, applications, manufacturers, part numbers, etc..). My objective is to generate a parts list and also add up the individual loads on each circuit. When I use the "generate repport" function native to sketchup,I do get all of the attributes that I want, but I get a lot which I don't want -- specifically XYZ dimensions and locations. While I can work with what I have, it involves a lot of spreadsheet drudgery and I was looking for a way to choose only the component attributes that I want. I tried a couple of plug-ins (CutList and ComponentReporter), but either I couldn't figure those out very well, or those two plug-ins don't have the functionality I'm looking for.

Thanks for any help that you can give me!

Frank

[jeff hammond]

hi Frank

your* best bet is importing the data into Excel (or something similar) then filtering there..

*(maybe not 'you' because i'm not sure of your spreadsheet experience but in general, it's the better way to go about it)

[EDIT] realize i'm saying that ^ without know what kind of control the ruby writers have with this.. maybe it's filterable via ruby?

[ArCAD-UK]

If you export the data to a CSV file then as Jeff has indicated Exel can do a lot of the processing & filtering for you by importing the data to a workbook with a data worksheet which is then analysed in subsequent worksheets.

Unfortunately if you aren't familiar with Exel the learning curve is quite steep and the old computer phrase "Garbage in = Garbage out" comes to mind.

[fcborik]

All,

Thanks for the advice on the .csv file. I'm pretty familiar with excel and its capabilities, and what I have works OK, but I have to do a lot of fiddling with the spreadsheet before I can get it into a useable state. What I found works really well is to pre-format a blank worksheet with all of the headers and column widths the way I want them, then hide the columns that I won't use. I then copy and paste the data from the .csv into the blank (cntrl+shift+end from the first cell of the .csv, then cntrl+V into the first cell of the .xlsx). So, no problem with getting the results I want after a few steps. I was just wondering if a plug-in existed that would do all of that output management up-front so I could export exactly what I want into the spreadsheet and save a few steps.

Thanks, again, for your help!

Frank