Excel Data Import into gINT

Hello,

We are using gINT V8i and are new to the software. 

We have tried to import using: File->Import->Excel (2003.xls) format.  But get an error "No records in any selected table.  Nothing to merge." 

Thanks in advance for any help with how we can perform a simple data import from excel without error?

Parents
  • You can't import just any excel file into gINT.  Simplistically, the first row of the sheet needs to have the field name, and the data starts on the second row.  The sheet name needs to be the table name in gINT.  You need to define key field data in Excel if it is to import.

    Phil Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

    Get the most out of gINT with Datgel Tools.

Reply
  • You can't import just any excel file into gINT.  Simplistically, the first row of the sheet needs to have the field name, and the data starts on the second row.  The sheet name needs to be the table name in gINT.  You need to define key field data in Excel if it is to import.

    Phil Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

    Get the most out of gINT with Datgel Tools.

Children
  • Often the easy way to import is to export your empty database to excel, then paste into those sheets, then import the updated spreadsheet back to gint.

  • That is true if you are a lot more familiar with using Excel than with using gINT - but remember, you can also copy-and-paste columns of information from Excel directly into gINT.

    As Phil pointed out in part, though, to import directly from Excel into gINT (without a correspondence file or other import management tool), three things need to be true:

    1. The Excel file needs to be in a gINT "layout"; that is, the individual sheet names will be the names of tables you'll import into, the first row of each sheet contains the names of fields for that table, and subsequent rows contain data for the fields named in row 1 for each column, with no blank rows or columns.
    2. The names of the sheets and their fieldnames in row 1 of each sheet in the Excel file match the names of tables and their fields in the gINT structure you're importing data into.
    3. This one gets left out most often, but it is critical. The required tables PROJECT and POINT are present as sheets in the Excel file, and the required data for each table is present in the data rows 2 and onward for each sheet that has data to be imported. Further, key identifier "child" data in worksheets that will be imported needs to match the key data from the "parent" worksheets. For example, the PointID given for a POINT record and the PointID entered for each of the dependent SAMPLE records for that point need to be identical.

    You can easily generate from gINT, either in .xls or .xlsx format, a blank Excel file that meets criteria 1 and 2, but Excel does not provide a simple way to verify that number 3 has been met.

    Entering data in gINT - or using copy-and-paste to move data from Excel to gINT - uses the built-in features of gINT to verify that data in dependent tables is correctly identified with the parent key data.