Connect XYZ Export Co-ordinates to 6 decimal places

Question

I am trying to export co-ordinates to 6 decimal places, however the drop down only allows me to go to 4 ? Yet I can label co-ordinates to 6 decimal places. Other than labelling the elements and copy/pasting the label into a spreadsheet, is there any other way I can get an export to 6 decimal places ?

Jan Šlegr · Answer

Hi Sue, 
 Sue Martin said: is there any other way I can get an export to 6 decimal places ? 
 Yes, use key-in, not Export Coordinates tool GUI, to define the export accuracy: 
 export accuracy 6 
 When this key-in is used and the tool is restarted, you should see empty Accuracy menu (because it is set to a value that menu does not contain) and the exported file should be created with 6 decimal places. 
 With regards, 
 Jan

Andrew Bell · Answer

I don't usually provide external Wiki's but thought this one from Jon Summers @ LA Solutions was worth it. 
 http://www.la-solutions.co.uk/content/CONNECT/Reports/ExportCoordinates.htm 
 It shows an alternative from the XYZ Tools for how to use the new Reporting functionality in MicroStation CONNECT Edition to export coordinates.

Ron Jones · Answer

You could try exporting the desired elements to Google Earth as a .kml file. Once you have the .kml file, change the extension to .xml and open it in any web browser. This will display the .xml files contents and you should be able to easily select and copy the lat/long coordinates.

Lorys · Answer

just had an idea, can you import your file into a GIS package and as they are just points you can easy create table in GIS and export table to excel.. otherwise its a CE14 job...

Connect XYZ Export Co-ordinates to 6 decimal places

Top Replies