<< Click to Display Table of Contents >> Navigation:  Professional > Interfaces > Graphics Interfaces > EQuIS for gINT > Import Data from gINT

•Load gINT Project in EDP

•Review Data and Resolve Errors

•Create Package and Commit to Database

 

The EQuIS Data Processor (EDP) is used to import data from a gINT project database. The gINT format file (gINT.zip) will import data from a .gpj project database. The gINT.zip format is available on the EarthSoft Community Center Downloads dashboard for those with permissions. Data issues will need to be resolved in the .gpj prior to importing.

 

The gINT format file contains the following formats which correspond to a .gpj project database: PROJECT, POINT, CPT, LITHOLOGY, REMARKS, SAMPLE, TESTS, WELL

 

When the .gpj project database is loaded for use with the gINT format (see instructions in the next section), each of the formats' sections are populated with data from the corresponding table. However, only data from the tables and fields that exist in both the gINT database and the format file will be loaded into EDP. Many of the tables containing laboratory data, such as DIRECT SHEAR, COMPACTION, HYDROMETER, and others will be ignored as they are not defined in the gINT.zip format file. To review the fields defined in the gINT format file, click the Description button, per Description and Blank EDD Files. To import additional data from a gINT database, unencrypted versions of the gINT.xse and gINT.vbe files must be customized to include the definition, mapping, and any custom handling information for those tables and fields.

 

Load gINT Project in EDP

 

As gINT database are project-based, the EQuIS facility should be the same as the gINT project Name and Number in the PROJECT table. (If the DT_FACILITY table is populated from the gINT database, the Insert and Update commit will change the facility code and name to the project number and name defined in the gINT PROJECT table).

1.Click the EDP button to open EDP in the Import group on the Home tab of EQuIS Professional.

2.Click the Format button in the Open group, in EDP, to open a format file.

3.Browse to the gINT format file, gINT.zip.

4.Click the EDD button to open the gINT project database.

5.Browse to the .gpj project database.

 

Review Data and Resolve Errors

 

Once the gINT database has been opened in EDP, each of the sections will be populated with data from the corresponding table in the gINT database. Tables highlighted in red have errors that must be resolved before data may be imported into EQuIS. Tables highlighted in green have no errors.

 

1.Select the LITHOLOGY table by clicking on LITHOLOGY.

 

 

"Reference value not found" errors can appear in the Graphic column. This can occur because those material names are not found in the RT_MATERIAL table. These errors may be resolved by selecting a valid value from the drop-down list in the cell or by adding the reference value to the table.

 

Reference values can be added individually, by column or by adding all reference values in the dataset that do not exist in the database. In this case, add all reference values:

 

2.Right-click on any error cell in the Graphic column.

3.Select "Add All Values, All Formats" from the drop-down menu.

 

All errors should now be resolved in all tables. Each of the gINT tables should be displayed in green, which is the default color for a table without any data errors.

 

Create Package and Commit to Database

 

Once any errors or problems with the data have been resolved, the data package can be created and committed to the database.

1.Click the Create button on the EDP Professional tab. Each row in each data table is processed, and the progress is displayed.

2.Click Finish. All rows of data should now be removed from the EDD (format file) tab and should be visible on the Package tab.

3.Click the Commit button and select Insert and Update.

4.Click Finish.