Add to Apple App Staging PlaylistAny Track database which has an Apple App PID column can add items directly to the Apple App staging playlist. Duplicate items will not be added. All selected or clicked rows will be added.
Show ArtworkDisplay the artwork viewer with the image in the clicked row. Same as double clicking on a thumbnail image.
Apply Cell Value to Selected RowsThe value in the cell where you clicked will be applied to the same column in all selected rows. Note that for columns which display a menu you can double click on a cell in the column, select a menu item and it will be applied to all selected rows.
Apply Clipboard to CellsThis function is used to copy the contents of the clipboard to cells in the clicked column. The rows affected are determined as in the Finder. If the clicked row is disjoint from the current selection, only the clicked row will be modified. If the clicked row is in the current selection, the entire selection will be modified.
Apply Database Values to Open FilesAll files open in the main Yate window which are represented in the database, will have their values updated to reflect the values in the database. Note that the value ??? used to represent multiple values will not be written. You cannot use this function to change the name of an album from an album database.
When inline editing values in a track or album database and the associated files are loaded, the files will automatically be updated. This feature can be disabled by the Settings - Databases - When updating automatically update loaded files setting. Note that the setting only affects inline edited cells in the database and is not applied to cells modified by a context menu function.
Update Database Values from Main Window FilesThis function is used to update entries in the database with the values of the currently displayed files in the main window. Any files currently open which cannot be located in the database, will be added.
Add Empty RowThis function is only valid on standalone databases and while not filtering. It adds an empty row to the end of the database.
Delete RowsThis function is used to remove entries from the database. The rows affected are determined as in the Finder. If the clicked row is disjoint from the current selection, only the clicked row will be deleted. If the clicked row is in the current selection, the entire selection will be deleted.
Hide Items With Data Equal to CellThe value of the data in the cell which is clicked will be used to filter the display. Note that the filter is case insensitive. Those rows have the same column value will be hidden. The rows supplying data to the filter are determined as in the Finder. If the clicked row is disjoint from the current selection, only the clicked row's column data will be applied. If the clicked row is in the current selection, column data will be used from every selected row.
Hide Items with Data not Equal to Cell
The value of the data in the cell which is clicked will be used to filter the display. Note that the filter is case insensitive. Those rows which do not have the same column value will be hidden. The rows supplying data to the filter are determined as in the Finder. If the clicked row is disjoint from the current selection, only the clicked row's column data will be applied. If the clicked row is in the current selection, column data will be used from every selected row.
Hide Selected ItemsAll selected items (rows) will be hidden.
Hide Selected ItemsAll selected items (rows) will be hidden.
Hide Items Not SelectedAll items (rows) which are not selected will be hidden.
Hide Items Without Today's Date any YearThis item allows you to locate all items with a date field in the current column which have today's date (any year). There must be at least yyyy-mm-dd data present in order for the filter to be applied.
Hide Items Not Equal to Cell's Date any YearAlmost the same as Hide Items Without Today's Date any Year except that the filter date is extracted from the clicked cell.
Advanced Filter...This item allows you to configure complex filters to hide files. Additional information can be found in Advanced Filtering.
Hide Items Matching Saved FilterThis item displays a list of saved advanced filters. A selected filter will be applied and used to hide items matching the filter.
Hide Items Not Matching Saved FilterThis item displays a list of saved advanced filters. A selected filter will be applied and used to hide items not matching the filter.
OpenThe contents of the folders specified in the Folder or File Path column of all effective rows will be opened in the main window. If you are in Playlist mode, a single track will be opened from a Track database. The effective rows are determined as in the Finder. If the clicked row is disjoint from the current selection, only the clicked row will be applied. If the clicked row is in the current selection, multiple albums will be opened. How these files are opened depends on the current Open Mode. Double clicking on a folder column item will have the same effect as this context menu entry.
Open WithIn Album and Track databases you can open the selected rows with The Open With Menu. When this menu item is selected from the context menu, the clicked row will be included in the list of selected files to be opened.
CopyCopy the contents of the clicked cell to the clipboard.
Deselect AllSelected rows can be processed by actions. Selecting rows is straightforward however deselecting all rows can be difficult.
Show Small/Large ThumbnailsThe Database Viewer can display thumbnails in two sizes. These entries toggle between the two sizes.
Refresh ThumbnailsIf the thumbnail image source is changed or if a folder.jpg file is changed, the thumbnails will not automatically refresh. This item will refresh the thumbnail display.
Show in FinderLocate the selected album or tracks in the Finder.
Show in Path FinderLocate the first selected album or track in the Path Finder application (when enabled in Settings - General).
Show Folder in File BrowserDisplay the folder associated with the first selected album or track in the File Browser.
Show Album in Track DBThis is only displayed in Album databases containing a Yate Album ID column. If you have specified a default Track database in Settings - Databases, the database will be loaded if necessary (it must have a Yate Album ID column). If a default Track database has not been specified, and an open database is a Track database containing a Yate Album ID column, it will be used. An attempt will be made to filter the referenced database to display the tracks contained in the selected album. Note that double clicking in a cell in the Yate Album ID column will have the same effect.
PreviewPlay the selected track(s). Only available in Track databases. Hitting the spacebar will have the same effect.
Query...Issue a query against the currently displayed items. More information can be found here
Look for Duplicates...Start the Duplicate Identification process.
Open URLLoads the selected URL in a browser. Note that fields containing Discogs and MusicBrainz IDs can be synthesized into URLs.
Open Discogs Wizard for Release ID...Opens the Discogs Wizard with a row's Discogs Release ID column's data. Note that due to the acquisition of Discogs Release Ids from MusicBrainz, an ID prefixed with an m actually represents a master.
Open Discogs Wizard for Master ID...Opens the Discogs Wizard with a row's Discogs Master ID column's data.
MusicBrainz Wizard for Release ID...Opens the MusicBrainz Wizard with a row's MusicBrainz Release ID column's data.
Set as Key ColumnMakes the clicked column the key column for the In file mode of the Open Database for Querying statement.
Create m3u File...A prompt will be issued to choose the location of an m3u file. The produced file will contain an entry for every non hidden item in the database regardless of the current selection. When producing the file, Yate will save it with a .m3u extension if the contents of the file can be saved with the Latin1 encoding. If the filenames contain non Latin1 characters, the file will be saved as a UTF8 file with the extension .m3u8.
Unless you choose the Write absolute paths option, Yate will attempt to write the file with relative paths whenever possible. A produced file will contain all relative or all absolute paths.
You can choose to write the file encoded in a Standard, Extended or Yate format. More information on the formats can be found in m3u File Formats. Note that the Extended and Yate formats will only work if the required fields are available in the database. Extended requires a title and timing field. Yate format requires a Yate Track ID field.
This function is only applicable in Track databases.
Create Apple App Playlist...This function is only valid in Track databases which have Apple App PID columns. You will be prompted for the name of a playlist which will be overwritten if it already exists. The specified name can use any of the Apple App Playlist Naming Conventions. All visible rows will be used when creating the playlist.
Add to Apple App Playlist...This function is only valid in Track databases which have Apple App PID columns. You will be prompted for the name of a playlist which will be created if it does not exist. The specified name can use any of the Apple App Playlist Naming Conventions. All selected rows will be used when adding to the playlist.
Clear Key Column StatusRemoves the key column status associated with the clicked column. The key column is used for the In file mode of the Open Database for Querying statement.
Lock/Unlock the DatabaseWhen a database is locked all updating and removing of items from the application's main window is disabled. When files are saved, no updating will occur regardless of the auto-update on save setting (in Settings-File List). The Open Database action statement's Update database values after opening option is also disabled. The only means of modifying content in a locked database from an action is via the Update Database and Remove Items from Database statements. Note that locking a database has no effect on editing within the database. When a database is locked, a lock icon is displayed in the window's title bar.
View Options...You can configure the view options for a database. These options include the colour and grid type to be used. Note that these options will override the default settings specified in Settings-Databases.
Note...You can edit and view a note which is retained in the database's associated plist file.
Make Alias on DesktopAn absolute symbolic link will be created on the desktop which references the database file. This really only makes sense if you make Yate the default application for the database's file type. You can do this as follows: In the Finder select a Yate database file. eg. mydb.csv. From the context menu do a Get Info. In the Get Info panel you can use the Open With drop down control to select Yate. If you wish you can make Yate the default application for all files of the same type. Note that a Yate icon will be associated with the file and alias.
Make this a standalone/track/album DatabaseYou can always change a Track or Album database to be Standalone via this menu item. Depending on the fields in the file and their encoding in the sidecar file, you may be able to change a Standalone database to be a Track or Album database. Warning: Standalone databases have no restrictions on editing fields. Any data can be placed into any field. Be careful when changing from a Standalone database to a Track or Album database. Note that the tooltip for this menu item displays the character encoding of the file when read.
Display Column Mappings...The column mappings will be displayed in the Log Viewer. Essentially export set metadata will be displayed.Cells in Rating, Love, and Yes/No columns can be edited inline, supplying numeric vales, or by double clicking on them. Yes/No columns will toggle. Rating and Love columns will display a menu with symbolic values.
Cells which were created as OOB or Variable columns and were assigned a qualifying popup menu will display the menu when a cell is double clicked. If inline editing was disabled, a single click will work if only one row is selected. When multiple rows are selected the cells in each row in the clicked column will be modified. Typically the menu text overwrites a cell's contents. If the Option key is down when the menu item is clicked, the text will be appended. Note that if the text to be entered is empty it will always overwrite.
Album databases which do not have a Yate Album ID field associate items by the Album field and folder path. Track databases which do not have a Yate Track ID field associate items by the file path. If the ID fields are not present and you rename or move your files or if you change the album name you will not be able to associate the files to the database. In this case you can use the file list context menu item Show Files in Database (Original) to locate the associated items in the database by using the original metadata obtained when the tracks were loaded into Yate.
Note that when viewing an Album or Track database, rows can be dragged outside the database: to the Finder to copy the files or folders; to the Yate main window to open the dragged items as if dragged from the Finder; to an Apple application to add files and/or add them to playlists, etc.
An action can open a database as being readonly. When a database is readonly, a red circle icon is displayed in the window's title bar. Note that when readonly, only manual editing of the database is disabled. The database can still be updated and changed via query database statements. Further, the database cannot be closed while an action is running.
An action can open a database as being transient. When a database is transient, a dim grey icon is displayed in the window's title bar. Note that when transient the database is also readonly. However, the contents cannot be saved via File&Save as the database files no longer exist.