Editing the music database
Only users with editor or administrator permissions may edit or combine database entries. Give editor permissions to DJs who volunteer to tidy the music database. For the rest of this section we assume you have permission to edit.
There are two database editing features. You can:
- Edit an individual item (i.e. an artist, a disk or a label entry) in the music database to add or correct details in that one item, or
- Combine multiple items that really ought to be just one item.
Editing individual items
The "info page" for an item shows the full details for that item in the database. It contains a link to the "edit info page" for the same item. Editing the item returns you to the info page. So you edit an item via its info page.
You access the info page for an artist, disk or label by clicking any instance of the item's name that's shown as a link. For example, clicking an artist name in a playlist (whether you are entering or viewing it), in a table of search results, or in the alphabetical database browser brings up the artist's info page. Such links can appear elsewhere too, for example, an artist or label info page lists the disks associated with that item, each of which links to a disk info page. This makes it very quick to correct details even while you're in the middle of something else.
Combining duplicate items
Errors in spelling or typing during data entry can easily lead to duplicated, redundant database items, e.g.
- Afro Cuban All Stars
- Afro-Cuban All Stars
- Afro-Cuban All-Stars
Such problems can be sorted out by combining redundant items. Users with editor or administrator permissions can combine items.
There are three starting points for choosing items to combine:
- The Music database browser
- A page of artist, disk or label search results
- The table of disks shown on an artist or label info page
Step 1. Choose the items you want to combine by using
- Search feature or Info page — mark the check boxes of all the rows you want
- Browse feature — click the © symbol to add items, during your selection you can:
- Navigate to other pages (of the same kind) – the list stays in place
- Move the list by dragging it's orange bar
- Click an item's X to remove it from your list
- Clear the list by clicking the X in the orange bar
Step 2. Click the combine button
Step 3. Select one item to keep and click the combine button. The other items are then deleted.
Resources belonging to the deleted items are reassigned to the kept one:
- Artists — disks belonging to deleted artists are reassigned to the kept artist
- Disks — songs belonging to deleted disks are reassigned to the kept disk
CAUTION when combining disks, take care not to create unwanted various-artists disks, as explained in combining disks below
- Labels — disks belonging to deleted labels are reassigned to the kept label
When combining disks, hover the mouse over a disk to see the artist name in a tool-tip. Artist names are also listed with the disk name in the combine list.
Combining disks is not as simple as combining artists or labels. If the disks you choose to combine involve more than one artist then a Various Artists disk will be the result. This can happen even when the disk is not a V/A disk if duplicate (i.e. redundant) artist entries are involved.
For example, say you spotted that there are three entries for the disk "A Toda Cuba le Gusta" by the Afro-Cuban All Stars. You want to combine them. But look closely:
- Afro Cuban All Stars A Toda Cuba le Gusta
- Afro-Cuban All Stars A toda Cuba le gusta
- Afro-Cuban All-Stars A Toda Cuba Le Gusta
Apart from the three different ways of typing the disk name, there are in fact three different artists here, all typed differently. If you combine these three disks you'll get a Various Artists disk with all three spellings of the Afro-Cuban All Stars appearing on it as different artists. Untidy!
Spinitron will warn you about such matters. When it detects more than one artist involved in a disk combination, it displays a detailed table setting out the artists and disks involved.
If you see this warning when you don't want to create a V/A disk then you typically need to go back and combine the artists before combining the disks. For example, search for artists (not disks) starting with "Afro" and combine the three artists Afro Cuban All Stars, Afro-Cuban All Stars, Afro-Cuban All-Stars into Afro-Cuban All Stars. Then click on the artist name Afro-Cuban All Stars to see the disks belonging to the artist and combine the redundant disks.