• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to delete all songs with no genre?
#1
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
Samsung Galaxy Note Pro 12.2 Android 5.0.2,  AirTurn BT-105
Reply
#2
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
Samsung Galaxy Tab A6
Reply
#3
(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
Samsung Galaxy Note Pro 12.2 Android 5.0.2,  AirTurn BT-105
Reply
#4
(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.
Reply
#5
(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
Samsung Galaxy Note Pro 12.2 Android 5.0.2,  AirTurn BT-105
Reply
#6
(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!
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.