Thanks for the hints on possible tag viewers for Win.
My tags are in order again and all necessary backups and scans have
been performed. And it worked! Thanks Erland!
For the potential benefit for others with similar wishes I detail how I
did it:
> Library consisting of
> MP3 files with ID3v2.3 tags; TYER for release (album) year and TORY for
> recording/original release/performance (track) year
> and
> flac files with Vorbis Comments; DATE for release (album) year and
> ORIGYEAR for recording/original release (track) year.
>
> Problem: SBS now lets the TORY tag take precedence over the TYER tag in
> MP3 and ORIGYEAR tags are not scanned at all in flac files.
>
> Change in Modules/CustomTag.pm the line
> 'TYER' => 'YEAR'
> to
> 'TYER' => 'TYER'
>
> In CustomScan module Custom Tag:
> Tags to scan: ORIGYEAR,YEAR,TYER (I have no YEAR tags but this is where
> SBS stores its year data)
> Tag mapping: TRACKYEAR=oneof ORIGYEAR|YEAR,ALBUMYEAR=oneof TYER|YEAR
> (this means as per Erland's explanation i.a. that the tag TRACKYEAR
> will be populated by ORIGYEAR data if it exists, else with YEAR data)
> Use raw MP3 tags: Checked (this makes CustomScan populate the TYER
> field from the TYER tag as per the change in the Modules/CustomTag.pm)
>
> Do a manual scan with Custom Tag.
>
> In CustomBrowse make two new Custom Tag Albums menus using the tag
> TRACKYEAR for one menu ("Trackyears" and the tag ALBUMYEAR for the other
> ("Albumyears"). This gives you one menu for years originally
> released/performed and another menu for years when an album was
> released.
I further tried to merge the two menues (Trackyear and Albumyear) into
one ("All years"). I used a Custom Tag Albums menu and in the Tag name
field in the form I wrote ALBUMYEAR since I did not think two tags were
allowed. I replaced the resulting xml code with the following:
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<menu>
<menuname>All Years</menuname>
<menuorder>50</menuorder>
<menu>
<id>customtag</id>
<menuname>Albums</menuname>
<pathtype>sql</pathtype>
<pathtypedata>
select distinct
customscan_track_attributes.value,customscan_track_attributes.value from
customscan_track_attributes
where
module='customtag' and
attr='TRACKYEAR' and
value='{context.itemid}'
or
module='customtag' and
attr='ALBUMYEAR' and
value='{context.itemid}'
</pathtypedata>
<customitemtype>customtagTRACKYEAR</customitemtype>
<menutype>sql</menutype>
<menulinks>alpha</menulinks>
<menudata>
select
customscan_track_attributes.value,customscan_track_attributes.value,
substr(ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value),1,1)
from customscan_track_attributes
where
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='TRACKYEAR'
or
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ALBUMYEAR'
group by customscan_track_attributes.value
order by
ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value)
asc
etc. where I supplemented every occurrence of 'TRACKYEAR' with a
corresponding OR statement containing instead 'ALBUMYEAR'.
--------------------
Unfortunately it did not work. Invoking the menu just choked SBS and
eventually I received a connection error in iPeng.
I have read the wiki and the tutorials but I have no clue what else I
have to do to get the result I want. The OR statement does not result in
an error in MySQL Query Browser.
--
vagskal
2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng
on iPod Touch, muso on remote computer running Win XP | 7.4.2 on Win XP
------------------------------------------------------------------------
vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
