|
|
Database related tools
 Convert dates to standard format
Tool to convert most commonly used date formats to the following standard format: YYYY-MM-DD. This format allows the entries in the database to be sorted according to time. When the "Save changes" checkbox is checked, the standard-formatted dates are permanently stored in the database.
Convert field to upper case
Converts all characters of a specified field into capitals. Optionally with a checkbox, you can convert only the first character to uppercase.
Copy field to key
Copies any field you select to the Key. Note that this function requires the field you copy into the key to contain a UNIQUE string per entry; otherwise duplicate keys would be generated. When the field is empty for an entry, the script retains the original key.
Copy key to field
Copies the key to any field you select. Any information in the selected field will be overwritten!
Copy one field to another
Copies the content of one database field to another. The operation can be performed on the entire database or on a selection of entries. Any information in the target field will be overwritten!
Delete unused fields
Deletes "dummy" information fields in the database, i.e. fields for which nothing is filled in for any entry. Before actually deleting the fields, the empty fields are listed, from which you can select the ones you want to delete.
Field statistics
Tool to display the relative occurrence of names in a selected information field. The statistics can be done on the whole database, or on a selection only, using a checkbox. Furthermore, the names can be displayed by their frequency. The results are either presented as a tab-delimited text-file, or graphical, as a pie chart diagram, which can be printed or copied to the clipboard.
Find and replace
Allows you to enter a search string and replace this string by another string. You can select all fields, or one specific field. A checkbox allows the replace function to be executed only on the selection made in the database. The changes can be permanently saved to the hard disk using another checkbox.
Invert selection
Tool to invert the selection of entries in the database. All entries that were selected will become unselected whereas all non-selected entries will become selected.
Pad field with spaces (left)
For a selected field, this tool will insert spaces before the strings, so that all strings have the same length. This feature is useful to sort numerical information. Optionally, when checking "Save changes to disk", the changes are permanently stored.
Pad field with spaces (right)
For a selected field, this tool will insert spaces after the strings, so that all strings have the same length. This feature can be useful to display aligned columns in text format. Optionally, when checking "Save changes to disk", the changes are permanently stored.
Remove selected database entries
Using this tool, you can erase a number of selected entries from the database at once. This tool can easily cause unrecoverable losses of database information and therefore, should be used with extreme caution. Note that the script does not remove the associated experiment information for the deleted entries. In order to restore the entries, you can run the Inspect program to create database entries for any unlinked experiment keys.
Remove selected entries
Using this tool, you can erase a number of selected entries from the database at once. Experiment information associated with the deleted entries is also erased. This tool can easily cause unrecoverable losses of database and experiment information and therefore, should be used with extreme caution. Once deleted, there is no way to restore the database or fingerprint information of the deleted entries.
Replace database fields
A function to select a database field and replace a string by another string. With the "Save changes" checkbox, you can save the changes permanently.
Set field layout
With this tool, you can define which fields that are displayed and which fields are hidden in the database. Note that the function to hide fields is only accessible through a script. It is not equal to setting the length of a field to zero, because in the latter case, the field header will remain visible.
In case of databases with many fields, the function 'Set field layout' to create and store database views. The dialog box displays a checkbox for each database field, and allows you to apply, save and load a certain selection of fields.
|
