Excel Import
RSLog has Excel templates that are designed for data entry consistent with its data structure. These Excel templates include one file for project and one file for test hole, and they may be downloaded from the download link located on the Import page.
Data entry in several cells in these Excel templates use pre-defined lists (e.g. sample types, drilling methods, etc). These lists come from the Settings worksheet (hidden); At the time of downloading template files, RSLog will automatically update these lists in the Excel files based on your RSLog settings.
If you prefer data entry using a spreadsheet format, or if you don't have internet connection during data entry (e.g. staying on a remote project site), you may take the following steps.
Downloading RSLog Excel Templates
In order to download latest Excel templates:
- Go to the Import page and click on Download Templates button.
- Copy the project Excel template and save it under a different file name.
When you first open the test hole Excel template you may receive the message shown below; Please click Yes:
Data Entry in Excel Templates
- For each test hole, copy the test hole Excel template and save them with different names.
- Complete the data entry in Excel files.
- Once data entry is completed, login to your RSLog account and go to Import page.
- Click on Import Data link in RSLog Excel Templates panel to start uploading the files.
- After uploading all files, a new project will be created in your RSLog account and you will be automatically directed to the Test Holes page.
The page should appear as follows:
Select a destination project; The imported data could be saved under a new project or you can import borehole data to an existing project. Start by uploading the project Excel file. Then follow by uploading the test hole Excel file(s). Please note on the file browse dialog you can select multiple borehole Excel files:
- by holding Ctrl button and clicking on each file
- by clicking on the first file in the list, holding Shift button and clicking on the last file.
Once the files are uploaded, click on Import Data button. This will start processing each Excel file and if any data entry error is encountered during processing, an error message will be shown. If all files contain valid data, you will be redirected to the Test Holes page showing the list of all imported boreholes.
Export from Datanest App
If you use Datanest app for data entry, you can automatically generate Excel files compatible with RSLog. Then login to your RSLog account and go to Import page to upload your Excel files. A new project will be created in your RSLog account and you will be automatically directed to the Test Holes page.
Now that your data is transferred to RSLog, you can take advantage of all design and reporting features offered by RSLog.
Importing Older Excel Templates
RSLog Excel templates ver 1.3 and newer are supported for import.