#musicbrainz

/

      • Shepard
        ich verarsche dich nicht
      • 2006-08-13 22524, 2006

      • nikki_
        you two just launched into german convo and it amuses me
      • 2006-08-13 22526, 2006

      • deadchip
        du koenntest auch gleich sagen "doesn't interest me right now"
      • 2006-08-13 22539, 2006

      • deadchip
        then i'd stop telling you anything, cause it's 1) a waste of energy for me and 2) you're not interested anyway
      • 2006-08-13 22548, 2006

      • nikki_
        ...and back to english!
      • 2006-08-13 22549, 2006

      • Shepard
        komm mal wieder runter, ist ok jetzt :)
      • 2006-08-13 22558, 2006

      • deadchip
        ja weil du's sagst oder was
      • 2006-08-13 22500, 2006

      • deadchip
        LOL
      • 2006-08-13 22517, 2006

      • deadchip
        ne danke
      • 2006-08-13 22558, 2006

      • sidd_ has quit
      • 2006-08-13 22559, 2006

      • sidd joined the channel
      • 2006-08-13 22558, 2006

      • sxcbello joined the channel
      • 2006-08-13 22506, 2006

      • sidd_ joined the channel
      • 2006-08-13 22519, 2006

      • sxcbello
        hi guys
      • 2006-08-13 22528, 2006

      • sxcbello
        can someone help me with the dump file?
      • 2006-08-13 22555, 2006

      • sxcbello
        just wanted to know if artistalias is enough to get a full listing of all artists?
      • 2006-08-13 22510, 2006

      • nikki_
        hmm
      • 2006-08-13 22522, 2006

      • nikki_
        what exactly do you want?
      • 2006-08-13 22527, 2006

      • nikki_
        just the artist names or?
      • 2006-08-13 22500, 2006

      • sxcbello
        I want the unique artist names
      • 2006-08-13 22530, 2006

      • sxcbello
        I've got the artistalias file opened
      • 2006-08-13 22538, 2006

      • sxcbello
        say for beach boys:
      • 2006-08-13 22539, 2006

      • sxcbello
        5213 1135 Beach Boys, The 0 0 1970-01-01 00:00:00+00
      • 2006-08-13 22549, 2006

      • sxcbello
        106 1135 Beach Boys 33467 0 2005-12-31 23:12:47+00
      • 2006-08-13 22551, 2006

      • nikki_
        not all artists will have aliases...
      • 2006-08-13 22557, 2006

      • sxcbello
        they have 2 lines in the file
      • 2006-08-13 22558, 2006

      • sxcbello
        oh ok
      • 2006-08-13 22503, 2006

      • sxcbello
        so which file should I be looking at ?
      • 2006-08-13 22525, 2006

      • sxcbello
        even if all files don't have alias will they still be presnet
      • 2006-08-13 22531, 2006

      • sxcbello
        cos I did a search for Pink and she comes up
      • 2006-08-13 22534, 2006

      • sxcbello
        even though she has no alias
      • 2006-08-13 22514, 2006

      • nikki_
      • 2006-08-13 22527, 2006

      • sidd___ has quit
      • 2006-08-13 22531, 2006

      • sxcbello
        oh ok
      • 2006-08-13 22542, 2006

      • sxcbello
        so I have to cross the data from artist with artistalias right?
      • 2006-08-13 22502, 2006

      • nikki_
        why not just the data from the artist table? o_O
      • 2006-08-13 22549, 2006

      • sxcbello
        oh um how do u relate say like tupac = 2pac?
      • 2006-08-13 22505, 2006

      • nikki_
        oh. those'll be aliases
      • 2006-08-13 22511, 2006

      • nikki_
        but you said you wanted the unique names...
      • 2006-08-13 22537, 2006

      • sxcbello
        true, I guess I want unique names that are mapped
      • 2006-08-13 22545, 2006

      • sxcbello
        so for example if I have The beach boys vs beach boys
      • 2006-08-13 22552, 2006

      • sxcbello
        I would only want the proper name of The beach boys
      • 2006-08-13 22530, 2006

      • sxcbello
        u saying that the artist file as all the "real" names?
      • 2006-08-13 22559, 2006

      • Nine99 joined the channel
      • 2006-08-13 22522, 2006

      • sidd___ joined the channel
      • 2006-08-13 22525, 2006

      • nikki_
        the artist table has all the real names, artistalias has various names which are linked to those real names
      • 2006-08-13 22517, 2006

      • sxcbello
        oh ok excellent
      • 2006-08-13 22528, 2006

      • sxcbello
        I don't have posgres so it's going to be fun parsing the tables hehe
      • 2006-08-13 22552, 2006

      • sxcbello
        is there someone on the site where I can see what each column means in the file?
      • 2006-08-13 22512, 2006

      • sxcbello
        Artist File: Artist ID, Artistname, MBID, etc
      • 2006-08-13 22528, 2006

      • nikki_
        I guess it's the same as the db schema
      • 2006-08-13 22553, 2006

      • sxcbello
        oh yeah I think I just found the schema
      • 2006-08-13 22500, 2006

      • sidd has quit
      • 2006-08-13 22506, 2006

      • sxcbello
      • 2006-08-13 22520, 2006

      • sxcbello
        is a file missing artist_relation? in the dump
      • 2006-08-13 22559, 2006

      • nikki_
        no, that's a separate dump
      • 2006-08-13 22552, 2006

      • sxcbello
        cool I think I got it...
      • 2006-08-13 22559, 2006

      • sxcbello
        just one thing 1135 The Beach Boys ebfc1398-8d96-47e3-82c3-f782abcdb13d 0 Beach Boys, The 107024673 \N 1961-00-00 \N 2
      • 2006-08-13 22507, 2006

      • sxcbello
        what does the last item represent?
      • 2006-08-13 22510, 2006

      • sxcbello
        \n 2 ?
      • 2006-08-13 22501, 2006

      • nikki_
        I think 2 is the artist type
      • 2006-08-13 22502, 2006

      • Nine99
        anyone got the Alec Empire album Intelligence and Sacrifice?
      • 2006-08-13 22511, 2006

      • nikki_
        in that case, a group
      • 2006-08-13 22517, 2006

      • nikki_
        why, Nine99?
      • 2006-08-13 22527, 2006

      • sidd_ has quit
      • 2006-08-13 22533, 2006

      • sxcbello
        where did u find the artist_type meaning?
      • 2006-08-13 22542, 2006

      • Nine99
        cause i want to know i the last track on disc 2 has a " (reprise)" in its name
      • 2006-08-13 22547, 2006

      • sidd joined the channel
      • 2006-08-13 22549, 2006

      • nikki_
        0 is unknown, 1 is person, 2 is group
      • 2006-08-13 22552, 2006

      • nikki_
        hmm...
      • 2006-08-13 22529, 2006

      • sxcbello
        thanks for all ur help nikki appreciate it
      • 2006-08-13 22511, 2006

      • deadchip
        Nine99: yeah i haev it
      • 2006-08-13 22513, 2006

      • deadchip
        have it*
      • 2006-08-13 22520, 2006

      • Nine99
        ho do you make those personal messages?
      • 2006-08-13 22522, 2006

      • deadchip
        Nine99: yeah it has
      • 2006-08-13 22528, 2006

      • Nine99
        ok thx
      • 2006-08-13 22553, 2006

      • deadchip
        cool you reminded me to listen to it again :D
      • 2006-08-13 22554, 2006

      • deadchip
        heh
      • 2006-08-13 22500, 2006

      • deadchip
        i forgot about it o_O
      • 2006-08-13 22515, 2006

      • MBChatLogger
        I hate the evil empire
      • 2006-08-13 22515, 2006

      • sxcbello
        mmm I wonder if I can import these files in microsoft sql as tab delimited files mmmm
      • 2006-08-13 22522, 2006

      • Nine99
        @deadchip test
      • 2006-08-13 22540, 2006

      • nikki_
        I just type the first few letters and hit tab
      • 2006-08-13 22543, 2006

      • nikki_
        Nine99: see!
      • 2006-08-13 22555, 2006

      • Nine99
        how?
      • 2006-08-13 22503, 2006

      • deadchip
        well tab completion
      • 2006-08-13 22509, 2006

      • deadchip
        depends on your irc client
      • 2006-08-13 22516, 2006

      • deadchip
        xchat has it and i think irssi has it (?)
      • 2006-08-13 22518, 2006

      • Nine99
        mozilla irc
      • 2006-08-13 22547, 2006

      • deadchip
        Nine99: well
      • 2006-08-13 22553, 2006

      • nikki_
        irssi has tab completion, unless I've been imagining things :P
      • 2006-08-13 22554, 2006

      • deadchip
        Nine99: on the outer sleeve thing
      • 2006-08-13 22500, 2006

      • deadchip
        Nine99: it says reprise
      • 2006-08-13 22509, 2006

      • deadchip
        but e.g on amazon, it doesn't say it
      • 2006-08-13 22525, 2006

      • nikki_
        I would keep it, there's two identically named tracks otherwise
      • 2006-08-13 22527, 2006

      • Nine99
        Private messages from unregistered users are currently blocked due to spam problems :(
      • 2006-08-13 22530, 2006

      • deadchip
        but here it says 2641998 (reprise)
      • 2006-08-13 22537, 2006

      • deadchip
        Nine99: you need to register with freenode
      • 2006-08-13 22554, 2006

      • slaad
        A registered user can also allow unregistered users to private message them, deadchip.
      • 2006-08-13 22501, 2006

      • deadchip
        hmm
      • 2006-08-13 22507, 2006

      • sidd_ joined the channel
      • 2006-08-13 22511, 2006

      • deadchip
        yeah well but that's more complex
      • 2006-08-13 22513, 2006

      • deadchip
        err
      • 2006-08-13 22518, 2006

      • deadchip
        no actually it's less complex
      • 2006-08-13 22519, 2006

      • slaad
        No it isn't.
      • 2006-08-13 22521, 2006

      • slaad
        :P
      • 2006-08-13 22536, 2006

      • deadchip
        slaad: yeah but you can't know whether that user has approved this or not
      • 2006-08-13 22555, 2006

      • slaad
        What?
      • 2006-08-13 22501, 2006

      • deadchip
        so generally it's "safer" to register with freenode and privmsg someone, but you can always try to privmsg him anyway
      • 2006-08-13 22517, 2006

      • slaad
        You can ask them in channel.
      • 2006-08-13 22535, 2006

      • deadchip
        slaad: try privmsg/you are not registered -> doesn't arrive -> can you be sure he's seen it ?
      • 2006-08-13 22536, 2006

      • deadchip
        vs.
      • 2006-08-13 22553, 2006

      • slaad
        It'll tell you if it's blocked.
      • 2006-08-13 22503, 2006

      • deadchip
        privmsg/you are registered -> has to arrive (unless the user blocks privmsgs by other means) -> you can be sure he has seen it but doesn't respond for some reason
      • 2006-08-13 22513, 2006

      • deadchip
        slaad: not everyone looks into the server tab
      • 2006-08-13 22523, 2006

      • deadchip
        that's where the information appears in xchat at least, and most people don't see it
      • 2006-08-13 22529, 2006

      • slaad shrugs.
      • 2006-08-13 22530, 2006

      • nikki_
        where that message appears depends on the client
      • 2006-08-13 22539, 2006

      • deadchip
        yeah i know hence i said "in xchat"
      • 2006-08-13 22544, 2006

      • Nine99 has left the channel
      • 2006-08-13 22541, 2006

      • Nine99_ joined the channel
      • 2006-08-13 22503, 2006

      • sxcbello
        damn can't import the data in mssql
      • 2006-08-13 22505, 2006

      • sxcbello
        :-(
      • 2006-08-13 22515, 2006

      • sidd__ joined the channel
      • 2006-08-13 22534, 2006

      • sxcbello
        scratch that I can
      • 2006-08-13 22535, 2006

      • sxcbello
        heeh
      • 2006-08-13 22543, 2006

      • sidd___ has quit
      • 2006-08-13 22549, 2006

      • Nine99_ has left the channel
      • 2006-08-13 22543, 2006

      • Nine99 joined the channel
      • 2006-08-13 22536, 2006

      • sidd has quit
      • 2006-08-13 22514, 2006

      • sidd_ has quit
      • 2006-08-13 22546, 2006

      • sidd joined the channel
      • 2006-08-13 22556, 2006

      • sidd_ joined the channel
      • 2006-08-13 22546, 2006

      • sidd__ has quit
      • 2006-08-13 22507, 2006

      • sidd has quit
      • 2006-08-13 22503, 2006

      • sxcbello has quit
      • 2006-08-13 22529, 2006

      • Nine99 has quit
      • 2006-08-13 22534, 2006

      • Amblin joined the channel
      • 2006-08-13 22544, 2006

      • Amblin- has quit
      • 2006-08-13 22543, 2006

      • dholmes
        Vote begging time!
      • 2006-08-13 22546, 2006

      • dholmes
      • 2006-08-13 22502, 2006

      • dholmes
        "Yes" on any of my open edits
      • 2006-08-13 22511, 2006

      • dholmes
        I'll love you forever! Or at least for a few minutes.
      • 2006-08-13 22518, 2006

      • flamingcow
        dholmes: i think there's some etiquette thing about asking for votes but not telling people what to vote on them :)
      • 2006-08-13 22532, 2006

      • dholmes
        Oh, uh, sorry
      • 2006-08-13 22546, 2006

      • dholmes
        Since they are in fact MY edits, I thought it was implied
      • 2006-08-13 22552, 2006

      • dholmes
        But "Yes" would be nice =D
      • 2006-08-13 22514, 2006

      • dholmes
        I suppose asking for 24 was a bit much though
      • 2006-08-13 22547, 2006

      • dholmes
        It would be cool if Picard could tag according to pending edits, so that I could tag tracks without having to wait until the edits go through, or retag them later, or tag them manually
      • 2006-08-13 22553, 2006

      • sidd joined the channel