MobileSheets Forums

Full Version: How to delete all songs with no genre?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
As I wait for a reply to my database post I am trying without success to delete all songs that have no genre set.   How do I do this?
Ian
Go to the Songs display
Tap the 3 vertical dots (top right)
Tap "Show Filters"
On the Genre (middle of 3rd line), press the down triangle
Set the Mode to UnAssigned (or alternatively Select All and set Mode to Exclude)
The resultant display should be solely those without a Genre

Long Press one of the songs until the tick shows
Select all songs by tapping the open square box (bottom right)
Delete Song (top line)

When doing major operations like this, it is always a good idea to make a backup before you start - this gives you something to recover to if you haven't quite got it right.
I do this with the Companion (it requires a window pc) because this means the backup is not on the same device as the MSP installation.

Geoff
(04-01-2020, 09:55 PM)Geoff Bacon Wrote: [ -> ]Go to the Songs display
Tap the 3 vertical dots (top right)
Tap "Show Filters"
On the Genre (middle of 3rd line), press the down triangle
Set the Mode to UnAssigned (or alternatively Select All and set Mode to Exclude)
The resultant display should be solely those without a Genre

Long Press one of the songs until the tick shows
Select all songs by tapping the open square box (bottom right)
Delete Song (top line)

When doing major operations like this, it is always a good idea to make a backup before you start - this gives you something to recover to if you haven't quite got it right.
I do this with the Companion (it requires a window pc) because this means the backup is not on the same device as the MSP installation.

Geoff
Geoff,
Thanks I tried your suggestion but on deleting the 4551 songs MobileSheets crashed.  I'll keep trying.
Ian
(04-01-2020, 10:32 PM)Beemer Wrote: [ -> ]
(04-01-2020, 09:55 PM)Geoff Bacon Wrote: [ -> ]Go to the Songs display
Tap the 3 vertical dots (top right)
Tap "Show Filters"
On the Genre (middle of 3rd line), press the down triangle
Set the Mode to UnAssigned (or alternatively Select All and set Mode to Exclude)
The resultant display should be solely those without a Genre

Long Press one of the songs until the tick shows
Select all songs by tapping the open square box (bottom right)
Delete Song (top line)

When doing major operations like this, it is always a good idea to make a backup before you start - this gives you something to recover to if you haven't quite got it right.
I do this with the Companion (it requires a window pc) because this means the backup is not on the same device as the MSP installation.

Geoff
Geoff,
Thanks I tried your suggestion but on deleting the 4551 songs MobileSheets crashed.  I'll keep trying.
Ian
Has there been a resolution to this? I'm trying to figure out how to delete all Composers no longer connected to any song.
(04-05-2020, 03:54 AM)KHS Wrote: [ -> ]
(04-01-2020, 10:32 PM)Beemer Wrote: [ -> ]
(04-01-2020, 09:55 PM)Geoff Bacon Wrote: [ -> ]Go to the Songs display
Tap the 3 vertical dots (top right)
Tap "Show Filters"
On the Genre (middle of 3rd line), press the down triangle
Set the Mode to UnAssigned (or alternatively Select All and set Mode to Exclude)
The resultant display should be solely those without a Genre

Long Press one of the songs until the tick shows
Select all songs by tapping the open square box (bottom right)
Delete Song (top line)

When doing major operations like this, it is always a good idea to make a backup before you start - this gives you something to recover to if you haven't quite got it right.
I do this with the Companion (it requires a window pc) because this means the backup is not on the same device as the MSP installation.

Geoff
Geoff,
Thanks I tried your suggestion but on deleting the 4551 songs MobileSheets crashed.  I'll keep trying.
Ian
Has there been a resolution to this? I'm trying to figure out how to delete all Composers no longer connected to any song.

Yes this worked for me, I suggest you use the same instruction substituting Composer for Genre
Ian
(04-05-2020, 08:05 AM)Beemer Wrote: [ -> ]
(04-05-2020, 03:54 AM)KHS Wrote: [ -> ]
(04-01-2020, 10:32 PM)Beemer Wrote: [ -> ]
(04-01-2020, 09:55 PM)Geoff Bacon Wrote: [ -> ]Go to the Songs display
Tap the 3 vertical dots (top right)
Tap "Show Filters"
On the Genre (middle of 3rd line), press the down triangle
Set the Mode to UnAssigned (or alternatively Select All and set Mode to Exclude)
The resultant display should be solely those without a Genre

Long Press one of the songs until the tick shows
Select all songs by tapping the open square box (bottom right)
Delete Song (top line)

When doing major operations like this, it is always a good idea to make a backup before you start - this gives you something to recover to if you haven't quite got it right.
I do this with the Companion (it requires a window pc) because this means the backup is not on the same device as the MSP installation.

Geoff
Geoff,
Thanks I tried your suggestion but on deleting the 4551 songs MobileSheets crashed.  I'll keep trying.
Ian
Has there been a resolution to this? I'm trying to figure out how to delete all Composers no longer connected to any song.

Yes this worked for me, I suggest you use the same instruction substituting Composer for Genre
Ian
Thanks, Ian. So your crash proved unrelated to the procedure? In your example, you were deleting Songs that had or lacked a certain attribute. I only want to delete Composers values that have no Songs associated with them. I'm very cautious!