#musicbrainz

I've had a few bands I've caught doing that too

BrianFreud: I completely fail at whatever UPC is, where does it appear on the site? :)

fauxfaux: since you seem to be so quick at this ;) how about a search for 13-digit barcodes that begin with "999"?

barcode

(Interscope Records 602498611265) <---

very easy to quickly find the missing ASIN, if there is one, if you have a ECC-13/UPC to find it with

!upc 602498611265

BrianFreud: ASIN: B0000DZDYN; UPC: 602498611265; Country: U.S. and Canada; Label: Interscope Records; Year: 2003; Title: The Singles 1992-2003; Artists: No Doubt

brianfreud: i predict such reports will be HUGE

Jugdish: Won't be bigger than the REPORT OF DOOM. :p

lol

releases with ASINs but no barcodes? that'll be like 70% of the db :P

how sure are we of the accuracy of UPC from Yaub?

it's direct from amazon

i always google the upc given by YAUB just to double-check

I have yet, in a few 100 checks, to find a bad asin-upc linkage

yeah...but without more info they may be from completely diff versions

no, that's the type I was looking for

cross-checking at B&N or wherever

yeah

always comes up the right version

PgAdmin sucks asss.

question for you guys...

okay...could i maybe ask when entering a yaub UPC (as opposed to one from an actual copy or photo of such)...to include YAUB on the edit note

how much do you trust non-.fr Amazon dates for non-imports?

drsaunde: sure, if not cross verified

most ppl have no idea what YAUB is, so they get confused

ty....won't be much effort..but just in case something is wrong or added to the wrong version it'll be easier to determine

sure

Jugdish: I'm done failing, you can have your report now. :) http://faux.no-ip.biz/mergeproblems/barcodes999...

umm, I get 5 listings now

fauxfaux: thanks! actually, it turns out a report of 13-digit barcodes beginning in just "99" would be more accurate :P

Jugdish: Fixed. :p

quick!

and no difference :P

LOL

ah

99-upc = bogus?

yeah

--> http://en.wikipedia.org/wiki/List_of_GS1_countr...

Jugdish: There's only 5 starting with 99, regardless of length. :)

hmmm

what about a report of releases with the "amazon bogus date" date?

How would that work? *looks at upc->asins while you explain*

LOL good god, i am responsible for 3 of these bogus barcodes

FauxFaux: Amazon assigns "1990-10-25" to any release they have no idea on release date for.

BrianFreud: Don't think that data is in mb, though, is it?

release events?

Oh, releases with that release event? YOu can do that search via the site. :)

you can?

Well, you can do it in the webservice, so I guess so. :p

lol

the 1990-10-25 is the date amazon started...those are dates from releases from the site opening

ah

hmm, there's a few of those too

Or http://musicbrainz.org/search/textsearch.html?q...

brianfreud: do an advanced text search with "date:1990-10-25"

ah, ok, thanks :)

not bad, only 6

My method for getting releases with upc but no asin appears to take aaages.

can't be worse than mine...

load in picard, resave to "has upc no asin/music" or "has asin no upc/music"

:p

fauxfaux: i have a feeling because there will be 239845723987432 results

Cost: 660975571.65.

That's bad, kay?

heh

Jugdish: UPC but no asin, not the other way around. :)

oh

yeah, that's the more useful one anyhow

asin, no upc... so many bad asins from the old bot, I wouldn't trust it anyhow

SQL huts my head, you bastards.

BrianFreud is now known as KenneyIsDead

KenneyIsDead is now known as BrianFreud

Hah, yes, that's slightly faster.

lol

i remember those buttons

Heh, don't make me go buy a new machine. :P

so stupid, it's like having a fast/slow switch

This one has a cost of 7k, that's slightly better.

ugh, I so need to rebuild mine

it's so mangled, trying to keep it running, bits just slapped in til they break again

I have one of those Abit board with the bad cap problems... mine's lasted much longer than most, but it's on its last legs

UPC but no asin: http://faux.no-ip.biz/mergeproblems/upcnoasin.php

(No, you don't deserve names)

O_o

It takes a disgusting ammount of time to fetch the names in sql, for no apparent reason, maybe I'll do it manually. >.<

There you go, even uglier. :P

how about a:visited color?

There's no style-overrides, does your browser not have an a-visited colour by default?

hmm, supposedly

lol

thanks FauxFaux

wonder if it's not registering because /show/?releaseid= redirects to mbid/XXXX-XXX-XXX.html

Works in ie/opera.

And it doesn't redirect here. :)

and FF here

well i just suck then

Unlucky.

O_o

there is no way to get rid of labels! AHHHHH --> http://test.musicbrainz.org/show/edit/?editid=417

well, there's one less ASIN missing :)

Refresh for album names, not sure how that helps, though. :)

trying to see why the xml won't validate

Hmm?

actually, it's maybe more useful with the barcodes

Can't have both, I'm afraid. :p

yeah

Barcodes, without the eyeburning.

trying to import into access, so it's manageable

it's whining about non-compliant xml

Oh, it's nowhere near valid. Allow me to fix.

lol

So, I dunno if that's better or not, but try it now. :)

;)

Ugh, printing rss is a pain, y'know. What format do you want the stuff for access? Tsv?

nah

actually, it's cool now

friendlier xml than the mb service

Access doesn't understand xml attribute values :(

oh, very nice :)

I hate the evil empire

yeah, you get a sense of how microsoft doesn't talk internally when you try to use the "xml friendly" O2K3

Excel supports attribute tags, access doesn't

Heh. I have 2007 installed here, I haven't even launched it.

so if you need them, you have to import into excel, then link the access db to the excel data

Hah, that file is 400k as an access db.

lol

I'm refusing to install 2007

the whole idea of "make it simple - get rid of all the menus" seems idiotic to me

It's apparently very good, I'm sure I'll find out if I ever use an office product. :)

oh, all the MS reps who tried to pitch me on it raved about it

but every client who tried switching to it, they hated it

Excuse me if I don't trust your clients. :)

all used the retro-active licensing clause and had me order then O2003 install cds

I guess I'm more a fan of menus that stay put... the idea of the menu trying to guess what options I want, I just want the button to be where it should be, not have to hunt for it :P

My first Vista install, I re-enabled the menus in explorer immediately, I haven't done it yet on this one, and I only just noticed, been using it extensively for a week.

yeah... that's the problem in office 2007