Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki How To Use a Case Sensitive Search to Create Geology Code 2 data automatically
    • 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 Use a Case Sensitive Search to Create Geology Code 2 data automatically

    Explanation

    When reviewing your Geology data, it may be useful to create custom geology code 2 values based on the descriptions found within the data. This is most common where the main constituents are capitalised within the description. It is not currently possible to do a filter within OpenGround Cloud Professional that is case sensitive (it will treat gravel and GRAVEL as the same) which would allow for a quick interrogation of this data, however, it is possible to export the data and then edit using Excel, then import it back in.

    Process

    • Open the Data Grid within OpenGround Cloud Professional that contains the values that need to be changed.
    • Select CSV Export from the Grid Tools ribbon.
    • Export the file to a convenient location.
    • Open the exported CSV file within Excel.
    • Open up the Field Geology Descriptions Tool available in the downloads section below.
    • Copy the relevant data from the CSV file (A2:G2 in a non edited CSV file).
    • Paste the data into the corresponding cells into the Field Geology Descriptions Tool (A3:G3)
    • The tool has already been setup to use the search phrases found in cells I2:Q2. If other search phrases are needed then edit these as appropriate.
    • The values in the 'ABBR to use table' (Cells T2:AB2) can then be adjusted to give the output that will be needed.
    • The results of this process will then appear in column AD
    • Check your output, put a filter on your new Geology Code 2, and manually modify any that are peculiar (i.e. SAND and SANDSTONE will both be found where SANDSTONE is present).

    • Copy Column AD and replace the values in column G.
    • Delete all of the columns following Column H (so all of the working columns) so you are left with just the relevant data.
    • Save the file as a CSV file (File - Save As, ensure type is set as in the below screenshot (File Name and Type is important).
    • Import into OpenGround Cloud Professional using the Data Import function.

    Download

    The tool mentioned in the above process can be downloaded from here.

    Acknowledgement

    This process and tool was provided with many thanks by one of our users - Jim Poole from Coffey. If you would like any assistance with this process then please contact Bentley Support.

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Tue, Mar 23 2021 6:09 AM
    • Marie-Claude Dubé Last revision by Bentley Colleague Marie-Claude Dubé
    • When: Fri, Nov 26 2021 3:01 PM
    • Revisions: 2
    • 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