Locations File
A locations file is a CSV file used to import and export locations using Tools > Locations. Each location is represented by one line of text in the file.

An example of a locations CSV file is available on request from Bentek support. It is a good idea to use this as a starting point before you transform you data into Locator format.

A typical method of creating a locations file is to export it from a spreadsheet. The cells can be filled in the spreadsheet. A locations file can also be constructed using a text editor or by running a script.

The following table shows each field in the order they appear on each line of text in the file. For more information about each field see the Edit tab. Also see the Editing Locations topic.

The 'Unused Setting' is the value you should use if you do not want to enter a value for the field. If a cell in the table is blank then you can enter nothing between the two commas that delimit that field.

GRID_TYPE must be entered. Either SGRID or an (SLAT, SLNG) pair must be entered. If both are entered then SGRID is used to calculate SLAT and SLNG. If GRID_TYPE is set to 'UWI' it is good practice to enter LE and/or ES but this is optional.

Field Identifier Field Name Data Type Unused Setting
COMPANY Company CHAR(40) ""
FIELD Field CHAR(40) ""
GRID_TYPE Grid type (DLS, BCNTS, or UWI) CHAR(5) "DLS"
LE Location exception CHAR(3)  
ES Event sequence CHAR(3)  
SGRID Surface grid CHAR(40)  
SLAT Surface latitude (e.g. 51.258913) DOUBLE  
SLNG Surface longitude (e.g. 112.56312) DOUBLE  
DGRID Downhole grid CHAR(40) ""
DLAT Downhole latitude DOUBLE NaN
DLNG Downhole longitude DOUBLE NaN
LOC_TYPE Location type CHAR(40) ""
LOC_QUAL Location type qualifier CHAR(40) ""
LOC_NAME Location name CHAR(80) ""
COMMENT Comment VARCHAR(4000) ""
ENTRY Entry direction (North, East, West South) CHAR(5) ""
ACCESS Access level (0=private,1= public,2= semi-private) DECIMAL(1) 0
ELEV Elevation (m) DOUBLE NaN
PRESSURE Pressure (kPa) DOUBLE NaN
ALAT Actual latitude DOUBLE NaN
ALNG Actual longitude DOUBLE NaN
AELEV Actual elevation DOUBLE NaN
GLAT GPS latitude DOUBLE NaN
GLNG GPS longitude DOUBLE NaN
GELEV GPS elevation DOUBLE NaN
USER_ID User ID CHAR(80) ""
URL List of URLs VARCHAR(400) ""