When I try to run a report by disc number my numbering is out of whack. I have over 4000 titles and want to list these by disc number. This is the sequence I am getting when I do this. Any help on this subject is appreciated.

#1
#100
#1000
#1001
#1002
#1003
#1004
#1005
#1006
#1007
#1008
#1009
#101
#1010
#1011
#1012
#1013
#1014
#1015
#1016
#1017
#1018
#1019
#102
#1020
#1021
And so on and so on. Why is it doing this?
Thanks

P.S. Yes I have discs for the missing numbers.

This is because data is alphanumeric and the order is then alphabetic : so 102 is before 1020 but after 1019.
To get the right order, all disk# must have the same number of digits.
A disc# numbering tool plugin is currently under development but you can already get things ok with the following :
- Switch to JeF's interface (F10 > user interface)
- Go to db tool page (gear icon)
- Click 'Edit Sql Requests File (advanced users)' and copy paste following lines at bottom of file
- Make sure there's is no blank space inserted before Z...
- Make sure id 0112 is not already in use (replace it with 0125 for instance if it is)
- Save and close file
- Back to Movienizer, click 'Reload Sql Requests File'
- You'll then see a new line 'Format Disc # to have 4 digits'
- Click that link and disk# numbers which length is under 4 digits will all be reformated to have one more leading 0
- Click again that link 2 more times to make sure all disk# are processed (even the shortest like '1', '2', and so...)
- Go back to your prefered interface (F10 > user interface)


JeF

that is way to much crap for me to understand and do. I switched to Jeffs interface but when I click on "Tools" I do not see what your mentioning. The only options I have are
Create Dune Catalog
Import from text file
Update scripts
Options

thats all I can do from the TOOLS section.

When will the plugin for this be ready?
Cannot believe such a nice program doesn't have a basic numbering system!

You should download and run this plugin once:
viewtopic.php?f=21&t=2920