1.1.1                 About this manual

 

This manual documents the SQL version of the BMS Editor where the operation is different to the standard ‘file’ editor.

 

It should be read in conjunction with the BMS Editor Operation Manual. All the audio functions within the database version of BMS Edit act in exactly the same way as described in the Operation Manual.

 

Throughout this manual, the corresponding sections from the Operation Manual are given, in order to easily see where the operation varies in the SQL version of the editor.

 

1.1.2                 Registering Audio in the Database

 

See Ops Manual, section 3.1.3

 

In the database version of the editor, it is only possible to open audiofiles which have previously been registered in the database. It is possible to register existing files into the database from within the editor, so they can be used in projects.

 

To do this, select the ‘register audio’ item from the ‘Tools’ or the ‘File’ menu:

 

 

 

 

 

 

 

 

 

 

 

 

 


A standard Windows file open dialog will appear, where the file to be registered can be found:

 

 

 

 

 

 

 

 

 

 

 

 

 


Find the audio file you want to add to the database, and select it.

 

The following dialog will then appear.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


This is the BMS database browser, and it is here that the attributes about the file can be entered. When entered, it is these which will enable the file to be found.

 

The first thing to decide is the Title of the audio item; by default the title suggested is the same as the name of the file, but this can be changed. To change the title, simply type the new title in the ‘Title’ box:

 

 

 

 

 

 

 

 


It is also possible to add a comment about the audio clip in the ‘Comment’ box.

 

The Program Block, Category and Sub Category can then be set as required using the various dropdowns. For a description of the BMS database data structure, see chapter 1 of the SQL installation manual, which contains information about the category structure.

 

Note that controls will remain greyed out until a selection is made which enables the changes; for example only one category allows for sub-categories, and hence the sub-category drop-down remains greyed out until the appropriate category is selected.

 

When the data is entered as desired, click OK. There will be a short delay whilst the audio is transferred to the server, then the dialog will close. The audio file will then be opened in the editor, and the waveform will be visible.

1.1.3                 Saving a Project

 

See Ops Manual, sections 3.1.2, 6.1.1

 

It is possible to save the project to the database, so that it can be re-opened later, or used by another user connected to the database.

 

To save the project, select ‘Save’ from the ‘File’ menu.

 

 

 

 

 

 

 

 

 

 

 


The first time the project is saved, the following dialog will appear:

 

 

 

 

 

 

 

 

 


It is possible to give the project a title, and to assign a Program Block for storage.

1.1.4                 Opening a project

 

See Ops Manual, sections 3.1.2

 

It is possible to open any project stored in the database.

To open a project, select ‘Open Project’ from the ‘File’ menu.

 

 

 

 

 

 

 

 

 

 

 

 


The following dialog will appear, where the projects stored in each category can be browsed:

 

 

 

 

 

 

 

 

 

 

 

 


Select the desired Project, and click ‘OK’ to open it.

 

Note

·         If the project is in use by someone else, it will open in ‘read only’ mode. It is not possible to save any changes back to the database when a project is read only. This is to prevent conflicts between versions.

 

1.1.5                 Mixing down audio

 

See Ops Manual, section 6.1.3

 

It is possible to perform a ‘mix to file’ operation. When this is done, the audio will be written back into the database, and a new database entry created. Once mixed, that resulting audiofile can then be opened by anyone accessing the database.

 

To perform a mixdown, select ‘Mix’ in the ‘File’ menu:

 

 

 

 

 

 

 

 

 

 

 

 


A dialog the same as for the ‘register audio’ operation described above will then appear. The details about the resulting audiofile can be entered exactly as described in section 1.1.2 above.

 

1.1.6                 Opening audio from the database

 

See Ops Manual, section 3.1.3

 

It is possible to include any audio registered in the database in edit projects, simply by browsing for the desired audio in the database.

This is done by selecting ‘Get audio’ in the ‘File’ menu:

 

 

 

 

 

 

 

 


The following browse window will appear.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Simply use the Program block and category dropdowns to browse the database; audio registered in each area will be visible in the right hand pane. When the desired audio is found, simple select it by clicking on it, then click ‘OK’ to open the audio into the project.

 

Notes

·         If the ‘ready to send’ box is checked, only audio which is flagged as such will be visible. Uncheck the box to see all the audio available.

·         Some dropdowns will be greyed out until a category which allows for that sub category etc is selected

 

It is also possible to search by send date, using the ‘From day’ and ‘To day’ dropdowns. Note that these are only available for one subcategory.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Use the date dropdowns to select dates between which you want to search. By default the ‘To day’ is the current date, the ‘From day’ can be configured to default to any number of days before the current date; see chapter 3 of the SQL installation manual for details.

 

1.1.7                 The Project Archive

 

It is possible to browse the projects currently stored in the database, and delete or modify them.

 

To access the Project Archive, select ‘Project Archive’ from the ‘File’ menu:

 

 

 

 

 

 

 

 

 

 

 

 

 


The following dialog will appear:

 

 

 

 

 

 

 

 

 

 

 

 


This window is similar to the ‘Open Project’ window, in that the Program blocks can be browsed, and project stored under each one seen.

 

However, it is possible to edit attributes and delete projects from this dialog.

 

To rename a project, select the project to be renamed, then click on it with the alternative mouse button (normally the right button).

A small menu will appear as shown:

 

 

 

 

 

 

 

 

 

 

 


Select ‘Edit’, and the following dialog will appear:

 

 

 

 

 

 

 

 

 

 


The project title, comment and program block can be changed from this dialog.

 

It is also possible to delete a project, by clicking on it and pressing ‘delete’ on the keyboard, or by selecting ‘delete’ in the right-click menu.

 

Note that this will not permanently delete the project, but put it into a ‘trash’ location where it cannot be accessed from the ‘Open Project’ function.

 

To view items in the trash location, click the ‘Show trashcan’ checkbox at the bottom left of the Project Archive:

 

 

 

 

 

 

 


Items in the trash can now be viewed. To delete something permanently, locate it in the trash, select it and press ‘delete’ on the keyboard.

 

To restore an item from the trash, right click on it and select ‘edit’. Clicking OK in the ‘edit project’ dialog without making any changes will restore it from the trash.

 

1.1.8                 The Audio Archive

 

As for the project archive, there is a similar dialog which allows audio stored in the database to be viewed.

 

This is accessed via the ‘Audio Archive’ item in the ‘File’ menu. When selected, the following dialog will appear:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


By browsing the program block and category dropdowns, it is possible to view an audio stored in the database – audio is displayed in the right hand pane.

 

Notes

·         If the ‘ready to send’ box is checked, only audio which is flagged as such will be visible. Uncheck the box to see all the audio available.

·         Some dropdowns will be greyed out until a category which allows for that sub category etc is selected

 

__________________________________________

Browsing recordings

 

In the Audio Archive, it is possible to see not just source audio files (which can be added to projects as described earlier), but also recordings. Recordings are made when audio is recorded into the editor, and are not visible when performing a ‘Get Audio’ function. However, they can be viewed by clicking the ‘Show Recordings’ checkbox in the Audio Archive dialog:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Recordings made in each category will then be displayed. As recordings are associated with projects (it is necessary to create a project before making a recording), recordings are always in the top level Program Block category, with the projects.

_____________________________________

Editing entries in the Audio Archive

 

It is possible to alter the attributes about audio files from the Audio Archive. To edit an audiofile entry, select the audio file in the Archive, and right click on it – the following pop-up menu will appear:

 

 

 

 

 

 

 

 

 

 


Select ‘Edit’ to edit the entry, and the following dialog will appear:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


This is very similar to the ‘Register audio’ dialog described earlier. All attributes of the file can be altered, including title, categories and so on. It is also possible to modify the ‘ready to send’ and ‘recording’ flags – for example to specify that an audio item is ready for broadcast. It is also possible to use this to remove the ‘recording’ flag from audio, in order that it can be added to other projects.

 

_____________________________________

Copying audio

 

It is possible to make a copy of an audio file, for example to register it in another location in addition to its original one. To copy an audiofile entry, select the audio file in the Archive, and right click on it – the following pop-up menu will appear:

 

 

 

 

 

 

 

 

 


Select ‘Copy’ to copy the entry, and a dialog similar to the ‘register audio’ dialog will be displayed. A new title, category and so on can be specified for the copy, and clicking OK will create a copy of the audio with the new attributes.

 

_____________________________________

Deleting entries in the Audio Archive

 

It is possible to delete audio files from the Audio Archive. To delete an audiofile entry, select the audio file in the Archive, and right click on it – the following pop-up menu will appear:

 

 

 

 

 

 

 

 

 

 


Select ‘delete’ to delete the audio. Alternatively, simply click on the item and press delete on the keyboard.

 

When items are deleted, they are not immediately removed, but mode into a trash location. It is possible to view the items in the trash location by clicking the ‘Show trashcan’ checkbox at the bottom of the Audio Archive dialog.

 

To remove an item permanently, carry out the same procedure as above on the trash. To restore an item, simply select ‘Edit’ in the menu, then click ‘OK’ without making any changes. The item will be restored from the trash.

 

Note

·         The audiofile is not removed from the server until it is deleted from the trash. If the trash folders are not emptied regularly, the server disk space can run low, even though the database appears quite empty.

 

_____________________________________

Exporting items from the database

 

It is possible to export audio items from the database, for example to copy them to a local drive to import them to another system, or to burn the audio to a CD.

 

This is done by right clicking on the item in the Audio Archive, and selecting ‘Export’ from the pop-up menu.

 

The following standard Windows dialog will then appear:

 

 

 

 

 

 

 

 

 

 

 


A location to place the file can be selected, and the export file name entered. As a default, the file name created is the same as the title of the audio in the database.

 

Note

·         It is possible to set up a default path for exporting audiofiles to – see Chapter 3 in the SQL installation manual for details

 

This function will copy the audio from the database, but the original database entry will remain intact.

 

_____________________________________

Moving items from the database

 

It is also possible to move items out of the database. This is essentially a combination of the ‘Export’ function outlined above, together with a ‘delete’ function.

 

This is done by right clicking on the item in the Audio Archive, and selecting ‘Move to Store’ from the pop-up menu.

 

The following standard Windows dialog will then appear:

 

 

 

 

 

 

 

 

 

 

 


A location to place the file can be selected, and the file name entered. As a default, the file name created is the same as the title of the audio in the database.

 

 

Note

·         It is possible to set up a default path for moving audiofiles to – see Chapter 3 in the SQL installation manual for details

 

This function will remove the audio from the database, deleting the database entry.

_____________________________________

Registering Audio from the Archive

 

It is possible to register audio into the database from the Audio Archive. To do this, click the ‘Register’ button at the top right of the Archive dialog:

 

 

 

 

 

 

 

 

 


The procedure is exactly as described in section 1.1.2, and the attributes about the audio files being registered can be entered.

 

The only difference is that when registering things from the archive, they do not automatically get added to the current project; they are simply added to the database.

 

After registering a file, the Windows Open dialog will automatically reappear, enabling the rapid registration of several items. Simply click Cancel to stop the registration process.

 

In this way the ‘Register Audio’ function outlined in section 1.1.2 is optimised for getting an audio file for use in the current project, whilst the Register function in the Archive is optimised for putting many items into the database in one go. However, they are completely interchangeable in terms of end result.

 

1.1.9                 Mixing audio to local storage

 

See Ops Manual, section 6.1.3

 

In addition to the export and move functions outlined in section 1.1.8, it is also possible to grab audio directly from the project and mix it to a local storage. This does not make a database registration; it simply creates an audiofile on a specified drive.

 

To access this function, select the audio required (or select nothing to capture the whole project)  and select ‘mix to file’ from the ‘Tools’ menu:

 

 

 

 

 

 

 

 

 

 

 


A Windows Save dialog will appear, where the file name and path for the audio can be specified:

 

 

 

 

 

 

 

 

 

 

 

 


The audio will then be mixed to the desired storage, without making any database registration.