Sort by date added or movie number

by **scottw** on Fri Feb 10, 2006 5:59 pm

I an using the Xant plugin to import my collection into XL. I cannot figure out the sort function. I want to have a button to list my movies from recently added to oldest.

1) I tried the Date added variable in ant ($$ITEM_dateadd) but it was not in date format, instead of 11/14/2003 I got 37939ED and I am not sure how to fix that.

2) I also tried to sort by movie number but it was sorting 1, 10, 11, etc... instead of 1,2,3.

3) How do I reverse the sort order??? I set a button to call Category>Set Sort Order and filled in the sort order field with the field I wanted it sorted by, but how do I reverse the sort on that (Accending/Decending)

Thanks,

by **lar282** on Fri Feb 10, 2006 10:18 pm

I think its -1:xxxxxx
like -1:sorttitle

by **scottw** on Mon Feb 13, 2006 12:56 am

Thanks lar282 that worked great. I had a feeling you would be the one to reply, I read your other post about a similar problem

Did you figure out the number sequence problem eg...1, 10, 11???

by **lar282** on Mon Feb 13, 2006 8:52 am

scottw wrote:Thanks lar282 that worked great. I had a feeling you would be the one to reply, I read your other post about a similar problem

Did you figure out the number sequence problem eg...1, 10, 11???

I cant remember my other problem. refresh my memory

//Lasse

by **scottw** on Mon Feb 13, 2006 12:43 pm

I was trying to sort buy movie number and it would sort 1, 10, 11, etc... instead of 1,2,3

Here is your post:
http://www.xlobby.com/forum/viewtopic.php?t=1450&highlight=sorting

Thanks for your help!!!

by **scottw** on Thu Feb 16, 2006 1:50 pm

Bumpin

Anyone know how to sort by movie number (as in 1,2,3 not 1, 10, 11)????

Thanks,
Scott

by **badubo** on Thu Feb 16, 2006 1:52 pm

put 01,02,03,...10,...

by **scottw** on Thu Feb 16, 2006 3:49 pm

Doh....don't know why that did not hit me, it's always the simple things.

I am using ANT with Xant. Is there any automated way to fix this instead of having to rename manually that you can think of???

Thanks!

by **badubo** on Thu Feb 16, 2006 4:00 pm

I take a look at ANT options, there is a possibility to prefix numbers but only when exporting.

Don't know what can be the solution except to manage this issue in XAnt. But all people don't want to have their number modified this way...

by **scottw** on Thu Feb 16, 2006 4:04 pm

no I understand completely!!!!

If you come up with a solution let me know.
Right now I am sorting by the date added option and it is working OK but by movie number would be best.

Thanks

by **stevenhanna6** on Fri Feb 17, 2006 2:15 am

i have a solution, what are you guys using as the field name for your movie number...its it literally "movienumber"? I can add some functionality to deal with this field.....right now I have this issue fixed for the "tracknumber" thats why you can use 1,2,3,10 there and they are sorted properly. Just tell me what the field name is and I will make a fix for it to treat it as a number...I also need to know what kind of values are found in this field do they go above 9999? or is it just a number that assigned to each dvd starting from 1?

by **dalanik** on Fri Feb 17, 2006 8:24 am

Speaking of XAnt/AMC, I have problem where movie rating (number with a decimal, i.e. 7.4) is shown in XLobby as 74 so it looks kind of funny to see:

Rating: 74 / 10.

in the database it looks like this:

<rating>74/10</rating>

If it was at least 74/100 it would manke sense... :-)

I dunno whether fault is in XAnt or AMC or XLobby (most probably XAnt since it makes the database from AMC)

D.

by **badubo** on Fri Feb 17, 2006 9:48 am

i have a solution, what are you guys using as the field name for your movie number...its it literally "movienumber"? I can add some functionality to deal with this field.....right now I have this issue fixed for the "tracknumber" thats why you can use 1,2,3,10 there and they are sorted properly. Just tell me what the field name is and I will make a fix for it to treat it as a number...

For me, it will be better to create a generic field, not called "movienumber" (too much related to movies), but may be something like "itemnumber" that should be always considered by xlobby as integer so we can use an integer based sort for all kind of databases.

I also need to know what kind of values are found in this field do they go above 9999? or is it just a number that assigned to each dvd starting from 1?

Does it matter ? If the item is treated as integer, I guess that any sort algorithm will work

I dunno whether fault is in XAnt or AMC or XLobby (most probably XAnt since it makes the database from AMC)

You probably right, I have to confirm, but probably that AMC stores the rating value multiplied by 10

by **lar282** on Fri Feb 17, 2006 11:56 am

scottw wrote:I was trying to sort buy movie number and it would sort 1, 10, 11, etc... instead of 1,2,3

Here is your post:
http://www.xlobby.com/forum/viewtopic.php?t=1450&highlight=sorting

Thanks for your help!!!

I use the item "number" and that works for me. I think Steven did something special with this one already!!Ususally its collectionnumber but that does not work.

I use dvdprofiler so maybe it's differrent with Ant..

//Lasse

by **scottw** on Fri Feb 17, 2006 5:07 pm

lar282 wrote:
scottw wrote:I was trying to sort buy movie number and it would sort 1, 10, 11, etc... instead of 1,2,3

Here is your post:
http://www.xlobby.com/forum/viewtopic.php?t=1450&highlight=sorting

Thanks for your help!!!

I use the item "number" and that works for me. I think Steven did something special with this one already!!Ususally its collectionnumber but that does not work.

I use dvdprofiler so maybe it's differrent with Ant..

//Lasse

I tried this and using -1:number but it started at 99, like 99,98,97

using 0:number did 1,10,100 :?:

Keep the ideas coming