Library
In this chapter, you will learn how to use the library part of mAirListDB to add and manage playlist items in your database.
The library part of mAirListDB can be found on the Library tab in the database application.
Library View
The library window consists of two parts:
- A tree-like structure to navigate through the library (on the left-hand side), and
- the list of items, with various columns (on the right hand side).
Overall, the library window works pretty much like Windows Explorer, with folders (and more) on the left-hand side, and items on the right hand side.
Library Tree
The tree structure on the left-hand side consists of the following nodes, most of which can be expanded to access additional sub-nodes or filters:
- Folders: Expand to see and manage the virtual folders and the items assigned to them. See below for more information on virtual folders.
- Artists: When you expand this, you see an auto-generated list of all artists of which there are items in the database. Clicking an artist will show all items of that artist in the item list.
- Types: Expand to see a list of available item types (e.g. music, jingles, etc.), and click a type to filter the items by that type.
- Attributes: This contains a list of all attributes (keys) assigned to any item. Further expanding an attribute will show all values that are used in any item, and clicking a value will filter the item list by this key and value.
- Storages: Expand to see a list of all storages set up in the configuration, and click a storage to filter all items by that storage.
- Advertising: This provides quick filters to access all items of type “advertising”, optionally filtered by campaign.
- Everything: As the name suggests, this will just load the entire list of items into the item list on the right-hand side.
The current view can be refreshed at any time by hitting the F5 key. This also refreshes the cached database settings (storages, folder list, etc.), which mAirList keeps in memory in order to minimize loading times.
Search
In the lower left corner, there is a search box where you can search the library for specific terms.
Clicking the magnifier glass icon in the search box will open a popup menu where you can choose between two modes:
- Search entire database: Enter one or more search terms and press Return to search the entire library. The results are shown in the item list.
- Filter current view: The item list currently displayed (e.g. the folder you navigated to in the tree) is filtered as you type, no need to press Return.
The popup menu also gives access to the Advanced Search dialog.
Press Escape to clear the search box.
Search Terms
When searching the entire database, mAirList will look for the search terms in the
artist, title and external ID fields, and also accept a database ID.
Multiple search terms separated by spaces are combined, i.e. an item must match all
of them, but the terms may be found in different fields. For example, searching for
Yesterday Man Chris Andrews will find the song “Yesterday Man” by Chris Andrews.
Use double quotes to search for a phrase, e.g. "Chris Andrews".
How exactly the search terms are matched depends on the Full Text Search mode that is selected on the Options page of the database connection properties in the configuration app:
- Fast: The search terms are matched against the beginning of the fields (or words that follow each other in a field). This is the fastest option, as it can make use of SQL indexes.
- Full: The search terms may appear anywhere in the fields. This also finds partial words, but can be slow in large libraries.
- SQL native: Uses the full-text search function of the SQL server. This is currently only available for PostgreSQL databases, and must be set up with the Set up FTS Tables button next to the mode selection first.
Advanced Search
The Advanced Search dialog allows you to search the library by a combination of criteria. Open it by clicking the magnifier glass icon in the search box, and select Advanced Search… from the popup menu. The Advanced Search is also available in the Database Search browser of the playout window.
The dialog provides the following criteria:
- Keywords: The same kind of search terms you can enter in the search box (see above).
- Title, Artist, Comment, End Type, Database ID, External ID: Choose a condition from the drop-down list (equals, starts with, contains, does not equal, does not start with, does not contain), and enter the value to compare the field with.
- Item Types: Click the … button to select one or more item types (e.g. Music, Jingle), and choose whether the item type must be one of or none of the selected types.
- Duration, Ramp: Enter a minimum and/or maximum value in order to find items with a duration or ramp (intro) in this range. You may leave either field empty, e.g. only enter a maximum value to find all items shorter than that.
- Attributes: Below the fixed criteria, there is one row for each Standard
Attribute defined in your configuration. In addition to the text conditions listed
above, you can choose:
- is between / is not between, then enter a minimum and/or maximum value,
- is one of / is none of, then enter a list of values separated by semicolons,
e.g.
Rock;Pop;Jazz.
Criteria left empty are ignored. All other criteria are combined, i.e. an item must match all of them in order to be included in the result. If you leave the Keywords field empty, the search is performed on the entire library, using the other criteria only.
Click Search (or press Return) to perform the search; the results are shown in the item list. The dialog stays open, so you can easily refine your criteria and search again. Click Reset to clear all criteria, and press Escape to close the dialog.
When using a remote database through mAirList DB Server, the server must run version 8.1 or newer in order to support the Advanced Search. With an older server, only the Keywords criterion is taken into account.
Adding Items
This section covers the process of adding audio files to your library, by defining storages and then using either synchronization or file import, as well as adding other kinds of items such as streams or containers.
Manage Storages
Before audio files can be added to the library, one or more storages must be defined in the database settings. This is done in the Database app: Go to Administration -> Configuration and switch to the Storages tab.
A storage is basically a Windows folder, which can either be a folder on your local hard drive, or on a network share.
Future versions of mAirList may offer additional storage options besides Windows folders, this is why the more general term “storage” is being used.
As soon as a Windows folder is registered as a storage, all audio files in that folder, including all subfolders, will become part of the database library.
Audio files in the storage folders can be added to the library in one of two ways:
Synchronization: mAirList will scan the storage folder for new files, and create items in the library for them. The original audio files will remain untouched. This is perfect when migrating from another software (you can add your existing audio folder as a storage, and have mAirList synchronize/scan it), or if you plan to manage the audio files in a clean file system structure on your own (something we actually encourage you to do).
File Import: Alternatively, mAirList can copy new files into the storage folder, and create the item in the library at the same time. This is what happens when you e.g. drag files into the database app with the mouse.
More details about these two methods can be found in the sections below.
Once an audio file is added to the library (i.e. its dataset is created), you must never rename or move the file within the storage folder, because mAirList will be unable to find it afterwards.
Generally, we recommend that you use separate storages for your different types of audio. A common structure for new libraries would be using three separate storages for music, jingles and advertising:
C:\Audio\MusicC:\Audio\JinglesC:\Audio\Advertising
The advantage is that mAirList remembers some preferences (e.g. the last item type set in the Synchronize dialog) on a per-storage basis.
Add Storage
To add a storage, click the Add button, and the Edit Storage dialog appears. The required fields are:
- Name: Enter a name for the storage. This will be used in menus etc.
- Default location: This is the Windows folder that will be used for the storage.
Hint: The Name field is populated automatically with the folder name when you select the default location, and no name has been entered yet.
Do not register both a parent folder - e.g. C:\Audio - and any of its
subfolders - e.g. C:\Audio\Music - as storages at the same time! This is not only
redundant (remember that all subfolders of a storage will be included automatically),
but the ambiguity will also lead to unexpected behavior when importing files
into the database.
The three other settings - Redirect to, Backup location and Cache location refer to Storage Redirection. They cannot be edited from here, but only from the database connection properties in the configuration app or Control Panel. See the section on Storage Redirection below.
For maximum performance, mAirList caches the storage configuration at startup. Consequently, any changes to the storages (adding, removing or editing storages) requires a restart of all mAirList processes connected to the database.
Edit Storage
Clicking the Edit button will bring up the Edit Storage dialog again, where you can change the name and/or default location for an existing storage.
It is easily possible to move a (Windows) storage folder to a new location, e.g. from a local hard disk to a network share, and then edit the storage location here (and restart all mAirList instances).
This works because mAirList does not store the absolute path for the audio items, but only the numeric ID of the storage, plus the relative path within the storage folder. Just make sure that you move the storage folder as a whole.
Remove Storage
Before a storage can be removed, all of its items must be deleted from the library first. Then click Remove in order to remove the storage from the configuration. Again, you must restart all mAirList processes to reflect the change.
Storage Redirection
In a typical SQL-based multi-computer setup, audio files usually reside on network
shares, and each mAirList computer in the LAN has direct access to the files, either via
a UNC path (\\server\share) or a mapped drive letter, using the Default Location
set up in the storage configuration.
There are situations, however, where a particular computer must use a different path to access the file, for example when the UNC path used for the default location is not available on that part of the network, or a different drive letter is used for the mapped network drive.
Another common situation is that there are particular computers that maintain a synchronized copy of all audio files on their local hard disk, so they can keep on playing even if the file server should have a temporary failure.
This is where Storage Redirection comes into play. It allows you to modify the path used to access a particular storage, as well as setting up alternative paths where mAirList should look for the audio files.
As this is a per-computer setting, these settings must be accessed over the configuration app (or live configuration) on the particular computer. You can find them on the Storage Redirection tab of the database connection properties dialog.
To adjust storage redirection, you must first click the button to retrieve a list of available storages. Then double-click a storage to edit it.
The dialog that appears is the same as the one from the storage configuration in the database app (see above); but this time, you can only edit the following settings:
- Redirect to: If a path is entered here, mAirList will always use this path to access files on this storage. Leave empty to use the default location set in the storage configuration.
- Backup location: If a path is entered here, and a file cannot be found in the default location (or the default location is not available, e.g. because of a server outage), mAirList will look in this folder instead. Use this when you have a synchronized copy of the storage folder on your local hard disk, and you want to use this as a backup for the default location.
- Cache location: This is pretty much like backup location, however, mAirList will first try to access the file in the local “cache” directory, and only use the one from the default location if the file doesn’t exist in the cache (or the file size or modification date differs).
Note that, when making changes through the live configuration (Control Panel), they will only become active after you restart mAirList or reconnect the database.
You can verify that backup and/or cache location has been configured correctly by looking at the values on the Audio File tab in the item properties dialog - the backup and cache filename fields should be populated with the correct values.
Synchronizing Storages
Synchronization is one of two ways to add new audio files to (and remove obsolete files from) the database. It involves the following steps:
- Retrieve a list of audio files currently known to the database.
- Scan the storage folder recursively, make a list of audio files found in the folder.
- Compare these two lists, to find out which files are “new” and which are “missing” (obsolete).
- Create items in the database for all “new” files.
- Remove items from the database for all “missing” files.
Synchronization is a suitable approach when you intend to manage the audio files in your Windows folders manually (first copy to Windows folder, then add to database), or when you want to add an existing audio library to the mAirList database library.
To perform synchronization, go to the database app, Library tab, then click Synchronize and select the storage you want to synchronize from the dropdown menu.
mAirList will now retrieve the list of files currently known to the database, and scan the Windows folder for audio files (steps 1 and 2 from the list above). When finished, the Synchronize Storage dialog appears.
On the left hand side, you see the list of new audio files that have been discovered in the storage folder, not yet known to the database. On the right hand side, there is a list of missing files - those that are registered in the database, but that cannot be found in the storage folder anymore.
Add New Files
When the dialog appears, all new files on the left hand side are selected by default. You can hold Shift or Control and use the left mouse button to (de-)select ranges or individual files that you are going to add in this run.
Before you start with the import, adjust the Import Options according to your requirements:
- Disable Auto Cue: This will disable the Auto Cue feature, not setting any cue markers (Cue In, Fade Out, Cue Out) automatically. Useful when reporting advertising etc.
- Add to folder: Select the (virtual library) folder to which the new items should be added (see Managing Folders below).
- Preserve folder structure: If checked, mAirList will create subfolders in the selected (virtual) folder, and add items automatically to these subfolders, replicating the folder structure of the (Windows) storage folder.
- Set type to: Select the desired type for the newly added items, e.g. Music or Jingle.
When ready, click Import Selected Files, and mAirList will create library items for all selected files, removing them from the left-hand list.
Remove Items for Missing Files
The right-hand list in the Synchronize Storage dialog shows a list of “missing” files, i.e. those that have been imported into the database earlier, but are no longer (physically) present in the storage folder. This is typically the case when you have (deliberately) deleted some audio files in your storage, and now want to remove the items from the database as well.
By clicking the Delete Selected Items button, you can remove the library items (datasets) associated with these missing files.
Again, all items are selected by default, and you can use Ctrl or Shift and the mouse to select individual files or ranges of files.
Fix Renamed Files
As said earlier, you should never rename (or move) any files once they have been synchronized into the database. If you do, the renamed file will appear twice in the Synchronize Storage dialog: Once under its old name (as missing, on the right hand side), and once under its new name (as new, on the left hand side).
If it ever happens that you renamed a file, and want to fix the filename in the database library, select the new and the old filename (exactly one item from each list, left and right), then click Join Selected Entries. This will update the existing library item with the new filename.
If you batch renamed multiple files, you can use the Auto Repair function. It will look for files with similar names (you can adjust the “fuzziness” with the slider at the bottom of the dialog).
File Import
Alternatively, you can import files into the library by using the New Item button in the toolbar and selecting Import Files… from the drop-down menu. You can also drag files from Windows Explorer and drop them onto the library window.
In both cases, mAirList will copy the files into the selected storage folder and register the corresponding items in the library at the same time.
When the Import Files dialog opens, it shows the list of files that will be imported. In the Destination section, choose the target folder inside the selected storage. You can either type the folder name directly or click the … button to pick it from the folder tree.
Use Advanced Settings… to configure the import options for the selected destination. In particular, this is where you can adjust the target storage. Otherwise, the default storage (from the database settings, or folder properties) will be used.
Click Import to start the import process, or Cancel to close the dialog without making any changes.
Adding Other Items
The database does not only manage audio file items, but also any other kind of playlist item available in mAirList, including streams, containers, dummy items, etc.
To add such an item to the library, navigate to the library folder that you want to store this item in, then click New Item in the toolbar, and select the appropriate item type. The item properties dialog will appear, where you can adjust the properties of the item, and as soon as you click OK, it will be added to the library and the folder you navigated to.
Managing Folders
Folders are used to organize the items in your library. They can be found under the Folders node in the library tree.
Folders in mAirListDB are entirely virtual. They are not related to the Windows folders in which your audio files are stored (see Storages), and creating, moving or deleting a library folder will never touch any files on disk.
It is best to think of folders as categories: An item can be assigned to any number of folders, e.g. a song can be in both “Rock” and “80s” at the same time.
Folders can be nested, i.e. each folder can have any number of subfolders.
The Unsorted Folder
At the end of the folder list, there is a special folder named Unsorted. It always exists and cannot be renamed or deleted. It contains all items that are not assigned to any other folder.
Creating, Renaming and Deleting Folders
To create a new folder, click the New Folder button in the toolbar. The folder is created as a subfolder of the currently selected folder, or at the top level if no folder is selected. You can enter the name of the new folder right away.
To rename a folder, select it in the tree and press F2, or click its name once more, then enter the new name.
To move a folder (along with all its subfolders) to a different place, drag it with the mouse and drop it onto the new parent folder, or onto the Folders node to move it to the top level.
To delete a folder, select it and click Delete Folder in the toolbar. This will also delete all of its subfolders. The items are not deleted from the library; they are only removed from the deleted folder(s). Items that are no longer assigned to any folder will then appear in the Unsorted folder.
Assigning Items to Folders
There are several ways to assign items to folders:
- Drag one or more items from the item list and drop them onto a folder in the tree. This will move the items, i.e. remove them from the folder you are currently viewing. When you view something other than a folder (e.g. an artist or a search result), the items are removed from all other folders.
- Hold down the Ctrl key while dropping the items in order to copy them, i.e. add them to the target folder while keeping their existing folder assignments.
- Drop items onto the Unsorted folder in order to remove them from all folders.
- In the Item Properties dialog, the Folder Assignment section on the Scheduling tab lets you check or uncheck all folders the item should be assigned to.
When you import new files, you can also select the destination folder right away; see Adding Items above.
Creating, renaming and moving folders, and assigning items to them, requires at least the Folder Manager user level. The Folder Properties dialog (see below) requires the Manager level.
Show Items from Subfolders
By default, only the items assigned directly to a folder are shown when you click it. Enable Show items from subfolders in the View menu in order to also include the items from all subfolders.
Folder Properties
Right-click a folder and select Folder Properties to open a dialog with additional settings for that folder:
- General tab:
- Opener and Closer: Select a library item that will be inserted by the Mini Scheduler before (Opener) or after (Closer) any item it picks from this folder or its subfolders, e.g. a jingle announcing a particular music category. An opener or closer set in the item’s own attributes takes precedence.
- File Import: Check Override import settings for this folder and click Edit… in order to use different file import settings when importing files into this folder, e.g. a different storage.
- Standard Attributes tab: Define additional Standard Attributes that only apply to items in this folder. They will only appear in the Item Properties dialog when the dialog is opened from this folder’s view in the Database app.
- Smart Folder tab: Turn the folder into a Smart Folder, see Smart Folders below.
- Scheduler tab: Check Override default Mini Scheduler settings for this folder in order to use different scheduling settings (e.g. separation rules or selection strategy) when the Mini Scheduler picks items from this folder.
The settings on the General and Scheduler tabs are stored separately for each station. Standard Attributes and the Smart Folder configuration apply to all stations.
Smart Folders
A Smart Folder is a folder whose content is determined automatically by a search query, rather than by assigning items manually. Whenever you open a Smart Folder, it will contain all items currently matching the query. For example, you can create a Smart Folder “Short Songs” that contains all music items shorter than 3 minutes, and it will always be up to date as you add or edit items.
To create a Smart Folder, first create a regular folder (see above), then open the Folder Properties dialog and switch to the Smart Folder tab. Click Turn this folder into a Smart Folder, then click Edit… in order to set up the search query. The query uses the same criteria as the Advanced Search (keywords, title, artist, item types, duration, attributes, etc.). A summary of the query is displayed on the tab.
Smart Folders are displayed with a different icon in the library tree. As their content is controlled by the search query, items cannot be dragged into or out of a Smart Folder, nor can they be assigned to it in the Item Properties dialog.
Other than that, Smart Folders behave like regular folders. In particular, they can be used in scheduling just like any other folder.
To turn a Smart Folder back into a regular folder, click Disable Smart Folder on the Smart Folder tab. This removes the search query, and the folder will contain the items that were assigned to it manually before it was turned into a Smart Folder (if any). Items can be assigned to it manually again.
Managing Items
This section describes how to edit the properties and cue markers of library items, either one at a time or several at once.
Item Properties
To view and edit the properties of a library item, right-click it and select Properties, or double-click it while the Edit click mode is selected in the toolbar.
The Item Properties dialog consists of a number of tabs, some of which only appear for particular kinds of items (see below). At the bottom of the dialog, you will find:
- Playback controls (play/pause, END MON and a position slider) to preview the item.
- The Export… button, which lets you save the item’s metadata to the file tag, an MMD file or the database, or re-read the metadata from any of these sources.
- Two arrow buttons to save the current item and move on to the previous or next item in the list, without closing the dialog.
Click OK to save your changes, or Cancel to discard them. If mAirList detects inconsistencies in the item’s data (e.g. an empty filename), a warning is displayed, and you can choose to ignore it or go back to the dialog.
General
This tab contains the basic metadata of the item:
- Title and Artist.
- Type: The item type, e.g. Music, Jingle, Advertising, etc.
- Comment/Description: Free text, e.g. notes for the presenter.
- Ending: A short description of how the item ends, e.g. “fade” or “cold”.
- Duration: The total duration of the item. For audio files, it is determined automatically, and there is usually no reason to change it. One exception is a file that is downloaded and overwritten regularly from an external source, e.g. hourly news: Here you can enter a fixed “imaginary” duration, which is then used for scheduling and backtiming.
- Color: An optional color for the item in the playlist, overriding the color defined for its item type.
- Icon: An optional picture displayed with the item in the playlist.
- Internal ID: The database ID of the item (read-only).
- External ID: An optional ID, e.g. from an external music scheduler, used when importing playlists from external sources.
Audio File
This tab is shown for audio file items:
- Filename/URL: The location of the audio file.
- Backup Filename and Cache Filename: These fields are managed automatically by the database, based on the Storage Redirection settings.
- Maximum Age: If set, the player will refuse to load or play the file when it is older than the specified number of minutes. This is useful for files that are updated regularly, e.g. weather or news. Enter an Alternative Filename in order to check the age of a different file than the audio file itself.
- Audio Levels: The peak, true peak and R128 loudness of the file. Click Analyze to (re-)determine these values.
Attributes
The Attributes tab shows the Standard Attributes as input fields on the left-hand side. Folder-specific Standard Attributes are included when the dialog is opened from the respective folder (see Folder Properties).
On the right-hand side, the list of Other Attributes shows all attributes of the item that are not Standard Attributes, as key/value pairs. You can add, edit and remove attributes freely in this list. Press the cursor-down key in the last row in order to add another row.
Playback
This tab contains settings that affect how the item is played:
- Options: A list of checkboxes that control the playback behavior of the item, e.g. Exclude from logging, Skip in automation mode, Avoid overlap with previous item or Don’t fade out in automation.
- Settings:
- Fade duration (ms): The duration of the fade when the item is stopped prematurely, e.g. manually, or by a fixed time item in automation. If empty, the fade duration set on the Settings tab of the Miscellaneous section in the configuration is used.
- Amplification (dB): The gain applied to the item during playback. Click Normalize to calculate the amplification automatically from the loudness of the audio file, using the target levels set in the Normalization configuration.
- Tempo (%) and Pitch (%): Change the playback speed and pitch of the item.
- Timing: Select how the item is handled by the playlist timing, e.g. Normal, Hard fixed time, Soft fixed time or Backtimed. For fixed times, enter the Fixed time, optionally check hourly in order to repeat the fixed time every hour, and set the Time frame in seconds.
- Actions on Start and Actions on Stop: Actions that are executed automatically when the item is started or stopped, e.g. switching the ON AIR mode or running a script.
Scheduling
This tab contains settings related to the database and scheduling:
- Folder Assignment: Check all folders the item should be assigned to. Smart Folders cannot be selected here.
- Don’t schedule before and Don’t schedule after: Restrict the period in which the Mini Scheduler may pick the item, e.g. for seasonal content.
- Hour Restrictions: A grid with one row for each hour and one column for each weekday. Click a cell to toggle whether the item may be scheduled in that hour. Click an hour or a column header in order to toggle the entire row or column, respectively; Shift+click an hour to allow only that hour on all days.
- Apply date and hour restrictions to all stations: By default, the date and hour restrictions are stored separately for each station; check this box in order to use the same restrictions for all stations.
Editing these settings requires the Manager user level.
History
This tab lists all times the item was played, with date and time, duration, the studio it was played from, and the number of listeners at its start and stop (if available). Click Export… to export the list.
Item Type Specific Tabs
Depending on the kind of item, additional tabs are available:
- Stream: The stream URL, the reconnect timeout after a lost connection, and the fade-in and silence detection durations.
- Live Feed: The record device, an optional delay, and the fade-in and silence detection durations.
- Content (containers): The list of items in the container. Use Load… to fill the container, or open the Mix Editor to arrange the items.
- News Container: The content and imaging items of the news container.
- Container (auto file containers): The source folder and filename pattern of the files to include, a limit for the number of items, and the sort order.
- Region Content (region containers): One tab for each region with its content, plus the auto fill option and filler item.
- Hook Container: The number of songs to include.
Cue Editor
The Cue Editor tab of the Item Properties dialog lets you set the cue markers of an item, which control how it is played and mixed with other items. It shows the waveform of the audio file at the top, and the list of cue markers below.
Options for the Cue Editor, including the waveform appearance and the selection of favorite markers, are found in the configuration.
Cue Markers
The following cue markers are available:
- Cue In: The position where playback starts.
- Fade In: The end of the fade-in, starting at Cue In.
- Ramp 1, Ramp 2, Ramp 3: The end of the instrumental intro of a song, i.e. the point where the vocals begin. Multiple ramps can be used for songs with more than one intro section.
- Hook In, Hook Fade, Hook Out: A short excerpt of the song (“hook”), used e.g. for teasers and hook containers.
- Loop In, Loop Out: A section of the file that is played repeatedly if the Loop function is enabled in the player.
- Outro: The beginning of the instrumental outro of a song.
- Start Next: The position where the next item in the playlist is started.
- Fade Out: The position where the item starts to fade out. If no Start Next marker is set, the next item is started at Fade Out as well.
- Fade End: The end of the fade-out, i.e. together with Fade Out, this determines the length of the fade.
- Cue Out: The position where playback stops.
- Preroll: Marks the end of a lead-in at the beginning of the item. In automation, the item is started early, so that the Preroll position (rather than Cue In, or the beginning of the file) coincides with the end of the previous item. The effect is the same as moving the Start Next marker of the previous item forward by the length of the lead-in, but it is defined with the item itself, so it works regardless of which item is played before it.
- Anchor: The point of the item that is aligned to a fixed time, instead of its beginning.
If favorite markers have been selected in the configuration, the list is split into the tabs Favorites and All.
Each marker row provides a set of buttons:
- - and +: Move the marker backward or forward by 10 ms (100 ms with Shift, 1 second with Ctrl). You can also use the mouse wheel over these buttons.
- Reverse: Toggle between a position relative to the beginning and one relative to the end of the file. The latter is displayed with a minus sign, and remains correct if the length of the file changes.
- AUTO: Determine the position automatically using Auto Cue (available for some markers only).
- SET: Set the marker to the current playback position.
- Clear: Remove the marker.
- TEST: Start playback from the marker. For Cue Out, playback starts two seconds earlier; for Loop In and Loop Out, the loop is played.
- Zoom: Zoom the waveform to the position of the marker.
Double-click a marker row in order to test it. Shift+double-click it in order to enter the position manually.
Waveform
You can interact with the waveform using the mouse:
- Click anywhere on the waveform in order to jump to that position, or click a marker in order to jump to the marker position.
- Drag a marker in order to move it.
- Double-click the waveform in order to start playback.
- Use the mouse wheel in order to zoom in and out, and drag the waveform in order to scroll. The buttons next to the waveform allow you to zoom in, zoom out, show the entire file, and reload the waveform.
- If the volume envelope is displayed, drag the envelope line in order to add a new point, drag existing points to move them, or drag a point out of the waveform area in order to remove it.
The controls above the marker list allow you to start, pause and restart playback, switch between elapsed and remaining time, and run END MON.
Other
The Other tab lists additional cue data of the item (e.g. track markers), with its time, type and parameter. Click Import… in order to import the data from a cue sheet file.
Export
Use the File Tag, MMD and Database buttons at the bottom of the Cue Editor in order to save the cue markers right away, without closing the dialog.
Mass Edit
The Mass Edit dialog allows you to change several items at once. Select the items in the item list, right-click and select Mass Edit (this menu item is only available when more than one item is selected).
The dialog shows the list of selected items on the left-hand side. On the right-hand side, there is a list of fields and functions, each with its own button. When you click one of these buttons, the change is applied to all selected items:
- Title, Artist, Ending, Type, Comment: Enter the new value and click Apply. When all selected items have the same value, it is displayed in the field.
- Set Attribute: Select or enter the attribute name and value, then click Apply. The dropdown lists show all attributes used by the selected items, plus the Standard Attributes, and the values used for the selected attribute.
- Color: Click the color field to select a color, or Reset to remove the color, then click Apply.
- Amplification (dB): Enter the amplification and click Apply, or click Normalize to calculate it from the loudness of each audio file, using the target levels set in the Normalization configuration.
- Duration: Click Determine in order to re-read the duration from the audio files.
- Auto Cue: Run Auto Cue for Cue In, Fade Out, Cue Out, or All of them.
- Loudness: Analyze the loudness of the audio files.
- Re-read: Re-read the metadata from the File Tag, MMD file or Database.
- Export: Save the metadata to the File Tag, MMD file or Database.
If an error occurs for a particular item, you can choose to retry, ignore it, ignore all further errors, or cancel the operation.
Click OK to save the changes to the database, or Cancel to discard them. Note that exporting to the file tag or an MMD file writes these files immediately.
Import and Export
The Database menu of the Database app provides functions to export library items to files, e.g. in order to transfer them to an external music scheduler, and to import or update items from files.
Export
The Database -> Export submenu contains three commands, which differ only in the items being exported:
- Export Entire Library… exports all items in the library.
- Export Current View… exports all items currently shown in the item list, e.g. the content of a folder or a search result.
- Export Selection… exports only the items selected in the item list.
The same commands are also available from the dropdown menu of the Export button in the library toolbar.
After choosing one of the commands, select the export format, and then the destination file. mAirList remembers the last format and filename used. The following formats are available:
- CSV file: A CSV file with one line per item, which can be edited e.g. in Excel and imported back into the database (see Import below). The columns include the database ID, External ID, filename, title, artist, comment, ending, duration, all cue markers, amplification, audio levels, the Standard Attributes, and all other attributes used by the exported items.
- CSV file (without IDs): The same, but without database IDs, e.g. in order to import the items into a different database.
- CSV file (zero-padded IDs): The same, but with database IDs padded to 8 digits with leading zeros, for external software that requires this.
- Text file (custom format): A text file with one line per item. You will be asked
for the format of each line, which can contain any of the
Logging Variables, e.g.
%a - %b. - Playlist file: Exports the items as a playlist. You can choose any of the playlist formats supported by mAirList.
- Import files for external music schedulers: Several formats for transferring the library to external scheduling software, e.g. Powergold Import File, MusicGen Import File, MusicMaster Nexus, and Raduga Album/Rotation.
The CSV export uses a comma as delimiter by default; this can be adjusted with the
Delimiter and QuoteChar settings in the [CSVDBExport] section of mAirList.ini
(use \t for a tab).
Clone Database
The Database -> Export -> Clone database… command copies the contents of the current database into a new database. This is useful e.g. for migrating from a local database to an SQL server, or for creating a test copy of your production database.
In the Target section, choose whether to create a local database file (SQLite), or to copy the data into an SQL database. For the latter, enter the server type, hostname, database name, username and password. The SQL database must already exist and be empty.
In the Options section, choose which data to include in addition to the library:
- Include playlists, optionally only those not older than a particular date.
- Include playback history, again optionally limited by date.
- Include icons of the playlist items.
- Change Database ID to: Assign a new Database ID to the copy, so that it can be used alongside the original database (see Settings).
Import
The Database -> Import… command updates existing library items, or adds new items, based on the contents of a file. Select the file and its format in the file dialog. The following formats are available:
- CSV file: A CSV file as created by the CSV export (see above).
- CSV file (exact match): The same, but without matching by artist and title (see below).
- Files from other software: SAM4 CSV, SAM4 CSV New, DRS2006 v3 HRDat, Carmen digital.mdb, Carmen jingles.mdb, GSelector Song XML and GSelector Link XML.
CSV Import
A typical workflow is to export items as CSV, edit the file (e.g. in Excel), and import it again.
The file must be UTF-8 encoded. Both comma and tab are accepted as delimiters, and values may be enclosed in double quotes. The first line must contain the column names, as written by the CSV export:
ID,ExternalID,Filename,Title,Artist,Comment,EndTypeDurationand the cue markers (CueIn,FadeIn,Ramp1,Ramp2,Ramp3,HookIn,HookFade,HookOut,LoopIn,LoopOut,Outro,StartNext,FadeOut,FadeEnd,CueOut,Preroll,Anchor), in seconds with decimals, e.g.12.345Amplification(in dB),LevelPeak(dBFS),LevelTruePeak(dBTP) andLevelLoudness(LUFS)- All other columns are imported as attributes, using the column name as the attribute name.
The EffectiveDuration column written by the export is ignored on import.
Columns may be omitted, so you can e.g. import a file with just an ID and a Comment
column in order to update the comments of a number of items. A value of - (dash)
leaves the respective field of the item unchanged.
Folder assignments, playback options and cue data (see Other) cannot be exported or imported through CSV files.
For each line, mAirList tries to identify the existing library item as follows:
- If an
IDcolumn is present, the item with this database ID is updated. If no such item exists, the line is skipped. - Otherwise, if a
Filenamecolumn is present, the item with this audio file is updated. - Otherwise, if an
ExternalIDcolumn is present, the item with this External ID is updated. - Otherwise, if
ArtistandTitlecolumns are present, the item with the same artist and title (ignoring case) is updated. This step is skipped by the CSV file (exact match) format.
If no existing item can be identified, a new item is created: an audio file item if a
filename is given, or a dummy item otherwise. So in order to add new items, leave the
ID column empty, and make sure that the filename and External ID do not exist in
the library yet. Audio files must be located inside one of the configured
storages.
Import Preview
Before any changes are made to the database, the Import Preview dialog is shown. It has two tabs:
- Modified Items: Existing items that will be updated. Items whose data is unchanged are not listed.
- Unidentified Items: Items that could not be matched to an existing item.
Check Add unidentified item as new items to Library in order to add the unidentified items to the library as well. In this case, you can also select the folder to add them to (Add to folder), and an item type to assign to them (Set type).
Click OK to save the changes to the database, or Cancel to abort the import without making any changes.