Database Table Editing

The database option for the selection of a spectral area is build on a text file in csv format: signalDB.csv.

Personalisation of the database input options can be performed with the following steps after closing MSbrowser:

1. Locate database table

   Locate the database table file signalDB.csv with the following R command

   system.file(file.path('extdata', 'signalDB.csv', fsep=.Platform$file.sep), package='msbrowser')

2. Open and edit

   Open the file with a spreadsheet editor (e.g., MS Excel or Google Sheets). The spreadsheet rows can edited, removed and new rows can be appended to change the compound entries showing up in the MSbrowswer database option. It is important that the the column structure (header names and column order) remains as it is, since this links with the graphical user interface (UI). Rows starting with # indicate comments and these will not be considered for the UI (so please feel free to include compound comments as required).

3. Save file

   Save the spreadsheet in csv format at the same folder location and with the same name: signalDB.csv. MSbrowser can now be started, the respective edits are shown under the database option of the target area selection.

---

In future app versions, it is planned to integrate MSbrowser with spectral databases that run locally. If you would like to get involved in this development, please feel free to get in touch using the email-link below.