Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki Unable to Import Parent and Child data due to different precision in shared key fields
    • 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
            • '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
            • Error generated when trying to Preview Site Plans.
            • Importing AGSv4 file and get a message saying TYPE table can't be found
            • Incorrect Display Format Error Message when importing Test Schedule
            • ISPT - ISPT_NVAL will be ignored... message when importing data
            • Mapping fails to display
            • OpenGround Cloud Professional and Data Entry not opening after upgrade from Keynetix.cloud
            • OpenGround returns a selected item does not have any geometry message
            • The Grids are not Displayed in Alphabetical Order under the Project Explorer in OpenGround
            • Trouble connecting to @mis solution in OpenGround
            • Unable to Create a Project in OpenGround
            • Unable to Import Parent and Child data due to different precision in shared key fields
            • Unable to log into a project that was previously accessible
            • Web Mapping layers not showing
            • Well/Installation not showing on log after entering Pipe Work data
          • +Professional User Guide
        • +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. 

    Unable to Import Parent and Child data due to different precision in shared key fields

    When importing data into OpenGround Professional, it is important to ensure that all of the data has the same precision in all incoming files. For example, note the below files which are for the Sample Information and Liquid and Plastic Limit tests.

    In these files, the sample depth top, which is a key field shared between the 2 tables, has different precision. When performing a database import, Professional will try to combine these files together and do a check on the data to ensure that there are no 'orphan' records. As these fields are showing different results, this will return an error during import checking.

    You may find that importing these files separately, with the samples being imported first, works successfully. This is because the sample information is already in the database and will therefore be treated as a value instead of a string, allowing for a successful match of data.

    This is a known issue and a future fix to ensure that incoming data will be checked consistently, as a value rather than a string has been logged for consideration in the future.

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Thu, Apr 8 2021 10:15 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