Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenGround | gINT | Keynetix
  • Product Communities
  • More
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki "Out of memory" error importing from Excel
    • Sign in
    • -gINT | Keynetix Wiki
      • -gINT
        • Subscription Entitlement Service Benefits for gINT Users
        • Downloading and Installing gINT
        • +The gINT Files
        • -gINT Help, Tips and Tricks, and FAQs
          • How To Turn on Error Logging in gINT
          • Add Tracking Codes to your Report Templates
          • Adding or Replacing your Logo in Report Forms
          • Can't Open Report Entities for Editing
          • Copy report entities to another report template or another library
          • Create an Internal Block
          • Cursor Disappears in Report Design and Preview
          • +Data Entry - gINT
          • Display Depth-Related Data in a Text Entity
          • Easier Report Template Editing Using the Data Tool and a Data Template
          • +Export Data - gINT
          • How do we update the address on our reports?
          • -Import Data - gINT
            • "Out of memory" error importing from Excel
            • Import stops at 100% in 08.30.03.135
            • Using Correspondence Files for Importing and Exporting
          • +Installation - gINT
          • +Lab Testing Tables - gINT
          • +Library Database - gINT
          • +Licensing - Technical - gINT
          • +Printing - gINT
          • +Project Database - gINT
          • +Report-Fence - gINT Professional and Professional Plus
          • +Report-Graph - gINT Professional and Professional Plus
          • +Report-Graphic Text Doc - gINT Professional and Professional Plus
          • +Report-Log - gINT
          • +Report-Multiple General
          • +Symbol Design - gINT
          • Using Range Filters in the Output Tab
          • +Utilities - gINT
          • Water Level Information Missing Sometimes with gINT Std US Lab.GLB Library
          • Working With Blocks Part 1: Introduction
          • Working With Blocks Part 2: Drawing Library Blocks
          • Working With Blocks Part 3: Internal Blocks
          • Working With Blocks Part 4: Private Blocks
        • +gINT Professional Plus
        • Report-Fence
        • +Report-Log
        • +Downloads: Free Reports and Examples
        • +Geotechnical White Papers and Articles
        • +gINT for ArcGIS Toolbar
        • +How-To FAQs
        • +Things You Can Do In gINT
        • +Troubleshooting gINT
        • Videos on gINT and subsurface data topics
        • +Tutorials
        • gINT User Guides
        • Learning with gINT - On Demand
        • Working from home with gINT
      • +gINT Collector
      • +gINT Civil Tools
      • +Keynetix

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

    "Out of memory" error importing from Excel

       
      Applies To 
       
      Product(s): gINT Logs, gINT Professional, gINT Professional Plus
      Version(s):
      Environment:  N\A
      Area:  Export Data
      Subarea:  N\A
      Original Author: Kathleen Holcomb, Bentley Technical Support Group
       

     

    Error Message Importing from Excel

    7 Out of memory===gInt8a 

    Explanation

    Sometimes in Excel, you can have rows that appear empty but have nulls or spaces.  If there are too many of these rows importing to gINT will fail.

    How To Correct

    To see if this is the problem, open the Excel file.  Click Ctrl+End on your keyboard.  This will move the cursor to the last row with data.  If the cursor goes to an empty row, then it contains either nulls or spaces.   If it is a few thousand rows below your data this is the problem.

    To fix this:

    1. Copy the data to a new worksheet.  
    2. Delete the original worksheet.
    3. Rename the new worksheet.
    4. If needed, repeat in other worksheets.
    • Export Data
    • gINT
    • SELECTsupport
    • gINT Professional
    • Share
    • History
    • More
    • Cancel
    • Kathleen Holcomb Created by Kathleen Holcomb
    • When: Wed, Jun 18 2014 2:29 PM
    • Kathleen Holcomb Last revision by Kathleen Holcomb
    • When: Wed, Jun 18 2014 2:55 PM
    • Revisions: 4
    • 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

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies