Skip to content

Import into LOCA child tables

For each table, there is an auto-incrementing unique identifier called nomtable_*id0. When you import data into the LOCA table, the loca_id0* are created automatically.

To import data into a row 2 table, you first need to specify the id0 corresponding to the source boreholes in a new column in your file.

Coming soon

A wizard will soon be able to automatically search for matches based on the names of the boreholes and the text identifiers of the tests.

While you're waiting for the wizard, it's easy to prepare your file in Excel.

Let's take the GEOL table as an example.
In your lithostratigraphy import file, you have entered the name of the borehole in a column. To add the id0 of the corresponding Orbow :

  • export the LOCA table by clicking on the "export" button
  • add this export as a new tab in your workbook
  • in the tab containing the data you want to import into GEOL, add a loca_id0 column
  • using Excel's SEARCHV function, search the tab containing the LOCA data for the id0 corresponding to the name of each borehole
  • Now that the match is made, you are ready to import your lithostratigraphy data into Orbow.

For your information

Using a language such as python or R, you can also perform a join of the two tables in a single command line.

The process is the same for tables of rank 3 and above: you will need to match the id0 of the parent table.