# Convert gINT database

## Introduction

This tutorial will guide you through the process of converting gINT database files into GeoDinML. The gINT converter will convert the groups **PROJECT**, **LITHOLOGY**, **POINT**, and **SAMPLING** into GeoDinML format. If any groups or parameters are missing, adjustments must be made to the gINT database file before conversion.

## Conversion Process

* Open the gINT Converter
* Choose your gINT database. It can be either a gINT database (.gpj) or a Microsoft Access database (.mdb or .accdb)

<figure><img src="https://3138966068-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOh9veY55xgALNVUW8siX%2Fuploads%2F4UvvbCQcxj2OTVWDPR4r%2Fimage.png?alt=media&#x26;token=71517346-1df0-4866-8cfe-2f7f44e6f132" alt=""><figcaption></figcaption></figure>

* The conversion process will begin automatically. The gINT converter will convert the groups **PROJECT**, **LITHOLOGY**, **POINT**, and **SAMPLING** into GeoDinML format.

<figure><img src="https://3138966068-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOh9veY55xgALNVUW8siX%2Fuploads%2FsNNDNs6x1kcsBbj1oQiH%2F2025-03-19_14-33-25.png?alt=media&#x26;token=a392c0a8-3376-4a94-bb94-8298bbf095ff" alt=""><figcaption></figcaption></figure>

* Once the conversion is complete, save the GeoDinML file to the desired location

<figure><img src="https://3138966068-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOh9veY55xgALNVUW8siX%2Fuploads%2FIopmsdtPkonjy7rKgucl%2F2025-03-19_14-34-28.png?alt=media&#x26;token=e1416aba-10c9-4bbd-a5b3-220035df8b8a" alt=""><figcaption></figcaption></figure>

## Troubleshooting

If the uploaded gINT database does not match the mapping schema, the gINT converter will provide information indicating which mandatory groups or parameters are missing.&#x20;

<figure><img src="https://3138966068-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOh9veY55xgALNVUW8siX%2Fuploads%2Flt0eC6tvOwGxW4X0Di3m%2F2025-03-19_14-56-32.png?alt=media&#x26;token=97290963-7604-46eb-8d24-129be7cde1c0" alt=""><figcaption></figcaption></figure>

You can then adjust the corresponding tables and parameters within the gINT database file either directly in gINT or by renaming the file extension to `.mdb` or `.accdb` and making the necessary changes in Microsoft Access.

<figure><img src="https://3138966068-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOh9veY55xgALNVUW8siX%2Fuploads%2FZDcpkDVsUxR5FRHqQ2eL%2Fimage.png?alt=media&#x26;token=eb668422-1060-4aca-889f-522b4e6dc062" alt=""><figcaption></figcaption></figure>

## Mandatory Groups and Parameters

The following gINT groups and parameters are mandatory for the conversion:

| **Group**     | **Parameters**           |
| ------------- | ------------------------ |
| **PROJECT**   | Name                     |
|               | Manager                  |
|               | City                     |
|               | Country                  |
|               | Location                 |
|               | Number                   |
|               | Input\_Units             |
| **POINT**     | PointID                  |
|               | ShortName                |
|               | East                     |
|               | North                    |
|               | CoordSys                 |
|               | HoleDepth                |
|               | Hole\_Diameter           |
|               | Elevation                |
|               | Drilling\_Company        |
|               | Driller                  |
|               | Start\_Date              |
|               | End\_Date                |
|               | Drilling\_Method         |
|               | Drilling\_RigType        |
|               | Logger                   |
|               | Location                 |
|               | Water\_Initial           |
|               | Water\_Liqu              |
|               | Water\_Static            |
|               | CPT\_AreaRatio           |
|               | CPT\_File                |
|               | CPT\_Dir                 |
|               | Expl\_Dir                |
|               | Station\_Number          |
| **LITHOLOGY** | PointID                  |
|               | Material\_Description    |
|               | Material\_Graphic        |
|               | Depth                    |
|               | Layer\_Bottom            |
|               | Comment                  |
|               | Line\_Type               |
|               | Additional\_Descriptions |
| **SAMPLING**  | PointID                  |
|               | Sample\_Number           |
|               | Depth                    |
|               | Bottom\_Depth            |
|               | Recovered\_Length        |
|               | Driven\_Length           |
|               | Sample\_Type             |
|               | Sample\_Diameter         |
