| Author |
Message |
| Registered: May 26, 2007 |  Posts: 186 |
| | Posted: | | | | As of now the program counts/sorts like this:
1
10
100
11
111
2
3
4
etc.
I would really like it to count/sort correctly. | | | | "The only way to get rid of a temptation is to yield to it. Resist it, and your soul grows sick with longing for the things it has forbidden to itself, with desire for what its monstrous laws have made monstrous and unlawful." |
|
| Registered: March 20, 2007 | Reputation:  |  Posts: 2,851 |
| | Posted: | | | | Quoting DorianGray: Quote:
As of now the program counts/sorts like this:
1
10
100
11
111
2
3
4
etc.
I would really like it to count/sort correctly. It will, if you "spell" the number correctly: 001 002 003 004 010 011 100 111 --------------- |
|
| Registered: March 14, 2007 | | Posts: 5,734 |
| | Posted: | | | | Quoting DorianGray: Quote:
As of now the program counts/sorts like this:
1
10
100
11
111
2
3
4 That's not true, the program sorts like this:  | | | | Don't confuse while the film is playing with when the film is played. [Ken Cole, DVD Profiler Architect] |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 2,217 |
| | Posted: | | | | Quoting DorianGray: Quote:
I would really like it to count/sort correctly. It does sort correctly ... alphabetical  For numerical sorting you have to go the way of the leading 0, as scotthm already mentioned. The Sort-Titles are local, so you can fuc... change them however you like.  | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
| Registered: March 29, 2007 | | Reputation: |  Posts: 4,479 |
| | Posted: | | | | Quoting DorianGray: Quote:
I would really like it to count/sort correctly. +1 | | | | Images from movies |
|
| Registered: March 18, 2007 | Reputation:  | | Posts: 6,461 |
| | Posted: | | | | The plugin Bulkedit has a padding feature for some fields. If you try it and the field you need is not supported, let me know and I will fix it. I plan to update Bulkedit sometime soon. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | The feature I talked about is already implemented for the Slot field. DVD Profiler does not honor the leading zeros in Collection Number. I tested it. I didn't get any responses, so I didn't make any changes to Bulkedit, but in the future if there are text fields other than Slot you want to use Bulkedit for, you can:
Using Multicopy Tool 1 (Column copy), with the overwrite option:
(1) Copy the Slot field to Work1
(2) Copy the field to Slot
(3) Right click - pad Slot with 0's
(4) Copy Slot back to field
(5) Copy Work1 back to Slot
Then File > Save Validated Changes | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: by mediadogg |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,744 |
| | Posted: | | | | Quoting mediadogg: Quote:
The feature I talked about is already implemented for the Slot field. DVD Profiler does not honor the leading zeros in Collection Number. I tested it. I didn't get any responses, so I didn't make any changes to Bulkedit, but in the future if there are text fields other than Slot you want to use Bulkedit for, you can:
Using Multicopy Tool 1 (Column copy), with the overwrite option:
(1) Copy the Slot field to Work1
(2) Copy the field to Slot
(3) Right click - pad Slot with 0's
(4) Copy Slot back to field
(5) Copy Work1 back to Slot
Then File > Save Validated Changes If a movie starts with a number, e.g. 13 Going On 30, 11:14, The 13th Warrior then I will pad the number to 8 digits total. The sort titles become 00000011:14 00000013 Going on 30 00000013th Warrior | | | Karsten
DVD Collectors Online
 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 13,202 |
| | Posted: | | | | Quoting DJ Doena: Quote:
If a movie starts with a number, e.g. 13 Going On 30, 11:14, The 13th Warrior then I will pad the number to 8 digits total.
The sort titles become
00000011:14
00000013 Going on 30
00000013th Warrior I do the same thing, I just don't pad my numbers quite so high. | | | No dictator, no invader can hold an imprisoned population by force of arms forever.
There is no greater power in the universe than the need for freedom.
Against this power, governments and tyrants and armies cannot stand.
The Centauri learned this lesson once.
We will teach it to them again.
Though it take a thousand years, we will be free.
- Citizen G'Kar |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 17,334 |
| |
| Registered: March 20, 2007 | | Reputation: | | Posts: 2,851 |
| | Posted: | | | | Quoting TheMadMartian: Quote:
I do the same thing, I just don't pad my numbers quite so high. Some of us must, since the amount of padding is dictated by the highest numerical title. 00000007 Faces of Dr. Lao 00000007th Voyage of Sinbad 00000012 Angry Men 00000039 Steps 00000101 Dalmatians 00002001: A Space Odyssey 00002010: The Year We Make Contact 00020000 Leagues Under the Sea 20000000 Miles to Earth --------------- |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,744 |
| | Posted: | | | | Quoting TheMadMartian: Quote:
Quoting DJ Doena:
Quote:
If a movie starts with a number, e.g. 13 Going On 30, 11:14, The 13th Warrior then I will pad the number to 8 digits total.
The sort titles become
00000011:14
00000013 Going on 30
00000013th Warrior
I do the same thing, I just don't pad my numbers quite so high. I also don't have such a high number but I didn't want to risk buying a movie like 1,000,000 B.C. and then having to edit all my 2 Broke Girls, 21 Jump Street and 24 season and disc profiles. | | | Karsten
DVD Collectors Online
|
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 17,334 |
| | Posted: | | | | very good point... I currently went with 4 leading 0's. May have not been enough. | | | | Pete |
|
| Registered: March 29, 2007 | | Reputation: | | Posts: 2,749 |
| | Posted: | | | | I also went with 4 leading 0's (20,000 Leagues Under the Sea). If I had to add more I guess I could look at it as, it gave me something to do. | | | | Marty - Registered July 10, 2004, User since 2002. |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | Using BulkEdit MultiCopy Tool 4, Regex + Math: Regex Look for: ((^[0-9]+)(.*)) Check Math, Select CSharp and paste the following script (not including "Quote:" of course): Quote:
int paddedlen = 8;
int numlen = "$2".Length;
if (paddedlen > numlen)
{
return (new string('0',paddedlen-numlen))+"$1";
}
else return "$1";
You can choose to output directly back into the original column (e.g. Sort Title), or to a Work column. Of course, you need to set the paddedlen variable to whatever you want. Click "All" and go for coffee while the program makes the changes. When done, validate the results visually by clicking the sort header in BulkEdit, and if it looks good, just File > Save Validated changes. Note that you can save and reload scripts if you want to reuse them in the future. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: by mediadogg |
|
| Registered: May 30, 2008 | | Posts: 445 |
| | Posted: | | | | Quoting TheMadMartian: Quote:
I do the same thing, I just don't pad my numbers quite so high. Me too, but since I have less than 4,000 titles, I just out out to four spaces. But I also add a couple of other twists, since I have trouble remembering how a number is handled within a title. "Zero Dark Thirty" = 0000 Dark Thirty "One Day in September"= 0001 Day in September One Flew Over the Cuckoo's Nest= 0001 Flew Over the Cuckoo's Nest "2 Brothers & a bride: A Foreign Affair" 0002 Brothers & a bride: A Foreign Affair A great strength of Profiler is that we all get to do our own crazy thing without bothering anyone else ... |
|