2008-02-22T00:02:20 *** sylvar has joined #openils-evergreen 2008-02-22T00:07:13 *** sylvar has quit IRC 2008-02-22T00:48:52 *** lisppaste6 has quit IRC 2008-02-22T00:56:42 *** lisppaste6 has joined #openils-evergreen 2008-02-22T02:46:58 *** asmodai has quit IRC 2008-02-22T02:47:00 *** asmodai has joined #OpenILS-Evergreen 2008-02-22T05:22:15 *** ibbo has joined #OpenILS-Evergreen 2008-02-22T08:10:58 *** dmcmorris_esi has joined #openils-evergreen 2008-02-22T08:17:11 *** pmurray_away is now known as pmurray 2008-02-22T08:20:36 *** gmcharlt has quit IRC 2008-02-22T08:20:46 *** gmcharlt has joined #OpenILS-Evergreen 2008-02-22T08:34:14 *** greg-g has joined #openils-evergreen 2008-02-22T08:41:08 *** Karen_ has joined #OpenILS-Evergreen 2008-02-22T08:48:33 *** dbs has joined #OpenILS-Evergreen 2008-02-22T09:02:11 *** rsinger has quit IRC 2008-02-22T09:19:19 *** rsinger has joined #OpenILS-Evergreen 2008-02-22T09:30:53 *** atheos has joined #OpenILS-Evergreen 2008-02-22T09:55:06 So dfiander's stuff isn't visible at http://acq.open-ils.org/oils/acq/base/index yet, eh? 2008-02-22T10:06:08 *** djfiander has joined #OpenILS-Evergreen 2008-02-22T10:06:15 test 2008-02-22T10:06:23 dbs: I svn up that box 2008-02-22T10:06:26 *** djfiander has left #OpenILS-Evergreen 2008-02-22T10:06:27 s/I/I will/ 2008-02-22T10:06:34 *** djfiander has joined #OpenILS-Evergreen 2008-02-22T10:06:39 test 2008-02-22T10:06:43 ok 2008-02-22T10:06:43 pong 2008-02-22T10:07:12 *** djfiander has left #OpenILS-Evergreen 2008-02-22T10:07:36 awesome 2008-02-22T10:08:17 no new code.. 2008-02-22T10:09:21 djfiander's 'view all picklists' is up there 2008-02-22T10:18:18 *** djfiander has joined #openils-evergreen 2008-02-22T10:21:56 dbs: have your travel woes been resolved, yet? 2008-02-22T10:22:11 berick: ah, okay - I thought there had been progress on viewing po's and lineitems and stuff too 2008-02-22T10:22:21 berick: well, I'm at home 2008-02-22T10:22:31 but my passport is apparently in the hands of fedex 2008-02-22T10:23:15 this calls for a rain dance 2008-02-22T10:25:17 progress? what is this progress of which you speak? 2008-02-22T10:26:04 heh 2008-02-22T10:27:06 bah 2008-02-22T10:27:09 brb 2008-02-22T10:27:11 *** djfiander has quit IRC 2008-02-22T10:27:44 dbs: there was, but not comitted yet, it seems 2008-02-22T10:27:56 eeevil: you think that 1GB of RAM might be too small for a transaction spanning the import of 2.1 million bib records? 2008-02-22T10:28:40 I wondered whether removing the transaction would alleviate the import problem (that being said, there will still be an incredible amount of other memory-related problems) 2008-02-22T10:28:56 *** djfiander has joined #openils-evergreen 2008-02-22T10:29:10 lets see if this works any better 2008-02-22T10:29:11 berick: i'll just remind djfiander to commit early and commit often 2008-02-22T10:29:47 I can commit now, as long as you don't go too far into the po stuff 2008-02-22T10:30:25 incomplete interfaces are fine at this point, IMO 2008-02-22T10:30:50 ok 2008-02-22T10:33:07 yay! 2008-02-22T10:36:12 * dbs feels like a fanboi 2008-02-22T10:41:16 ok, PO stuff has been committed. 2008-02-22T10:41:35 just don't try to look at a line item in a PO 2008-02-22T10:41:51 djfiander++ 2008-02-22T10:42:00 * berick updates the acq box 2008-02-22T10:46:54 and now I've fixed the typos in the PO code. ;-) 2008-02-22T10:47:43 would it be geeky for me to have a whiteboard in my office at home? 2008-02-22T10:48:12 i'd have one if I had a free wall 2008-02-22T10:48:53 djfiander: the whiteboard doesn't equate to geekiness... the contentes of the whiteboard may ;) 2008-02-22T10:49:13 s/contentes/contents 2008-02-22T10:54:54 dbs: sorry ... yeah, 2.1M bibs will be on the order of 60M rows in full_rec alone (or more, if they're "good" records) ... theoretically, it should work, but there's a lot of management overhead going on there 2008-02-22T10:56:24 djfiander: if I could get to the walls of my home office over the junk piled along them then I'd have whiteboards here ... so, consider that how you will ;) 2008-02-22T10:56:28 how does one go off the record 2008-02-22T10:56:37 -= THIS MESSAGE NOT LOGGED =- 2008-02-22T10:56:46 no sticky setting yet, though 2008-02-22T10:56:52 -= THIS MESSAGE NOT LOGGED =- 2008-02-22T11:09:52 -= THIS MESSAGE NOT LOGGED =- 2008-02-22T11:12:32 -= THIS MESSAGE NOT LOGGED =- 2008-02-22T12:05:48 miker_: just fix your client so it always prepends ! and you've got your damned sticky setting 2008-02-22T12:06:50 Hmm 2008-02-22T12:07:29 dbs: indeed 2008-02-22T12:07:44 problem: if different copies can be charged to different funds, then it DOES matter which copies arrive. 2008-02-22T12:08:15 that is, if we have a partial shipment, then we need to mark off the line item detail lines for the funds that we want to charge now 2008-02-22T12:18:31 won't there be a shipping manifest that maps copies to purchase orders? 2008-02-22T12:19:44 one PO==one fund? If so, then dbs would be correct (if not the packing list, then the invoice from them) 2008-02-22T12:19:53 dbs: yes, but remember when we talked about branch-based funding? if I ordered 10 copies to be charged to 6 branches, and 7 copies arrive, then some funds need to be charged and others not 2008-02-22T12:20:21 and what the provider lists doesn't necessarily correspond to what we decide to do with the partial shipment 2008-02-22T12:21:32 dmcmorris_esi: not quite. we pushed funds into individual copies to deal with a system that does central ordering, but charges books to branch budgets 2008-02-22T12:21:32 I guess I don't understand the problem 2008-02-22T12:23:51 * djfiander takes it to email 2008-02-22T12:24:21 djfiander: ahh.... ok... /me is too uninvolved to have opinions ;) 2008-02-22T12:59:20 berick: when I call open-ils.acq.po_lineitem.retrieve to fetch the list of lineitem details, it would be good if the lineitem itself was fleshed out the way it is when I call open-ils.acq.purchase_order.retrieve to fetch the list of lineitems 2008-02-22T13:05:17 *** djfiander is now known as djf-out 2008-02-22T13:05:28 djf-out: lemme look at what it's returning 2008-02-22T13:05:53 IIR, it could be quite a lot of data. we may be able to trim some bits out just for that interface, though 2008-02-22T13:06:47 true. I just want summary info to display at the top. 2008-02-22T13:07:04 ok, now for lunch and erranding. keep me posted. 2008-02-22T13:14:20 *** ibbo has quit IRC 2008-02-22T13:18:40 djf-out: will do 2008-02-22T13:45:10 *** dmcmorris_esi is now known as dmcmorr_esi_away 2008-02-22T13:45:16 *** dmcmorr_esi_away is now known as dmcmorris_esi 2008-02-22T14:09:29 *** dmcmorris_esi is now known as dmcmorr_esi_away 2008-02-22T14:09:31 *** dmcmorr_esi_away is now known as dmcmorris_esi 2008-02-22T14:33:43 *** djf-out is now known as djfiander 2008-02-22T14:36:14 *** Karen_ has left #OpenILS-Evergreen 2008-02-22T14:45:38 berick: open-ils.acq.po_lineitem.retrieve needs a "clear_marc" option 2008-02-22T15:23:15 trying to do everything in in the template is insane. I'm going to do the data generation in the controller and pass simple data to the template. 2008-02-22T15:33:20 that sounds roughly the way pylons is supposed to work 2008-02-22T15:52:37 ok, you can now see line item details. 2008-02-22T15:52:43 assuming there are any ;-) 2008-02-22T16:01:28 *** djfiander has quit IRC 2008-02-22T16:13:06 *** djfiander has joined #openils-evergreen 2008-02-22T16:14:26 eeevil: you'll cry a little bit, but I've reinvented a worse version of import_holdings.pl for the pre-conf holdings import phase (hardcoded values for the subfields, etc) 2008-02-22T16:15:15 *** djfiander has quit IRC 2008-02-22T16:15:30 but it's only about 50 lines of Perl code, and commented, so it's hopefully way easy for people to grok 2008-02-22T16:15:32 *** djfiander has joined #openils-evergreen 2008-02-22T16:16:31 *** denials has joined #OpenILS-Evergreen 2008-02-22T16:20:15 *** djfiander has quit IRC 2008-02-22T16:27:21 *** djfiander has joined #openils-evergreen 2008-02-22T16:31:12 test 2008-02-22T16:31:46 let's see how long my network connection lasts 2008-02-22T16:32:56 *** djfiander has quit IRC 2008-02-22T16:36:17 *** djfiander has joined #openils-evergreen 2008-02-22T16:40:37 *** sylvar has joined #openils-evergreen 2008-02-22T16:43:03 oh, and the exchange rate when selling USD is 0.996 :( 2008-02-22T16:43:45 I'm still getting no results when trying to search. open-ils.search_unix.log says: 2008-02-22T16:43:51 2008/02/22-14:34:19 OpenSRF::UnixServer (type OpenSRF) starting! pid(32537) 2008-02-22T16:44:03 Binding to UNIX socket file /openils/var/sock/open-ils.search_unix.sock using SOCK_STREAM 2008-02-22T16:44:05 Group Not Defined. Defaulting to EGID '1003 1003' 2008-02-22T16:44:06 User Not Defined. Defaulting to EUID '1003' 2008-02-22T16:44:28 That looks like maybe I need to fix a config file -- or am I wrong? 2008-02-22T16:45:24 * sylvar sighs. She *would* need a ride just now... 2008-02-22T16:45:31 *** sylvar has quit IRC 2008-02-22T17:05:27 *** pmurray is now known as pmurray_away 2008-02-22T17:28:38 * berick updates the acq box 2008-02-22T17:29:19 time to eat and go get The Kid for the weekend. laters 2008-02-22T17:29:21 *** djfiander has quit IRC 2008-02-22T17:59:44 berick: the passport didn't arrive today 2008-02-22T17:59:59 and there are no fedex shipments on weekends here 2008-02-22T18:00:05 so I'm screwed. 2008-02-22T18:13:57 *** eeevil has quit IRC 2008-02-22T18:17:13 *** eeevil has joined #openils-evergreen 2008-02-22T18:20:36 dbs: holy crap 2008-02-22T18:21:24 * berick is shocked they don't deliver on saturydays 2008-02-22T18:25:28 but, since there's no such thing as "saturydays", i should cut them some slack 2008-02-22T18:28:07 hah 2008-02-22T18:28:28 dbs: i assume getting into the states with no PP is neigh on impossible? 2008-02-22T18:28:34 well - I'll call to confirm, but that's what I've been able to tell from their web site 2008-02-22T18:28:57 berick: I could drive across the border and catch another flight from within the states 2008-02-22T18:36:21 *** pinesol` has joined #openils-evergreen 2008-02-22T18:36:51 berick: I'm going to do my best to have everything completely packaged up for you and murph 2008-02-22T18:37:09 *** pinesol has quit IRC 2008-02-22T18:37:09 *** dmcmorris_esi has quit IRC 2008-02-22T18:37:45 I can't tell you how bad I feel about this. 2008-02-22T18:40:26 dbs: cool, point me at whatever you have as you have it. i'll start going through it and preparing for the worst ;) 2008-02-22T18:51:36 *** dmcmorris_esi has joined #openils-evergreen 2008-02-22T19:07:36 dbs pasted "miker_ / eeevil - does this make sense as a patch for marc2bre?" at http://paste.lisp.org/display/56347 2008-02-22T19:09:34 dbs: it does, assuming we're checking for uniqueness of $id in the main loop and not just trusting what the legacy system says ... because, well, they very often lie :) 2008-02-22T19:09:54 eeevil: by way of explanation, I've dumped the catkey into 035a and without that patch I'm going nowhere fast :) 2008-02-22T19:10:30 sure, I understand 2008-02-22T19:10:33 dbs: i'm amazed you're still getting work done 2008-02-22T19:10:35 yup, the system finds dupes and drops in record# as substitute as otherwise expected 2008-02-22T19:10:41 I've seen duplicate catkeys, though :) 2008-02-22T19:10:49 right 2008-02-22T19:10:52 purrrrfect 2008-02-22T19:10:55 miker_: hell, I've got 4 dupe catkeys in 500 records 2008-02-22T19:11:01 gah 2008-02-22T19:11:03 hrm... 2008-02-22T19:11:17 could it just be overflow-holdings dupes? 2008-02-22T19:11:23 gsf: yeah, now the pressure is to get everything as solid as possible for berick and murph to pick up the slack 2008-02-22T19:11:51 U spits out multiple records if the holdings won't all fit in a single 100k record 2008-02-22T19:12:38 miker_: yep, that seems to be the case - the dupes just have 852/853 fields 2008-02-22T19:13:06 -= THIS MESSAGE NOT LOGGED =- 2008-02-22T19:13:07 gah 2008-02-22T19:13:17 dbs: i'm sure they'll do fine 2008-02-22T19:13:22 852, 853, 863, 866 - they're serials holdings 2008-02-22T19:28:33 *** sarabee has quit IRC 2008-02-22T19:31:04 *** sarabee has joined #openils-evergreen 2008-02-22T19:39:42 *** sarabee has quit IRC 2008-02-22T19:43:26 *** sarabee has joined #openils-evergreen 2008-02-22T20:10:41 booo 2008-02-22T20:12:40 dbs: miker_: hey database gurus; I'm working on generating fake patron data for demo usage, and am tempted to generate SQL statements like so: INSERT INTO actor.card (barcode,usr) VALUES ('blah', (select last_value from actor.usr_id_seq)); INSERT INTO actor.usr_address, etc. except that's not reliable, even within a transaction.. the seq may get incremented elsewhere.. so I'm just curious about the best way to do things like that. Create a tem 2008-02-22T20:12:48 let me know if some of that got truncated 2008-02-22T20:14:21 got truncated afte "Create a tem" 2008-02-22T20:14:23 for me 2008-02-22T20:14:47 Create a temp table and treat it like a variable, throwing nextval('actor.usr_id_seq') into it? or are there variables I could use in psql? Or would you just specify id's manually from some large offset? 2008-02-22T20:15:39 s//specify a starting point and generate your own sequence of id's to use/ 2008-02-22T20:19:17 I like the notion of having a sql script that I could give to anyone for them to populate their EG instance with fake patrons, regardless of how their existing actor.usr and related tables are populated 2008-02-22T20:19:25 the sequence should be reliable within a given transaction, shouldn't it? 2008-02-22T20:19:37 it's not, at least not the way I was using it 2008-02-22T20:20:32 sequences don't get rolled back either 2008-02-22T20:22:30 sequences not getting rolled back doesn't surprise me, but not being able to count on the sequence within a transaction does 2008-02-22T20:23:17 can you paste what you were doing? 2008-02-22T20:23:30 If I use nextval(), I can rely on that number not getting re-used, but I can't rely on select last_value from sequence; not changing from things happening elsewhere 2008-02-22T20:24:35 so I really just need a way to store the value from nextval for use in multiple insert/update statements within a transaction 2008-02-22T20:25:11 phasefx pasted "example for dbs" at http://paste.lisp.org/display/56348 2008-02-22T20:25:17 i think you want currval, no? 2008-02-22T20:25:46 wasn't familiar with it, let me try that 2008-02-22T20:25:49 see http://www.postgresql.org/docs/8.2/static/functions-sequence.html 2008-02-22T20:25:57 it's the same way db2 operated 2008-02-22T20:26:00 dbs++ 2008-02-22T20:27:27 that works exactly like it needs to 2008-02-22T20:27:32 thanks man 2008-02-22T20:27:35 yay 2008-02-22T20:27:58 I can nextval all day long outside of that transaction, but within the transaction, I'm getting the last sequence value used in that transaction 2008-02-22T20:29:00 I wrote the sequence docs for db2, so something's still rattling around in my brain 2008-02-22T20:29:51 so selecting from actor.usr_id_seq is akin to peeking into an implementation; don't do that 2008-02-22T20:31:03 phasefx annotated #56348 with "use currval" at http://paste.lisp.org/display/56348#1 2008-02-22T20:31:16 ignore that, just for posterity 2008-02-22T20:39:18 good idea 2008-02-22T20:40:20 phasefx_: curval('seq_name') 2008-02-22T20:40:30 er, currval ... yeah 2008-02-22T20:41:05 confirmation++ 2008-02-22T20:41:25 nevermind me and my flu-addled, scrollback-non-completing brain 2008-02-22T20:41:50 -= THIS MESSAGE NOT LOGGED =- 2008-02-22T20:42:22 dbs beat me to the punch :) ... I read "I'm using select last_val ..." and started typing before I read the rest 2008-02-22T20:42:27 dbs++ 2008-02-22T20:42:39 heh 2008-02-22T21:06:39 yay, successfully imported holdings... miker_++ 2008-02-22T21:07:24 I munged my demo set of records to use the BR[1-4]/BM1/SL1 libraries 2008-02-22T21:08:30 *** sarabee has quit IRC 2008-02-22T21:09:05 dbs: good man 2008-02-22T21:09:06 dbs++ 2008-02-22T21:11:24 *** sarabee has joined #openils-evergreen 2008-02-22T21:11:50 do we want to include a set of import bib records + holdings + a simple bash script of magic spells in, say, an Open-ILS/examples/ subdirectory? 2008-02-22T21:13:53 dbs: I would sooo smooch you if you were to do that! ;) 2008-02-22T21:13:58 I'm not sure about in the repo, but I wouldn't be against a tarball sitting next to in on the downloads page ... would that be enough? 2008-02-22T21:14:17 miker_: sure, that would be fine 2008-02-22T21:14:36 of course, my demo records are half french :) 2008-02-22T21:14:46 goood 2008-02-22T21:15:34 people might think titles like " Esquisse de cours 12e année : english eae4e cours préemploi" are typos 2008-02-22T21:15:52 haha 2008-02-22T21:16:20 dbs: your demo features adult items? cool! ;) 2008-02-22T21:16:50 but tarballing it all up with instructions would probably make berick's life easier on Monday 2008-02-22T23:38:33 tarballed sample and instructions is now at http://open-ils.org/downloads