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
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.
Regards, Jon Summers LA Solutions
Jon, don't feel offended. This is a feature I personally need maybe once every three years, so I have no need for a Macro.
I did it exactly as Ron did. In a second go I placed a cell (small circle) to highlight the exact location of the values. There's no direct way to place such an object along with values I would know of.
Unknown said: Jon, don't feel offended. This is a feature I personally need maybe once every three years, so I have no need for a Macro. I did it exactly as Ron did. In a second go I placed a cell (small circle) to highlight the exact location of the values. There's no direct way to place such an object along with values I would know of.
so you would like the cell to have the coordinate values displayed as well as the cell right?
Yes this is possible there are examples in the forum and in youtube ... and ask inga
you have to build a cell that can assign Fields to the xy of an origin point.... if you want the T value too that is more difficult, but I like to keep it simple and use the run the import twice and put things on diffferent levels..
I used to this alot in GIS ( mapInfo) but essentially you do the same thing only more steps with plain microstation and with excel you can do a lot ..
Like arrange all the Text ( numeric like your results Bar or pressure) values from high to low or group then so you get 0-20 bar, 21-30 bar etc
Then I would create levels with that range and import the first lot to place my cells by level name and colour, and repeat through all the separate groups ( each a separate csv ... then make a nice colour bar chart result being Thematic mapping of your points you can even add in the total of each groups points next to the bar chart legend.. mind you this would take about 30 to 40 mins for the whole show and 5 mins in MapInfo (Gis)... but once you get the hang of it, it is mostly done in excel and the import xyz in microstation... this approach can still accommodate actual value text on a hidden level or turned off level...
If you make layered pdfs you can even take advantage of only showing specific levels in presentations.. no need for microstation after its been built...
I promise you if you make a Thematic map and pdf layered your boss will think your magic... Management love coloured thematic maps.... pictures speak thousands of words...
If you need help please pm me and I'll be glad to assist you...
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
Hi Lorys
Tank you for these useful tips, i like the idea of sliting up stuff in to different ranges, different layers, thematic map etc.
Yes, and I was wondering if you cold send me some of the links for this to look at?
Thanks
Unknown said: Hi Lorys Tank you for these useful tips, i like the idea of sliting up stuff in to different ranges, different layers, thematic map etc. so you would like the cell to have the coordinate values displayed as well as the cell right? Yes this is possible there are examples in the forum and in youtube ... and ask inga Yes, and I was wondering if you cold send me some of the links for this to look at? Thanks Helge
A place holder cell is what you want ...it contains text Fields, (later you can place that cell via the xyz tools and txt or csv )
you already made a cell for this so open the cell in the cell library then follow the instructions in ask inga video tip from Samir explains it very well