Create Database Utility

This action sets up configuration information to optionally perform the following via the Batch Processor:

• Create an album database
• Create a track database
• Fill preference lists
• Create an Artist Reference database
• Write Yate Album IDs
• Write Yate Track IDs
• Create folder.jpg files

Track and Album databases have their column information defined in Export Sets. Sample export sets are provided to help you get started: Create Database Utility - Track and Create Database Utility - Album. Before you use these sets it is strongly advised that you look at these export sets in Preference - Export Sets. You can add and remove columns to meet your requirements. It is recommended that you do not modify the sample sets but rather duplicate them prior to making changes. This is so that you do not lose your modifications on subsequent action updates. A sample export set which has sufficient information to perform a look for duplicates function on a track database is also provided.

The action displays the following panel:

Note that the Create artist reference database row is only displayed if the Artist Reference Database suite of actions (v7.0 or greater) is installed.

The help button displays a usage summary. It also displays a link to display this document. To display row specific help, select a row and press the spacebar.

If you close the settings panel via the Save & Exit button, the settings will be saved and the action will terminate.

If you close the settings panel via the Run button, the settings will be saved and batch processing will start.

The Profile button provides support for saved profiles. You can create and remove profiles from the displayed menu. Selecting a profile name in the menu will load the associated profile. A profile named ❨Initial Settings❩ is always displayed. Selecting this profile will restore the settings in effect when the action was first started. This profile is always restored if you exit via the Cancel button. Note that Artist Reference database settings are not preserved in a profile. The Artist Reference database configuration panel has its own profile support.

This action uses the batch processor. For security reasons, you will be asked if you want to start the process. You can disable this behaviour via the Enable Batch Processor auto start from Stop Action and Run Batch Processor setting in Preferences - Actions. The action will also attempt to automatically close the Batch Processor's panel when processing is finished. In order for this to work you have to enable the Automatically close the Batch Processor panel when done setting in Preferences - Actions.

If you want to create a database you must enable it via the Create track database and/or the Create album database settings. When enabling one of these settings, other settings will be enabled.

For each database being created you must specify a location for the database files. Click on the file icon to the right of the field to select a location. The export set row must be supplied the name of an export set to use. Use the icon to the right of the field to select an appropriate export set.

Album and track databases offer a large degree of interoperability with Yate including the ability to display per row artwork. These databases have minimum requirements: a File Path column for Track databases and Album and Folder columns for an Album database. When a database is standalone the column requirements are eliminated. The produced databases have no interoperability with Yate. A plist sidecar file is still produced so that font sizes, background colours, etc. can still be changed, however it may be discarded. Regardless of the Standalone setting, a Track database always contains one row per track and an Album database contains one row per album. When standalone is enabled, the list of export sets displayed on the track/album database Export Set row's associated menus, is modified.

It may be convient to fill your preference lists on the same run of the batch processor. When the Fill lists row is enabled, the control to the right of the row will display a panel listing all fields mapped to a preference list and the Involved People and Musician Credits fields. You can select any combination of these fields to be fill the preference lists. Note that the fields add to whatever is currently in the preference lists and will not overwrite existing entries.

If you select Involved People or Musician Credits as a field to be examined when filling, you must supply the target list for the field. Logically, Musician Credits would be associated with the Artist field but you can choose any list that you desire.

If you have installed the Artist Reference Database suite of actions you can elect to create the database. When selecting Run, the Artist Reference Database suite's configuration process may be run if there are issues. You can manually run the configuration process by clicking on the control to the right of the Create artist reference database row.

The Source folder is the root folder to be passed to the batch processor. ie. it contains (directly or in subfolders) the audio files to be processed.

While not required it is a good idea to use Yate Track and Album IDs in your files when using databases. If you rename some tracks and forget to update the track database, you can always locate them via their Yate Track IDs. Further, if you set the Preferences - Default track database setting, you can display all tracks in an album from within an album database. There are two settings which support the creation of IDs. The possible values for each are:

Never

Never create the associated ID.

If Missing

Only create the associated ID if an audio file does not already have the ID.

Always

Always create the associated ID.

Note that if an ID is created in an audio file, it will be written.

If Create artist reference database is enabled, and Create Yate Album IDs is set to Never, it will be changed to If Missing when the batch processor is run.

Track and Album databases can display an artwork thumbnail on each row. The best method of doing this is to have folder.jpg files in every folder containing audio files. There is a setting to create folder.jpg files. The three possible values are the same as for the IDs.

The Open produced databases when done setting will open a created track and/or album database when the batch processor terminates.

While the action is named Create Database Utility, it is not mandatory to have it create a database. As long as one function is enabled, the action can be run.

Content List, Requirements & History

Actions:

Folder: Create Database Utility

Create Database Utility

Create Database Utility - Batch Processor

Export Sets:

ARDB: Artist DB

Create Database Utility - Track

Create Database Utility - Album

Create Database Utility - Look for Duplicates

Requirements:

Yate v6.18

History:

Download