Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Future consideration
Created by Guest
Created on May 24, 2023

Direct Export Style from ORD - CSV for Survey

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
  • Guest
    Reply
    |
    Aug 1, 2024

    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.

  • Guest
    Reply
    |
    Jun 8, 2023

    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.