Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-07 Thread sts78

Well this is my current artist-albums-tracks menu (filtered on a
special folder, the singles have their own menu), just like the
original SBS artists menu (some unnecessary tags included, too lazy to
tidy up ;) ):


Code:


  ?xml version=1.0 encoding=utf-8?
  custombrowse
menu
menunameAlben/menuname
menugroupMusik/menugroup
menuorder50/menuorder


menu
idvariousartist/id
menulinksalpha/menulinks
menunameDiverse Interpreten/menuname
menutypesql/menutype
menudata
select 
contributors.id,contributors.name,substr(contributors.namesort,1,1)
from contributors
where contributors.name='Diverse Interpreten' 
and 
{property:server:variousArtistAutoIdentification}=1
group by contributors.id
order by contributors.namesort asc
/menudata
menu
idalbum/id
menunameSongs/menuname
itemtypealbum/itemtype
itemformatalbum/itemformat
menutypesql/menutype
menudata
select albums.id,albums.title from 
albums
where albums.compilation = 1
group by albums.id
order by albums.titlesort 
asc,albums.disc asc
/menudata
menu
idtrack/id
itemtypetrack/itemtype
itemformattrack/itemformat
playtypeall/playtype
menutypesql/menutype
menudata
select tracks.id,tracks.title 
from tracks,albums
where tracks.audio=1 
and tracks.album={album}
group by tracks.id
order by 
tracks.disc,tracks.tracknum asc,tracks.titlesort asc
/menudata
menu
idtrackdetails/id

menutypetrackdetails/menutype
menudatatrack|0/menudata
/menu
/menu
/menu
/menu


menu
idartist/id
menunameAlbums/menuname
itemtypeartist/itemtype
menutypesql/menutype
menulinksalpha/menulinks
menudata
select 
contributors.id,contributors.name,substr(contributors.namesort,1,1) 
from 
contributors,contributor_album,albums,tracks
where contributor_album.contributor = 
contributors.id 
and contributor_album.album = albums.id 
and contributor_album.role in (1,5) 
and 
(
albums.compilation is null 
or albums.compilation=0 
or 
{property:server:variousArtistAutoIdentification} = 0
)
and tracks.album = albums.id 
and tracks.url like '%/share/Musik/Alben/%'
group by contributors.id 
order by contributors.namesort asc
/menudata
menu
idalbum/id
menunameSongs/menuname
itemtypealbum/itemtype
itemformatalbum/itemformat
menutypesql/menutype
jivepattern^(.*)\s\((.*)\)$/jivepattern
menudata
   

Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-07 Thread erland

sts78;661943 Wrote: 
 Well this is my current artist-albums-tracks menu (filtered on a
 special folder, the singles have their own menu), just like the
 original SBS artists menu (some unnecessary tags included, too lazy to
 tidy up ;) ):
 
 ...
 
 Maybe someone can tell me why this menu doesn't group the artists on
 iPeng, but the original SBS artists menu does (with the exactly same
 data load)?
Try to change:

Code:


  itemformatalbum/itemformat
  



In both places to:

Code:


  itemformatalbum/itemformat
  menulinksalpha/menulinks
  



I haven't tried if it works but as I remember it the
menulinksalpha/menulinks element should result in that it produces
textkey element which I think iPeng is using to produce the grouping.
Please note that this only works if the menu is sorted alphabetically
but this seems to be the case in this menu.


-- 
erland

Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets (both free and commercial)'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
Interested in music discovery ? See 'Social Music Discovery (SMD)'
(http://forums.slimdevices.com/showthread.php?p=656713) project.

erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


[SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread sts78

Hello,

I use iPeng via a squeezeslave htpc to play my music, and I use some
Custom Browse menus. (SBS 7.6.2 on a QNAP NAS, iPeng and CB most
current releases)

If I use the standards artist menus, iPeng groups the Artists by their
first letter (those little gray bars). But if I use the artist template
of CB, the output is quite the same, but without this grouping, just the
list of the artists. 

Is this a matter of iPeng or CB? If it is the latter case, how can I
achieve to get those bars?

Thx in advance
Steffen


-- 
sts78

sts78's Profile: http://forums.slimdevices.com/member.php?userid=50205
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread pippin

If you want to get the bars you have to make sure the output is
alphabetically ordered.
Leading Articles as listed in Settings-My Music in the SBS Web
Interface will be ignored by iPeng, so Robbie Williams, The Rolling
Stones would be an example of an alphabetically sorted list while
Tangerine Dreams, The Rolling Stones would not.
If your CB menu has a different order you might need to either change
the menu or the Ignored Articles in the setting I mentioned above.

I'm not 100% sure whether CustomBrowse might also deliver textkey
indexes for indexing. If it does, iPeng should always show the index so
probably not but maybe there is a way to include them, Erland would have
to tell.


-- 
pippin

---
see iPeng, the Squeezebox iPhone remote and 
*New: iPeng for iPad*, at penguinlovesmusic.com

pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread sts78

I have no leading articles, all my music is stored of the form Rolling
Stones, The and so on. Maybe ugly for some people, but very useful for
me. ;)
So I think the articles are not the problem in my case.

What do you mean with textkeys? Currently I used only the standard
artist template without going into the xml. But on some xml examples I
saw something like [..]substr(contributors.namesort,1,1)[..] as the
third field of the SELECT. Is this the textkey? Because when I dig into
the CB source code and look into the artist.xml template of CB, there is
only a select contributors.id,contributors.name from contributors.


-- 
sts78

sts78's Profile: http://forums.slimdevices.com/member.php?userid=50205
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread pippin

Actually yes, this looks like it. But then THIS should be sorted
correctly, shouldn't it?
How are accented characters handled on your server (where does it list
them)?

Have you simply created a new menu using the template? I'd give it a
try if yes. The CB menus I use now work fine...


-- 
pippin

---
see iPeng, the Squeezebox iPhone remote and 
*New: iPeng for iPad*, at penguinlovesmusic.com

pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread pippin

Oh. And where are Various Artists shown? And how many of these items
do you have?


-- 
pippin

---
see iPeng, the Squeezebox iPhone remote and 
*New: iPeng for iPad*, at penguinlovesmusic.com

pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread pippin

Just created a new menu based on the default artists menu template in CB
and it works fine for me.
Do you SEE anything that doesn't look sorted correctly in the menu?


-- 
pippin

---
see iPeng, the Squeezebox iPhone remote and 
*New: iPeng for iPad*, at penguinlovesmusic.com

pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread sts78

Just recreated an artist menu (third template in the CB list) from
scratch (after rescanning whole database and clearing ipeng cache).

No roles included, with various artists section checked, default sort
by title...

Result:
The artist list is sorted, the alphabetical list of letters on the
right side exists, various artists is the first entry before the
a-artists and after the play all entry. No artists with obscure
accents and so on (it's just a test drive machine). Artist count on the
list: 36. The original artist menu has the bars.

Did I miss something?


-- 
sts78

sts78's Profile: http://forums.slimdevices.com/member.php?userid=50205
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread pippin

50 items minimum :)


-- 
pippin

---
see iPeng, the Squeezebox iPhone remote and 
*New: iPeng for iPad*, at penguinlovesmusic.com

pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread sts78

But why is the original artist menu grouped with exactly the same number
of artists?


-- 
sts78

sts78's Profile: http://forums.slimdevices.com/member.php?userid=50205
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins


Re: [SlimDevices: Plugins] iPeng + Custom Browse: Grouping by letters in artist menu

2011-10-06 Thread pippin

Interesting question :)


-- 
pippin

---
see iPeng, the Squeezebox iPhone remote and 
*New: iPeng for iPad*, at penguinlovesmusic.com

pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777
View this thread: http://forums.slimdevices.com/showthread.php?t=90754

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins