[Plugin] Export Vertices to CSV

TIG · 23 Nov 2012, 20:57

I'd be grateful for the feedback.
I'm sure this'll fix your locale issue... but I can't test it directly !

pichuneke · 23 Nov 2012, 22:51

It works!

142.416,120.528,-0.533
142.416,122.201,-0.013
143.444,120.528,-0.013
140.002,120.528,-1.721
140.002,122.941,-0.965

I'll make the map later

vislaw · 16 Feb 2014, 22:37

Forgive me, but I am new to Sketchup. I have Sketchup Pro 8.0 and I VERY VERY MUCH am excited about your plug-in that permits export of CSV files from terrains. In fact, it is amazingly exactly what I have been looking for.

Alas, probably because I am a newbie I am having no luck getting it to work.

I installed the .rb file in the plug-ins as stated and I pasted "Exportvertices2csv.new" in the Ruby Console.

I get this result:

Exportvertices2csv.new
Error: #<NoMethodError: undefined method uniq!' for nil:NilClass> C:/Program Files (x86)/Google/Google SketchUp 8/Plugins/exportvertices2csv.rb:30 (eval):0:in new'
(eval):0

Can somebody help me understand what I'm doing wrong? Could it be because I am using the Eval version? Or, am I just dumb as a rock and missing something obvious.

16Feb2014: Figured it out and am MOST appreciative of this very useful tool.

vislaw · 17 Feb 2014, 18:25

I absolutely LOVE this tool and want to thank you, TIG, for your generosity.

One thing, though. It seems that when I bring the resulting CSV file into another application to generate a terrain, I get some artifacts that seem to be almost linear whereby some of the points are too high and some too low. See the images below. The top is the terrain inside Sketchup and the bottom example is from SiteTOPO showing the sort of linear artifact lines that are showing up in my generated terrains:

I've imported files into several different applications (ARAS 360HD, AutoCAD MAP3D, SiteTOPO) and all show the same artifacts so I assume it is somehow occurring as the grid is generated in Sketchup. It is a pain to clean up the artifacts so I'm hoping somebody can help solve this for me.

TIG · 18 Feb 2014, 10:58

I assume if you view the original mesh SKP in Monochrome mode with View > Hidden Geometry ON, you don't see these 'artifacts' ???

Can you post [or PM] the original mesh SKP and resultant mesh after export.
I suspect it's something to do with perhaps 'vertical' or inverted faces ?
Once we see the SKP we can hopefully find out...

vislaw · 18 Feb 2014, 16:21

@tig said:

I assume if you view the original mesh SKP in Monochrome mode with View > Hidden Geometry ON, you don't see these 'artifacts' ???

Can you post [or PM] the original mesh SKP and resultant mesh after export.
I suspect it's something to do with perhaps 'vertical' or inverted faces ?
Once we see the SKP we can hopefully find out...

Thank you so much TIG. This happens on all the terrains I've generated so far. I'm attaching the SKETCHUP file and also the CSV file that is generated from your script. Here's what the terrain looks like when I bring the CSV file into my terrain generator:

As you can see, there are pits and spikes that shouldn't be there.

I really appreciate your help as this would be an incredibly useful tool for me to have.

Many many thanks for your generosity. I sent you a donation and will encourage my compadres to do so as well.

OriginalMeshInSketchup.skp

OriginalMeshInSketchup_verts.csv

TIG · 18 Feb 2014, 16:58

I'll try and look at it on Wednesday...
At first sight I can't see why it should do that...

It's a very simple script so it ought to work and/or be fixable

TIG · 19 Feb 2014, 12:25

Here's v1.3 http://sketchucation.com/forums/viewtopic.php?p=298614#p298614
Get it from the PluginStore download link, or AutoInstall it from within SketchUp itself...

The recently reported issues of 'artifacts' appearing in exported meshes was caused by having the Model Units set to 'Fractional' [already advised against!] but it is is now trapped - the Units LengthFormat is temporarily reset to 'Decimal' whilst it is exporting, and it's reset afterwards as needed.
It also now in a 'TIG' module.
It has a new easy to use File menu item TIG.exportvertices2csv to run it.
Or you can still use the clunky Ruby Console 'command-line' [note that you now must type TIG.exportvertices2csv ]

vislaw · 19 Feb 2014, 15:07

Beautiful work. I tip my hat to you for making this great tool. This provides me with a very easy way to bring 3D Google Earth terrains into an external application. Bravo TIG!

Isher · 12 Jun 2015, 15:42

Hi TIG,

The export2CSV does not extract the points in the proper manner. You may export a circle and draw a Scatter Graph in MS Excel. The lines appear out of order.

Would appreciate if there is any improvement

TIG · 12 Jun 2015, 16:38

@isher said:

Hi TIG,

The export2CSV does not extract the points in the proper manner. You may export a circle and draw a Scatter Graph in MS Excel. The lines appear out of order.

Would appreciate if there is any improvement
It just exports the vertices.
It does not order them.
A 'Delauney' algorithm is probably needed to arrange them...

BluesDog · 27 Aug 2016, 19:56

Hi TIG

I made a modification to an earlier version of your script that extends its functionality. Specifically, I tweaked it such that it exports the vertices of all the faces and edges in a model (not just the active selection). The tweak also finds all the faces and edges tucked away in groups and components. As well as applies the respective group and component level transforms to the vertices. I've uploaded the tweak to Gist, here's the link: modifiedScript

If the features are useful to you or your users feel free to integrate them with the latest version of your script.

Thanks a lot for creating and sharing the original script. It has been very useful!

Regards

Axello · 2 Jul 2020, 10:27

Great plugin! Is there any chance to pull out more than 2 approximated decimal points out of sketchup? e.g. 10 or more? thx

Dave R · 2 Jul 2020, 11:52

@axello said:

Is there any chance to pull out more than 2 approximated decimal points out of sketchup? e.g. 10 or more?

If you read through this thread you can see that the number of decimal places you get depends on your precision settings in Model Info.

What units are you working in that you think you need 10 or more places past the decimal?

zander83 · 23 Jan 2021, 16:21

Hi TIG, is there somewhere I could look up as a guide for using your plugin? Out of my depth here but I basically just want to export the vertices from scatter instances in sketchup, to open in octane standalone scatter node. When I select the geometry / group (even if just a simple box) and hit TIG.exportvertices2csv under File nothing happens. What am I doing wrong? Using skp2019. Thanks very much for any help in advance!

TIG · 29 Jan 2021, 17:13

There's help within the posts in the thread, have you read them all ?

MLUY · 8 Jan 2023, 10:51

Hi is there perhaps a way this plugin (or other) can export the co-ordinates of the polyline segments in the correct order? I am trying to reconstruct a polygon by loading in the co-ordinates from the csv, but I need them in the correct order. At the moment I am basically getting a point cloud

Thanks
Michiel