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 from the toolbar at the top of the table.
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".