• State Verified Answer
  • Replies 44 replies
  • Answers 5 answers
  • Subscribers 116 subscribers
  • Views 13925 views
  • Users 0 members are here

3d Surface from 2d text height point

martinezx
Offline

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
  • 0 Offline

    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

  • 0 Offline in reply to Krister Surell

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

  • 0 Offline in reply to Jon Summers

    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 

  • 0 Offline in reply to Jon Summers

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


    balice teren 3d test.dgn

    Fullscreen Text2D 2B.txt Download 
    -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 

  • 0 Offline in reply to martinezx
    martinezx said:
    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

  • 0 Offline in reply to Jon Summers

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

  • 0 Offline in reply to martinezx

    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

Reply
  • 0 Offline in reply to martinezx

    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

Children
No Data
Communities
Support and Services
Training and Learning
Social Media