IMPORT COORDINATES AND TEXT USING THE XYZ TOOL

Hi

Using Microstation connect U5.

If i create a .txt file with many ( a few thousen ) x,y,z coordinates, and every coordinate should have a different text ( a combination of numbers and letters ( Something like this; 1:Coordinate; x100 y200 z150 text= 1bar. 2:Coordinate; x300 y200 z250 text= 12bar etc...  ) Would that be possible to import in to Microstation, maybe using the XYZ tool? If so how would i set this up to make it work?

Not very well explained, but i simply want to import data from another software ( CFD simulations ). In excel i have all XYZ the coordinates and i have the text for each XYZ coordinate. Im just not sure if there is a way to get this in to microstation without programming?

Regards

Helge

Parents
  • Hi Helge,

    You can import text with coordinate values in several different arrangements. (TXYZ, TYXZ, XYZT, and YXZT)

    The format of the text file you plan to import should be as follows:

    Order Formatting
    TXYZ $,X,Y,Z
    TYXZ $,Y,X,Z
    XYZT X,Y,Z,$
    YXZT Y,X,Z,$

    (Replace the X Y and Z with the actual coordinate values and replace $ with Text (Limit of 10 characters))

    For the example file you provided you should just replace the spaces with commas to seperate the fields and use the XYZT order as shown below.

    12,47,8,10Bar
    8,52,8,130.4Bar
    9,52,8,10Bar
    10,52,8,160Bar
    8,53,8,17.5Bar
    9,53,8,17.3Bar
    9,43,9,152.1Bar
    10,43,9,152.6Bar
    8,44,9,7Bar
    9,44,9,120Bar
    10,44,9,172Bar
    11,44,9,102Bar
    9,45,9,152Bar
    10,45,9,125Bar
    11,45,9,162Bar
    12,45,9,12Bar
    9,46,9,12Bar
    10,46,9,12Bar
    11,46,9,162Bar
    12,46,9,12Bar
    13,46,9,125Bar

    HTH,
    Ron

    Answer Verified By: helgeh 

Reply
  • Hi Helge,

    You can import text with coordinate values in several different arrangements. (TXYZ, TYXZ, XYZT, and YXZT)

    The format of the text file you plan to import should be as follows:

    Order Formatting
    TXYZ $,X,Y,Z
    TYXZ $,Y,X,Z
    XYZT X,Y,Z,$
    YXZT Y,X,Z,$

    (Replace the X Y and Z with the actual coordinate values and replace $ with Text (Limit of 10 characters))

    For the example file you provided you should just replace the spaces with commas to seperate the fields and use the XYZT order as shown below.

    12,47,8,10Bar
    8,52,8,130.4Bar
    9,52,8,10Bar
    10,52,8,160Bar
    8,53,8,17.5Bar
    9,53,8,17.3Bar
    9,43,9,152.1Bar
    10,43,9,152.6Bar
    8,44,9,7Bar
    9,44,9,120Bar
    10,44,9,172Bar
    11,44,9,102Bar
    9,45,9,152Bar
    10,45,9,125Bar
    11,45,9,162Bar
    12,45,9,12Bar
    9,46,9,12Bar
    10,46,9,12Bar
    11,46,9,162Bar
    12,46,9,12Bar
    13,46,9,125Bar

    HTH,
    Ron

    Answer Verified By: helgeh 

Children
No Data