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