How do I get more information showing up in the server console log? I want prints and warns showing up
2014-03-31 09020, 2014
navap
I tried enabling CATALYST_DEBUG but that just shows that annoying front end sidebar
2014-03-31 09054, 2014
JesseW joined the channel
2014-03-31 09005, 2014
navap
Looks like I can resort to using dies :/
2014-03-31 09035, 2014
JonnyJD_ joined the channel
2014-03-31 09046, 2014
ruaok joined the channel
2014-03-31 09001, 2014
xram joined the channel
2014-03-31 09009, 2014
MBJenkins joined the channel
2014-03-31 09001, 2014
djinni` joined the channel
2014-03-31 09031, 2014
d4rkie joined the channel
2014-03-31 09039, 2014
nikki joined the channel
2014-03-31 09016, 2014
UmkaDK joined the channel
2014-03-31 09008, 2014
TheoDickson joined the channel
2014-03-31 09024, 2014
TheoDickson
Hi all. I was here last week asking about setting up a local copy of the server as VM, you were all so helpful and I managed to do that as well as point the python API towards it. Now I can start gathering data for my project without the rate limit so thanks very much! however my scripts need to work off of a comprehensive list of all the recording IDs in the database, and I'm struggling to figure out how I might obtain this. All the method
2014-03-31 09016, 2014
TheoDickson
I'm sure there is a much more efficient way to obtain this than using the API, but I don't really know how to operate inside the VM terminal.
2014-03-31 09015, 2014
ruaok
TheoDickson: do you speal SQL?
2014-03-31 09000, 2014
TheoDickson
ruaok: that is indeed the problem, I do not.
2014-03-31 09022, 2014
ruaok
that seems a bit of a blocker for this project, no?
2014-03-31 09045, 2014
ruaok
do you know how to use SSH?
2014-03-31 09021, 2014
TheoDickson
Well I'm eager to learn whatever is necessary, I didn't even know any python three weeks ago when i started but now I have loads of scripts written to do all sort of stuff, which I've tested on smaller lists of IDs. so I only really need enough SQL to just get the list of IDs. and yes yes sort of.
2014-03-31 09048, 2014
ruaok
select gid from recording;
2014-03-31 09050, 2014
ruaok
:)
2014-03-31 09013, 2014
ruaok
but just the recording IDs without any other information isn't likely going to yield anything useful.
Once I have a list of IDs I can do all sorts of stuff via the python API. I understand that it will probably take much longer to execute that if I learnt to directly extract data from the database using SQL but I have plenty of time. I may end up just trying to learn SQL anyway though!
2014-03-31 09031, 2014
ruaok
if you ask for the list of ids, you'll have 15M of them. most of them irrelephant to what you're doing.
2014-03-31 09044, 2014
TheoDickson
haha that is my life right now
2014-03-31 09000, 2014
TheoDickson
I know... i have a python script that takes a list of IDs, grabs the artist list for each, does nothing if that list is of length 1 and otherwise appends a dict entry to a 'collaborations list' that looks like {songid: [artistlist]}
2014-03-31 09022, 2014
TheoDickson
so then I would have a comprehensive list of all the collaborations.
it would be if there was a way to access the track number of each medium, which I don't think there is
2014-03-31 09021, 2014
Mineo
but then again, the proper way to fix it is to not buy shitty devices :P
2014-03-31 09033, 2014
Nyanko-sensei joined the channel
2014-03-31 09006, 2014
Mineo
it's not like multi-disc releases and id3 were just invented last year
2014-03-31 09029, 2014
chirlu`
Oy, but it’s a Walkman®!
2014-03-31 09027, 2014
olaf_
would ogg and flac players have the same bug? or just mp3 players? my walkman also doesnt like fullsize images as cover art, see 579
2014-03-31 09012, 2014
olaf_
at least that part has a (partly working) UI to work around it. But again, why default to fullsize if 500px would work as well for "everyone"? No idea where fullsize actually makes a difference. And how large "all the other covers pics" are.
2014-03-31 09010, 2014
warp
olaf_: presumably in the kind of media playback devices hooked up to living room HD TVs.
2014-03-31 09042, 2014
olaf_
warp: sure. not sure what the quick dimension check is, but "find -name "cover*" -type f -print0 | sort -z | xargs -0 display" shows various sizes, from maybe 400x400 up to 2000x2000 or whatever. So I think those players have to scale up anyway.
2014-03-31 09019, 2014
warp
olaf_: There are only three sizes available at the cover art archive, max 250px, max 500px, and original.
2014-03-31 09049, 2014
olaf_
in the end the user tagging the MP3s for that sort of Walkman has to tweak UI settings anyway (if they get implemented), so he can very well select different size from pulldown menu, and tracknumber workaround checkbox.
2014-03-31 09049, 2014
warp
olaf_: it might be a good option to take the original and resize to max 1200 (to match iTunes), but that means picard needs to start resizing images -- which is slightly more work than just embedding whatever was downloaded.
2014-03-31 09014, 2014
olaf_
would be nice to know how many devices are affected by that tracknumber sorting bug. All of Sony, or just the ones produced on Monday.
2014-03-31 09031, 2014
olaf_
regarding the '?' in filenames, looks like I forgot to set windows compatibility. Or its a new option, after 1.2, and it does not default to ON. which would be a bug. In the end files go to FAT32.
2014-03-31 09013, 2014
kepstin-laptop joined the channel
2014-03-31 09058, 2014
chirlu` has left the channel
2014-03-31 09050, 2014
chirlu` joined the channel
2014-03-31 09055, 2014
hawke1 joined the channel
2014-03-31 09019, 2014
Mineo
fwiw, the default file size has been changed between 1.2 and now
2014-03-31 09015, 2014
CallerNo6 joined the channel
2014-03-31 09059, 2014
JesseW joined the channel
2014-03-31 09013, 2014
bitmap joined the channel
2014-03-31 09041, 2014
bitmap joined the channel
2014-03-31 09008, 2014
nikki joined the channel
2014-03-31 09019, 2014
barrynorton joined the channel
2014-03-31 09005, 2014
ruaok
uh oh. barrynorton is here.
2014-03-31 09019, 2014
barrynorton
hey :)
2014-03-31 09050, 2014
ruaok
welcome.
2014-03-31 09011, 2014
ruaok
ruaok has changed the topic to: Ice Ice Baby week | Agenda: Heckle Barry (ruaok), DRs
2014-03-31 09043, 2014
barrynorton
I've a question about URL-encoding of tags, which is a bit of a blocker for me - would be good to know who to quiz about that
2014-03-31 09004, 2014
ruaok
oh, right. sorry, that's been sitting in my personal email box for eons.
2014-03-31 09008, 2014
ruaok
BANG!
2014-03-31 09030, 2014
ruaok
ruaok has changed the topic to: Ice Ice Baby week | Agenda: URL encoding tags (barrynorton), DRs
2014-03-31 09036, 2014
ruaok
right. anyone present?
2014-03-31 09042, 2014
bitmap is here
2014-03-31 09043, 2014
ruaok
now that we're all on the same page again?
2014-03-31 09046, 2014
ruaok pokes Freso
2014-03-31 09053, 2014
Freso
Wha'?
2014-03-31 09058, 2014
chirlu` just came in.
2014-03-31 09008, 2014
Freso
Oh, crap. There went my cover. :(
2014-03-31 09016, 2014
ruaok
poke poke poke poke
2014-03-31 09020, 2014
ruaok runs after Freso
2014-03-31 09023, 2014
Freso
D:
2014-03-31 09030, 2014
warp has one eye in this channel.
2014-03-31 09037, 2014
Freso
And the other on the sky?
2014-03-31 09040, 2014
ruaok wonders where the other eye is
2014-03-31 09040, 2014
reosarevok is here
2014-03-31 09058, 2014
warp
ruaok: working
2014-03-31 09009, 2014
ruaok
good good.
2014-03-31 09017, 2014
ruaok
well, no ianmcorvidae. or nikki.
2014-03-31 09036, 2014
ruaok
lets answer barrynorton's question.
2014-03-31 09043, 2014
ruaok
barrynorton: explain it to us please?
2014-03-31 09057, 2014
barrynorton
so mostly tags seem to tag URL-encoded on the end of mb.org/tag...
2014-03-31 09059, 2014
chirlu`
chirlu` has changed the topic to: Ice Ice Baby week | Agenda: URL encoding tags (barrynorton), place duplicate check (chirlu), DRs
