[marantz]

I installed beta1 and scanned the album, it shows up twice in kodi too.. wonder why this didnt happend when I did my entire libary

[marantz]

http://pastebin.ca/3725893 here is output of that query with mysql 5.7.15
http://pastebin.ca/3725895 with mariadb 10.0(10.1 is same)

so yes there is difference

edit: just to be sure I tested in kodi with mysql 5.7.15 with this db and it works there.

[DaveBlake]

You probably know this, but it's generally not a good idea to expect a certain kind of sorting from a database, especially if you don't know what kind of database engine you are querying. Without ORDER BY, record order is usually undefined, so, taking a certain kind of result for granted can backfire, as seen here.

Yes I know, but since no queries had ORDER BY when I arrived, I accepted it and continued the trend. Bad decision
It really is hard when comming to an established project just how much you meddle, and how much you blend in with the existing approach. I always assume that those who where here before me knew what they were doing, it is my job to deduce their reasoning. In this case processing is order dependent, so an ODER BY is needed.

Marantz thank you for independently confirming the problem.

A fix will be comming soon

[Zaister]

I understand what you're saying there, I have been working on FOSS projects myself.

[DaveBlake]

OK there is a build here KodiSetup-20161008-ef6f476-MusicTest02.exe (and similar on mirrors for other palforms).

This solves the issue of duplicate songs when artist roles e.g. composer or orchestra, tagged appearing on MariaDB servers - try out Stefan and Marantz just for confirmation?

It also has compliation flag and lastplayed as album playlist rules - you can create own node for recently played compliations, exclude complilations from album lists etc. Maybe try that out too?

Recently played compilation albums playlist

Code:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="albums">
    <name>Last Played Compilations</name>
    <match>all</match>
    <rule field="compilation" operator="true" />
    <limit>25</limit>
    <order direction="descending">lastplayed</order>
</smartplaylist>

[Zaister]

Thanks, Dave. Yes, the duplicate song issue is gone with this build.

I will test the new playlist rules later when I have reimported my database. I'll get back to you then.

[hugo57]

Hi All,

After installing Krypton beta 1 I noticed that new directories (albums) copied into the music folder on my NAS are not recognized and scanned to the library when I run a library update. I have to go to "Files", find the new folder, and use "Scan Item to Library". In Jarvis this was working OK and for videos is working in Krypton as well.

Am I alone or others are also experiencing the issue?

Currently running beta 3, same behavior. Beta 2 was also like this.

[DaveBlake]

After installing Krypton beta 1 I noticed that new directories (albums) copied into the music folder on my NAS are not recognized and scanned to the library when I run a library update. I have to go to "Files", find the new folder, and use "Scan Item to Library". In Jarvis this was working OK and for videos is working in Krypton as well.

Am I alone or others are also experiencing the issue?

Currently running beta 3, same behavior. Beta 2 was also like this.

Sorry, I can not repeat this issue - added folders within a music source location on my NAS do get scanned on library update as expected. So I will need more information about specifics.

Is your NAS drive music folder definitely added as a music source itself? That is the most obvious issue - you are adding extra sources for each sub-folder, but the common one is missing? Can you provide a copy of you sources.xml from the userdata folder?

What platform are you using?

[elee532]

Is there some way to scan for number of channels and sample rate as part of these music library improvements you are working on? I would love to be able to know whether an album and/or song is stereo or multi-channel when browsing albums in my music library. Likewise for sample rate. Thanks!

[hugo57]

Sorry, I can not repeat this issue - added folders within a music source location on my NAS do get scanned on library update as expected. So I will need more information about specifics.

Is your NAS drive music folder definitely added as a music source itself? That is the most obvious issue - you are adding extra sources for each sub-folder, but the common one is missing? Can you provide a copy of you sources.xml from the userdata folder?

What platform are you using?

Hi Dave,

Thanks for your prompt reply!

I am using Windows 10 and also have a network drive mapped to the NAS share holding my media (music, movies and TV shows).

My music is organized in folders by file type and albums, like this:

Music
----Albums
--------DTSs
--------FLACs
--------MP3s
----Playlists

In each of the DTSs, FLACs and MP3s folders I have sub-folders by albums. I take great care in tagging the tracks with Mp3Tag, although using only a limited number of tags: ALBUM, ARTIST, GENRE, TITLE, TRACK and YEAR. With albums having contributing artists also using ALBUMARTIST.

In Kodi I defined one source (MyMusic), with 3 paths for the file type sub-folders, like this:
X:\Music\Albums\DTSs
X:\Music\Albums\FLACs
X:\Music\Albums\MP3s


In this setup the behavior of the library update was like I described in the original post. I say "was" because what you wrote made me thinking and I changed (could not resist the temptation...) the source definition to this (one single path):
X:\Music\Albums


And now the library update does find the new albums... You may try replicating this but for me - problem solved.

Otherwise I am very happy with the library changes I see, thank you VERY MUCH for the work you put into it. Much appreciated! My biggest complaint (although never mentioned it) was that list positions (Artist / Albums / Recently Added / etc.) were not handled properly and you were never returned to the same position when switching between lists. This now works nicely.

Kodi is very important for me, it is practically the only way I listen to music. Not sure if there's a more appropriate thread, maybe you could forward this to your colleagues, but I would also like to mention that I find the sound I get from Krypton better than what I got from Jarvis (same equipment, no changes there). Jarvis was also quite good but Krypton is still better... Thanks for this improvement too...

[DaveBlake]

Is there some way to scan for number of channels and sample rate as part of these music library improvements you are working on? I would love to be able to know whether an album and/or song is stereo or multi-channel when browsing albums in my music library. Likewise for sample rate. Thanks!

In short, no. This data is not in tags and thus not scanned into the library. I guess there is an argument for holding other music file information in the library, just not something I have been looking at yet.

I will put it on my long list and see if something comes to me.

[HomerJau]

Is there some way to scan for number of channels and sample rate as part of these music library improvements you are working on? I would love to be able to know whether an album and/or song is stereo or multi-channel when browsing albums in my music library. Likewise for sample rate. Thanks!

I add the No. Of Channels and Source format to the Album tag:
Dark Side of the Moon (Quad BDA)
Dark Side of the Moon (5.1 SACD)
Meddle (Stereo 96kHz Vinyl)

That info then shows up while browsing in Kodi. (I also name the album folders like that for me to know what's there when viewing the folders/files).

I've got a small Windows app that scans all my music contents and it reports each album, no. Of tracks and their channels, sample/bit rates which can be imported into Excel. (Also allows me to select which ones to copy to another disc since I have a 'master' disc and don't copy everything to my Kodi music disc, also compares my master source disc to another disc showing what's there already, and what's missing. Copies all the extrafanart etc too.

I'll eventually upload the app somewhere as it also has a few tools for auto renaming music concert chapter files, creates nfo files for Kodi Music Concert Videos, creating playlists for audio and music videos, resampling audio, changing quad audio to 5.0 (add silent centre channel for some AVRs that won't play quad correctly), creates automatically playlists for all music concert videos - easy way to play random concert songs from my Kodi iPad app...

[elee532]

HomerJau, this app sounds awesome!! I have a lot of concert videos.

Question about album tagging... when you add information to the album name tag such as "(Stereo 96kHz Vinyl)" wouldn't this impact Kodi's ability to correctly identify the album when scanning it into the library.

[DaveBlake]

Question about album tagging... when you add information to the album name tag such as "(Stereo 96kHz Vinyl)" wouldn't this impact Kodi's ability to correctly identify the album when scanning it into the library.

Yes it would.

Rather than clutter the album title, although that does guarentee that you can see which version you are looking at, I would suggest using other tags as a work around. You could include bit rate and channels in the GENRE tag, e.g. "Rock / Stereo" that would result in genre item of "stereo". Or with v17 you could use RELEASETYPE tag, or just put things in the COMMENT tag.

Another approach would be to use path rules in smart playlists, and organise your music files so all the Stereo are in a different folder to the 5.1 etc.

[elee532]

Thanks for the advice. It never occurred to me to use genre tag. So, if I tag something as "Rock / Stereo" does that create two separate genres... one "Rock" and one "Stereo" or is it a single genre labeled "Rock / Stereo?"

RELEASETYPE tag sounds like a great option. Unfortunately, I'm still on v16. Ive been planning to give v17 a try. Hoping I might find some time to do it today. Can I use most any tagging app to add RELEASETYPE tag?

Thanks!