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?
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 WadeDatgelBentley Channel Partner and Developer PartnerE: email@example.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
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:
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.