A new export style for exporting a file directly into Excel/Data collector from ORD needs to be created. The format would need to be a P,N,E,Z,D, Note export style. The File should be exported out of ORD in the same format that the CSV was brought into ORD. ORD generates an extra column for the link code and control codes, but those columns should remain combined. Attached are:
CSV - What it looks like upon export from ORD
CSV - What it should look like
Word Doc. - Formatting workaround for excel file after export
| Civil Product Used | OpenSite Designer, OpenRoads Designer, OpenRail Designer |
100% agree! We frequently need to take files from ORD and put them into data collectors, TBC, or Civil3D. I wrote an excel VBA macro to handle this but it should be a standard part of the software like any other survey program.
Attached are examples of how our system works. Like many it is not elegant, but it gets the job done in a few clicks.
I had created an XML Report for InRoads that accomplished this same result from any FWD file. At my previous employer, we had standardized all survey processing within InRoads and for the Civil 3D projects, we would export this PNEZD CSV file to get the Civil 3D survey deliverable. This capability would allow that process to continue as companies migrate to ORD.
This was aided by the ability to configure Civil 3D to use many of the InRoads control codes. But it did require some decisions to disallow the use of certain commands that were not universally supported. The new StartCurve and Non-Tangent codes add complications to this process but is probably not insurmountable.