Contents

About
License agreement
Contents
Introduction
Toolbar and Menus
Borehole Editor
Soil Profiles
Import / Export
Import from text files
Import from gINT files
Export to graphic format
Preferences
Soil Grouping
Soil Class Editor
Object Management
Viewer
Starting with VisLog
3D Viewer
Info-Layers and Viewer Settings
Examples
Topography Modelling
Ground Improvement Modelling
Object Modelling
File Formats
Points
Polyline
Polyface
Surface
Online
Updates
Contact us

 
Home
Borehole Log Visualization (VisLog) User Manual
Prev Page Next Page
 
 
  Importing Data from Text Files

If your boreholes data stored in a text file, you can import them directly to VisLog and save the data entry time. The first 8 columns should be arranged in the following order:

  • Name

  • Depth

  • X

  • Y

  • Z

  • Water Level

  • Azimuth

  • Plunge

You may add more columns for custom data such as diameter of Borehole or Pile to the subsequent columns. Separate data columns with comma on each row. Following is a sample of boreholes data saved in a text file. In this example, three custom data: "Gravel Vol", "Diameter" and "Date" are also stored in additional columns.

 

Figure 1 : borehole data stored in Text file.

 

Importing data from Microsoft Excel

You can also import data indirectly from Excel spreadsheets. The first 8 columns should be arrange in the following order:

  • Name

  • Depth

  • X

  • Y

  • Z

  • Water Level

  • Azimuth

  • Plunge

 

You have the option to add custom data such as Diameter of Borehole or Pile in the subsequence columns. Once the Excel file is arranged as described, please save it as comma-delimited Text format by using Save As menu in Excel. Then use VisLog "Import from text file" feature to import this data.

 

Figure 2 : borehole data stored in Microsoft Excel file.

 

© 2008-2010 www.NovoTechSoftware.com All Rights Reserved

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)