Application icon

Create Database Utility

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

Track and Album databases have their column information defined in Export Sets. Two sample export sets are provided to help you get started: Create Database Utility - Track and Create Database Utility - Album. Before you run this action 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.

The action displays the following panel:




Permute Panel


The help button displays context sensitive help for the selected row. To display this document, hold down the Option key while clicking on the help button.

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 processing will start.

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've created profiles, there will be a Profile button which will display a menu containing the list of defined profiles. Selecting a profile will load its values. The menu will also have a Save as Profile item. If you specify the name of a profile which already exists, it will be overwritten. Remove Profiles will display a panel allowing you to select those profiles you want to delete.

If you close the panel via the Cancel Action button, the current settings will not be saved and the action will terminate.


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 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 they 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.

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.

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 does what you would expect.

While the action is named Create Database Utility, it is not mandatory to have it create a database. As long as one database is being created or an ID potentially is being written or a folder.jpg file is potentially being written, the action can be run.



Content List, Requirements & History


Content List:

Action : Create Database Utility

Action : Helper: Create Database Utility - Process

Export set: Create Database Utility - Track

Export set: Create Database Utility - Album

Requirements:

Yate v6.10.1

History:


Date Version Information
2022-05-18 v1.0 First release.
2022-05-27 v1.1 Added Standalone and Open options.

Download


Back to Yate Resources