#musicbrainz

'Barcode "07464476022" is not a valid EAN barcode.' it tells me

comparing to another barcode, it appears to be missing a digit

the one in the right corner of the barcode, I think

should I just tick the checkbox and enter it as-is?

are there some docs on an "official" way of extending XSPF playlists with MB data?

Dhraakellian, it could be missing the checksum digit

Dhraakellian, 00074644760224 maybe

"0 7464 - 47602 - 2" is how it's written on the back cover

i don't know any barcodes with 11 digits

Dhraakellian: you're missing a digit at the end

xlotlu: yeah, I figured that, given the alignment

like that 0 at the beginning is sifferent, there should be another one at the end

everything but the 0 at the beginning is centered under the lines

the first zero is off to the left

which makes me think that, like you said, there should be another on the right

so should I put it in with the 4 at the end, as deadchip suggested?

i dunno

iirc that's the last one is the check digit, and you could compute it yourself

dunno exactly how though :)

xlotlu, i just gave a website to do it

ah :)

Dhraakellian, check digit is4

deadchip: i'm only ignoring urls :)

heh

Dhraakellian: the 4 looks right http://www.google.com/search?q=074644760224

amapedia o.O

amapedia?

lol

wtf

since when do they have that

Amapedia is a community for sharing information about the products you like the most. .....

since very recently :)

well amazon has always been slightly low-brow

user-generated content ftw

"Askville Can't find what you're looking for? Ask Askville! There's a growing community of people just waiting to answer your question. "

lol

although their mechanical turk idea is great

it's basically like all user-generated-content web sites work

so, hmm... that's really useful

they list the UPC for all ASINs it seems

Dhraakellian: do that, do that

8 tracks with track-level AR's... is there a quicker way to do this?

wee. pretty amapedia: http://musicbrainz.org/show/edit/?editid=9119992 :)

Dhraakellian: start by adding an AR to the release. on that page you have a link to "add relationships to tracks on this release"

also, would 'Symphonies Nos. 1 "Classical", 5' be better than the current release title?

or something alike... and then you get a nice page with checkboxes for tracks

xlotlu: it already has the symphony orchestra and conductor AR's for each track

Dhraakellian: ah :/

then no, no faster way

Dhraakellian: but at least put the date in the annotation...

already done

hmm... "The Royal Edition"

"No. 64 of 100"

with a painting by HRH the Prince of Wales on the front cover

Dhraakellian: last time i had to do that, i removed all the previous ARs

hmm

which got some mixed opinions...

and changing the "&" to "from ... to" is still *technically* correct, I suppose

but then again, that was a 50-track release

hehhehheh

niklas: ping!

hello

hi!

hi ruaok

so, the easy way to do date calculations is to either doit using julian dates or seconds.

hi xlotlu

julian dates are total overkill for this and would require a new module.

Dhraakellian: http://musicbrainz.org/show/edit/?editid=8904247

so, that's silly.

yes

but you can get a date expressed in seconds since the epoch (1-1-70)

then to add one to the date simply do

date += (24 * 60 * 60)

and convert the date back into yyyy-mm-dd format

ruaok: but a mistake results in epoch fail

but dont that conversion back to yyyy-mm-dd format require some module I dont have?

Dhraakellian: thanks. I was waiting for that. :)

:D

niklas: maybe. I would have to review what functions we have.

sometimes its possible to have postgres add a day

I'm not sure if that works in this context.

ahh

you certainly don't want to make an extra call to postgres for that.

ok

but if you can squeeze that in as part of a sql query then you're in good share.

shape.

everyone: if you want to follow my blogging of OSCON, look here: http://radar.oreilly.com/robk/

there's no CAST for casting e.g. unix timestamp to yyyy-mm-dd format?

Google invited a bunch of people for dinner and I dont want to be late -- its a nice dinner. :)

<3 Google

not a cast, no.

select foo, foo + '1 day'::interval as foo_tomorrow

ding!!

xlotlu: something like that is what I had in mind.

if ARs could be edited in a single page like track titles and lengths, it'd just be a matter of doing a bunch of middle-clicks

<3 X11's middle-click paste

Dhraakellian: i want this: http://bugs.musicbrainz.org/ticket/3758 :)

i dream of editing an entire release in a text editor in say.. yaml format

xlotlu: thank you :)

xlotlu: one day... one day

niklas: extract (epoch from datefield)

how would one encode dates before 1970?

niklas: sorry, you wanted the other day around: to_timestamp(int)

(or was it double?)

Dhraakellian: negative integers, obviously :)

heck with BC/AD and BCE/CE!

BE and AE?

xlotlu: ah, but this wont work if its not a timestamp?

niklas: what / which part?

dates are stored as CHAR(10) formatted "yyyy-mm-dd"

foo ´'1 day'::interval and extract

they are char in the db, not timestamp??

yes, as far as I can see

why? o.O

niklas: you can use to_timestamp(date_string, date_format) ...

xlotlu: seems like most dates are stored as timestamps, but not the one Im using. its possible that Im messing with the wrong date

great

you can just cast it to timestamp if it's in the default format (normally yyyy-mm-dd)

no need to specify format string if its YYYY-MM-DD?

niklas: casting as in 'string'::timestamp

about to_timestamp, i dunno. if there's a to_timestamp(varchar) function, then that's what it probably does :)

ohh

if there was ever cheese on a pizza then it's on the one i just made

hmm

i think it's b ecause "was ever" were placed unusually

maybe rather "if there ever was cheese"

xlotlu: thanks for helping niklas.

niklas: if you need more help, send me another mail.

:)