Exporting from Isatis.neo

• Exporting from Isatis.neo
• • CSV/Excel Export
  • GTXserver Export
  • Datamine Export
  • CAD Export (DXF, DWG, STL, OBJ, OFF)
  • OGR Export

This chapter describes which types of data you can export from Isatis.neo and to which file formats and softwares.

• Points: Points can be exported:

  • in a CSV/Excel file,
  • using the GTXserver connection to directly export from an Isatis.neo project to an Isatis study,
  • in a Datamine file,
  • through the Petrel plugin.

• Boreholes: Boreholes can be exported:

  • in a CSV/Excel file.
  • using the GTXserver connection to directly export from an Isatis.neo project to an Isatis study.

• Grid:

  • in a CSV/Excel file,
  • using the GTXserver connection,
  • in a Datamine file,
  • in an Irap file,
  • in a CPS3 file,
  • in a raster file: either a georeferenced image (a .tif file) or a data file (GeoTIFF, ArcGIS, NetCDF or ZMap file),
  • in a Vulcan file (this export requires to have the Vulcan license installed on the same machine as Isatis.neo),
  • in an Eclipse file (*.grdecl),
  • in a SEG-Y file,
  • through the Petrel plugin (surfaces and grids).

• Mesh:

  • in a CSV/Excel file,
  • using the GTXserver connection,
  • in a CAD file,
  • through the Petrel plugin (for faults).

• Polygons:

  • in a CSV/Excel file,
  • in a vector file (dxf from AutoCAD, shapefile from ESRI or kml),
  • in a Datamine file.
• Polylines: Polylines can only be exported in a CSV/Excel file.

CSV/Excel Export

All types of Isatis.neo data (points, boreholes, grids, meshes, polygones and polylines) can be exported in CSV files or Excel files (.xls, .xlsx).

Input: Two modes are available: Input xxx and Input Data Table. If data you export contain a unique data table (that is the case for points and grids), there will be no difference between the two modes. But if your data are associated to a multi-table file, the choice of the mode will impact the exported files. The first mode will export all the data tables of your data file. For example, if you export a boreholes file, you will create three files: tops, surveys and assays, one file for each data table. If you select the Input Data Table mode, you will export one data table (you should choose which one) of the data file.

If you apply a Selection to the data you want to export, only the samples which are not masked by the selection will be exported, except for the grid file where all cells will be exported but cells outside the selection will be set to undefined values for all variables.

• Grid: This field is only active when the file to export is of grid type.

  • Grid Cell Position: Choose the implicit variables automatically added to the list of variables to be exported. If a selection is active, only selected samples will be exported.

    • X, Y, Z: Coordinates are automatically added to the list of variables to be exported.
    • IB: Cell index is automatically added to the list of variables to be exported.
    • IX, IY, IZ: Cell indices are automatically added to the list of variables to be exported.
    • No Position: Only selected variables are exported. Be careful if a selection is applied on input, you will have no reference to identify your grid cells.

  • Sorting: It is used to define in which order the grid nodes will be written in the output file using the appropriate sorting mode (from the fastest to the slowest). It is not available if you choose to add the X, Y, Z coordinates.

    For example: +Z +Y +X means that the second node will be: ix=1, iy=1,iz=2. A + sign means nodes are exported from the nearest of the grid origin to the furthest. A - sign means nodes are exported from the furthest of the origin to the nearest. For instance, -Z +Y +X will export from top to bottom. A sorting different from +Z +Y +X will increase the export time.

• By default the toggle Export All Variables is activated. All the variables contained in the selected file will be exported. If you want to export only a part of the variables, untick the toggle to access the Variables list and select the variables you want to export.

  Note: The implicit variables (sample number, coordinates, ...) do not appear in the Variables list but they are automatically exported, except for the grids where you choose a Grid Cell Position defining the added variables.

  Note: If you choose to export boreholes, all the associated tables (tops, samples and contacts) will appear. They will be exported at the same time in three separated files (respectively named XXX_Tops.csv, XXX_Samples.csv and XXX_Contacts.csv) when exporting to CSV, or as several sheets when exporting to an Excel file.

• Output:

  • Select the Output File in which you want to save the exported data. Click the folder to pop up a window file selector. Data can be exported as a CSV file or as an Excel file.
  • Select a Separator (only available if the output file is a CSV file). To specify the CSV symbol that will be used to separate the fields. By default, a comma is set.
  • Select a Decimal Separator (only available if the output file is a CSV file). To specify the CSV symbol that will be used to represent the decimal point. The default value is a dot.
  • Select a Coordinate System. You cannot select any coordinate system if the coordinate system of the project is a local coordinate system. By default the coordinate system selected is the one of the project but if it is different, data will be transformed in the output coordinate system.
  • If the coordinate system you are looking for is not in the list, click More to pop up the Coordinate System Selector.
  • Tick the Create OGR Header (.vrt) option to save a description header that will make the file directly readable by QGIS. Whatever the exported file, it will be read by QGIS as a points file. This option will not be available if the exported file corresponds to Boreholes.
  • Tick the Create Isatis Header option to save a description header that will make the file directly readable by the Isatis import ascii module. It can also be kept only for information. The header will be saved in a separated file (with the same name as the defined output file but with a .hd extension). This option will be available only for one-table files (i.e. points and grids).

GTXserver Export

This application is meant to directly export data from an Isatis.neo project into an Isatis study using the GTXserver. This export can deal with points, grids, boreholes (3D lines) and meshes (wireframes in Isatis).

Exporting boreholes just requires the definition of the Isatis.neo assays data table, the tops table will be automatically associated.

If you export a mesh file, only the geometry and the object names will be exported, not the file attributes (i.e. the variables contained in the different data tables).

The GTX Server Settings button allows you to:

• Run GTX Server: in that case Isatis.neo will automatically launch the GTX Server associated with Isatis. Click on Specify GTX Server executable if you want to give the path for the GTX Server.
• Use existing GTXserver instance: in that case you have launched manually the GTX Server and you need to specify the Host Name and the Port where it is running so that Isatis.neo can identify it. Enter a Data Path, if the study list you want to use is not the one by default in Isatis.

All Isatis.neo variables will keep the same role, except the categorical variables which will be transformed into alphanumerical variables.

Datamine Export

This export can deal with points, grids and polygons.

The export asks for a conversion table to associate the names of Isatis.neo variables and the names of these variables into Datamine because they are limited to 8 characters if variables are exported in a single precision (32-bit floating point) file and to 24 characters if exported in a double precision (64-bit floating point) file.

CAD Export (DXF, DWG, STL, OBJ, OFF)

This export only deals with meshes. Only geometry and object names are exported, not the file attributes (i.e. the variables contained in the different data tables).

OGR Export

This export only deals with polygons. Only geometry and object names are exported, not the file attributes (i.e. the variables contained in the different data tables).