RocFall3 | Your new tool for 3D assessment of slopes at risk for rockfalls. Get started with RocFall3 today!
 

Search Results

DIGGS Import

The DIGGS Import feature is accessed from Data Entry > Import page, and allows the user to import their project data from a DIGGS file to their RSLog account.

Requirements for DIGGS Import

This feature requires one DIGGS file (*.xml) prepared based on the latest DIGGS format.

Overview of DIGGS Import Process

This feature reads project data from the DIGGS file and writes data in your RSLog account. Due to the flexibility of DIGGS files, the import tool needs to know where in the DIGGS file specific data is stored. For example, most DIGGS files store Project Title in Projects parent node and Title child node. Using the DIGGS Import tool, there are two types of 'data mapping' that needs to be done:

  • Simple Data Mapping: Simple data such as project name, borehole depth, etc. only require determining the 'parent node' and 'child node' in the DIGGS file where the data is stored.
  • List Data Mapping: For more complex data types such as Sample Types, Soil Classification, Drilling Methods, etc. each item in the DIGGS list should be mapped to its corresponding 'type' in RSLog list. For example, in the DIGGS file you may have a sample type saved as "AUG", representing a soil sample taken from an auger flight during drilling. In your RSLog account you want to link this type of sample to RSLog Auger Sample.

When you open the DIGGS Import tool for the first time, the program automatically selects the default parent nodes and child nodes, however you will be able to review and edit this settings using the aforementioned two types of data mapping.

Selecting the DIGGS File

Click on the Browse button next to Choose DIGGS File to select your DIGGS project file. This will initiate data processing. Once completed, you will see several tabs on the DIGGS Import dialog.

    List of Data Entities

    Once your DIGGS file is processed, the dialog will show the list of Data Entities such as Projects, Boreholes, Samples, etc. in various tabs. Each tab shows the list of items ('properties') available for each Data Entity (see screenshot below). Each table is structured as follows:

    • Property (RSLog): shows the name of the property for a specific RSLog data entity. For example, each project (as Data Entity) has a Title (as property).
    • Type: the data type for each property is shown in this column.
    • Parent Node: indicates the table in the gINT file where the data for this property is stored.
    • Child Node: indicates the column (field) in the select gINT Table where the data for this property is stored.
    • Example Value (1st Record): shows the actual value of the property for the first record in selected gINT Table.
    DIGGS Import Page
    Import: DIGGS Import Page

    Simple Data Mapping

    The first time you use the DIGGS Import tool, the program automatically selects the default parent and child nodes for the most common data entities.

    1. Review /select the parent and child nodes for each item in the tables. You can use the example value shown in the last column to verify if the right combination of parent and child node is selected.
    2. Go through all the tabs and make sure that data mapping is completed for all data entities. Depending on the structure of your DIGGS files, some tabs may not be relevant. For example if piezometer data is available in your DIGGS file, you can skip settings for Piezometer/Well tab.

    List Data Mapping

    Where the value of a property in RSLog (e.g. project 'unit system') should be selected from a list of options, an icon will be displayed next to the child node dropdown. Clicking on this icon will open the Data Mapping page, allowing a user to link the DIGGS lookup lists to the RSLog lists.

    In RSLog, user can customize the list of data types (e.g. sample types, boring methods etc) from the Settings > Rock Classifications and Settings > Field Investigation pages.

    The following screenshot shows an example of list data mapping for Sample Types. For each Equivalent RSLog value in the second column, the DIGGS sample type must be entered in the first column.

    DIGGS List Data Mapping

    If you know the exact phrases used in your DIGGS data structure, enter it in the first column for each RSLog sample type. Please note by pressing Enter, the item is added to the list and you can start entering new item for the same RSLog value, if it is necessary. Once your data mapping is completed, click the Save button. Your settings will be saved under your account and next time you use the DIGGS Import tool, your settings will be loaded automatically.

    Importing Data

    Once all settings are completed, click on the Import Data button. This will create a new project in your RSLog account and all the 'mapped' data will be imported.

    What Happens to the Unmapped Data?

    The data that is not directly 'mapped' between your DIGGS file and RSLog account will be imported to your new RSLog project. This data is typically shown in Miscellaneous Data tab of each borehole.

        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