• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
sorting lists with and without leading 0 numbers
#1
Hi,

i have some really different collections of songs. Some of them where numbered with leading 0 numbers some of them not.

Windows would sort numbers with and without leading 0 "correct" which would look like this:
Code:
001
002
3
10
22
31
105

But in MobileSheets the same list would look like this:
Code:
001
002
10
105
22
3
31

Would it be possible to improve the sorting of songs like windows does?
I know it would be much better to have a better file-naming. But it is hard to rename 2000-3000 songs ;-)

Best regards,
Bond
Reply
#2
I already have a sorting mode like that for the Songs tab (tap the sort option at the top and switch to "Numerically").  In theory, I could use this sorting algorithm as the default for alphabetic sorting which would handle both, but it's a slower sorting algorithm, so it would provide worse performance than the standard A-Z sorting. There are scenarios where this may matter, especially if the number of songs grows beyond 10000. So I would prefer to just add the numerical sorting option as an option for sorting groups (as I'm assuming that's what you need).

Mike
Reply
#3
@Bond246: please consider making your number scheme consistent.
@Mike: I really don't like that windows sorting scheme and switch it off all the time
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#4
@Bond246

When naming files it is nearly always best to use a format so that they can be sorted alphabetically e.g. for dates using yyyy-mm-dd rather than dd-mm-yyyy.

It sounds as though your files have a number at the start followed by some text. Your best bet is to rename the files so that the numbers are all the same length (i.e. prefix small numbers with the required number of '0' characters). There are "tools" on the web that will do batch renaming but how easy it is may be dependent on the remaining text in the filename.

I suggest you copy all the files into a directory on your main pc and experiment renaming them into your desired order.
When happy,  recreate your MSP library with the renamed files. 
Obviously, this won't be ideal if your existing library contains lots of metadata which would need to be reentered.

Another possibility is that you use SQL operations to rename the Title entries in the MSP library (leaving the actual file name unchanged). This is beyond my knowledge (make sure you backup the MSP database before attempting to change it!). One disadvantage of this is that there is a mismatch between the MSP name and the physical filename and this may make updating files difficult (use the Swap feature in the companion?). Sciurius  has some SQL tools - perhaps one of those can be modified to do what you want.

Whichever way you choose sounds a lot of work!

Geoff
Samsung Galaxy Tab A6
Reply
#5
I would use the batch rename feature of Total Commander to rename the files https://www.ghisler.com/ddownload.htm
and Sciurius' MSPro-Tools to adapt the database https://github.com/sciurius/MSPro-Tools
Check with MSP's "find missing files" if everything's OK
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#6
Hi,

all of you are absolutely correct! The best would be to rename all files where all files have the same number-length.

In our choir a man beside 80 years old unsalaried generates our music an filenames. I'm the only one using MobileSheets.
So in my case i should rename the files for me which would be fine. But within some months i replace all the files because i don't know which part of all the files the man changed during this time.

So in this case i would need to rename again all files...
Or in my case it would be better to have a number based sorting option.

The numerical sorting option in song-list tab as an option in all other tabs would be fine. 

Thanks for your help. 
I definitly will look into it changing filenames with total commands batch options.

Bond
Reply
#7
Thanks at first again for this great app that has made the musicians life so much easier!

I would like to chime in with the request to do sorting (as it already is) with the possibility to do ascending and descending sorting. I have e.g. my setlists named like "2019-12-24 Churchservice Christmas" or 2020-01-29 Special Event" and ever in the lists (e.g. when you add new songs) the most new setlist is down at the bottem. As the setlists are bound to get more I need to scroll all the way down to the bottom to e.g. add songs to the recent setlist...

Can there be a "per menu" switch for ascending oder descending order that will be remembered?
Reply
#8
I've previously suggested this to others:

When creating a setlist, put a leading space at the beginning of the name; this displays the list at the top of the page (when the lists are sorted alphabetically)
After the event, remove the leading space so that it sorts as at present.

I notice you have the date at the front; I put the name of the venue/event there with the date at the end. This means that each venue is sorted together (in your method, multiple venues will all be intermixed because you are effectively only sorting on the date)

Hope this helps
Geoff
Samsung Galaxy Tab A6
Reply
#9
McConner - Tap the "Sort: A-Z" option at the top of the screen and you will see a checkbox for "Ascending". Just uncheck that if you want descending sort order.

Mike
Reply
#10
(03-06-2020, 07:06 PM)Zubersoft Wrote: McConner - Tap the "Sort: A-Z" option at the top of the screen and you will see a checkbox for "Ascending". Just uncheck that if you want descending sort order.

Mike

This works great for the setlists - didnt see this before. Thanks! But if you were to edit or add a song and in the song properties want to add the song to a setlist this list will be sorted ascending with no possibility to change that... Or is there some hidden button somewhere?
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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