A "Synonym Table" is used to define synonyms for RockWorks for the following programs:
- Target and replacement text to be used by the RockWorks Utilities Edit | Columns | Translate program.
- Expected and actual worksheet names used for the multi-worksheet Excel import (File | Import | XLS) when this program is run via an RCL script.
! You can store multiple Synonym tables in your project database. If you assign detailed names they'll be easy to distinguish when you're selecting which to use. Synonym tables can be accessed in the Project Manger, under the Project Tables | Synonym Tables grouping.
Table Format
Column Translation
- Target: This defines the text that will be searched for in the RockWorks Utilities datasheet.
- Replacement: This defines the text that will be recorded in the designated output column if the target text is located.
In the above example, a set of geographical names (which happen to be listed in a Google Earth placemark file) are associated with a file name. When the user runs the Edit | Columns | Translate option, the program will look for instances of the target text, and record the designated file name in the output column. This is a quick way to associate a geographical name with a specific icon when loaded into Google Earth.
- You may list as many target-translation pairs as you wish.
RCL Excel Import
- Target: List in this column the "expected" worksheet name for the Excel import process. Please refer to the RCL documentation for a list of the standard worksheet names.
- Replacement: Here you can list the actual name of the worksheet in your Excel file that contains the indicated data.
In the above example, RockWorks will "understand" during the RCL import of the Excel data that your raster log names and depths are to be imported from the worksheet named "Raster log names" rather than the expected worksheet named "Bitmap". And, the borehole location information is to be read from the worksheet named "Collar data" rather than the expected "Location" worksheet.
- You may list as many target-translation pairs as you wish.
See also:
RockWare home page