Rocscience International Conference 2023 | April 24-26, 2023 Learn More about RIC2023
 

Search Results

CSV Import

Most tables in RSLog have CSV Import feature; using this feature instead of a line-by-line data entry you can import the entire data from a Comma Separate Values file (.csv). 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.

A CSV file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. A CSV file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields.

Importing From CSV Files

In RSLog, when applicable you can import data from CSV files into tables (read more about working with tables). Our CSV Import feature allows both filtering and mapping of data during import. To start importing from a CSV file, click on CSV Import button CSV Import from the toolbar at the top of the table.

CSV Import
CSV Import

Selecting a File

Start with clicking on the Browse button and selecting a CSV file. These files have .csv extension and may be created by any other software such as Microsoft Excel. Your CSV file must contain the column-headers in the first row of the file.

Filtering Data

If you don't want to import the entire data from your CSV file, use the filtering function to select records that are relevant to your import. To do so:

  • Click on the dropdown and select a column of the CSV file,
  • 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-03"
    • < used for comparing a number with your filter criteria; for example Depth < 12.8
    • Like used for comparing a string with your filter criteria; for example Borehole Like "BH22-"
  • Select a filter criteria,
  • Click Go button. This will update the preview table.

Selecting CSV Columns (data mapping)

Your CSV file may contain several columns that you may or may be want to import to RSLog. Review the preview table and select which column corresponds to which standard field from the dropdown. For example, in the screenshot shown above, the CSV column "Depth (m)" is mapped to the RSLog field "Depth *" from the dropdown. We note that the fields in the dropdowns indicated with * sign are mandatory and must be mapped to a column in the CSV file in order to start importing data.

When you select a CSV file, the program automatically compares the column titles from the CSV file with RSLog fields from the dropdowns. If they match, the program automatically maps the column and field together. You can change this automatic setting if required.

Preview Table

When a CSV file is loaded or filter criteria is updated, the preview table will show the filtered data.

Importing Data

Once filtering and data mapping is completed, click on Import button to start importing process.

Data Type Issues

In general, data imported from a CSV file will be saved in 3 different fields:

  • Numeric Fields (e.g. Depth of a field test): numbers are typically imported smoothly. Integer or decimal numbers are both accepted.
  • Text / String Fields (e.g. Sample Description): text could only be imported to fields of the type text. For example, a text cannot be imported to Depth field.
  • List Items (e.g. Sample Type): for list items such as sample type, hatch pattern, drill method, etc you need to follow your account settings. The values given in the CSV file for List Items should match their text or Symbol on Rock Classification and Field Investigation tabs.

For example assume you have defined a sample type in your account settings as "Auger Sample" with its symbol defined as "AS". In your CSV file to indicate a sample type is auger, you should either use "Auger Sample" text or "AS".

Account Icon - click here to log in or out of your account Shopping Cart icon Click here to search our site Click here to close Learning Tech Support Documentation Info Chevron Delete Back to Top View More" PDF File Calendar Location Language Fees Video Click here to visit Rocscience's LinkedIn page Click here to visit Rocscience's YouTube page Click here to visit Rocscience's Twitter page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users RSLog RocFall3 CPillar Dips EX3 RocFall RocPlane RocSupport RocTopple RS2 RS3 RSData RSPile Settle3 Slide2 Slide3 SWedge UnWedge Commercial License Education License Trial License Shop safe & secure Money-back guarantee