← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
12:03 | |Lupin| | magnusenger: and the permissions are the same, too ? |
12:05 | magnusenger | |Lupin|: sorry for being unclear, yes. |
12:07 | |Lupin| | magnusenger: np |
12:07 | magnusenger: I asked because I have met this problem | |
12:08 | just because I have ea restrictive umask and forgot to re-run chmod after having generated the translations | |
12:09 | magnusenger | -rw-r--r-- should be ok, right? |
12:16 | |Lupin| | magnusenger: depends for what |
12:17 | magnusenger: if it's for the directories, I'd add x for group and others | |
12:17 | magnusenger: to be sure the webserver is allowed to enter directories | |
12:18 | please everybody | |
12:18 | is it correct that the different libraries are stored in the branches table ? | |
12:18 | and also: why is his called branches rather than, say, libraries ? | |
12:19 | magnusenger | |Lupin|: no, those were the files, eg in prog/nn-NO/modules. Directories are drwxr-xr-x |
12:20 | |Lupin| | magnusenger: should be enough, indeed |
12:20 | magnusenger: after you got the repository, which commands did you use to install ? | |
12:21 | kf | lupin: the defined libraries are stored in branches |
12:22 | magnusenger | |Lupin|: I followed the steps in INSTALL.debian-lenny |
12:22 | kf | lupin: I think the name is for a historical reason, also look at branchrelations and branchcategories |
12:23 | magnusenger | |Lupin|: git clone git://git.koha.org/pub/scm/koha.git kohaclone; cd kohaclone; git checkout -b myinstall origin; perl Makefile.PL; make; make test; sudo make install |
12:23 | kf | lupin: when you define search groups the relation is stored in these tables, but I think groups aren't used in Koha atm |
12:26 | |Lupin| | kf: ok, thanks. I was trying to figure out where the "branch" term comes from. And yes I noticed that several tables have branch in their names |
12:28 | magnusenger: I think there is one additional command to run when compiling from git | |
12:28 | but can't find it | |
12:29 | however I myself added it to the wiki a few days ago | |
12:29 | can't remember to which page, though | |
12:29 | magnusenger | |Lupin| ;-) |
12:32 | |Lupin|: I was a bit unsure about the bit that says "git checkout -b myinstall origin", I can't remember doing that on earlier installs... | |
12:39 | |Lupin| | magnusenger: 'm not sure either, but this may be to create a branh, i.e. if you intend to modify the code |
12:43 | hmm | |
12:43 | once loged in to the wiki | |
12:43 | is there a way to see all the pages one has changed on it ? | |
12:43 | hdl_laptop | there is an rss feed |
12:44 | http://wiki.koha.org/doku.php?do=recent&id=start | |
12:47 | |Lupin| | hdl_laptop: I 'm not sure this is what I'm looking for |
12:47 | hdl_laptop: I'm looking for a list of all the pages _I_ have modified once, even not recently | |
12:53 | magnusenger: cd KOHADIR/misc/translator/ | |
12:53 | magnusenger: ./install-code.pl LANGUAGECODE | |
12:54 | magnusenger: and replace LANGUAGECODE by what is appropriate for you | |
12:54 | magnusenger: does that help ? | |
12:54 | magnusenger: I have finally found the page: http://wiki.koha.org/doku.php?id=en:development | |
13:01 | magnusenger | |Lupin|: That sounded promising, but I get this: http://pastebin.com/m5cf50a07 And I'm not doing a dev install, just a normal install but from git. |
13:06 | |Lupin| | magnusenger: then I don't know. |
13:07 | magnusenger: I guess if I were you I'd examine the script and see wha goes wrong, since it's perhaps not much. | |
13:07 | magnusenger | |Lupin|: Thanks for trying!! |
13:07 | |Lupin| | magnusenger: also: the command may be useful for any install from git, nos sure whether it is specific to dev-installs, installs from gi, ... |
13:27 | please everybody | |
13:28 | Is it correct that koha does not have a function to send a fresh password to a user that would have forgotten or lost it ? | |
13:28 | gmcharlt | |Lupin|: correct |
13:28 | hitting the road again - talk to you all later | |
13:30 | magnusenger | |Lupin| et al: finally thought to look in koha-opac-error_log. With each request to a detail-page in the opac, i get *5* of these: "File does not exist: /usr/share/koha/opac/htdocs/intranet-tmpl, referer: http://sksk.bibkat.no/cgi-bin/[…]pl?biblionumber=1" |
13:31 | now, why would Koha be looking for *opac*/htdocs/*intranet*-tmpl ? | |
13:33 | |Lupin| | magnusenger: no idea, but that's the kind of thing you may be able to debug with Perl's print function, at least |
13:34 | magnusenger: there is a function which is called something like find_user_and_template | |
13:34 | magnusenger: you look this one | |
13:34 | magnusenger | |Lupin|: sure enough, i'll give it a try |
13:35 | |Lupin| | magnusenger: grep "sub find_user_and template" to locate it, or even better use ctag, I think it supports Perl... |
13:38 | hdl_laptop | |Lupin|: ctags++ |
13:39 | |Lupin| | hdl_laptop: :) |
13:39 | it makes people think you are a real hacker when you give the location of a funciton implementing a syscall in the LInux kernel | |
13:45 | schuster | OK gmcharlt - you out of the office? |
13:46 | I see he was hitting the road, but didn't know for how long... | |
13:49 | hmmm I'll catch him via email. | |
13:53 | |Lupin| | schuster: he left a quarter ago or something like that, perhaps more |
14:06 | Snow_Fox | RHCL hate to break it to ya but i think you have incomming agian |
14:07 | wizzyrea | just rain in lawrence :P |
14:07 | Snow_Fox | prob not as bad though |
14:07 | about to rain here agian | |
14:07 | although not as ugly as whats in indiana right now | |
14:15 | |Lupin| | pls, is it correct- to store a user login in the borrowers.userid column ? |
14:15 | not sre what userid refers to. | |
14:16 | ah that's ok | |
14:16 | just had a look to what we have in our database | |
14:17 | schuster | userid is user login to pac and also to staff interface if you provide permissions. |
14:21 | |Lupin| | schuster: yep, that's what I finally figured out. Thanks a lot for your help. |
14:23 | I'm wondering what's he best way to implement dependent choices | |
14:23 | like one authorised value represents a list of manufacturers | |
14:23 | and then for each one there is a list of products | |
14:26 | so two lists, but choice in the second one depends on what has been selected in the first one | |
14:29 | one other ossibility would be onelist that combines manufacturer and products, but it does not look very elegant to me and also, at database level I'd like to have a clear distinction between the two concepts | |
14:29 | does anybody have suggestions or remarks on this, pls ? | |
14:30 | perhaps two lists and then in a function somewhere check that the (manufacturer, product) pair that has been chosen is valid | |
14:32 | schuster | This doesn't sound like a library issue...?? Are you using the system for another purpose? |
14:34 | |Lupin| | schuster: kind of. |
14:34 | schuster: we will use koha to deliver DRM-protected books to visuall impaired persons. | |
14:35 | schuster: so the system must know about manufacturers and platforms for which a book can be encrypted | |
14:35 | Snow_Fox | i know necessary evil |
14:35 | |Lupin| | Snow_Fox: I don't like them either |
14:36 | Snow_Fox: but given the way publishers react in France, the choice is not between DRM and no DRM. The choice is rather between books with DRMs and no book at all. | |
14:37 | Snow_Fox | true |
14:38 | but one can hope cant we | |
14:40 | |Lupin| | Snow_Fox: definitely |
15:00 | Snow_Fox | i think i may have asked this before but cant remember |
15:00 | is there a data dictionary for the database? | |
15:06 | magnusenger | |Lupin| et al: Looks like my earlier problem may have been related to Firefox, not Koha. I tried it in Safari and the languages worked as expected. Then i closed Firefox and started it again, and now it works there too! |
15:08 | paul_p | hey, magnusenger: I apologize... as it's a very known/common issue (related to page caching) |
15:09 | magnusenger | paul_p: good thing it wasn't something completely unknown, then! :-) |
15:10 | paul_p: is this something end users may run into, or is it related to the itranet? Firebug was reporting 404s for some js-stuff that seems to be only used in the intranet... | |
15:11 | ...in the opac | |
15:31 | gotta run, thanks for your help, folks! | |
15:54 | |Lupin| | till soon, everybody. Take care. |
15:57 | Snow_Fox | hey to make a patron a staff memeber is it better to go in a granulaly do it via the permissions or just to set the category to staff |
15:58 | owen | Permissions are the only thing that really affect access |
15:58 | The patron categories don't grant any kind of status on their own | |
15:58 | Snow_Fox | crapski |
15:59 | ok thanks owen | |
16:03 | atz | yeah, case in point... a library may have many "staff" who aren't actually librarians or circdesk ppl |
16:04 | Snow_Fox | well so much for the simple document :-P |
16:05 | rhcl | @seen chris |
16:05 | munin | rhcl: chris was last seen in #koha 5 hours, 59 minutes, and 55 seconds ago: <chris> yep |
16:07 | rhcl | 7.8 quake hit NZ I see, I assume everybody is OK. |
16:07 | Snow_Fox | i would assume not.... |
16:08 | 7.8 is nothing to scoff at ':\ | |
16:08 | rhcl | OK, well, I hope everybody is OK |
16:08 | Snow_Fox | there we go |
16:08 | me too | |
16:08 | rhcl | Yea, that will rattle your cage |
16:08 | Snow_Fox | ok so permissions are not quite like active directory in terms of user groups |
16:11 | well that kinda sucks | |
16:19 | atz | Snow_Fox: by not quite, you mean not at all. |
16:19 | permissions are all based on granted privs to individuals... | |
16:22 | paul_p | hello Snow_Fox & atz & owen |
16:22 | atz | greets paul_p, did you enjoy the holiday? |
16:23 | paul_p | almost time to leave for me, here in Europe |
16:23 | atz: yep. | |
16:23 | although I worked a little yesterday (working on our 2010 plans...) | |
16:24 | we are very very very busy and the next months/years will probably not be too quiet. (note i'm happy with that) | |
16:26 | Snow_Fox | nice |
16:26 | paul_p | atz: do you plan to have some holidays this summer (how many weeks do you have ? iirc, the US standard is 2 weeks per year, isn't it ?) |
16:27 | (in France, the legal minimum is 5 weeks) | |
16:27 | Snow_Fox | atz: yes i mean not at all, i cant set a generic permissions category like circ staff, and when i create a new user or add it to that category he doesnt get the perms |
16:27 | am i correct? | |
16:27 | pianohacker | Snow_Fox: Correct |
16:27 | schuster | snow_fox you are correct |
16:27 | pianohacker | You can only set global defaults right now |
16:28 | atz | paul_p: yes, the french are superior in that respect... |
16:28 | Snow_Fox | pianohacker pickaxe please |
16:28 | are they gonna change it eventually | |
16:28 | paul_p | atz: I won't tell you how many holidays librarians in universities have... you would decide to learn french & move here) |
16:28 | pianohacker | Snow_Fox: <thuck> |
16:28 | Snow_Fox | heh |
16:28 | pianohacker | Snow_Fox: I don't know if there's a bug out for it. |
16:29 | Would be a good thing to get some libraries together and co-sponsor, though | |
16:29 | Snow_Fox | ill keep that in mind |
16:29 | would make user management a bit easier | |
16:29 | atz | Snow_Fox: the proposed mechanism you describe would not be too difficult to implement |
16:30 | the difficulty would be when changing patron category, what happens then? | |
16:31 | your only choices would be (1) nothing, (2) overwrite w/ new categories defaults or (3) supplement w/ new categories defaults | |
16:32 | my impression is that none of this would matter much if you could batch edit effectively. | |
16:33 | Snow_Fox | well the idea is similar to active directory which is what im more familiar with anyways |
16:33 | if need be you can create a new user group and toss those users into it | |
16:33 | the only thing i figure would be problematic would be having users being part of multiple groups | |
16:34 | atz | yeah, the difference is that in AD you can be in many groups... koha has only one field for patron category |
16:34 | Snow_Fox | well |
16:34 | i dont think it would be that hard though | |
16:35 | would change the insides a little thats for sure | |
16:35 | atz | a ton, actually |
16:35 | Snow_Fox | why im not a dedicated programmer :-P |
16:35 | atz | all the circ rules and stats reports depend on patron category |
16:35 | Snow_Fox | oh i see |
16:35 | pianohacker | It would be one of those joyous, slog through the code refactoring projects |
16:36 | Snow_Fox | then why not just leave categorys alone so to speak |
16:36 | and add a feature like | |
16:36 | atz | having singular defaults for new users would be easy.... switching to a multiple group/category based system is a huge rewrite |
16:36 | Snow_Fox | Patron Permissions Blocks |
16:36 | or something | |
16:36 | atz | yeah, that makes sense |
16:36 | pianohacker | Would still be difficult, but more practical |
16:36 | atz | ryan might be working on something similar already |
16:37 | Snow_Fox | heh |
16:37 | nothing to see here | |
16:38 | no grand plans | |
16:38 | etc | |
16:38 | move on | |
16:38 | chris | http://www.stuff.co.nz/nationa[…]uake-measures-7-8 |
16:38 | no real damage | |
16:38 | http://geonet.org.nz/earthquak[…]ecent_quakes.html | |
16:39 | Snow_Fox | i would imagine with all the mountains in NZ especially in the rainforests it would be some nice rock slides |
18:01 | joetho | Hello Ryan! Are you here? |
18:02 | pianohacker | ryan: customerping |
18:03 | joetho | what does THAT mean. |
18:03 | never mind | |
18:34 | hello collum, hello tester | |
18:35 | pianohacker | <TMPL_IF __odd__>Hi, collum!</TMPL_IF> |
18:38 | collum | Hi |
18:39 | joetho | Hi, RYAN! |
18:40 | Five bucks to Ryan's paypal if he writes anything on here in the next hour. | |
18:42 | owen | joetho: If that turned out to work it could revolutionize Koha support |
18:44 | joetho | 56 minutes left. |
18:46 | ryam | Hi there |
18:46 | lost 5 $ ? :) | |
18:47 | pianohacker | @seen ryan |
18:47 | munin | pianohacker: ryan was last seen in #koha 1 week, 6 days, 23 hours, 45 minutes, and 29 seconds ago: * ryan Ryan Higgins, LibLime |
18:47 | pianohacker | So not since the meeting |
18:47 | ryam | hehe :) |
18:53 | wizzyrea | sneaky |
18:59 | joetho | this works great with my daughters |
19:00 | forty minutes left. Operators are standing by! | |
19:22 | Nineteen minutes remaining for this one-time offer! | |
19:22 | chris | heh |
19:23 | ill do it, $5 us is like 10 million nz | |
19:26 | ebegin | Chris, really? |
19:28 | 1 U.S. dollar = 1.54035736 New Zealand dollars | |
19:28 | joetho, what is the offer actually? | |
19:29 | chris | yeah i tend to exaggerate for effect |
19:29 | :) | |
19:30 | joetho | You mean the one that expires in TEN MINUTES?? |
19:31 | ebegin | Yeo |
19:31 | yep | |
19:31 | joetho | I have been trying to reach Ryan by email to schedule some stuff. |
19:31 | ebegin | Oh, i see |
19:44 | joetho | uh oh |
19:44 | times up. | |
20:32 | richard | hi |
20:32 | Snow_Fox | ello |
20:42 | chris | morning richard |
03:04 | quiet today | |
03:06 | ebegin | Hey, does anybody know how rss feed are managed? |
03:07 | chris | in koha? |
03:08 | ebegin | Yes. If I subscibe to a search result in the opac, will the request will be send every time I refresh my RSS reader? |
03:08 | chris | everytime your reader asks for the feed again, yes |
03:10 | ebegin | So if i read my feed from, let's say, Google Reader, every time I refresh my page, this will trigger a search in the catalogue... do you know if this is the way most of the rss feeds work? |
03:12 | chris | not in google reader it wont |
03:12 | google reader fetches feeds periodically | |
03:12 | like bloglines | |
03:13 | refreshing just refreshes your display, it doesnt refetch all the feeds you have subscribed to | |
03:13 | (that way if multiple people are subscribed to a feed, it only gets fetched once, every 10 mins or so ... instead of once per person) | |
03:14 | does that make sense? | |
03:14 | ebegin | a lot actually... :) |
03:15 | chris | if you wanted to publicise a feed |
03:15 | ebegin | Do you know iGoogle? |
03:15 | chris | say recently acquisitioned books |
03:15 | i would use feedburner | |
03:15 | then people could subscribe to that, feedburner fetches it once, ppl fetch it from feedburner lots | |
03:15 | saves your opac getting hit lots | |
03:18 | ebegin | ok, that is good for the example you explaine with the recent acqui... but feedburner can not really used on a search result feed. For exemple, I perform a seach about Computer in the OPAC. I subscribe to the search result to know when a new book will get out from my Computer query. |
03:19 | Am I right? | |
03:19 | chris | yep |
03:21 | ebegin | Ok, and we may encounter problems if 100 persons subscribes to 10 search queries each... |
03:22 | Amit | hi koha #good morning |
03:22 | ebegin | hey Amit! |
03:22 | Amit | heya ebegin |
03:22 | ebegin | How are you? |
03:23 | Amit | ebegin: i m fine what about u? |
03:23 | ebegin | pretty good, thanks. |
03:25 | How's the weather in India? | |
03:26 | Amit: IIRC, You are in India, right? | |
03:26 | Amit | yes i m from India |
03:26 | i m in bangalore weather is good here in bangalore | |
03:26 | ebegin | @wunder montreal, quebec |
03:26 | munin | ebegin: The current temperature in Montreal, Quebec is 19.0°C (11:00 PM EDT on July 15, 2009). Conditions: Mostly Cloudy. Humidity: 73%. Dew Point: 14.0°C. Pressure: 29.92 in 1013 hPa (Falling). |
03:27 | ebegin | @wunder bangalore, india |
03:27 | munin | ebegin: Error: No such location could be found. |
03:27 | Amit | hi munin |
03:28 | ebegin | :) Amit, munin is a bot, an automated machine answering our request |
03:28 | @seen amit | |
03:28 | munin | ebegin: amit was last seen in #koha 1 minute and 4 seconds ago: <Amit> hi munin |
03:28 | Amit | ok i think munin is a person |
03:28 | ebegin | A lot of person think so |
03:29 | Amit | haa.. |
03:50 | hi chris | |
03:50 | chris: http://www.topnews.in/delhi-pu[…]subbranch-2149652 | |
03:51 | chris | ah yep, i saw that a while ago |
03:51 | good news | |
03:52 | Amit | http://www.tenderhome.com/mcd/[…]ease.php3?sno=652 |
03:52 | http://www.indianexpress.com/n[…]doorsteps/489434/ | |
03:53 | ebegin | A lot of work on your shoulders Amit :) |
03:53 | Amit | hmm ur right |
04:52 | brendan | heya amit, chris, mason -- #koha |
04:53 | @ wilsall, mt | |
04:53 | munin | brendan: I suck |
04:53 | Amit | heya brendan |
05:00 | munin: @wunder Delhi | |
05:00 | munin | Amit: I'll give you the answer as soon as RDA is ready |
05:03 | brendan | @wunder wilsall, mt |
05:03 | munin | brendan: The current temperature in Shields Valley, Wilsall, Montana is 11.4°C (11:03 PM MDT on July 15, 2009). Conditions: Clear. Humidity: 84%. Dew Point: 9.0°C. Pressure: 30.27 in 1024.9 hPa (Rising). |
05:03 | ebegin | Amit, is there a province or state in which delhi is? |
05:03 | brendan | @wunder new delhi indian |
05:03 | munin | brendan: The current temperature in New Orleans Lakefront, Louisiana is 28.0°C (11:53 PM CDT on July 15, 2009). Conditions: Clear. Humidity: 77%. Dew Point: 24.0°C. Pressure: 30.06 in 1018 hPa (Steady). |
05:03 | brendan | @wunder new delhi, indian |
05:03 | munin | brendan: The current temperature in New Orleans Lakefront, Louisiana is 28.0°C (11:53 PM CDT on July 15, 2009). Conditions: Clear. Humidity: 77%. Dew Point: 24.0°C. Pressure: 30.06 in 1018 hPa (Steady). |
05:03 | brendan | hehe |
05:04 | ebegin | @wunder new delhi, india |
05:04 | munin | ebegin: The current temperature in New Delhi, India is 33.0°C (10:00 AM IST on July 16, 2009). Conditions: Haze. Humidity: 59%. Dew Point: 24.0°C. Pressure: 29.53 in 1000 hPa (Steady). |
05:04 | ebegin | haha! |
05:04 | brendan | :) |
05:04 | ebegin | @wunder delhi, india |
05:04 | munin | ebegin: Error: No such location could be found. |
05:04 | Amit | ebegin: Delhi is union territory. |
05:05 | brendan | @wunder delhi, uk |
05:05 | munin | brendan: Error: No such location could be found. |
05:05 | Amit | National Capital Territory of Delhi (NCT), is the second-largest metropolis in India. |
05:05 | brendan | @wunder National Capital Territory of Delhi |
05:05 | munin | brendan: The current temperature in Villages of Summit Woods, Reynoldsburg, Ohio is 21.8°C (1:03 AM EDT on July 16, 2009). Conditions: Mostly Cloudy. Humidity: 90%. Dew Point: 20.0°C. Pressure: 29.90 in 1012.4 hPa (Rising). |
05:05 | Amit | @wunder Dehradun |
05:06 | munin | Amit: The current temperature in Dehradun, India is 28.0°C (8:30 AM IST on July 16, 2009). Conditions: Mostly Cloudy. Humidity: 70%. Dew Point: 24.0°C. Pressure: 29.51 in 999 hPa. |
05:06 | ebegin | @wunder wonderland |
05:06 | munin | ebegin: Error: No such location could be found. |
05:06 | ebegin | :) |
05:06 | @wunder moon | |
05:06 | munin | ebegin: Error: No such location could be found. |
05:07 | Amit | @wunder Bangalore |
05:07 | munin | Amit: Error: No such location could be found. |
05:07 | ebegin | @wunder bangalore, karnataka |
05:08 | munin | ebegin: Error: No such location could be found. |
05:08 | ebegin | @wunder bangaluru, karnataka |
05:08 | munin | ebegin: Error: No such location could be found. |
05:08 | ebegin | @wunder bangaluru |
05:08 | munin | ebegin: Error: No such location could be found. |
05:08 | Amit | @wunder bangaluoore |
05:08 | munin | Amit: Error: No such location could be found. |
05:08 | ebegin | @wunder bangaluru, india |
05:08 | munin | ebegin: Error: No such location could be found. |
05:09 | brendan | @wunder bangalore india |
05:09 | ebegin | @wunder bangaluoore, india |
05:09 | munin | brendan: Error: No such location could be found. |
05:09 | ebegin: Error: No such location could be found. | |
05:10 | Amit | @wunder Bengaḷūru |
05:10 | munin | Amit: Error: No such location could be found. |
05:11 | ebegin | @wunder Bengaḷuru, india |
05:11 | munin | ebegin: Error: No such location could be found. |
05:11 | Amit | @wunder New Delhi |
05:12 | munin | Amit: The current temperature in New Delhi, India is 34.0°C (10:30 AM IST on July 16, 2009). Conditions: Haze. Humidity: 56%. Dew Point: 24.0°C. Pressure: 29.53 in 1000 hPa (Steady). |
05:12 | ebegin | @wunder texas |
05:12 | munin | ebegin: Error: No such location could be found. |
05:12 | ebegin | @wunder dallas, texas |
05:12 | munin | ebegin: The current temperature in South of Downtown Dallas, Dallas, Texas is 30.7°C (12:12 AM CDT on July 16, 2009). Conditions: Clear. Humidity: 56%. Dew Point: 21.0°C. Pressure: 29.99 in 1015.5 hPa (Rising). Heat advisory in effect until 7 PM CDT Thursday... |
05:25 | greenmang0 | @wunder mumbai |
05:25 | munin | greenmang0: The current temperature in Mumbai, India is 28.0°C (10:10 AM IST on July 16, 2009). Conditions: Light Drizzle. Humidity: 89%. Dew Point: 26.0°C. Pressure: 29.56 in 1001 hPa (Steady). |
05:33 | Amit | hi indradg |
05:33 | indradg | Amit, hey |
05:37 | greenmang0 | indradg: good morning |
05:38 | indradg: is it raining in Kolkata? | |
05:38 | indradg | greenmang0, morning... not raining right now... just overcast and gloomy |
05:39 | greenmang0 | indradg: it's pouring outside here... |
06:24 | Amit | hi nicomo |
06:24 | nicomo | hi Amit |
06:56 | |Lupin| | hello! |
06:58 | Amit | hi Lupin |
06:59 | |Lupin| | hey Amit |
06:59 | do you by chance know whether it is possible in KOha to get a list of recently added records ? | |
07:00 | like, given a date, all the records that are more recent than this date | |
07:00 | Amit | i think u can check this by guided report |
07:02 | |Lupin| | Amit: ah I didn't explore the report module so far so I didn' even thin about it. Thanks ! |
07:13 | the modules looks very cool ! | |
07:13 | no idea whether it can help for the functionality I'm looking for, though | |
07:24 | hello kf ! | |
07:24 | kf | guten morgen Lupin ! |
07:25 | Amit | hi kf |
07:25 | |Lupin| | gut geschlafen kf ? :) |
07:27 | kf | ja, aber zu kurz - wie immer :) |
07:28 | hi Amit | |
07:28 | |Lupin| | kf :) |
07:29 | kf: do you by chance know whether it is possible in Koha to see a list of records that have been added after a given date ? | |
07:30 | kf | I think its possible, but dont know how, perhaps I can look at it later today |
07:30 | |Lupin| | kf: thanks. Just posted to the list so maybe a reply will come from there... |
07:51 | kf | lupin: ok |
07:56 | chris | yes |Lupin| |
07:56 | you can query the items table | |
07:56 | for dateaccessioned | |
07:56 | |Lupin| | chris: ah there is no binding for this in the web interface ? |
07:58 | chris | you can do it in the reports module |
07:58 | if you are using acquisitions there is a prepared report | |
07:58 | if not | |
07:59 | just use the guided reports module | |
08:01 | |Lupin| | chris: ok, thanks ! We may not use the acquisition module systematically, so I think I'll have to use the guided report module. I'm just wondering where it is located in the web interface, I couldn't find it... |
08:01 | chris | go to reports |
08:01 | then guided reports | |
08:13 | |Lupin| | chris: right, I'm there and creating a new report |
08:13 | it's really impressive | |
08:13 | just surprised that title and author do not appear in the list of columns one can add... ? | |
08:15 | hmm missing the possibility to limit by date.. guess will have to use some scriptiong and SQL queries... | |
08:15 | hi laurence | |
08:16 | laurence | hello |lupin| |
08:16 | |Lupin| | laurence: thanks a lot for the nice pages you have written on the french site for Koha |
08:17 | laurence | :) |
08:19 | paul_p | |Lupin|: hello. So, you confirm koha-fr.org is OK for disabled ppl ? nice to read (Drupal is supposed to be, but it's always better when one can test it IRL) |
08:21 | chris | you can do sql in the guided reports to |
09:03 | |Lupin| | chris: ah, will have to figure that out |
09:47 | chris: I don't see where one can do sql in the guided report... | |
09:48 | chris | go to reports, then guided reports |
09:48 | |Lupin| | yep |
09:49 | chris: I did step 1 to 4 | |
09:49 | chris | dont do that :) |
09:49 | instead of choosing build new | |
09:49 | choose create report from sql | |
09:49 | |Lupin| | chris: it chris: aaaaah |
09:49 | sorry I missed this button | |
09:49 | chris | np |
09:50 | easy to do | |
09:51 | |Lupin| | chris: and then in the SQL field, you give the whole select request ? |
09:51 | s/request/query/g | |
09:51 | chris | thats right |
09:52 | |Lupin| | chris: ok |
09:52 | hmm I guess I'll have to learn some sql because it's not onl a select, also have to midify the db. | |
09:52 | chris | ahh you cant do that in the interface |
09:53 | have to do that in msyql | |
09:53 | |Lupin| | no ? |
09:53 | chris | can only run selects (too dangerous otherwise) |
09:53 | |Lupin| | not sure I understand that.. |
09:53 | chris | someone might go delete from biblio; |
09:53 | blam no database | |
09:53 | |Lupin| | if the query is passed as is to mysql, why not ? |
09:53 | chris | because we try to protect users from themselves |
09:53 | |Lupin| | chris: sure I understand |
09:54 | chris: but how do you warranty / check that the request won't modify the database ? | |
09:54 | is there a way to switch it to read only mode or something like that ? | |
09:54 | chris | by only running ones that begin with select |
09:54 | |Lupin| | ah |
09:55 | hmm so there could be a system preference to disable this checking ? | |
09:55 | chris | if ($sql =~ /;?\W?(UPDATE|DELETE|DROP|INSERT|SHOW|CREATE)\W/i) { |
09:55 | return (undef, { sqlerr => $1} ); | |
09:55 | nope | |
09:55 | if you want to manipulate the database | |
09:56 | its best to do it at the commandline | |
09:56 | after doing a mysqldump | |
09:56 | in case you make a mistake :) | |
09:56 | or you could use phpmyadmin or something similair | |
09:56 | |Lupin| | chris: the problem is |
09:57 | I have to provide a feature to my librarian | |
09:57 | so that she can generate a list of titles that have been added to the catalog recently | |
09:57 | chris | yep, a list of titles wont need changing anything |
09:57 | |Lupin| | here recently means since the last list was generated |
09:57 | the change is to store the date of the last request | |
09:58 | chris | that will be in the sql |
09:58 | |Lupin| | so that each request gives you the titles that have been added since the last time you have done the same action |
09:58 | chris | i would just put it in the report |
09:58 | |Lupin| | chris: I don't understand what you mean, sorry |
09:59 | chris | select * from items where dateaccessioned > '2009-06-30' and dateacessioned <= '2009-07-16' |
09:59 | the second date is today | |
09:59 | |Lupin| | chris: yes |
10:00 | but how do ou then remember the date of your last query ? | |
10:00 | chris | its saved |
10:00 | |Lupin| | I don't want my librarian to have to enter dates by herself |
10:00 | chris | when you make a report using guided reports |
10:00 | it saves it | |
10:00 | in that case, you will probably need to install phpmyadmin | |
10:00 | or write a script to do it for you | |
10:01 | |Lupin| | I see |
10:01 | chris | its too dangerous to allow sql that changes the database to be pasted in |
10:01 | |Lupin| | btw just one last question pls |
10:01 | nahuel | hi all :) |
10:01 | |Lupin| | what's the semantics of the accessionedate field, compared to the creatondate field in the biblio table ? |
10:02 | hi nahuel | |
10:02 | chris | one is at the item level |
10:02 | nahuel | hi |Lupin| and chris :) |
10:02 | what's up ? | |
10:02 | chris | the biblio might have been created last year |
10:02 | you might have just got a new item tho | |
10:02 | |Lupin| | chris: right. So these two could have the same name ? |
10:03 | chris: I was trying to figure out what accessionedate meant... | |
10:03 | chris | its a library term |
10:03 | |Lupin| | ah |
10:03 | chris | an item is accessioned when it is added to the catalogue |
10:03 | |Lupin| | oh I didn't know |
10:03 | thanks much | |
10:04 | chris | comes from french, (as lots of english does) |
10:04 | |Lupin| | yes ? |
10:05 | not sure from which word... | |
10:05 | chris | or maybe spanish |
10:05 | or latin :) | |
10:05 | |Lupin| | there is the word 'accession" but which is more from the legal field I'd say |
10:05 | chris | it means to increase, to add something |
10:05 | |Lupin| | ahah |
10:05 | probably not from french then | |
10:06 | chris | spanish i think actually |
10:06 | http://mw1.merriam-webster.com[…]tionary/accession | |
10:06 | |Lupin| | chris well from you NZ point of view french spanish and latin may be just one thing, seen from so far away |
10:06 | chris | Accesión :) |
10:06 | |Lupin| | ok |
10:07 | chris: anyway... many many thanks for your patience in helping | |
10:07 | chris | no problem |
10:20 | just about to hit the road gmcharlt ? | |
10:20 | gmcharlt | in a couple hours |
10:20 | Marlene wants to sleep in | |
10:20 | Amit | hi galen |
10:20 | chris | ahh fair enough :) do you both drive? |
10:20 | gmcharlt | yes |
10:21 | chris | that's good, i wasnt much help when laurel and I drove from seattle to san diego |
10:23 | gmcharlt | I got my license relatively late in life |
10:23 | when we moved to Alaska, at one point we were contemplating driving from Chicago to Anchorage | |
10:24 | chris | good grief |
10:24 | gmcharlt | and Marlene put her foot down and told me to get my license |
10:25 | chris | :) |
10:25 | gmcharlt | as she didn't want to drive the 4,000 mlles all by herself :) |
10:25 | chris | fair enough |
10:25 | gmcharlt | we ended up flying, of course |
10:25 | chris | i was ok between cities |
10:25 | but driving in the cities on the right freaked me out | |
10:26 | |Lupin| | till soon all, lunch time |
10:29 | chris | http://photos.bigballofwax.co.[…]hp?g2_itemId=1527 |
10:29 | one of the highlights of our drive | |
10:32 | Amit | chris: this is your baby snap http://photos.bigballofwax.co.[…]p?g2_itemId=11620 |
10:33 | chris | thats our first son |
10:33 | Amit | this is your second http://photos.bigballofwax.co.[…]p?g2_itemId=69849 |
10:33 | i think | |
10:34 | gmcharlt | chris: nice |
10:34 | chris | yep amit |
10:34 | Amit | nice baby |
10:34 | chris: this is your snap http://photos.bigballofwax.co.[…]p?g2_itemId=69840 | |
10:35 | chris: mummy papa & baby | |
10:36 | chris | yep all very tired |
11:02 | Amit | @wunder Delhi |
11:02 | munin | Amit: Error: No such location could be found. |
11:02 | Amit | @wunder New Delhi |
11:02 | munin | Amit: The current temperature in New Delhi, India is 36.0°C (4:00 PM IST on July 16, 2009). Conditions: Scattered Clouds. Humidity: 50%. Dew Point: 24.0°C. Pressure: 29.44 in 997 hPa (Steady). |
11:03 | Amit | @wunder Dehradun |
11:03 | munin | Amit: The current temperature in Dehradun, India is 32.0°C (2:30 PM IST on July 16, 2009). Conditions: Partly Cloudy. Humidity: 58%. Dew Point: 25.0°C. Pressure: 29.41 in 996 hPa. |
11:28 | paul_p | hello Amit, chris & gmcharlt |
11:28 | (back from lunch) | |
11:30 | chris | heya paul_p |
11:31 | gmcharlt | hihi paul_p |
11:34 | chris | morning jwagner |
11:37 | jwagner | Morning, chris. Hope that earthquake/tsunami wasn't anywhere near you! |
11:38 | Amit | hi paul_p, jwagner |
11:38 | chris | nope, nowhere near where anyone lives luckily |
11:38 | jwagner | Good. One day I'm going to learn my way around NZ geography.... |
11:39 | Hi Amit | |
11:40 | chris | it was off the cost of the bottom of the south island |
11:40 | i live at the bottom of the north island | |
11:40 | cost=coast :) | |
11:43 | jwagner | I'd love to get to NZ one of these days. There's a chance I may be going to Australia in 2010 for a conference in Melbourne, but I'm really dubious about spending that long on a plane. Maybe when I retire & can take a cruise ship across the Pacific :-) |
11:45 | gmcharlt | :) |
11:45 | ebegin | morning #koha |
11:45 | jdavidb | Howdy, ebegin. :) |
11:45 | gmcharlt | though if it's in NZ, I'd like to see if we can manage a live video feed and lots of backchannel |
11:46 | jwagner | Now if we could time Kohacon in NZ to match up with my thing in Melbourne, I could make a nice month-long trip :-) |
11:46 | jdavidb | That would be very cool, gmcharlt. |
11:46 | gmcharlt | I'll have to ping schuster and find out if any of the video he took at KohaCon came out |
11:47 | ebegin | jwagner, you thing in Melbourne is the IFLA? |
11:48 | jwagner | Nope, World Science Fiction Convention, Sept 2-6 http://www.aussiecon4.org.au/ |
11:49 | chris | ebegin: IFLA has been cancelled |
11:49 | jwagner | I used to be a regular con staff member for Worldcons, but "retired" from it several years ago. I had always wanted to go to one of the Aussiecons, though, so I'm tempted. |
11:49 | chris | or at least, its not going to australia anymore |
11:49 | ebegin | chris... you are serious?? |
11:50 | chris | jwagner and jdavidb its looking like october 2010 |
11:50 | jwagner | Hmmmmm........ |
11:50 | chris | ebegin: yes, thats what i am hearing from some australian librians |
11:50 | i will try to find a link to confirm | |
11:50 | jwagner | jdavidb, I'm SURE they can do without both of us for a month, no??? |
11:50 | jdavidb | Sure! :) |
11:50 | We *might* have EBPL fully live by then... | |
11:51 | ebegin | you are right chris... http://www.ifla.org/en/news/if[…]in-brisbane-austr |
11:51 | chris | yep |
11:51 | switzerland instead | |
11:51 | oh no | |
11:51 | sweden | |
11:52 | http://www.libraryjournal.com/[…]72.html?rssid=191 | |
11:52 | gmcharlt: i think we can manage live video feed | |
11:52 | ebegin | @wunder goteborg, sweden |
11:52 | munin | ebegin: Error: No such location could be found. |
11:54 | kf | live video feed would be great, I really learned to love twitter during texas kohacon |
← Previous day | Today | Next day → | Search | Index