Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki 'Unrecognised Column' warning when importing data
    • Sign In
    • -gINT | Keynetix Wiki
      • +gINT
      • +gINT Collector
      • +gINT Civil Tools
      • -Keynetix
        • +Installing or Upgrading to CONNECT Edition
        • +Archive Webinars
        • -HoleBASE
          • +Getting Started
          • +HoleBASE - Setup and Installation
          • HoleBASE Professional Release Notes
          • -HoleBASE: FAQs
            • +Background Mapping
            • +Components and Configuration Packs
            • -Data Management
              • 'Project Currently Locked' message when attempting an import
              • 'Unrecognised Column' warning when importing data
              • AGS Import Warning : [Field Name] will be ignored because the destination is a calculated field
              • AGS mapping isn't showing but the data exports correctly
              • How can a GPS file be prepared for import?
              • How CPT Data Works in the HBSI
              • How many locations do I have in HoleBASE?
              • How to do a basic Export of AGS data from HoleBASE SI
              • How to enter Pipe Records in HoleBASE SI
              • How To Enter Special Characters
              • How to Export multiple projects to AGS from HoleBASE 3.1 to import to HBSI
              • How To set up installation instrument drawing types
              • How To Template
              • How To Use a Case Sensitive Search to Create Geology Code 2 data automatically
              • Importing AGSv4 file and get a message saying TYPE table can't be found
              • Incorrect Display Format Error Message when importing Test Schedule
              • Is there a list of non-standard AGS 4 fields that have been added to HoleBASE SI?
              • ISPT - ISPT_NVAL will be ignored... message when importing data into HoleBASE SI
              • What is a CSV file?
              • What is the Data Journey?
              • Where should coring data be entered or edited
              • Why Can HoleBASE SI Not Handle High Precision Data?
            • +Depth Linking
            • +Logs
            • +Trigger Sets and Report Grids
            • +User Accounts
            • +Working with Projects
          • +How Tos
          • +Issues
        • +HoleBASE Civil Extension
        • +HoleBASE Data Entry
        • +HoleBASE Excel Extension
        • +HoleBASE Template Studio
        • +KeyAGS
        • +KeyLAB
        • +Keynetix Component Downloads
        • +Working from Home with Keynetix Products
        • Hardware Specifications and Recommendations
        • Supported Platforms

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

    'Unrecognised Column' warning when importing data

      Product(s): Keynetix
      Version(s): 1.0
      Area: Assist

    'Unrecognised Column' warning when importing data

    Issue Summary

    The incoming data file contains a column header which HoleBASE SI does not recognise. That is, some parameter has been included in the file which HoleBASE cannot determine where the appopriate place to store the data should be.

    Resolution

    Create a new column in HoleBASE SI's database model and map this to the name of the header in the file.

    1. Determine whether the change should be applied at Project or Configuration Pack level.

    2. Click the 'Manage Model' button from the appropriate ribbon.

    3. Highlight the appropriate grid for the new column of data and click 'Edit'.

    4. Click 'Add New Field' header and define the new column.

    5. Save the changes and then highlight the column.

    6. Click 'Edit Mapping' and define the header name for the appropriate form.

    7. Save the changes and re-import the file. The message on import should no longer appear and the data relating to the column identified brought into the system.

    The following recording provides a worked example of how the process can be applied:

    Other Workarounds

    A warning such as this need not prevent the import of the reminder of the data in the file. If the unidentified column is not considered necessary the import process can simply continue. In this case, the unrecognised column will be excluded from the import.

    • Migrated
    • Share
    • History
    • More
    • Cancel
    • wiki.author Created by Bentley Colleague wiki.author
    • When: Tue, Jun 9 2020 8:11 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