Connection to a CSV file. A CSV File source is a simple text file containing tabular data. CSV files usually have the extension “csv” but it may also be “txt”. A CSV file is actually a database table in a text format.

The first line in the file must be a header listing the names of the fields (columns) in the file. The columns must be semicolon or comma separated. Decimal separator may be dot or comma. Note: If the columns are comma separated the decimal separator must be dot.

Example CSV File:

ID;X;Y;Depth;Param1;Param2;Param3
Well1;713505.5;6193058.0;0.75095;6.44935;109.2679;115.91155
Well1;713505.5;6193058.0;55.44045;15.56755;117.55655;118.43845
Well1;713505.5;6193058.0;165.77625;8.38295;93.12655;94.451
.
.

GeoScene3D uses Microsoft Text Driver to access CSV files. The driver usually manages to determine what list separator and decimal separator is used in the file. If you are having trouble reading the file then check the CSV File Source editor that is available through the Source Manager and check that the settings are correct for the file.

The text driver writes a file called schema.ini in the same directory as the CSV file. CSV File Source editor edits the settings in this file. Advanced users may edit the schema.ini further.

Example if a schema.ini file:

[KGL89.csv]
Format=Delimited(;)
[JupiterSymbols.csv]
Format=Delimited(;)
DecimalSymbol=.
[Fence.csv]
Format=Delimited(;)
DecimalSymbol=.