Importing data from a text file

Top  Previous  Next

You may import the in-situ data, needed to run an analysis, from a text file. The text file should be a delimited ASCII file where data are entered in columns as described below :

 

In-situ data

Column 1

Column 2

Column 3

Column 4

Column 5

SPT

Depth

Nspt

Fines

Gamma

Infl. thickness

CPT

Depth

qc

fs

Gamma

Fines

Vs

Depth

Vs

Fines

Gamma

Infl. thickness

After the appropriate input data type selection is made, clicking on the Import test data button a window dialog  appears.

Using the Directory selection list box you can navigate through your folders. Every time you enter inside a folder the program searches for files with the extension ".txt", ".dat", ".cor" or ".gef" and (if any found) displays their name in the File selection listbox. When you click on a file, a preview of its content is loaded on the Data preview area. This helps you verify if the data file can be recognized by the software and contains all available data.

 

Import data dialog

Import data dialog

 

Note

".cor" files are provided by Gregg Drilling and they contain the corrected tip resistance, sleeve friction and u2 measurements from a CPTU test.

".gef" files are those created using the GEF structure.

Upon selection of the file, you must provide the program with some information regarding the structure of your data. These parameters are located in the Data input parameters box and consist of:

Decimal delimiter: Default decimal delimiter for LiqIT is full stop sign ".". In case data to be imported have as decimal delimiter the comma sign "," it has to be indicated accordingly.
Data delimiter: In text files, data can be separated by various visible or non-visible character. Various characters are usually used; you must specify which one is used to separate your data into columns by clicking on the drop-down list and selecting one of the following characters (which are the most commonly used ones):

       1. Tab delimiter if your file uses the tab character as the data delimiter.

       2. Semicolon if your file uses the ";" character as the data delimiter.

       3. Comma if your file uses the "," character as the data delimiter.

       4. Space if your file uses then " " character as the data delimiter.

Data begins from line: Enter the line number from where the data begin. For example, in the above dialog, data starts from line 2.

Note

Double quotes in the above text are used to distinguish the delimiter from the text

Your final step is to press the Import data button. If you choose to click the Cancel button then the above dialog closes without importing any data.

Importing data from a .gef file

When you select a .gef file from the File Selection list the following dialog will appear:

Data selection for a .gef file

Data selection for a .gef file

For each one of the input data needed (Depth, Cone resistance, Friction resistance and Unit weight) you must make a selection from the associated drop down list. This list contains the column headers of the data stored inside the .gef file. After the appropriate selections are made you must click on the OK button in order to preview the data in the Data preview section.

Copyright © 2006, GeoLogismiki