CSV files

The raw data CSV export enables you to export portions of one or more raw data files as human-readable comma-separated value files. These files can be processed in Microsoft Excel or other third party software. Since records in Hydromagic raw data files have different time stamps, a separate file will be written for each record type. The following Hydromagic raw data records can be exported as CSV (ASCII) file(s):

• POS - Position records - contains both WGS84 and projected coordinates;
• GPS - GNSS status records - contains satellite count, fix quality, etc...;
• DOP - GNSS DOP records - contains horizontal, overall and vertical DOP;
• ERR - GNSS error statistics - contains error statistics calculated by GNSS receiver;
• DPT - Depth records - high and low frequency depth measurements;
• MOT - Motion records - heave, pitch and roll measurements;
• BTM - Bottom records - advanced geotechnical parameters;
• HDG - Heading records - true or magnetic heading measurements;
• SPD - Speed records - vessel speed;
• TID - Tide observation records - tide measurements manual or from probe;
• SVS - Sound velocity records - measurements from a SV profiles;
• ANN - Annotation records - echo sounder annotations or events;
• SEN - Sensor records - other sensor data, like water temperature;

Starting the CSV export tool

The CSV export tool can only be started from the "Raw Data File Manager" in Hydromagic Survey. This option is not available in Hydromagic Dredging, since no raw data files are used in this application. First open the "Raw Data File Manager" by right-clicking the "Raw Data" folder in the "Project Explorer". From the pop-up menu which appears, select the "Manage Files..." option.

Right click the "Raw Data" folder and select "Manage Files...".

In the "Raw Data File Manager", multiple export options are offered, including HYPACK, SEG-Y, CSV and XTF format. Using the exporting tools, you can export one or more files. Select the raw data files you want to export and click the "Export CSV" button to start the CSV export tool.

The raw data files manager shows a list of raw data files in the project.

Select output folder

Click the "Browse..." button to select in which folder the CSV files will be written. By default, the 'Exports' folder in your project map will be used unless you selected another folder previously. When one or more files already exist you will be notified. To force the replacement of existing files, check the 'Overwrite existing files without warning' checkbox.

Select file(s) to export

If you didn't select any files from the 'Raw Data File Manager' tool before opening the CSV export tool, you can select the files to export by clicking the 'Select...' button. From the window that opens, you can select the files to be exported by setting the checkboxes.

Select which raw data files will be included in the export.

Select record type(s) to export

Since data records in Hydromagic raw data files are different and are not synchronized by time, a separate CSV file will be generated for each record type. To define which data you want to export, click the second "Select..." button (the button in the "Select Records" section).

Select which raw data record types will be included in the export.

Select fields to export

The output format is fully customizable; the following fields can be included in the generated CSV files (depending on the selected record types):

• Position: Date, Time, Easting, Northing, Longitude, Latitude, Mean Sea Level and Elevation;
• Depth: Date, Time, Raw Depth (Hi) and Raw Depth (Lo);
• Motion: Date, Time, Heave, Pitch and Roll;
• Tide: Date, Time, Tide;
• Heading: Date, Time, Heading (T) and Heading (M);
• Speed: Date, Time and Speed;
• Sound Velocity: Date, Time and Sound Velocity;
• Bottom Parameters: Date, Time, Bottom Loss, Reflectivity, Porosity and Density;
• Annotations: Date, Time and Comment;
• Position Error: Date, Time, ErrorLongitude, ErrorLatitude and ErrorElevation;
• GNSS Statistics: Date, Time, SatCount, Quality, CorrectionAge and CorrectionId;
• Dilution of Precision: Date, Time, VDOP, PDOP and HDOP;
• Temperature: Date, Time, WaterTemp and AirTemp.

To customize the exported fields, and the field order, click the "Select..." button in the "Format" section. The following dialog will be shown, allowing you to select the exported fields and their order. Click 'OK' to confirm and return to the 'Export Raw Data Files to CSV' dialog box.

You can customize the exported fields and field order.

Exporting the data

After configuring which information you want to export and which files to generate, click the 'OK' button to start the export process. If the export process did not complete successfully, you can refer to the activity view for more details on the error shown.

After selecting which data to export, click the "OK" button to start generating files.

Exported Files

When the export process finishes, the folder containing the exported envelope files will be opened in 'Windows Explorer'. Note that the files start with the original raw data file name and are suffixed with the data type.

The exported CSV files will be written in the Export folder by default.

Video Tutorial

The following YouTube video tutorial shows how to export Hydromagic raw data files as ASCII CSV files. Click below to play the video. When you like the video, please click the like button and subscribe so you will receive an update when new video tutorials on Hydromagic are uploaded.

Hydromagic can export raw data as CSV (Comma Separated Values) files.