3d Surface from 2d text height point

Question

Hello 
 a long time ago ( few or more years ) as i remember - someone from us ( communities ) make a script vba or something 
 to make a surface from 2d text on map ( for example 31.2 , 32.4 etc ... ) 
 Maybe someone remember this or can help ? I need to make sufrace from points but there are 2d 
 
 As i remember this script put text on level from text and than connect it to mesh ? 
 
 Martin

Jon Summers · Accepted Answer

martinezx said: why yours macro can't make Z on the end and you need to move it by hand ? 
 Here are the export options: 
 
 The third one x, y, z from text does what you ask. You don't need to move the columns by hand if you choose that option. 
 martinezx said: i try your old macro but have problem with divide columns in office , i have only commas / not dots in numbers / and hard to separate this 
 I guess that your computer is using the Polish locale . When you export coordinates, does your CSV look like this... 
 123.4, 567.8, 0.123 
 Or like this... 
 123,4, 567,8, 0,123 
 With an English locale, the decimal separator is a dot (period . ). With many non-English locales, the decimal separator is a comma ( , ). 
 I've updated the macro to offer different options for the column separator character. You can choose between a comma, semi-colon or tab character... 
 
 For example, here are your coordinates using tab separation... 
 tab-separated-coordinates.csv

Jon Summers · Answer

martinezx said: Look's great . Thank you very much ! 
 I'm pleased to read that! Please mark your post as 'answered'.

Andrew Bell · Answer

Is it possible you are thinking about tools that may be included in one of Bentley's Civil Design packages, like MX? The following Blog seems to explain a workflow in MX that is similar in scope to what you have described here. 
 
 communities.bentley.com/.../mx-2d-to-3d-surface

Judy Wong · Answer

Could it be the an option in PowerCivil , that allow you to convert the 2d text to 3d. Go to File->Import-> Surface. Import surface dialogue window , use the option in elevation drop down as , Use > Text , this it will convert all text element to 3D.

Lorys · Answer

For Mstn V8i users I have posted before a old bas macro (ExtractText ) that will extract the xy and Text of a 2d Text file and create a txt or csv file you can then us import coordinates tool and this text file to create 3d points in an 3d file and then use the 3d tools to create a surface from those points... it works off the justification as the xyz location.. 
 So you need to look at your file carefully to work out if the white crosses are ( if the are not txt node markers) but are where where you need the text to originate from, there is an mdl in the utilities section here that will change your text justification without moving the text ( a really useful utility) , I would set the justification to centre center then change all the text centre centre next I would select all the text and move it so the the text justification is aligned with the survey spot height crosses... then run the ExtractText.bas to recreate the spot height survey coordinate text file...FYI you may need to edit the bas or create the folder for it to save it defaults is "C:	emp\ExtText.csv" 
 If anybody would take on converting this very useful bas into vba I'm sure we would all benefit. 
 0116.ExtractText.zip

martinezx · Answer

Can't do this Jon 
 i try many times 
 - are inverted and not at correct height... 
 Can you or anyone with this experience check this ? ( meters ) 
 https://we.tl/3xbJXZAlWq

Jon Summers · Answer

Once again, I used CONNECT's reporting tools to create an Excel list of coordinates. 
 Krz-Kopia.xlsx 
 Not every point has a height -- some have a character string such as 'X'. 
 The data are in columns Text , Level Name , Coordinates . The coordinates are a comma-separated string x , y , z . Z is, of course, zero. 
 What you need to to: 
 
 Edit the worksheet to remove those rows that don't have a valid Z-value in your text 
 Edit the worksheet to separate the x , y , z text into separate columns
 
 You might want to write a macro to do that. Search the web for examples

Copy the Z value from your Text column into the new Z colum
 
 That gives you a set of x , y , z values with a valid elevation

Save the worksheet as a CSV file 
 Use XYZ Import to import the CSV file

3d Surface from 2d text height point

Top Replies