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, 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.

     
    Regards, Jon Summers
    LA Solutions

Reply
  • 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

Children
  • 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.

    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

  • 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

    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