LumberJocks
DAILY DEALS Confetti Lamp Inserts  |  Makita Makita Recon LCT203W 10.8 Volt Lithium Ion Impact Driver 2 Pc Kit

CutList and Materials Plugin Tip

Blog entry by DaveR posted 271 days ago 789 reads 0 times favorited 9 comments Add to Favorites Watch

If you are making use of Steve’s excellent plugin, here’s a little tip. Don’t use commas in your component names if you intend to export a CSV file of the cutlist. Commas in the component names will screw up the column alignment since in that CSV file, columns are delineating with commas.

If you have a large project with many components, it can be a bit time consuming to fix that problem. The Outliner is handy, though, because it’ll display the component names and help you find the ones that need to be corrected.

-- Until you spread your wings, you'll have no idea how far you can walk.


9 comments so far

View daltxguy's profile

daltxguy

568 posts in 812 days


posted 271 days ago

Hi Dave,

Good tip! Same goes for the material name.

For those who have their sketchup language setting set to other than English ( ie: other than en-US or en-GB), the same comment applies but here the use of the semi-colon in a component or material name would cause an issue. The comma is used for the decimal ‘point’ for measurements in the standard European notation and so the delimiter for the columns in the CSV file is the semi-colon(’;’)

Btw, since this appears to be an issue, I will look at putting in a solution which will reduce or eliminate this issue. It is easy enough to filter out the characters being used as delimiter from any text fields before writing the CSV file. I’ll add this to the things to do list!

-- Steve, New Zealand, www.steveracz.com

View DaveR's profile

DaveR

1527 posts in 619 days


posted 271 days ago

Thanks Steve.

Not to add to your work but would it be possible allow the user to specify a different delimiter such as tab? That would allow the file to be imported directly into Word or other word processor without ending up with a bunch of commas to clean up.

Thanks again.

-- Until you spread your wings, you'll have no idea how far you can walk.

View David_Bethune's profile

David_Bethune

243 posts in 291 days


posted 271 days ago

What plugin?.. Where do I find it, and what does it do?
Thanks
David

View DaveR's profile

DaveR

1527 posts in 619 days


posted 271 days ago

The plugin creates a cutlist from your SketchUp model. It can be found here:

Keep in mind that its accuracy depends upon how accurately you make your SketchUp model.

-- Until you spread your wings, you'll have no idea how far you can walk.

View daltxguy's profile

daltxguy

568 posts in 812 days


posted 271 days ago

Hi Dave,

I had a little play around with the delimiter value. Just replacing the comma with a tab produces a more readable output but it still doesn’t necessarily line up the columns because of the variable length of some of the text fields. I’d have to do more to make sure that it looks right as a text file.

If the idea here is to make a printable version of the cutlist, maybe it’s better to leave the commas in, read the file in with Excel and then print from there. Excel will do a nice job of placing each of the columns back in order. You can add borders or underline titles, etc with Excel. It’s the main reason the file format exists.

Let me know if I am missing something here about the motivation to read it in using a word processor ( is it because not everyone has excel? I use OpenOffice calc on my home PC)

-- Steve, New Zealand, www.steveracz.com

View DaveR's profile

DaveR

1527 posts in 619 days


posted 271 days ago

Hi Steve,

Yeah, I know there are issues with the tab. I was just kind of thinking.

I’ve been using your plugin with models I’ve been drawing for plans. After drawing the models, I’m using Layout to create the document. When I get to the cutlist I open the CSV file in Excel, massage it a little bit there, delete some columns that I don’t need, copy and paste it into Word, convert from table to text, do a little more formatting and then copy that and paste it into a text box in Layout. It’s fairly quick as it is. I was just thinking it could be faster if one could skip opening a program but I see other issues so no worries.

Cheers,

Dave

-- Until you spread your wings, you'll have no idea how far you can walk.

View daltxguy's profile

daltxguy

568 posts in 812 days


posted 270 days ago

Ah!

So what would really rock your world is to have the layout and the cutilist output in a single file. One button to produce the entire project files.

That sounds like a worthy pursuit!

-- Steve, New Zealand, www.steveracz.com

View DaveR's profile

DaveR

1527 posts in 619 days


posted 270 days ago

Steve, that would be cool. I was talking about Layout, the presentation application that comes with the pro version of SketchUp. Like this:

Photobucket

For this:

Photobucket

Photobucket

-- Until you spread your wings, you'll have no idea how far you can walk.

View daltxguy's profile

daltxguy

568 posts in 812 days


posted 269 days ago

Hi Dave,
That’s a very slick way to view your project. Sketchup keeps surprising me!

-- Steve, New Zealand, www.steveracz.com

You must be signed in to post the comments.

  • View all advertisers
  • Advertise with us

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com

Latest Projects | Latest Blog Entries | Latest Forum Topics

GardenTenders.com :: gardening showcase