Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki How to create a User Defined Field
    • Sign In
    • -OpenGround Wiki
      • -Applications
        • +Admin Portal
        • +Civil 3D Extension
        • +Data Collector
        • +Data Entry Module
        • +Excel Extension
        • +Launcher
        • +Power BI Connector
        • -Professional
          • Professional Release Notes
          • -Professional How To's
            • Changing the Default Quicklog Template
            • How can a GPS file be prepared for import
            • How Do Material Symbols (Legend Codes) Work
            • How is it Possible to Show the Coordinate System for the Project on Log Output
            • How Should I Be Using a 'Primary Controller' When Entering Data
            • How to add a SHP file
            • How To add a Watermark for 'DRAFT' to a log
            • How To Add Hatch Patterns to New Geologies
            • How To Adjust the Project Extents
            • How to Apply Column Sorting and Ordering
            • How to Apply Column Styling
            • How to Apply Grouping to Grids
            • How to Arrange and Customise the Interface
            • How To Assign a colour to geology codes
            • How To Assign Point Symbols and Connector Symbols to Picklists
            • How To Change the Appearance of Shape Files
            • How to Change the Data Report Type for Numeric Values
            • How to change the default logo that appears on a Template
            • How To Change the Location Symbols
            • How To change the range of depths displayed on each page of a log
            • How To Convert SQL Databases to Access format for use with the OpenGround Importer
            • How To create a Location Group
            • How To Create a Location Group from the Map
            • How to create a User Defined Field
            • How to create labels for location groups on the map
            • How to Determine CSV File Headers
            • How to do a basic Export of AGS data
            • How to edit or add items to a Picklist
            • How To Enable Additional Coordinate Systems for New Projects
            • How To Enable Environmental Laboratory Testing Grids
            • How to enter Pipe Records
            • How To Enter Special Characters
            • How To Exclude a document in an AGS Export
            • How to Export table from the model without associated picklists
            • How to Find a Project
            • How to freeze the columns within a grid
            • How to generate a Quick Log
            • How To Get a Laboratory XML file for Scheduling from KeyLAB
            • How To Get Started with the Grid Interface
            • How To Get Started with the Project Explorer Interface
            • How To Get Started with the Ribbon Interface
            • How To Import a Component File and Delete a Component File
            • How to import documents as bulk
            • How To Import Large Files
            • How To Import new Geology Code Images
            • How To Import Your Project Archive
            • How to jump to a specific grid page within a project
            • How To Manually add a coordinate system
            • How to move all data from one project to a new one based on a different configuration pack
            • How To Perform a Bulk Update
            • How to Search the Map
            • How to set a user up to be able to create projects and be the Project Manager of that Project
            • How To set up installation instrument drawing types
            • How to setup a security group that can create projects and edit the data
            • How To Show Mapping and Aerial Photography
            • How To Use a Case Sensitive Search to Create Geology Code 2 data automatically
            • How To Use Color Coding for Material Graphics
            • How to use FILE_FSET to export/import documents with AGS data.
            • How to use Grid Filters
            • How to use the Data Entry Feedback Tool
            • How to use the Project Explorer to Filter Data
            • How to Use the Reports Section of the Project Explorer
            • How to Work with Location Groups and Saved Searches
            • How to Work with Project Picklists
            • Adding your own Coordinate Systems manually in OpenGround Cloud
            • How to edit the Transfer Mapping should you need to map a field.
            • How To Remove the Project Locks for Import
            • How to Use Scheduleing and Chain of Custody in OpenGround
            • How to Manage Laboratories and Tests for Scheduling
            • How to use the Restrict User's Permissions on Project Creation
          • +Professional FAQ's
          • +Professional Common Issues
          • +Professional User Guide
        • +Template Studio
        • +Upload Portal
        • +Web API and Task Service
        • +Web Portal
      • +Guides and Learning
      • OpenGround Supported Platforms
      • +How To Contact Support
      • Component Center
      • Events
      • Training Guides
      • +Developer Resources

     
     Questions about this article, topic, or product? Click here. 

    How to create a User Defined Field

    Explanation

    Although OpenGround Cloud comes with a substantial database with a wide variety of tables and fields as standard, it may be necessary to expand the model to fit your needs. This can be completed using an "User Defined Field" (UDF).

    Process

    Ensure that no project is open and select Configuration Packs from the System menu, from within here, select the configuration pack that you wish to add this field to and then select Manage Model from the Configuration Tools menu. From the 'Manage Model' screen select the group of data for which the field is required:

    Hint: if you have received a screen shot of the required field the name of the table can be found in the title header, "LocationDetails" in the example below:

    On the highlighted row click the 'Edit' button. From the 'Edit Group' screen click the 'Add Header' button:

    The 'Add Heading' interface will open:

    Fill this out as required to define the required new field:

    Once complete click 'Save'. You will be returned to the 'Edit Group' screen.

    If the new field needs to correlate to a data transfer format, ensure the new field is highlighted in the interface then scroll across to find the 'Edit Mapping' column, :

    Click the 'Edit Mapping' button, specify the items in the drop down lists and define the correct column name as it is required to appear in the outgoing format:

    The above example would be used, therefore, to look for a field called "HOLE_TPGW" contained within an AGS3.1 file which is imported into OpenGround Cloud.

    Click 'Save' and you'll be returned to the 'Edit Group' interface. Click 'Save' from here and then 'Close'. In order to allow these structural changes to be applied OpenGround Cloud will now need to reload the project (close the project and reopen if it doesn't happen automatically).

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Tue, Mar 23 2021 5:47 AM
    • Jesse Greenwald Last revision by Bentley Colleague Jesse Greenwald
    • When: Fri, Mar 31 2023 4:01 PM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    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