How to place MicroStation points using database records?


  
 Applies To 
  
 Product(s):MicroStation
 Version(s):08.05.02.35
 Environment: N\A
 Area: Database
 Subarea: VSQL
 Original Author:Bentley Technical Support Group
  

Problem


How to place MicroStation points using database records ?

Solution

1. Connect to the database in MicroStation (Settings > Database > Connect)
2. Settings > Database > Query Builder
3. Execute a query on the easting, northing or XY coordinates in the appropriate table.
4. In Visual SQL Query Builder select Queries > Save Results.
5. Save the results as a delimited .DAT file.
6. Edit the .DAT file and remove the first line containing the table and column names.
7. In MicroStation select Tools > Annotation > XYZ Text.
8. The Import setting should be Point. The Order should be set to the appropriate XYZ or YXZ.
9. Set the appropriate symbology and click Process.



See Also