# LoggerImportMapping

> Column mapping and conventions used to turn imported rows into readings.

> **LoggerImportMapping** = `object`

Column mapping and conventions used to turn imported rows into readings.

## Properties

### dateColumn

> **dateColumn**: `number`

Zero-based column of the date (or date and time).

***

### dateFormat

> **dateFormat**: [`LoggerDateFormat`](/utils/api/type-aliases/LoggerDateFormat)

***

### headerRows

> **headerRows**: `number`

Number of leading rows to skip.

***

### offset?

> `optional` **offset?**: `string`

Offset (`-03:00`) applied to timestamps without an offset when `timeZone` is not set.

***

### pressureColumn?

> `optional` **pressureColumn?**: `number`

Zero-based column of the pressure, when present.

***

### sensorDepth?

> `optional` **sensorDepth?**: `number`

Sensor depth (m). Required for `water_column`.

***

### timeColumn?

> `optional` **timeColumn?**: `number`

Zero-based column of the time, when it is separate from the date.

***

### timeZone?

> `optional` **timeZone?**: `string`

IANA zone applied to timestamps without an offset (the well `timezone`).

***

### valueColumn

> **valueColumn**: `number`

Zero-based column of the measured value.

***

### valueKind

> **valueKind**: `"depth"` \| `"water_column"`

`depth`: the value is depth to water; `water_column`: height of water above the sensor.