Export as CSV
Added in 3.1.1
Professional Edition
If you need to export all your scan values and scan information, click Main Menu. The resulting CSV file can be used to create spreadsheets for Microsoft Excel or other external software programs. In figure 1 the Export as CSV Dialog is shown.
viaFirst, select the designated folder and filename for your CSV file. If you check the option Open CSV after Export, an external software program, that has been associated with the CSV file extension, will open up after your CSV file has been exported.
For that, you have to select what kind of information you would like to include in your generated CSV file. The file will be created using the UTF-8 character encoding.
Options
Following export options are available:
-
Characteristics
Check this option to embed your individual project information (title, description, GPS coordinates, field length and width, operating mode). These kind of information can be added to your measurement as described in section Scan Information / Characteristics.
-
Meta Data
Check this option to include all your individual Meta Data in the exported CSV file.
-
Soil Type
Check this option to embed additional information regarding the selected soil type (dielectric constant, relative permeability, mineralization, humidity, homogeneity). If you are using the Professional Edition of OKM Visualizer 3D Studio, you may add your own soil types as described in section Soil Types.
There are some more export options to define the output format of the resulting CSV file itself:
-
Column Separator
The column separator, which is a single character, is used to separate all of the selected columns (see below).
-
String Delimiter
If one of the selected column contains the character, that has been chosen as column separator, any external program interprets this as the end of the column rather than as part of the text. In order to prevent this, it must have a string delimiter. This string delimiter is placed around each column. The default string delimiter is double quotes (").
-
Decimal Separator
Select either comma (,) or point (.) as your decimal separator of choice.
-
Decimal Places
Select the number of decimal places in the range from 0 to 8.
Columns
Additionally, you can decide which columns you want to embed into the resulting CSV file. The number and type of available columns may vary from measurement to measurement. Figure 1, as an example, represents all columns of a Ground Scan.
-
Apply Active Modifiers
Check this option if all active Modifiers (Interpolation, Subdivision, etc.) should be applied before exporting the scan values. If you intend to export raw scan values, as received from the detector itself, keep this option unchecked.
After setting up all your export options and columns, click on Export to start generating your CSV export file.