-
Sargun has quit
2008-07-25 20751, 2008
-
srotta has quit
2008-07-25 20743, 2008
-
Dhraakellian joined the channel
2008-07-25 20739, 2008
-
Dhraakellian
'Barcode "07464476022" is not a valid EAN barcode.' it tells me
2008-07-25 20741, 2008
-
srotta joined the channel
2008-07-25 20750, 2008
-
Dhraakellian
comparing to another barcode, it appears to be missing a digit
2008-07-25 20719, 2008
-
Dhraakellian
2008-07-25 20740, 2008
-
Dhraakellian
the one in the right corner of the barcode, I think
2008-07-25 20753, 2008
-
Dhraakellian
should I just tick the checkbox and enter it as-is?
2008-07-25 20757, 2008
-
deadchip
are there some docs on an "official" way of extending XSPF playlists with MB data?
2008-07-25 20727, 2008
-
deadchip
Dhraakellian, it could be missing the checksum digit
2008-07-25 20729, 2008
-
deadchip
Dhraakellian, 00074644760224 maybe
2008-07-25 20723, 2008
-
deadchip
2008-07-25 20729, 2008
-
Dhraakellian
"0 7464 - 47602 - 2" is how it's written on the back cover
2008-07-25 20715, 2008
-
deadchip
i don't know any barcodes with 11 digits
2008-07-25 20713, 2008
-
xlotlu
Dhraakellian: you're missing a digit at the end
2008-07-25 20731, 2008
-
Dhraakellian
xlotlu: yeah, I figured that, given the alignment
2008-07-25 20735, 2008
-
xlotlu
like that 0 at the beginning is sifferent, there should be another one at the end
2008-07-25 20751, 2008
-
Dhraakellian
everything but the 0 at the beginning is centered under the lines
2008-07-25 20703, 2008
-
Dhraakellian
the first zero is off to the left
2008-07-25 20717, 2008
-
Dhraakellian
which makes me think that, like you said, there should be another on the right
2008-07-25 20739, 2008
-
Dhraakellian
so should I put it in with the 4 at the end, as deadchip suggested?
2008-07-25 20749, 2008
-
xlotlu
i dunno
2008-07-25 20707, 2008
-
xlotlu
iirc that's the last one is the check digit, and you could compute it yourself
2008-07-25 20714, 2008
-
xlotlu
dunno exactly how though :)
2008-07-25 20743, 2008
-
deadchip
xlotlu, i just gave a website to do it
2008-07-25 20750, 2008
-
deadchip thinks everyone is ignoring him :P
2008-07-25 20751, 2008
-
xlotlu
ah :)
2008-07-25 20703, 2008
-
deadchip
Dhraakellian, check digit is4
2008-07-25 20708, 2008
-
xlotlu
deadchip: i'm only ignoring urls :)
2008-07-25 20711, 2008
-
deadchip
heh
2008-07-25 20757, 2008
-
xlotlu
2008-07-25 20720, 2008
-
xlotlu
amapedia o.O
2008-07-25 20730, 2008
-
deadchip
amapedia?
2008-07-25 20741, 2008
-
deadchip
lol
2008-07-25 20742, 2008
-
deadchip
wtf
2008-07-25 20747, 2008
-
deadchip
since when do they have that
2008-07-25 20751, 2008
-
xlotlu
Amapedia is a community for sharing information about the products you like the most. .....
2008-07-25 20758, 2008
-
xlotlu
since very recently :)
2008-07-25 20700, 2008
-
deadchip
well amazon has always been slightly low-brow
2008-07-25 20709, 2008
-
xlotlu
user-generated content ftw
2008-07-25 20726, 2008
-
deadchip
"Askville Can't find what you're looking for? Ask Askville! There's a growing community of people just waiting to answer your question. "
2008-07-25 20727, 2008
-
deadchip
lol
2008-07-25 20741, 2008
-
deadchip
although their mechanical turk idea is great
2008-07-25 20755, 2008
-
deadchip
it's basically like all user-generated-content web sites work
2008-07-25 20759, 2008
-
xlotlu
so, hmm... that's really useful
2008-07-25 20717, 2008
-
xlotlu
they list the UPC for all ASINs it seems
2008-07-25 20753, 2008
-
Dhraakellian wonders if he should add dates to the performance AR's
2008-07-25 20710, 2008
-
xlotlu
Dhraakellian: do that, do that
2008-07-25 20737, 2008
-
Dhraakellian
8 tracks with track-level AR's... is there a quicker way to do this?
2008-07-25 20736, 2008
-
xlotlu
2008-07-25 20725, 2008
-
xlotlu
Dhraakellian: start by adding an AR to the release. on that page you have a link to "add relationships to tracks on this release"
2008-07-25 20739, 2008
-
Dhraakellian
also, would 'Symphonies Nos. 1 "Classical", 5' be better than the current release title?
2008-07-25 20746, 2008
-
xlotlu
or something alike... and then you get a nice page with checkboxes for tracks
2008-07-25 20700, 2008
-
Dhraakellian
xlotlu: it already has the symphony orchestra and conductor AR's for each track
2008-07-25 20719, 2008
-
xlotlu
Dhraakellian: ah :/
2008-07-25 20737, 2008
-
xlotlu
then no, no faster way
2008-07-25 20711, 2008
-
xlotlu
Dhraakellian: but at least put the date in the annotation...
2008-07-25 20721, 2008
-
Dhraakellian
already done
2008-07-25 20703, 2008
-
Infinito- joined the channel
2008-07-25 20700, 2008
-
Dhraakellian
hmm... "The Royal Edition"
2008-07-25 20709, 2008
-
Dhraakellian
"No. 64 of 100"
2008-07-25 20738, 2008
-
Dhraakellian
with a painting by HRH the Prince of Wales on the front cover
2008-07-25 20756, 2008
-
Dhraakellian should probably put something to that effect in the annotation
2008-07-25 20711, 2008
-
xlotlu
Dhraakellian: last time i had to do that, i removed all the previous ARs
2008-07-25 20731, 2008
-
Dhraakellian
hmm
2008-07-25 20744, 2008
-
xlotlu
which got some mixed opinions...
2008-07-25 20754, 2008
-
Dhraakellian
and changing the "&" to "from ... to" is still *technically* correct, I suppose
2008-07-25 20755, 2008
-
xlotlu
but then again, that was a 50-track release
2008-07-25 20718, 2008
-
Dhraakellian
hehhehheh
2008-07-25 20725, 2008
-
ruaok joined the channel
2008-07-25 20739, 2008
-
ruaok
niklas: ping!
2008-07-25 20746, 2008
-
niklas
hello
2008-07-25 20750, 2008
-
ruaok
hi!
2008-07-25 20706, 2008
-
xlotlu
hi ruaok
2008-07-25 20707, 2008
-
ruaok
so, the easy way to do date calculations is to either doit using julian dates or seconds.
2008-07-25 20710, 2008
-
ruaok
hi xlotlu
2008-07-25 20725, 2008
-
ruaok
julian dates are total overkill for this and would require a new module.
2008-07-25 20726, 2008
-
xlotlu
2008-07-25 20728, 2008
-
ruaok
so, that's silly.
2008-07-25 20745, 2008
-
niklas
yes
2008-07-25 20749, 2008
-
ruaok
but you can get a date expressed in seconds since the epoch (1-1-70)
2008-07-25 20705, 2008
-
ruaok
then to add one to the date simply do
2008-07-25 20716, 2008
-
ruaok
date += (24 * 60 * 60)
2008-07-25 20732, 2008
-
ruaok
and convert the date back into yyyy-mm-dd format
2008-07-25 20751, 2008
-
Dhraakellian
ruaok: but a mistake results in epoch fail
2008-07-25 20712, 2008
-
Dhraakellian isn't sure whether to be ashamed of himself for recycling that horrid pun
2008-07-25 20724, 2008
-
niklas
but dont that conversion back to yyyy-mm-dd format require some module I dont have?
2008-07-25 20731, 2008
-
ruaok
Dhraakellian: thanks. I was waiting for that. :)
2008-07-25 20731, 2008
-
xlotlu
:D
2008-07-25 20757, 2008
-
ruaok
niklas: maybe. I would have to review what functions we have.
2008-07-25 20705, 2008
-
ruaok
sometimes its possible to have postgres add a day
2008-07-25 20714, 2008
-
ruaok
I'm not sure if that works in this context.
2008-07-25 20716, 2008
-
niklas
ahh
2008-07-25 20727, 2008
-
ruaok
you certainly don't want to make an extra call to postgres for that.
2008-07-25 20739, 2008
-
niklas
ok
2008-07-25 20747, 2008
-
ruaok
but if you can squeeze that in as part of a sql query then you're in good share.
2008-07-25 20752, 2008
-
ruaok
shape.
2008-07-25 20712, 2008
-
ruaok
2008-07-25 20723, 2008
-
ruaok has to finish up the next blog post.
2008-07-25 20723, 2008
-
niklas
there's no CAST for casting e.g. unix timestamp to yyyy-mm-dd format?
2008-07-25 20745, 2008
-
ruaok
Google invited a bunch of people for dinner and I dont want to be late -- its a nice dinner. :)
2008-07-25 20748, 2008
-
ruaok
<3 Google
2008-07-25 20707, 2008
-
ruaok
not a cast, no.
2008-07-25 20707, 2008
-
xlotlu
select foo, foo + '1 day'::interval as foo_tomorrow
2008-07-25 20714, 2008
-
ruaok
ding!!
2008-07-25 20742, 2008
-
Dhraakellian is feeling lazy atm and will just leave the dates in the annotation
2008-07-25 20744, 2008
-
ruaok
xlotlu: something like that is what I had in mind.
2008-07-25 20752, 2008
-
Dhraakellian
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
2008-07-25 20732, 2008
-
Dhraakellian
<3 X11's middle-click paste
2008-07-25 20726, 2008
-
xlotlu
2008-07-25 20753, 2008
-
xlotlu
i dream of editing an entire release in a text editor in say.. yaml format
2008-07-25 20753, 2008
-
niklas
xlotlu: thank you :)
2008-07-25 20700, 2008
-
aCiD2
xlotlu: one day... one day
2008-07-25 20706, 2008
-
xlotlu
niklas: extract (epoch from datefield)
2008-07-25 20756, 2008
-
Dhraakellian
how would one encode dates before 1970?
2008-07-25 20719, 2008
-
xlotlu
niklas: sorry, you wanted the other day around: to_timestamp(int)
2008-07-25 20734, 2008
-
xlotlu
(or was it double?)
2008-07-25 20719, 2008
-
xlotlu
Dhraakellian: negative integers, obviously :)
2008-07-25 20739, 2008
-
Dhraakellian
heck with BC/AD and BCE/CE!
2008-07-25 20744, 2008
-
Dhraakellian
BE and AE?
2008-07-25 20700, 2008
-
pbryan has quit
2008-07-25 20705, 2008
-
niklas
xlotlu: ah, but this wont work if its not a timestamp?
2008-07-25 20727, 2008
-
xlotlu
niklas: what / which part?
2008-07-25 20730, 2008
-
niklas
dates are stored as CHAR(10) formatted "yyyy-mm-dd"
2008-07-25 20747, 2008
-
niklas
foo ´'1 day'::interval and extract
2008-07-25 20751, 2008
-
xlotlu
they are char in the db, not timestamp??
2008-07-25 20758, 2008
-
niklas
yes, as far as I can see
2008-07-25 20707, 2008
-
xlotlu
why? o.O
2008-07-25 20751, 2008
-
xlotlu
niklas: you can use to_timestamp(date_string, date_format) ...
2008-07-25 20720, 2008
-
niklas
xlotlu: seems like most dates are stored as timestamps, but not the one Im using. its possible that Im messing with the wrong date
2008-07-25 20737, 2008
-
niklas
great
2008-07-25 20745, 2008
-
Kerensky98 has left the channel
2008-07-25 20709, 2008
-
xlotlu
you can just cast it to timestamp if it's in the default format (normally yyyy-mm-dd)
2008-07-25 20703, 2008
-
niklas
no need to specify format string if its YYYY-MM-DD?
2008-07-25 20744, 2008
-
xlotlu
niklas: casting as in 'string'::timestamp
2008-07-25 20733, 2008
-
xlotlu
about to_timestamp, i dunno. if there's a to_timestamp(varchar) function, then that's what it probably does :)
2008-07-25 20735, 2008
-
niklas
ohh
2008-07-25 20736, 2008
-
deadchip
if there was ever cheese on a pizza then it's on the one i just made
2008-07-25 20751, 2008
-
Dhraakellian
hmm
2008-07-25 20705, 2008
-
Dhraakellian somehow read the word "war" in there somehow
2008-07-25 20726, 2008
-
deadchip
i think it's b ecause "was ever" were placed unusually
2008-07-25 20733, 2008
-
deadchip
maybe rather "if there ever was cheese"
2008-07-25 20737, 2008
-
Dhraakellian declares cheese on deadchip
2008-07-25 20700, 2008
-
deadchip accepts with sour and cream
2008-07-25 20708, 2008
-
Dhraakellian changes his mind and decides to seek Peas
2008-07-25 20713, 2008
-
deadchip
2008-07-25 20707, 2008
-
ruaok
xlotlu: thanks for helping niklas.
2008-07-25 20720, 2008
-
ruaok
niklas: if you need more help, send me another mail.
2008-07-25 20729, 2008
-
xlotlu
:)
