Loading the Add/change data module

The Add and change data features are a module in BeeHive, a component that can be enabled (loaded) or disabled (unloaded) by you as a user. Before you can use the Add/change data module, you must load it. 

1. Select File->Modules->Add/change data from the menu bar.
   A check mark will appear by the menu item and a new menu 'Data' appears to the right on the menu bar.

You only need to do this once, the next time you start BeeHive, the Add/change data module will be loaded at start-up.

Figure n: Use the Modules sub-menu to load or unload BeeHive modules.

Adding data

Much of Biovitrum's assay data that you see in BeeHive is imported automatically and continuously from ActivityBase. However, some database tables are designed so that you can type in data or import data from a text file. You will be able to add data only if you have been granted that permission for a particular table.  

In the sub-menu "Add" of the "Data" menu you will see the names of tables where you may add data.

Figure 24: The add data menu shows where you have permission to add data.

To open the add data module, select a table name from the "Add" submenu of "Data".

Figure 25: The add data module.

The upper part shows the data type and unit of measurement or maximal length of each column. Type lower part is where you may type in new data.

• Press the down arrow key with the cursor on the last row to add a new row.
• In some columns you may only be able to select values from a drop-down list.
• A column can also have a drop-down list where you may type a value which is not in the list.
• You cannot type text into numeric or date columns.
• The "Save" button will not be enabled until you entered some data.
• Use the "Clear" button to clear all data from the window. This does not affect data which is already in the database, i.e. has been saved.

When you are ready to save the new data to the database, press "Save". You will be asked to confirm adding the new rows of data. BeeHive will attempt to send the new data, row by row, to the database server. The server will further validate the data, e.g. by checking that compound IDs and batch numbers are valid. If there is a problem with the validation of the data, a message will appear:

Figure 26: Notification of a data validation failure.

The cursor in the add data window is placed on the row causing the problem. Press "Yes" to skip this row and continue processing the other rows.

Note that if you press "No" to stop processing, all rows prior to the error have already been saved. Take care not to add them another time!

Each row that is successfully saved is removed from the add data window. This means that when the processing completes, there the window will either be empty - if all rows were OK, or rows causing errors will be left. This makes it easy to find and correct the errors. Simply press save again when you have corrected the problems.

Importing data from a text file

To import data from a text file, the file must meet these requirements:

• The columns of data in the file must come in the same order as in the add data window.
• There number of columns in the file must be equal to or less than that of the add data window.
• The first row of the file may either contain column headings or the first data row. You need to know which.
• The file must be of one of the following types
  • Tab-separated columns, decimal point in numeric columns
  • Comma-separated columns, decimal point in numeric columns
  • Semi-colon-separated columns, decimal comma  in numeric columns

Follow this procedure to import a file:

1. Press "Import file" to bring up the import file dialog. 
2. Select the appropriate file type and header row setting.
3. Type in the file name, or press "Browse" to select a file.
   
   Figure 27: The import file dialog.
4. Press "Preview" to show a preview of the file's contents in a new window.
   
   Figure 28: The preview window shows the contents of a file before importing.
5. Make sure the file looks OK in the preview. 
   • If the first row contains column headings, you need to change the setting "Line 1 is header".
   • If you see only a single column, try changing the file type.
6. Close the preview window and press "Open". 
7. The contents of the file will now be filled in the table in the add data window. No data is saved to the database at this stage. If there are is a mis-match in data types between the file and the add data window, a message will appear and the import operation stops. In this case you need to clear the add data window, correct your file and try again.
8. Press "Save" and follow the instructions above to save the data imported from the file.

Changing data

Changing data in database tables works in a manner similar to adding data. Select the name of the table you want to update from the "Change" sub-menu of the "Data" menu. All the contents of that table will appear in a "Change data" window.

• You may edit data in the same way as in the add data module.
• To delete a row, right-click it and select "Mark row for deletion" from the pop-up menu.
  This can be reversed by selecting "Remove row deletion mark".
• Press "Save" to store the changes and do the deletions to the database table. 
• Data validation proceeds as when you add data.