by achimv » Sat Jan 16, 2021 2:44 pm
by achimv » Sat Jan 16, 2021 2:38 pm
by achimv » Sat Jan 16, 2021 2:25 pm
by ZvezdanD » Sat Jan 16, 2021 12:02 pm
achimv wrote: ↑Sat Jan 16, 2021 7:37 am I want the artist tag copied into the album artist field only if "unknown" in shown in the album artist field.
by achimv » Sat Jan 16, 2021 7:37 am
by ZvezdanD » Sun Dec 20, 2020 1:20 am
by Boobounder » Tue Dec 15, 2020 5:04 pm
by Lowlander » Tue Dec 15, 2020 4:39 pm
by Boobounder » Tue Dec 15, 2020 4:33 pm
by cokehearth » Thu Dec 10, 2020 11:11 am
ZvezdanD wrote: ↑Fri Dec 04, 2020 3:57 pm cokehearth wrote: ↑Fri Dec 04, 2020 4:53 am Is there a way to alphabetise the artists field? Maybe you could try this: Code: Select allSQLQuery("SELECT group_concat(AA, '; ') FROM (SELECT DISTINCT Artists.Artist AS AA FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID WHERE Songs.ID = " & oSongData.ID & ")")
cokehearth wrote: ↑Fri Dec 04, 2020 4:53 am Is there a way to alphabetise the artists field?
Code: Select all
SQLQuery("SELECT group_concat(AA, '; ') FROM (SELECT DISTINCT Artists.Artist AS AA FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID WHERE Songs.ID = " & oSongData.ID & ")")
by ZvezdanD » Fri Dec 04, 2020 3:57 pm
by cokehearth » Fri Dec 04, 2020 4:53 am
SQLQuery("SELECT group_concat(AA, '; ') FROM (SELECT DISTINCT Artists.Artist AS AA FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID WHERE IDAlbum = " & oSongData.Album.ID & ")")
by wdp » Mon Nov 23, 2020 4:17 pm
by ZvezdanD » Mon Nov 23, 2020 4:00 pm
wdp wrote: ↑Mon Nov 23, 2020 12:45 pm There is nothing to paste but there is an extra line.
by wdp » Mon Nov 23, 2020 12:45 pm
ZvezdanD wrote: ↑Mon Nov 23, 2020 1:40 am When I said copy/paste the Comment field, I meant that you open the problematic tracks (that cause the "|") in the Properties dialog in MediaMonkey, copy the Comment field as text and paste it here in the post. Did you notice an empty line on the beginning of the Comment field in tracks that result having the "|" after applying the preset? Could you try the next preset on such tracks: Code: Select all[\s\n]*(0x)?(([0-9A-F]{8} ){3}[0-9A-F]{16}( [0-9A-F]{8}){8}|([0-9A-F]{8} ){9}[0-9A-F]{8})[\s\n]*
[\s\n]*(0x)?(([0-9A-F]{8} ){3}[0-9A-F]{16}( [0-9A-F]{8}){8}|([0-9A-F]{8} ){9}[0-9A-F]{8})[\s\n]*
Top