Microstation: Import Excel Coordinates and Annotations

The case: I have data raised with Promark 100 GPS, and by using the GNSS postprocessing application that these computers have, I can send the information to Excel.

The columns marked in yellow are the east, north and their respective annotations; The rest is only information related to the post process.

The problem: I require that users with their versions of Microstation that have the data import.

Excel coordinates microstation

Slimy ways of doing it

If you import the coordinates with Microstation with the Command made for this, only the points are coming, not the labels. For the long way, a user was importing them from CivilCAD, which he does very well, then from Microstation it was opened and converted to which is the format where every day works. So… Although I almost went, I appreciate that you have asked me for a suggestion how to do it; although deep down I think they do it to prove that the commands are not rusted. It is just the procedure that I explained before With AutoCAD.

How to concatenate coordinates with Excel

Doing a vba would be ideal, but as a custom of what one day we concluded: Excel should be more productive than to do spreadsheet, here the procedure combining Microstation commands (key in) with Excel commands (concatenate)

Creating a point with Microstation is done with the command "place point", and if you want to place it in a specific coordinate, use "xy =", always using the command separator that is the semicolon (;). So, when entering the command place point; xy = 388218.835,1566315.816 You should draw a point right in that coordinate.

In the case of Excel, the concatenate command works like this: concatenate command, open parentheses, then indicate everything that is going to be concatenated, and finally close parentheses. I explain it plaintively, but it is not complicated when it is understood and done at least once:

Concatenate command = CONCATENATE We open parentheses ( then the commando command is a text, with its semicolon that separates the command «Place point;» then the comma to separate the next string , then the command in quotes as it is text «Xy =» the comma to indicate new string , and here we select the respective cell C3 then the comma to indicate new string , and the comma in quotes for separation of coordinates "," the comma to indicate the next string , cell that contains the north coordinate and the final semicolon D3,«;» Then we close parentheses )

It would look like this:

= CONCATENATE («Place point ;«, "Xy =",C3, ",",D3, ";")

Once this is done, just copy the formula to the following columns, as follows:

Place point; xy = 388218.835,1566315.816;
Place point; xy = 388219.911,1566320.28;
Place point; xy = 388216.28,1566320.868;
Place point; xy = 388215.36,1566316.473;
Place point; xy = 388211.706,1566317.245;
Place point; xy = 388212.713,1566321.593;

How to send it to Microstation

This text can be copied and pasted directly to the command line (utilities key in) and see that the points are drawn.

Excel coordinates microstation

But I can also copy it into a txt or csv file that I can call as a script.

For example, the file is called Glowpoints.txt, and it is stored in C; so to call it you write the key in @c: \ glowpoints.txt. The name should not have spaces, and it is preferable to place it in an easy route.

Importing annotations

It works in the same way, with the difference that the command is not point but text icon: Place text icon

Concatenamos of equal form, command place text icon, cell that contains annotation, coordinates where the text will be placed:

= CONCATENATE ("place text icon;", B3, »;», »xy =», C3, »,», D3, »;»)

And then we should stay that way.

Place text icon; 10; xy = 388218.835,1566315.816;
Place text icon; 11; xy = 388219.911,1566320.28;
Place text icon; 12; xy = 388216.28,1566320.868;
Place text icon; 13; xy = 388215.36,1566316.473;
Place text icon; 14; xy = 388211.706,1566317.245;
Place text icon; 15; xy = 388212.713,1566321.593;

And there they have it:

Excel coordinates microstation

To generate the traverse, the same thing would be done, but with the place line command, with the caution that the points must have sequence; that is not this case. It would be place line command, start coordinate, target coordinate ...

Sure there are other ways to do it, and open source programs that do it wonderfully. But the exercise is useful to speed up the mind and in my case, avoid rusting the commands.

6 Replies to “Microstation: Import coordinates and annotations from Excel”

  1. I do not have the program at hand, but you would have to place the complete command, such as PLACE CIRCLE RADIUS.

    Luck.

  2. Hello friend, excellent information, I have managed to refresh and better still solve situations that I thought could not be done in microstation, I have a question that is related to the topic discussed above by you, how do I import a circle instead of a point as a well reference ? I did all the above mentioned steps using as a parameter: = CONCATENATE ("place circle; ... ..) and then taken to .txt and then taken to key in as @d: \ circulo.txt, but I have not managed to graph them, could you help me in that regard?

    Greetings.

  3. Hello, good day, I would like to know if you have a tutorial or note on how to do a postprocess for a promark 200 gps in the GNSS solutions program ?? I've been trying for days but it was not possible because the gps throws me type .csv files ... I hope your answer thanks.

  4. Good, so I tell you that the workshop did not come the victores and when I came I wanted to impress them with their help, and rather they had adapted other things, and I was scared by asking them immediately how they had done ... heh he tells me we're looking for victor in geofumadas ... it's good that he always supports us because he has always been my master in this, also I did not do it because I tried it because I could understand that they could understand me little or nothing with the turnaround that had to be done with civilcad but really everyone in the workshop was impressed ...

    These help us generate more amplitude in the thousands of trick that can be done with the PC, but a guide is always necessary to be able to learn them ..

    On the part of the technicians THANKS, because my only I have to say guaoooo is a cheese.

Leave an answer

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.