MobileSheets Forums
How to delete all songs with no genre? - Printable Version

+- MobileSheets Forums (https://www.zubersoft.com/mobilesheets/forum)
+-- Forum: Support (https://www.zubersoft.com/mobilesheets/forum/forum-1.html)
+--- Forum: MobileSheets (Android) (https://www.zubersoft.com/mobilesheets/forum/forum-23.html)
+--- Thread: How to delete all songs with no genre? (/thread-6278.html)



How to delete all songs with no genre? - Beemer - 04-01-2020

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


RE: How to delete all songs with no genre? - Geoff Bacon - 04-01-2020

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


RE: How to delete all songs with no genre? - Beemer - 04-01-2020

(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



RE: How to delete all songs with no genre? - KHS - 04-05-2020

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


RE: How to delete all songs with no genre? - Beemer - 04-05-2020

(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



RE: How to delete all songs with no genre? - KHS - 04-05-2020

(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!


RE: How to delete all songs with no genre? - MarDer - 02-03-2023

(04-05-2020, 08:25 AM)KHS Wrote:
(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!
did you found a solution for this problem?


RE: How to delete all songs with no genre? - MarDer - 02-04-2023

the answer form the support (so easy...) :

you can add the composers tab under Settings->Library Settings->Tab Selection and Order.