Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki Picklist Set Validation and Caveats of Use
    • Sign In
    • -OpenGround Wiki
      • -Applications
        • +Admin Portal
        • +Civil 3D Extension
        • +Data Collector
        • +Data Entry Module
        • +Excel Extension
        • +Launcher
        • -OpenGround Professional
          • Professional Release Notes
          • +Professional How To's
          • +Professional FAQ's
          • +Professional Common Issues
          • -Professional User Guide
            • +Components of the Interface
            • +Working with Projects
            • +Snapshots
            • +User Accounts in Professional
            • +Teams
            • +Data Import
            • +Document Management
            • +Logs
            • +Using the Data Entry Tool
            • +Site Plan Production
            • +Trigger Sets, Grid Views and Report Grids
            • +Working with Location Groups and Saved Searches
            • -Components and Configuration Packs
              • Adding New Fields
              • Adding New Tables
              • +Advanced Calculated Fields
              • Changing a Projects Coordinate System
              • +Components
              • Configuring Default Templates
              • Configuring Template Images
              • Configuring the Model Structure
              • Configuring the Units
              • Coordinate Conversion
              • Creating a Picklist Set
              • Data Entry
              • Data Types
              • Default Locations Styling
              • Editing Units
              • Exporting a Configuration Pack
              • Extension Graph Styles Creation
              • Hiding Empty Tables
              • Import and Export Mapping
              • Importing Coordinate Systems
              • Introduction to Configuration Packs
              • Managing Picklists
              • Managing Report Profiles
              • Merging Project Picklists into a Configuration Pack
              • Pack Options
              • -Picklist Set Validation and Caveats of Use
                • Quicklists
              • Picklist Sets
              • +Setting Project Extents and Viewing Bounds Styling
              • The Data Dictionary
              • Unit Conversion
              • Using Picklists Sets within a Project
              • Validation Rules
            • Depth Linking
            • Editing Data in Professional
            • Exporting Data
            • +Lab Testing
            • Viewing Data in Professional
            • +Background Mapping
            • BGS Ordering Mapping Bundles
            • +Offices and Joint Venture
            • Replicate Location
        • +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. 

    Picklist Set Validation and Caveats of Use

    HBSI has in built validation to prevent picklists not existing within the set from being added via importing. There are also measures to restrict removal of picklist values where they exist in the project.

    When data is being imported into the project it is important to understand that the file being imported must only contain picklists from the set the project belongs to. For example, if the file contains Location Type RC but that picklist value does not exist in the Projects picklist set you will receive a warning message during the import stage.

    The message confirms that there is a matching picklist value already existing in the Configuration Pack but not in the set. Ideally this situation should be avoidable, as picklist set values would be agreed upon between client and contractors/consultants prior to commencement of works, therefore when AGS data is imported it will only contain valid Picklist Set values so data will import successfully. This facility acts as a warning to prevent unwanted picklist values that do not belong to the set from being added to the project.

    There is a caveat for this example; If the Project Pack Options has the option to allow undefined picklists to be created it is possible to import an AGS/CSV file with a picklist that does not immediately exist within the configuration pack.

    When imported the picklist will appear as a Project Picklist when viewed from the Manage Picklists dialog. (see below images)

    Please note that they will not be a part of the Picklist Set unless the picklist is merged into the configuration pack.

    Once merged the picklist value will now show in the set and is available for use in other projects created.

    Finally, validation messages will be presented under the following scenarios:

    • An attempt at creating a Picklist Set with the same name as an existing one
    • An attempt at deleting a Picklist Set when it is in use within a project
    • An attempt to remove Picklist values out of a set when they are in use within an existing project
    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Tue, May 31 2022 10:23 AM
    • 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