Conversion options from CSV.

interface FromCsvOptions {
    dateFormat?: string;
    delimiter?: string;
    escapeFormulaChars?: boolean;
    generatePrimaryKey?: boolean;
    geometryFields?: string[];
    geometryFormat?: GeometryFormat;
    includeHeaderRow?: boolean;
    inSpatialReference?: SpatialReference;
    locale?: string;
    numberFormat?: string;
    outFields?: string[];
    outSpatialReference?: SpatialReference;
    primaryKeyField?: string;
    rowDelimiter?: string;
    timeFormat?: string;
    useFormattedValues?: boolean;
}

Hierarchy

  • CsvBaseOptions
    • FromCsvOptions

Properties

dateFormat?: string

The format for dates. The default is DateFormat.ROUND_TRIP. This can be a defined DateFormat string, the "timestamp" pseudo-format, or a custom format string.

delimiter?: string

The delimiter between fields. If not specified, an attempt will be made to auto-detect the delimiter.

escapeFormulaChars?: boolean

Whether to a prefix values that start with typical formula triggering chars (=,-,+,@).

generatePrimaryKey?: boolean

Indicates if a primary key should be generated if not found, defaults to true.

geometryFields?: string[]

A set of custom field names to use with the selected geometry format.

geometryFormat?: GeometryFormat

The format for serializing the geometry. The default is WKT.

includeHeaderRow?: boolean

Whether to include a header row with field names. Default is true.

inSpatialReference?: SpatialReference

When importing from CSV, this is the spatial reference of the geometry in the CSV.

locale?: string

The locale to use for formatting values. Accepts a valid locale code (example: "inv", "fr" or "de-AT"). Default is "inv" or invariant culture.

numberFormat?: string

The format for numbers. The default is NumberFormat.ROUND_TRIP.

outFields?: string[]

A list of fields to include. Defaults to the FeatureSources PopupTemplate outfields if available, otherwise "*" meaning all fields.

outSpatialReference?: SpatialReference

When exporting to CSV, this is the spatial reference of the geometry in the CSV. The default is WGS84. When importing from CSV, this is the spatial reference of the geometry in the result.

primaryKeyField?: string

Optionally the primary key field, used for converting from CSV to features.

rowDelimiter?: string

The delimiter between rows. The default is the platform-specific line ending (e.g. "\r\n" on Windows, "\n" on Unix or MacOS).

timeFormat?: string

The format for time-only fields. The default is TimeFormat.ROUND_TRIP. This can be a defined TimeFormat string, or a custom format string.

useFormattedValues?: boolean

If true, the configured formatters will be run on the raw values in the supplied data and these values will be output with type information if possible. If false, the formatted or presentable values already present in the supplied data will be taken 'as-is'. Field types configured on the input will be ignored and all values will be output as strings.