CSV Import

Comma Separated Values (CSV) is a common data exchange format that is widely supported by consumer, business, and scientific applications. Among its most common uses is moving tabular data between programs that natively operate on incompatible (often proprietary or undocumented) formats. Most tables in RSLog offer the CSV Import feature. Using this feature, instead of a line-by-line data entry you can import the entire dataset from a CSV file.

Each record (line) in the CSV file consists of one or more columns, separated by comma. Please note that RSLog assumes the first line of your CSV file contains the column-headers:

Importing From a CSV File

Most tables in RSLog allow you to import data from a CSV file (read more about working with tables). The CSV Import feature allows for 'filtering' and 'mapping' of the data during import. To start importing from a CSV file, click + New → Import CSV File menu from the toolbar at the top of the table.

This opens a new dialog (see screenshot below). Start by clicking the Browse button and uploading the CSV file. Please note that the first row in your CSV file must contain the column-headers; This is needed for mapping the CSV columns to RSLog data entry fields:

Once a CSV file is uploaded or when the filter criteria is updated, the preview of the records will be updated in the table. Please note in order to avoid slowness of the application, only the top 50 rows will be shown in the table.

Import Behavior

The CSV import feature works in two different modes:

• Append: this option will add the CSV data to the end of the table (existing records in the table will be preserved), and
• Replace: this will replace the current data in the table with the CSV data (i.e. all existing records in the table will be lost).

Filtering Data

If the CSV file contains some records that should be excluded from the import, use the filter criteria to narrow down the records. To do so:

1. Select the Only import these records checkbox,
2. Open the dropdown next to the checkbox and select a column to filter,
3. Select a comparison operator:
   • > used for comparing a number with your filter criteria; for example 'Depth > 2.7',
   • = used for comparing a number or string with your filter criteria; for example 'Depth = 3.5' or 'Borehole = BH22-01',
   • < used for comparing a number with your filter criteria; for example 'Depth < 12.8', and
   • Like used for applying a text filter; For example a search for boreholes Like "BH22-" would return both "BH22-1" and "BH22-2".
4. Click Go button. This applies the filter and updates the preview table.

Data Mapping (CSV Columns)

Your CSV file may contain several columns that you may or may be want to import to RSLog. Review the preview table and for those CSV columns that should be imported, open the dropdown and confirm the data they carry. For example, in the screenshot shown above, the following data mapping is shown:

• CSV column "HOLE_ID" is mapped to the RSLog column "Test Hole Name",
• CSV column "SAMP_TOP" is mapped to the RSLog column "Depth", and
• CSV column "SAMP_REF" is mapped to the RSLog column "Sample No".

The following sings in the mapping list indicate the status of each column:

• * : the column is mandatory and it should be mapped,
• : the column has been mapped,
• ? : the mandatory column has not been mapped,
• ? : the optional column has not been mapped,

Once filtering and data mapping is completed, click Import button to initiate the process. RSLog saves your column mapping and automatically loads the same mapping next time you upload a CSV file.

Bulk Import

If your CSV file includes data for multiple boreholes, the following steps illustrate the most efficient way to import your data to RSLog:

Step 1: Importing the List of Boreholes

Once a new project is created, you can add boreholes one by one. However, if you have a CSV file with the list of all boreholes, you can add all of them to your project with a single CSV import:

1. From the left menu panel, under Data Entry & Design select the Test Holes menu. This takes you to the Test Holes page.
2. From the toolbar at the top of the table, click + New → Import CSV File menu.
3. In the dialog that appears, upload your CSV file and map the CSV columns as necessary.
4. Click the Import button to start adding boreholes.

Step 2: Importing Borehole Details

Borehole details may include list of samples, SPT results, stratigraphy, drill runs, etc. In a project with large number of boreholes, importing separate CSV files for every borehole is not practical. For bulk importing of borehole details:

1. Edit one of the boreholes created in Step 1 above.
2. Go to the desired tab (e.g. Samples tab).
3. From the toolbar at the top of the table, click + New → Import CSV File menu.
4. In the dialog that appears, upload your CSV file and map the CSV columns as required.
5. Select import behavior: Append vs Replace.
6. Select the This CSV file contains data for multiple test holes checkbox.
7. Select the column that carries borehole name and map it to Test Hole Name.
8. Click Import button to start the importing process. Please do not navigate to another page and do not close the browser as this may take up to several minutes.

Once a bulk import is initiated, you will see a spinner at the top of the table:

Data Type Mismatch Issues

The data imported from a CSV file contains the following data types:

• Numeric Fields (e.g. Depth of a field test, or Sample Recovery of a sample): numbers are typically imported smoothly.
• String (Text) Fields (e.g. Sample Description): a text column should be mapped to a RSLog column with string data type, otherwise it will be lost during the import. For example, "Dense" cannot be imported into the Depth column.
• List Items (e.g. Sample Type): for list items such as sample type, log symbol, and drill method the text should exactly match with the list items from your Settings page in RSLog. The values in your CSV file should match the Term or Symbol column on the corresponding table in Rock Classification tab, Soil Classification tab and Field Investigation tab. For example, in the following screenshot "Auger (Hollow Stem)" uses "A-HS" Symbol:

Example Symbols for Drilling Methods list (Settings page > Field Investigation tab > Sampling & Boring tab)