Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki Sort columns before export of data from TIG to Shapefile
    • Sign In
    • -Exor - Wiki
      • +ALIM Document Manager
      • An Attempt to Reset Your Password Has Failed
      • -AWLRS
        • AWLRS and Spatial Manager - Questions and Answers
        • +AWLRS 1.3.x versions
        • +AWLRS 1.2.x versions
        • +AWLRS 1.1.x versions
        • +AWLRS Troubleshooting
        • Learning
        • -How To
          • HOW TO: Use GPS Coordinates To Locate A Point Asset In AWLRS
          • HOWTO: Add a background layer
          • HOWTO: Create directional arrow symbols for linear layers
          • AWLRS How to change date format.
          • Bulk End-date or Delete Assets in AWLRS
          • Enable Relocate and Append Options on the Location Tab (Asset Details)
          • How to change the Center Map to Coordinate Length
          • Sort columns before export of data from TIG to Shapefile
        • Resolve potential date / time issue in the Exor database
        • +Transportation Data Loader
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • +Exor Network Manager
      • +Exor Oracle
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • Remove @ from the AWLRS Local Password Policy
      • +Transportation Intelligence Gateway
      • Unable to connect to Power BI dataset
      • +Video Series for Exor
      • Working From Home with Exor
    • +AssetWise ALIM for Transportation
    • How To Import SSL Certificate 11g Weblogic

    You are currently reviewing an older revision of this page.

    • History View current version

    HOWTO: Sort columns before export of data from TIG to Shapefile

      Product(s): Transportation Intelligence Gateway
      Version(s): 2.6.0.9
      Environment: N/A
      Area: Export of Data
      Subarea: Sorting

    A TIG Extract that has been successfully registered in the Exor database is the starting point of this how-to.  Select View Extract Data in Table to begin.

    Once the dataset table has opened, select Export to Shapefile for this how-to.  in the subsequent dialog, the user can select only those fields deemed necessary in the shapefile by selecting the checkbox beside each attribute to be included in the output, or you can select all fields if that is the requirement.

    The order of the columns in the shapefile will follow the order defined in the Extract Summary Information Step (1) page, in the Order column.  In the screenshot below, you can see that the Primary Key has been set to a position of 1 which means it will be the first column in the shapefile output.  

    With the resulth shown in the Export to Shapefile Dialog:

      Original Author: XXX Author XXX
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies