You are currently reviewing an older revision of this page.
Note: This exercise requires the use of projects, library and other files available from: download.aspx. Instructions for unzipping and setting up these files is on: using gint downloaded examples.aspx.
When the table-and-field structure of an imported spreadsheet, Access database, delimited text file, or gINT project does not match that of the project you’re importing into, you use a correspondence file to specify the mappings between fields in the source and fields in the target. Similarly, you can use a correspondence file on export to create a file with a different structure than the source project. In addition to directly mapping source fields to their destination tables, you can also perform processing on the data in the fields to make necessary conversions.
Correspondence files are text files with a specific syntax. Generally they are stored in the \gINT\datatmpl\ folder. Correspondence files for import are usually given a .GCI filename extension, and those for export a .GCX extension. Once you have created a correspondence file for data files of a particular format, you can use it for import of these files as often as needed.
Note: You can use a .GCX file for import or a .GCI for export if desired, as the file syntax is the same.
gINT provides the DATA DESIGN->Correspondence Files utility application for creating and editing correspondence files. You could create correspondence files with a text editor, but the application is faster to use and less error-prone.
Each Target Field is what is being mapped to (in the destination project). You need to provide a Source Expressionto specify what you are mapping from (for those fields that are mapped from the source spreadsheet).
Select a Default Source Table of POINT. This is the name of the table (actually the sheet) in the source spreadsheet that maps to the POINT table in simple project.gpj.
Target Field
Source Expression
PointID
<<POINT.PointID>>
HoleDepth
<<POINT.HoleDepth>>
Elevation
<<POINT.Elevation>>
North
<<POINT.North>>
East
<<POINT.East>>
Plunge
<<POINT.Plunge>>
Logged By
<<POINT.HOLE_LOG>>
<<GEOL.PointID
<<GEOL.Depth>>
Bottom
<<GEOL.GEOL_BASE>>
Graphic
<<Case(<<GEOL.GEOL_LEG>>,=104,CONCRETE,=102,FILL,=403,SM,=810,BASALT)>>
USCS
<<Omit>>
Description
<<GEOL.GEOL_DESC>>
Line Type
For additional reference information on correspondence files, see Help->Index->Correspondence Files (data design).