3d Surface from 2d text height point

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

Parents Reply Children
  • I can't do this with this file

    I used the exporter macro to create a CSV file from your DGN model.  Here's a small extract...

    199.8, 7428930.45, 5545502.09, 10.20
    199.7, 7428941.88, 5545428.36, 10.20
    199.7, 7428924.39, 5545432.57, 10.20
    199.6, 7428959.58, 5545425.34, 10.20
    199.5, 7428942.98, 5545452.84, 10.20
    199.5, 7429027.53, 5545451.86, 10.20
    199.7, 7429050.23, 5545435.13, 10.20
    199.4, 7429074.21, 5545456.27, 10.20
    

    The first column has the Z coordinate from the displayed text.  The second and third columns are the X, Y coordinate of that text.  The fourth column is the Z coordinate of that text.

    You can choose to export the data differently: X, Y and Z taken from the text value.

    You need to move the first column to the third column so you have the required X, Y, Z coordinates.  Discard the unwanted fourth column...

    428930.45, 5545502.09, 199.8
    428941.88, 5545428.36, 199.7
    428924.39, 5545432.57, 199.7
    428959.58, 5545425.34, 199.6
    428942.98, 5545452.84, 199.5
    429027.53, 5545451.86, 199.5
    429050.23, 5545435.13, 199.7
    429074.21, 5545456.27, 199.4
    

    The reordered coordinates are attached:

    martinezx-test2-ordered.csv

     
    Regards, Jon Summers
    LA Solutions

  • Thank you Jon

    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  

    IS this a new macro ? 

    Btw why yours macro can't make  Z on the end  and you need to move it by hand ? 

  • why yours macro can't make  Z on the end  and you need to move it by hand ?

    Here are the export options:

    Text 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.

    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

     
    Regards, Jon Summers
    LA Solutions

    Answer Verified By: martinezx 

  • Jon - Polish ;) 

    Look's great .  Thank you very much !

    Old macro  with option x, y, z from text  give me 0  at the end

    Martin

  • Look's great .  Thank you very much !

    I'm pleased to read that!  Please mark your post as 'answered'.

     
    Regards, Jon Summers
    LA Solutions

    Answer Verified By: martinezx