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.
2010-12-07 34116, 2010
docAdams
there is a plugin you have to download first and some options to enable I think
2010-12-07 34155, 2010
matitaccia
docAdams, thank you.
2010-12-07 34103, 2010
docAdams
np
2010-12-07 34108, 2010
docAdams
I made a bit of a mess, I have a 27-track compilation that is listed with only 20 tracks arranged alphabetically.
2010-12-07 34150, 2010
docAdams
I fixed the track numbers and added the new tracks but got some sort of error.
2010-12-07 34143, 2010
docAdams
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?
2010-12-07 34135, 2010
arturo
@nikki, is it to keep a history of the actual links?
2010-12-07 34143, 2010
nikki
those are the actual links
2010-12-07 34105, 2010
nikki
so if I link an artist to their myspace page, there'll be a row in l_artist_url
2010-12-07 34143, 2010
arturo
@nikki: or many? depending on the dates? (just making sure I'm getting it right)
2010-12-07 34130, 2010
nikki
it should be just one row for each relationship
2010-12-07 34109, 2010
nikki
link points to the link table, which has the dates
2010-12-07 34119, 2010
nikki
and I'm not sure how attributes are linked right now
2010-12-07 34121, 2010
nikki has a look
2010-12-07 34112, 2010
arturo
Mmm... I feel I'm lost with that l_*_* tables and the *link* table....
2010-12-07 34139, 2010
Jormangeud joined the channel
2010-12-07 34132, 2010
arturo
@nikki, ok, thx, will keep looking into that.
2010-12-07 34105, 2010
nikki isn't very good at explaining things :/
2010-12-07 34154, 2010
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...
2010-12-07 34159, 2010
nikki
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
2010-12-07 34131, 2010
nikki
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
2010-12-07 34152, 2010
arturo
@nikki: O_O
2010-12-07 34118, 2010
arturo
@nikki: Ok, I see. Now, when I search, then I should always join through the link table I guess
2010-12-07 34134, 2010
arturo
@nikki: to get proper info.
2010-12-07 34142, 2010
nikki nods
2010-12-07 34130, 2010
arturo
@nikki: I'm staring at it hoping the knowledge will permeate through my skull...
2010-12-07 34109, 2010
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
2010-12-07 34148, 2010
arturo
@nikki: yeah, I've mirrored it and i'm trying to get a hint of the actual data
2010-12-07 34159, 2010
nikki
particularly the relationships... for a long time I ignored them because I couldn't be bothered to figure out how they worked :P
2010-12-07 34114, 2010
nikki
and now I have to learn how to select everything from the ngs database...
2010-12-07 34118, 2010
arturo
@nikki, yeah, it feels a bit too much trying to put this info on a relational model. But *hey*
2010-12-07 34118, 2010
nikki wonders if luks is around
2010-12-07 34143, 2010
v6lur joined the channel
2010-12-07 34106, 2010
arturo
exit
2010-12-07 34111, 2010
arturo joined the channel
2010-12-07 34145, 2010
arturo
Hi again guys! Where can I find a sample hourly replication file for the NGS database?
2010-12-07 34129, 2010
KRSCuan joined the channel
2010-12-07 34113, 2010
G-Bleezy joined the channel
2010-12-07 34138, 2010
kurtjx joined the channel
2010-12-07 34104, 2010
chrisb joined the channel
2010-12-07 34105, 2010
ruaok joined the channel
2010-12-07 34140, 2010
Mineo joined the channel
2010-12-07 34155, 2010
murdos
arturo: what would you do with this replication file?
2010-12-07 34158, 2010
nikki
apparently he's doing stuff for the bbc so they're ready for ngs
2010-12-07 34135, 2010
nikki
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
2010-12-07 34122, 2010
murdos
nikki: I don't think there's a ticket for that yet
2010-12-07 34106, 2010
murdos
but we need one ;)
2010-12-07 34111, 2010
nikki
indeed!
2010-12-07 34100, 2010
STalKer-X joined the channel
2010-12-07 34137, 2010
v6lur joined the channel
2010-12-07 34110, 2010
Milosz joined the channel
2010-12-07 34120, 2010
Milosz joined the channel
2010-12-07 34115, 2010
nikki wonders if she can get the bitrate for mp3s in picard
2010-12-07 34137, 2010
outsidecontext joined the channel
2010-12-07 34126, 2010
KRSCuan
What do you need it for, nikki? Just for naming files?
2010-12-07 34134, 2010
nikki
yes
2010-12-07 34104, 2010
KRSCuan
Looks like there isn't a Picard tag for that yet. But even then, writing a plugin should hopefully be trivial.
2010-12-07 34107, 2010
FauxFaux
I just class anything that's mp3 as inferior and anything that's in ogg/vorbis or flac as superior. :)
2010-12-07 34123, 2010
KRSCuan
The bitrate information is available to Picard after all
2010-12-07 34144, 2010
nikki
I do too, FauxFaux
2010-12-07 34138, 2010
KRSCuan
Most of my Vorbis files are encoded with 112bps, so most of them are probably worse than my mp3s.
2010-12-07 34117, 2010
KRSCuan
Plus, I'd have to transcode them before they could be played on my Nokia.
2010-12-07 34158, 2010
FauxFaux really needs to bother transcoding stuff for portable players.
2010-12-07 34101, 2010
KRSCuan
That's why I switched back to mp3s (and flac for stuff I really care for)
2010-12-07 34133, 2010
KRSCuan
Also, Picard does some odd stuff to ogg files which makes (or made) them unusable in Amarok.
2010-12-07 34142, 2010
nikki
my main problem with trying to switch to using only flac/ogg is stupid digital releases
2010-12-07 34145, 2010
KRSCuan
Though this only happens when I embed cover art.
2010-12-07 34148, 2010
FauxFaux
Sounds like a raisable bug in at least one of them.
2010-12-07 34144, 2010
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.
2010-12-07 34135, 2010
Milosz joined the channel
2010-12-07 34145, 2010
Milosz joined the channel
2010-12-07 34123, 2010
outsidecontext has left the channel
2010-12-07 34154, 2010
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 :)
2010-12-07 34129, 2010
KRSCuan
I'll check whether it still affects current versions.
2010-12-07 34123, 2010
KRSCuan
If an ogg file had an image embedded, Amarok couldn't read some of its tags, e.g. the track title.
2010-12-07 34144, 2010
KRSCuan
If I tried to fill in the tags within Amarok, it would break the ogg file.
2010-12-07 34113, 2010
KRSCuan
But I don't remember the details right now.
2010-12-07 34144, 2010
[1]matitaccia joined the channel
2010-12-07 34156, 2010
enjayhch joined the channel
2010-12-07 34105, 2010
ruaok joined the channel
2010-12-07 34111, 2010
caller_6 joined the channel
2010-12-07 34143, 2010
outsidecontext joined the channel
2010-12-07 34155, 2010
Milosz joined the channel
2010-12-07 34154, 2010
BurgessShale joined the channel
2010-12-07 34143, 2010
gekl joined the channel
2010-12-07 34156, 2010
ijabz joined the channel
2010-12-07 34108, 2010
Milosz joined the channel
2010-12-07 34119, 2010
Milosz joined the channel
2010-12-07 34154, 2010
tori joined the channel
2010-12-07 34111, 2010
praest76 joined the channel
2010-12-07 34133, 2010
PasNox joined the channel
2010-12-07 34108, 2010
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?
2010-12-07 34152, 2010
luks
use the real artist
2010-12-07 34155, 2010
xlotlu joined the channel
2010-12-07 34118, 2010
matitaccia
luks, and then I end up having lots of artist having just one song or so.
2010-12-07 34135, 2010
luks
is that a problem?
2010-12-07 34100, 2010
luks
if you are using a tagger like Picard, you can set the artist field to VA
2010-12-07 34111, 2010
luks
but in the MB database, it should be the real artist
2010-12-07 34122, 2010
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.
2010-12-07 34100, 2010
KRSCuan
Whatever suits you best :)
2010-12-07 34124, 2010
luks
doesn't it use the same concept of "Compilations" as iTunes?
2010-12-07 34138, 2010
KRSCuan
But I have terrible experiences at least with the way iTunes handles compilations…
2010-12-07 34102, 2010
matitaccia
Oh, lol. I'm not using itunes right now... I'll use it just to transfer the files.
2010-12-07 34115, 2010
matitaccia
Or... at least I would like to use it just for that. Lol.
2010-12-07 34119, 2010
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
2010-12-07 34159, 2010
KRSCuan
Does Picard set the compilation tag that iTunes uses?
2010-12-07 34113, 2010
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
2010-12-07 34138, 2010
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.
2010-12-07 34105, 2010
luks
I have no idea about Magic MP3 Tagger
2010-12-07 34116, 2010
luks
I've never even seen it actually :)
2010-12-07 34154, 2010
matitaccia
What do you use to tag? Something that keeps compilations files together? :-)
2010-12-07 34117, 2010
luks
Picard, but I'm obviously biased :)
2010-12-07 34134, 2010
KRSCuan
Hehe.
2010-12-07 34125, 2010
Muz joined the channel
2010-12-07 34117, 2010
matitaccia
But picard permits to tag? I have used to get information from the web but to actually tag?
2010-12-07 34113, 2010
KRSCuan
You can tag individual files by right-clicking them and selecting "Details".
2010-12-07 34134, 2010
KRSCuan
Or you can modify the "New Metadata" on the right hand side of the window.
2010-12-07 34156, 2010
KRSCuan
But for large amounts of files, Picard is cumbersome IMO,
