IMPORT COORDINATES AND TEXT USING THE XYZ TOOL

Question

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

Ron Jones · Accepted Answer

If you leave the Text: field blank in the dialog shown in my previous post, the text in the T field of the import file will import along with the coordinate.

Ron Jones · Answer

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

IMPORT COORDINATES AND TEXT USING THE XYZ TOOL

Top Replies