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?
fmandoki 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.
fmandoki 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.
fmandoki 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.
Regards, Jon Summers LA Solutions
fmandoki said:Thanks for the hint but the video link seems to be gone...
as screen shot here....even has sound...
MicroStation user since 1990 Melbourne Australia.click link to PM me
helgeh said: I don't see any options to use text (T value) as the source for the bar chart
MicroStation includes the following thematic display handlers:
Height — Color is derived from the height (elevation) of the geometry
May I suggest that you start a new thread for this question? We're straying from the XYZ import topic.
helgeh said:I was wondering is it possible to make a thematic map of the all the T values, instead of manually grouping The T values in to different ranges ( 0-20, 20-40 etc) and get this in to a bar chart? I was looking at the thematic display options in microstation and Descartes but I don't see any options to use text (T value) as the source for the bar chart. Regards Helge
The T is text so thematic using T values is not available option in mstn view attribute rendering
I meant you can make a thematic look a like via the level names grouping to make it easy via excel and then reimport several times for you individual grouping .. the only other way is to find all the text by regex or vba , I find the excel filter much easier and can save the answer to separate work books and then save each as csv then make your own MANUALLY DRAW bar legend.. as I said before it would take a few seconds to import and create in MapInfo ( GIS) and make the thematic map, bar chart, title block and north point but 20-30 mins in mstn especially if you never done it before.. I can knock these out pretty quick with excel and mstn now days as I've done lots before.. if you to do it often then a third party product like flexitool from LA solutions might be worth considering it also has lots of other functions especially tags for title blocks in both directions cad to table and table to cad...
You could trick microstation and change the shapes to adopt the T value for Z ie make them 3d for example one room has a value of 20 bar and another has 10 bar and another 5 bar, now if you have closed true polygons for those room boundaries then change the Z value for each to match the bar values then you could do thematic rendering via microstation view attributes... with the height or z values but your legend will be in m not bar... but my original answer via excel is still quicker and neater than that... unless you use gis there is no faster automatic way...( Well apart from some custom vba or mdl )...