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
  • I tried another approach just for fun.

    You can generate a report for the desired  text element.

    Use X and Y coordinates and text for columns and export to csv. If you want to import the text as well add a copy of the text field.

    This file could then be imported using Import Coordinates (XYX Text) and used to create a mesh (remember to delete the first row which contains column names!).

    /Krister

    Owner consultant at Surell Consulting AB

  • But if you have tousend of this points ? You need to add height manually

  • I dont know how / never do a reports

    Reports are tricky, but extremely useful.  Here is some help!

     
    Regards, Jon Summers
    LA Solutions

  • Thank you Jon and Krister very much. Works with some problems but finally i have a mesh :)

    In add Text string column you forget that you need to choose Text String from properties ( to have height from text )

    Than i export from excel to csv but not working ( process give errors )  -  only way was export to txt with spaces

    In fact - it would be nice if Bentley can do this directly in Microstation :)   Mesh from text values 

  • Jon another try but i miss something  - i have strange result using reports  - please check my DGN


    balice teren 3d test.dgn

    -52,06	43,47	281,5
    -45,68	42,88	280,3
    -52,21	42,72	280,6
    -31,42	40,75	278,3
    -19,78	57,65	282,8
    -26,04	52,89	280,9
    -16,79	48,8	281,3
    -22,48	44,19	279,3
    -18,15	39,12	278,3
    -45,25	37,24	280,2
    -45,16	102,59	288
    -51,79	98,58	286,6
    -56,04	98,37	286,2
    -49,5	93,05	285,9
    -41,81	92,3	286,5
    -37,87	91,8	286,3
    -39,46	85,08	284,3
    -45,03	80,68	284,2
    -23,47	12,08	274,4
    -23,94	4,37	272,9
    -12,52	12,64	274,3
    -13,18	5,22	272,9
    -14,94	-1,97	271,3
    -19,71	71,97	284,5
    -21,97	68,16	284,1
    -24,05	73,83	284,6
    -24,9	81,28	285,3
    -31,07	66,27	282,4
    -31,16	88,03	286,3
    -32,09	66,45	281,8
    -35,17	74,64	282,8
    -26,5	32,34	277,3
    -31,59	26,04	278
    -44,12	26,99	279
    -17,88	22,51	276,2
    -4,83	34,24	278,2
    -6,46	31,86	276,1
    -2,4	-4,95	270,7
    11,16	-5,55	271,3
    18,66	-0,16	273,5
    32,15	-2,8	274,2
    22,91	-2,72	273,3
    -27,53	52,68	279,88
    -30,49	51,53	279,91
    -23,59	43,95	278,57
    -26,32	42,02	278,65
    -18,81	38,17	277,66
    -20,43	35,29	277,56
    -51,87	93,91	285,7
    -44,42	91,57	285,58
    -47,52	83,88	284,55
    -40,44	81,43	284,01
    -37,78	78,63	282,99
    -42,34	71,51	282,49
    21,37	93,71	285,21
    -36,49	63,67	284,64
    -5,71	28,35	275,91
    -5,94	20,58	275,49
    -5,61	11,21	273,19
    -2,02	11	273,16
    -3,3	-2,65	271,62
    -6,83	-0,5	271,31
    11,97	-4,12	271,62
    -4,7	-4,87	270,86
    1,89	-5,29	270,7
    28,26	-0,34	274,14
    -2,49	7,3	272,74
    -0,61	7,33	272,53
    -0,51	6,14	272,48
    -0,33	4,17	272,04
    0	0	272,01
    -3,52	-2,23	271,19
    -24,66	71,62	283,68
    -31,32	72,34	282,71
    -25,1	70,51	283,55
    -19,65	68,61	284,16
    -14,89	67,52	283,76
    -11,07	67,06	283,67
    -6,26	66,02	283,33
    -1,06	65,07	283,06
    4,1	63,86	282,58
    9,35	63,52	282,3
    15,52	62,79	282,02
    19,1	61,72	281,7
    17,42	56,28	281,25
    10,92	56,85	281,48
    5,19	58,2	281,94
    -0,91	59,27	282,36
    -6,61	61,08	282,71
    -12,43	62,22	283,01
    -17,95	63,12	283,51
    -23,3	63,99	283,37
    -28,44	63,77	282,4
    -26,66	59,03	281,82
    -21,1	58,38	282,55
    -15,42	56,8	282,39
    -10,2	54,49	282
    -4,09	53,11	281,74
    1,76	51,9	281,34
    6,76	50,07	280,9
    11,47	48,34	280,44
    14,25	46,96	280,25
    11,53	40,92	279,64
    5,4	42,75	279,93
    -0,24	44,29	280,32
    -6,01	45,84	280,48
    -11,44	47,4	280,77
    -16,81	48,54	280,96
    -21,65	49,25	280,7
    -19,57	44,32	279,59
    -13,49	43,14	279,61
    -7,73	41,17	279,36
    -2,16	39,07	279,38
    3,02	37,12	279,3
    7,68	34,62	279,03
    11,8	33,13	278,9
    9,13	28,74	278,54
    6,39	30,01	278,55
    2,1	32,23	278,44
    -2,81	34,58	278,22
    -8,04	36,56	278,08
    -11,89	38,72	278,48
    -15,86	40,49	278,71
    -19,5	42,17	278,95
    
     Text2D.xlsx 

  • i have strange result using reports
    -52,06	43,47	281,5

    Is that what you see when you export a Report as CSV?  Your Polish locale is affecting the formatting.  When I open Test2D.xlsx it looks OK.

    This is what I see when I run a Report in UK English locale...

    XYZ text

     
    Regards, Jon Summers
    LA Solutions

  • Thank you Jon for checking. I will answer after weekend cos i have urgent "trip" right now.

Reply Children
  • Don't understand - you mean dots or comma ?   All looks the same  - X Y Z have the same results.

     I can change dots and comma in Excel.  I change the columns  to X  Y  and Text String to  Z and move as 3rd column  but after import  3d points looks strange as you see in my dgn 

    Ok i changed language to ENG and export once again. Than i correct text file ( spaces between ) and looks ok.

    Thanks