I have seen it's possible to bind it to tags, but I haven't suceeded in downloading it yet (from musicbrainz DB), otherwise there are other sites, I know.
docAdams
there is a plugin you have to download first and some options to enable I think
matitaccia
docAdams, thank you.
docAdams
np
I made a bit of a mess, I have a 27-track compilation that is listed with only 20 tracks arranged alphabetically.
I fixed the track numbers and added the new tracks but got some sort of error.
I don't remember what it was but I added the release again separately. Anybody know what I should do?
@nikki, yeah, I'm on that. Question: What does l_*_* tables *really* contain?
@nikki, is it to keep a history of the actual links?
nikki
those are the actual links
so if I link an artist to their myspace page, there'll be a row in l_artist_url
arturo
@nikki: or many? depending on the dates? (just making sure I'm getting it right)
nikki
it should be just one row for each relationship
link points to the link table, which has the dates
and I'm not sure how attributes are linked right now
nikki has a look
arturo
Mmm... I feel I'm lost with that l_*_* tables and the *link* table....
Jormangeud joined the channel
@nikki, ok, thx, will keep looking into that.
nikki isn't very good at explaining things :/
nikki
the l_*_* ones are closest to what you see on the website, so when someone adds foo has an official homepage at foo.com, a row is added l_artist_url, when someone adds bar has an official homepage at bar.com another row is added to l_artist_url...
however, since they're both official homepage relationships with no dates set, there would only be one row in the link table, which would have link_type pointing to the official homepage relationship type and no dates set
but if someone then adds asdf has an official homepage at asdf.com until 2009 as a relationship, we get a new row in l_artist_url *and* a new row in the link table because this time one of the dates is set
arturo
@nikki: O_O
@nikki: Ok, I see. Now, when I search, then I should always join through the link table I guess
@nikki: to get proper info.
nikki nods
@nikki: I'm staring at it hoping the knowledge will permeate through my skull...
nikki
I usually find that the best way to understand it is to find an example I recognise and try selecting it from the database
arturo
@nikki: yeah, I've mirrored it and i'm trying to get a hint of the actual data
nikki
particularly the relationships... for a long time I ignored them because I couldn't be bothered to figure out how they worked :P
and now I have to learn how to select everything from the ngs database...
arturo
@nikki, yeah, it feels a bit too much trying to put this info on a relational model. But *hey*
nikki wonders if luks is around
v6lur joined the channel
exit
arturo joined the channel
Hi again guys! Where can I find a sample hourly replication file for the NGS database?
KRSCuan joined the channel
G-Bleezy joined the channel
kurtjx joined the channel
chrisb joined the channel
ruaok joined the channel
Mineo joined the channel
murdos
arturo: what would you do with this replication file?
nikki
apparently he's doing stuff for the bbc so they're ready for ngs
and murdos, do you know if we have a ticket for adding relationships to all recordings/works on a release? I thought we did but I can't find one
murdos
nikki: I don't think there's a ticket for that yet
but we need one ;)
nikki
indeed!
STalKer-X joined the channel
v6lur joined the channel
Milosz joined the channel
Milosz joined the channel
nikki wonders if she can get the bitrate for mp3s in picard
outsidecontext joined the channel
KRSCuan
What do you need it for, nikki? Just for naming files?
nikki
yes
KRSCuan
Looks like there isn't a Picard tag for that yet. But even then, writing a plugin should hopefully be trivial.
FauxFaux
I just class anything that's mp3 as inferior and anything that's in ogg/vorbis or flac as superior. :)
KRSCuan
The bitrate information is available to Picard after all
nikki
I do too, FauxFaux
KRSCuan
Most of my Vorbis files are encoded with 112bps, so most of them are probably worse than my mp3s.
Plus, I'd have to transcode them before they could be played on my Nokia.
FauxFaux really needs to bother transcoding stuff for portable players.
That's why I switched back to mp3s (and flac for stuff I really care for)
Also, Picard does some odd stuff to ogg files which makes (or made) them unusable in Amarok.
nikki
my main problem with trying to switch to using only flac/ogg is stupid digital releases
KRSCuan
Though this only happens when I embed cover art.
FauxFaux
Sounds like a raisable bug in at least one of them.
KRSCuan
I had that problem with Amarok 1.4, so I'd doubt their devs would care to fix it. If it was their fault in the first place.
Milosz joined the channel
Milosz joined the channel
outsidecontext has left the channel
luks
KRSCuan: Amarok uses TagLib, which is maintained by me, and I'm supposed to be maintaining Picard, so filling a bug in either bug tracker is fine :)
KRSCuan
I'll check whether it still affects current versions.
If an ogg file had an image embedded, Amarok couldn't read some of its tags, e.g. the track title.
If I tried to fill in the tags within Amarok, it would break the ogg file.
But I don't remember the details right now.
[1]matitaccia joined the channel
enjayhch joined the channel
ruaok joined the channel
caller_6 joined the channel
outsidecontext joined the channel
Milosz joined the channel
BurgessShale joined the channel
gekl joined the channel
ijabz joined the channel
Milosz joined the channel
Milosz joined the channel
tori joined the channel
praest76 joined the channel
PasNox joined the channel
matitaccia
Hello everyone. I have a question: when you have a compilation with various artists how do you tag the artist field? As various artists or do you put the real artist?
luks
use the real artist
xlotlu joined the channel
matitaccia
luks, and then I end up having lots of artist having just one song or so.
luks
is that a problem?
if you are using a tagger like Picard, you can set the artist field to VA
but in the MB database, it should be the real artist
matitaccia
Oh, I have to introduce the fact that I'm not talking about the online DB. I'm trying to find the best solution for use on one ipod.
KRSCuan
Whatever suits you best :)
luks
doesn't it use the same concept of "Compilations" as iTunes?
KRSCuan
But I have terrible experiences at least with the way iTunes handles compilations…
matitaccia
Oh, lol. I'm not using itunes right now... I'll use it just to transfer the files.
Or... at least I would like to use it just for that. Lol.
luks
maybe I remember it wrong, but I think it groups VA albums under Compilations, so you don't have artists from VA releases in the artist list
KRSCuan
Does Picard set the compilation tag that iTunes uses?
matitaccia
Yeah, I think this is the second option I have: to tag them all as VA and remember that under VA I have all the compitlations.
KRSCuan: yes, everything with multiple artists should have the Compilation flag set
matitaccia
luks, when I do that on Magic MP3 Tagger though, it will force me to rename files in his order which puts the album first. And I don't want that to happen.
luks
I have no idea about Magic MP3 Tagger
I've never even seen it actually :)
matitaccia
What do you use to tag? Something that keeps compilations files together? :-)
luks
Picard, but I'm obviously biased :)
KRSCuan
Hehe.
Muz joined the channel
matitaccia
But picard permits to tag? I have used to get information from the web but to actually tag?
KRSCuan
You can tag individual files by right-clicking them and selecting "Details".
Or you can modify the "New Metadata" on the right hand side of the window.
But for large amounts of files, Picard is cumbersome IMO,