Importing AGS Format Data

The AGS format

Procedure to import the data

Example of a Ménard pressuremeter survey file

Below is a geotechnical investigation of two boreholes for which drilling parameters were recorded and in which it has been performed a series of Ménard pressuremeter tests.

Demo Geo-log4/AGS4: Google Drive spreadsheet

Demo Geo-log 4/AGS4: AGS file

Example of importing a spreadsheet containing drilling parameters

Below is an example of a LibreOffice spreadsheet document that contains tabular data from a drilling parameters record, with a macro to generate a file in AGS 4 format.

Prerequisites

Install LibreOffice, the free and open source office suite, from the official site of LibreOffice
Configuring Calc (LibreOffice Spreadsheet)
- In order to get a correct AGS file, the easiest way is to set the language to English (USA)
- Menu Tools > Options > Language Settings > Languages >
  - User interface: English (USA)
  - Locales setting: English (USA)
  - Decimal separator key: Same as locale setting (.)
  - Default Languages for Documents >
    - Western: Default - English (USA)
- LibreOffice > Security > Macro Security >
  - Security Level: Medium
Download the LibreOffice template > LibreOfficeExportationAGSTemplate.ods

Creating the spreadsheet

Copy the LibreOfficeExportationAGSTemplate.ods file and rename it with the name of the borehole you want to import (e.g. drilling1.ods)
Open created file (e.g. drilling1.ods)
- Message when opening file: The document contains document macros >
  - Enable Macros
Follow the procedure at the Help tab
Enter the general information into the Header tab
Enter the drilling parameters data into Drilling parameters tab

Creating AGS file

Create the AGS file by clicking Export data in AGS 4 format… at Header tab
The ags file is created in the current directory (e.g. drilling1.ags)

Importing AGS file in Geo-log 4

Import the generated file into Geo-log 4 (e.g. drilling1.ags) via Uploading records
The file must be accepted and appear in the list of recordings a few moments later (Refresh the page with the F5 key)
If the file does not appear after a few minutes, the file was refused because the AGS 4 format is not valid
- Check that the format is valid with an external utility AGS 4 Data Format Validator
- Contact Technical support
Possibly modify the properties not defined by the spreadsheet (e.g. Creation date and Ending date of the record). See Editing record properties

For the other text format files to import, copy the ods file created previously (e.g. drilling2.ods) and restart Creating AGS file