A database with some 6 million specimen records - the importance of having an adequately resourced server.
Assigning user permissions.
A review of system setup options.
Select and save visible column views in any table.
Using tags (record selection) in BRAHMS.
How to delete records.
Why you can edit some fields in tables but not others? Introducing table relationships.
Generate a summary of different data values in the selected column.
Using calculated fields in BRAHMS.
Using Edit History to track and undo changes in RDE and your main database.
Exporting data from any BRAHMS table to Excel.
An introduction to lookup functions in BRAHMS - why are they important and how to use them. Configuring your lookups is the topic of the next video.
How you can register fields in your lookup dictionary and how to add/edit the lookup values for these fields. The next video demonstrates how you can import lookup lists from Excel.
Rather than entering lookup values directly into BRAHMS, you can develop your lookup lists more efficiently by importing data from Excel.
Adding and editing taxa descriptive texts. You can download the example report template used in this video. This report template is for use with the taxa descriptions table and will list text descriptions under all the text categories you have added. It is usually best not to restrict the fields when opening sample report templates in case your current data grid view lacks required fields. Download report sample.
Apply filters in any table on single or multiple columns using the data grid filter row.
The multi-value search tool - a quick way to locate a list of values.
Importing data from Excel to BRAHMS via RDE.
Importing an RDE file of herbarium specimens into a BRAHMS database.
For more details on how to setup the internal components and features of reports in BRAHMS (including Expressions, Appearance, Text Formatting, Barcodes, Watermarks, and more), please refer to this report internals section.
Introducing the BRAHMS reporter: opening the reporter and passing data.
How to include record sorting in report templates. You can download the example template used in this video. This report template is for use with the Collection Events table and will list all tagged records. If you have done so, update your calculated fields in that table to ensure the sortable field number '#Field Number (sortable)' is updated as this is used in the template example. It is usually best not to restrict the fields when opening sample report templates in case your current data grid view lacks required fields. Download report sample.
How to control and format species names in reports. The formatting example used is available in the BRAHMS Manual reporting section 'Using conditional clauses to print the full taxa name' . You can download the example template used in this video. This report template is for use with the specimens table and will list the calculated fullname and formatted taxa name for all tagged records. It is usually best not to restrict the fields when opening sample report templates in case your current data grid view lacks required fields. Download report sample.
A report template to list data from a table, adding a watermark to the background. You can download the example template used in this video. This report template is for use with the specimens table and creates a basic list of specimens. It is usually best not to restrict the fields when opening sample report templates in case your current data grid view lacks required fields. Download report sample.
A report template to list specimens and group these by family, adding totals of collection events and different taxa per family. You can download the example template used in this video. This report template is for use with the collection events table. It is usually best not to restrict the fields when opening sample report templates in case your current data grid view lacks required fields. Download report sample.
A report template to create a species checklist by country, adding totals of collection events and different taxa per country. You can download the example template used in this video. This report template is for use with the collection events table. It is usually best not to restrict the fields when opening sample report templates in case your current data grid view lacks required fields. Download report sample.
A report template to prepare a list of botanic garden label requests, the type of list that could be given to a printing office. As engraved labels are quite costly, ths process is often controlled/documented. This report is run from the Label Requests table when working with Living Collections. It is usually best not to restrict the fields when opening sample report templates in case your current data grid view lacks required fields. Download report sample.
Using the in-built ArcGIS mapper with collection events, garden plants and other data with map references.
Adding/editing map points and locating places using the Map Editor.
Searching a map area to create a species check list.
How to connect to QGIS and add a base map. Video provided by Tim Pearce, RBG Kew. QGIS is a free and open source Geographic Information System. Vector and Raster basemap data can be downloaded from the Natural Earth website.
Preparing species distribution maps in QGIS based on collection event data. Video provided by Tim Pearce, RBG Kew.
Preparing species richness maps in QGIS based on collection event data from Ethiopia. Video provided by Tim Pearce, RBG Kew.
10 minute video presentation on BRAHMS for Botanic Gardens.