Well, I must admit that it has been fun talking about this subject, so in this post I want to show the best we have found.
- We saw that Microstation Has integrated The functionality to import directly from a txt file
- We also saw how Do it with AutoCAD
- We saw how Export from AutoCAD o Microstation to csv or txt
- Then we saw how to use the command concatenate In case of having bearings and distances in excel
- And we saw a VBA application for Microstation that works in both ways
But best of all was to learn from someone who in his comments told us about this tool that allows from an excel file to generate a dxf file, using the coordinates of x, y, z, an identification code and the level where We want it to be drawn.
The application is called XYZ-DXF and you can download it here;
Let's see how it works:
1. The data of origin:
This application is appropriate for information downloaded from a gps or total station, as long as the coordinates are UTM, means that its units in a Cartesian plane are in meters. The column of the code, is an identifier of the point, then the coordinates x, y, z and finally the layer we want to be drawn, these can be for example street axis, trees, boundaries, polygonal or any other feature that allows us to filter the data in AutoCAD or Microstation.
* All points must have code.
* All points must be entered one after the other, without leaving blank rows.
We have to thank Juan Manuel Anguita, a Surveyor from Jaén, Spain who made an effort to build this macro. The Excel file has three sheets, one of them called Preview allows you to see the graphic in plan, and side views (built to pure Excel graph!). Also each one of those 9 quadrants can be visualized, in case of changing data in the table the button «update views» is used
Configure data for export
The third sheet called options, allows you to define whether the file to be exported will go in two or three dimensions, the size of the letter, if we want the elevations (dots) and the name of the dxf file to be displayed.
Once the purple button is pressed, a .dxf file is created, which can be opened with Microstation, Arcview, AutoCAD or almost any CAD program. In this, a layer is created for each different text found in the 'Layer' column (eg: lev), in which the points are stitched; there will also be another layer whose monbre will be the text of the column 'Layer' + txt (ex .: levtxt), in which the codes will be, and another one will be created, in which the dimensions will be, with the monbre 'text of the column 'Layer' + dimensions (ex .: levcotas). An excel file with the same name and in the same destination is also created.
The destination file (dxf)
This is the example of the file displayed from AutoCAD. Then you can change the colors of the layers (format / layers) or the format of points (format / point styles).
It is simply an awesome application, for the useful and simple what it is to manage. Do not draw lines, just send points.