IMPORT COORDINATES AND TEXT USING THE XYZ TOOL

Unknown said:

1:Coordinate; x100 y200 z150 text= 1bar.
2:Coordinate; x300 y200 z250 text= 12bar

I don't think that MicroStation's Text XYZ tool can interpret that format. However, it's a relatively simple matter to write a VBA macro to work with that format.

Can you provide a sample file?

Unknown said:

CFD simulations

What tool do you use for CFD simulation?

Hi Helge, I did something similar the other day (placing ground levels from a geometer who sent coordinate files with heights only). You can't do it in one go, you'll have to create two or three Excel files and import them one after another, i. e. place a cell where the value has to go to and then the values themselves as text. I'll have to check again how I did it but there's no need for a VBA macro, only a bit of brain to get the right sequence of steps. ;-)

Unknown said:

There's no need for a VBA macro, only a bit of brain to get the right sequence of steps

There's no need for MicroStation either.  You can draw all your maps on a large sheet of vellum with a quill pen.

Unknown said:

You can't do it in one go, you'll have to create two or three Excel files and import them one after another, i. e. place a cell where the value has to go to and then the values themselves as text

If the OP has to import text many times, then your procedure is tedious and prone to human error.

Unknown said:

I'll have to check again how I did it

A VBA macro is a formal record of 'how I did it'. 

In other words, a VBA macro automates repetitive steps, saves time, eliminates human fallibility and doesn't require a bit of anyone's brain.

Hi Jon and fmandoki !
Im using a CFD tool that our company develops ( and sell). Im using it as a consultant for explotions and fire simulations. Its called FLACS ( www.gexcon.com).
So what i am trying to do is to take the results from the CFD simulation and show the values/ results inside microstation. To be more specific, this is monitor points in 3D space that shows some data. It could be pressure, it could be heat-loads or many other things .

Its not completely true that i have all the data in excel yet, but i think we easily can output something like the attached ASC testfile ( Ill confirm this with my coworker tomorrow and update this thread. We can probably also change this around, depending on what will work best with microstation. ). And from there take it in to excel if needed. What i am thinking is that i need a point and the text for each xyz coordinate. The point is just for showing the exact position of the coordinate. As i mentioned one of these files could have thousands of monitor points.

I would be interested to hear from both of you how i could do this. Im thinking that in the long run this is something that i defiantly would like to automate, but for now i would probably have to do it more manually.

Regards

Helge

t-007.zip

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