Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki How to include a Location Group name in the Excel Extension report
    • Sign In
    • -OpenGround Wiki
      • -Applications
        • +Admin Portal
        • +Civil 3D Extension
        • +Data Collector
        • +Data Entry Module
        • -Excel Extension
          • Excel Extension Release Notes
          • -Excel Extension How Tos
            • How To Add Project Details to the Excel Extension Report
            • How to include a Location Group name in the Excel Extension report
            • How To Remove Unwanted Templates
            • How to save a Template and save the ran report as a workbook
          • +Excel Extension FAQ's
          • +Excel Extension Common Issues
          • +Excel Extension User Guide
        • +Launcher
        • +OpenGround Professional
        • +Portal Technical Preview
        • +Power BI Connector
        • +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 include a Location Group name in the Excel Extension report

    Explanation

    We have asked how to include the location group name in a report without manually adding it after the report has run. To do this you can create a new field /column in the Location details Grid For "Location Group Name". Please follow the steps below on how this is done.

    Process

    Login as an Administrator

    Go to System>Configuration Packs>Select the pack

    From the ribbon select "Manage Model"

    Select the "Location Details" table and then "Edit"

    Select "Add Header"

    Create the header so it's as shown below:

     

    Save the changes and exit out of the Model.

    Open the project

    From the "All Data" selection tool select one of the Location Groups Previously created.

     

    This will update the data explorer on the left to only contain data for that group.

    For example, my project as a total of 28 locations and my "Tester" Location Group contains 5. Below we can see that

    The location details is now only showing the 5 locations listed:

     

    Double click the Location Details to then open the Grid that contains just so locations.

    You can now locate the "Location Group Name" column , select "Bulk Update" from the ribbon

    Select the Column "Location Details Name"

    Add the value which will be the name of your location group.

     

    Then select "Save", this will add the location group name to all the locations in that group.

    Please repeat this for any other location group you have. You will also be able to add the column to

    your excel reports and bring it back with the data.

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Mon, Mar 22 2021 12:14 PM
    • Revisions: 1
    • 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