A "Synonym Table" is used to define synonyms for RockWorks for the following programs:
- Target and replacement text to be used by the RockWorks Datasheet | Columns | Translate program.
- Expected and actual worksheet names used for the multi-worksheet Excel import (File | Import | XLS) when this program is run via a RockWorks Command 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.
Column Translation
- Target: This defines the text that will be searched for in the RockWorks 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 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.
Automated Excel Import
- Target: List in this column the "expected" worksheet name for the Excel import process. Please refer to the Command Script 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 scripted 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.
RockWare home page
Synonym Tables