← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
12:00 | chris | penny worked with me at catalyst |
12:00 | gmcharlt | :) |
12:00 | hi nahuel | |
12:00 | nahuel | hi gmcharlt |
12:01 | what's up ? | |
12:01 | chris, not yet at bed ? | |
12:01 | :) | |
12:02 | chris | not yet .. soon i hope :) |
12:03 | hehe | |
12:03 | gmcharlt | you are getting sleepy ... very sleepy |
12:03 | ... | |
12:03 | ... | |
12:04 | and now that you're hypnotized, instead of actually sleeping you'll work on Koha patches | |
12:04 | nicomo | eh eh |
12:04 | I was about to say : now wake up we found bugs in the new web site you just put online | |
12:05 | chris | dont say that |
12:05 | hehe | |
12:05 | thats what i was doing all day | |
12:06 | ok, time to turn the computer off, or at least hibernate | |
12:07 | paul_p | hi chris & gmcharlt & anyone else on this channel ! |
12:10 | jdavidb | Hi, paul_p! |
12:11 | gmcharlt | hi paul_p |
12:12 | owen | Hi #koha |
12:12 | paul_p | 'morning jdavidb & owen |
12:12 | how are things in US today ? | |
12:13 | sunny & summer weather here ! | |
12:13 | owen | Feels more like spring here in Ohio, cool and rainy |
12:13 | nicomo | ben si |
12:13 | oops, sorry, wrong channel | |
12:14 | |Lupin| | sorry guys, I'd like to add a MARC subfield |
12:14 | but I'm a bit lost in the interface. | |
12:15 | ONce the list of subfields is display, what do I do ? | |
12:15 | nicomo | |Lupin|: you edit the list of subfields |
12:15 | you'll get the current subfields and a "new" tab to enter an extra subfield | |
12:16 | |Lupin| | nicomo: okay I'm trying, thanks |
12:19 | hmm not sure this is working properly with lynx. Let's see with Mozilla... | |
12:26 | nahuel | nicomo, |Lupin|, strange to speak english between frenchies :) |
12:33 | |Lupin| | nahuel: yep but it's for our own good ! |
12:33 | nahuel | how ? |
12:33 | |Lupin| | hmm it's really tough to add marc fields through the web interface. s it okay to do it directly in the database ? |
12:33 | nahuel | .... it's harder to add via sql than web interface :) |
12:34 | |Lupin| | nahuel: it helps us to improve our english, I mean |
12:34 | nahuel: are there several tables to modify, or just one ? | |
12:35 | nahuel | if it's only subfields => marc_subfield_structure |
12:36 | |Lupin| | nahuel: yes at the moment it's only subfields |
12:36 | nahuel: later I'll want to add a complete MARC field, though | |
12:36 | nahuel | so it's only this table |
12:43 | |Lupin| | nicomo, nahuel, te frenchies: laurence has written a nice page on collection codes. Do you by chance have its URL easily accessible ? |
12:46 | hi hdl_laptop | |
12:47 | hdl_laptop | hello |
12:51 | nahuel | |Lupin|, by search engine of koha-fr.org ? |
12:55 | |Lupin| | nahuel: yeah I shall try thisthanks |
12:56 | nahuel: is it correct that the authorized values are bound to marc subfields and not to koha fields ? | |
12:59 | owen | Is anyone else seeing no search box on cataloguing/addbooks.pl when using Firefox? |
13:01 | nicomo | |Lupin|: yes, authorized values list can be bound to a subfield sometimes |
13:01 | owen: which version of Koha? | |
13:02 | owen | 3.01.00.032 or greater |
13:04 | nicomo | owen i don't have this version installed |
13:04 | magnusenger | owen: I can see a search box! I'm on Koha 3.01.00.037 and FF 3.5.1 |
13:05 | nicomo | owen: probably a bug tightly linked to you latitude and longitude :-) |
13:05 | |Lupin| | nicomo: and they can't be bound to a Koha field, directly I mean. Can they ? |
13:05 | owen | Glad to hear it magnusenger, that means I'm simply going crazy. |
13:06 | gmcharlt | well, if that's all you wanted to know ... :) |
13:06 | magnusenger | that's good to hear, owen ;-) |
13:07 | owen | Expect to read more on my blog about how the squirrels are stealing my cable. |
13:21 | |Lupin| | btw |
13:22 | a few hours ago I have posted a message about opacbaseurl and staffcleitnaseurl system preferences | |
13:22 | did this e-mail reach the list ? | |
13:24 | magnusenger | |Lupin|: I've got it. at least. Cant answer your questions though... |
13:24 | gmcharlt | |Lupin|: we've been trying to completely remove opacbaseurl and staffclienturl, actually |
13:25 | |Lupin| | gmcharlt: oh no !! why that ? |
13:25 | gmcharlt: there is no way to accomplish the same thing without them, is there ? | |
13:26 | gmcharlt | bug 2152 has some information why |
13:26 | munin | 04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2152 minor, P3, ---, galen.charltonliblime.com, NEW, eliminate OPACBaseURL system preference and replace with SERVER_NAME |
13:26 | gmcharlt | basically, want to avoid the extra configuration step |
13:26 | but I can see that your case (installing Koha on a webhost with htaccess) may need more tweaking | |
13:27 | |Lupin| | gmcharlt: yep, indeed. Any suggestion on how to do it ? |
13:28 | nahuel | gmcharlt, hey just a question |
13:28 | gmcharlt | nahuel: what's up? |
13:29 | nahuel | gmcharlt, do you have an idea how to solve problem with translations that replace tags values like hidden input ... ? |
13:30 | gmcharlt | off the top of my head, one approach might be to define an HTML comment to selectively disable string extraction |
13:30 | <!-- no_translate --> .... <!-- /no_translate --> | |
13:30 | for example | |
13:30 | would then require patching the string extraction code | |
13:30 | where there be dragons | |
13:30 | nahuel | héhé |
13:31 | gmcharlt | another would be to teach the parser to ignore the values of hidden input elements |
13:31 | nahuel | yep it's an idea... but why the extractor, extract values of tags... it shouldn't no ? |
13:31 | gmcharlt | perhaps not |
13:32 | probably was doing it for the case of <input type="submit" value="Click me!" />, but we could deprecate that construct | |
13:32 | nahuel | :( |
13:32 | because we had/have a loooot of problems with this stuff | |
13:33 | the label creator have a new one | |
13:36 | gmcharlt | |Lupin|: I think that the idea is that Koha would get the correct base URL from SERVER_NAME of the HTTP request |
13:44 | |Lupin| | gmcharlt: but the files may not be stored at the root of the server, that's what happens in the present situation |
13:57 | Snow_Fox | MOrning |
13:57 | owen | Hi Snow_Fox |
13:59 | Snow_Fox | Morning Owen how are you? |
13:59 | owen | I'm fine, thanks |
14:16 | |Lupin| | ehlo Snow_Fox |
14:16 | has someone experience with entering text with accents in Mysql ? | |
14:16 | I just added a field directly to the databse, whose description includes characters with accents. And these accents do not show up correctly in Koha. | |
14:22 | oh actually once the subfield is created itbecomes possible to modify it through the web interface tso that's great | |
14:25 | nahuel | |Lupin|, set names utf8; before inserting :) |
14:37 | |Lupin| | nahuel: thanks ! |
14:37 | nahuel | :) |
14:37 | |Lupin| | nahuel: this has also an impact on litteral character strings ? |
14:38 | nahuel | "litteral" ? |
15:02 | |Lupin| | hey pianohacker :) |
15:02 | nahuel: I meant a string used as a value, as opposed to a string used to name a table or column | |
15:03 | nahuel | pianohacker, hey jessie ! |
15:04 | |Lupin|, this impact all, but you must not name your tables/columns with diacritics... it's baaaaad :) | |
15:05 | pianohacker | Hallo |
15:11 | |Lupin| | :) |
15:11 | bt | |
15:11 | pianohacker | There you go, discriminating against us americans again |
15:11 | |Lupin| | is it possible to restrict the content of a MARC field to all te members of the staff client ? |
15:12 | i.e. is there a kind of authorised values associated with staff members ? | |
15:12 | pianohacker | |Lupin|: Not automatically, though you could create an authorised values category and keep it updated manually |
15:14 | |Lupin| | pianohacker: hmm that's a loooooot of work ! |
15:14 | pianohacker | Yes :/ What do you need this for? |
15:16 | |Lupin| | pianohacker: because we'd like to keep track of who has added a bib recore, and who has added the associated items |
15:17 | pianohacker | Ahhh |
15:17 | I think your only option there, if you don't want to add code, would be a manually updated authorised values category | |
15:24 | |Lupin| | pianohacker: like in a cron job ? |
15:25 | pianohacker | Maybe, if you have that list in some database/text file |
15:25 | |Lupin| | pianohacker: oh well I guess the cron job could connect to the koha database, couldn't it ? |
15:26 | pianohacker: also, suppose that code is developed to have something like a virtual authorized values list for staff, or even a real one, this may interest others... | |
15:26 | pianohacker | Yup |
15:27 | |Lupin| | so it would not look too much nonsense to me to have that piece of code integrated into Koha, if it gets written oneday |
15:34 | rhcl | oooohhh Google Voice is waaay cool. Is it compatable with Koha? |
15:35 | Could I, for example, call a library Google Voice number and ask it to put a book on hold? The transcription is absolutely perfect with the limited testing I've done. | |
15:35 | gmcharlt | rhcl: interesting idea - ultimately will depend on the APIs that Google makes available for it |
15:35 | rhcl | Yea, there should be hooks to extract data to do things like that. |
15:36 | gmcharlt | depending on how their SMS service work, may be a possible SMS gateway for Koha send (and recieve?) SMSs |
15:38 | rhcl | But the voice part (not the text) is the impressive part. It would be really good for people with various handicaps, and even a good thing for many of the elderly who just don't have tech skills. |
15:39 | Have you (gmcharlt) tested it. Few of the new tech apps really "ooohhh" me, I tend to be a bit skeptical, but Google Voice is PDC. | |
15:39 | ...tested it? | |
15:39 | gmcharlt | rhcl: waiting for invite |
15:40 | rhcl | Good time to get an invite. Some really good phone #'s available now. My tech assistant got 866-0001. |
15:58 | Snow_Fox | Hrm when looking at my patron test data the overdue items on patrons i see a column that says to o many renewals, but when i go to the history of that item it does not show any renewals. This has beent eh case in every overdue that was seen so far. Is this because our test data is not complete? |
15:59 | or is this question to vauge | |
16:00 | owen | Do you have a number of renewals allowed value specified for your item types? |
16:01 | Snow_Fox | thats a good question |
16:01 | where would i go to view that? | |
16:01 | kf | bye #koha |
16:01 | Snow_Fox | cya KF |
16:01 | owen | Snow_Fox: Administration -> Item types |
16:01 | Snow_Fox | k |
16:03 | apparently not | |
16:03 | right answers my question | |
16:03 | thankyou | |
16:05 | |Lupin| | bye kf |
16:06 | owen | My turn to ask a question: What does it mean when your MARC entry form has a "..." link but clicking it does nothing? |
16:06 | No value builder for that tag? But then why the "..." link? | |
16:09 | gmcharlt | French translation request: "If ON, displays patron image when a patron uses web-based self-checkout" |
16:09 | paul_p | gmcharlt: "si activé, affiche la photo de l'adhérent à l'utilisation de la console de prêt auto-contrôlé" |
16:09 | pianohacker | owen: Which subfield is it? |
16:10 | paul_p | well... |
16:10 | gmcharlt: "Si activé, affiche la photo de l'adhérent à l'utilisation de la console de prêt auto-contrôlé" | |
16:10 | is better ;-) (just s/^s/^S/) | |
16:10 | gmcharlt | paul_p: thanks - better use pastebin - looks like I'm missing diacritics |
16:10 | owen | pianohacker: 003 and 005 |
16:11 | paul_p | gmcharlt: http://biblibre.pastebin.com/d34de0f9c |
16:11 | pianohacker | owen: It's possible the JS for those two value builders is broken. Any errors in firebug/error console? |
16:12 | gmcharlt | paul_p++ |
16:16 | |Lupin| | hm I just reinstalled KOha this morning |
16:16 | starting from an empty DB | |
16:16 | since then I added some MARC fields and subfields | |
16:16 | linked them to some koha fields | |
16:17 | mib_451idk | I type in Harriets Had Enough and get something about slavery on Koha, what is up with that? Does anyone know? |
16:17 | |Lupin| | turned on OpacSuppression |
16:17 | modified the NoZEbraIndexes syspref so that the Suppress index is linked to the right field | |
16:17 | and bulkmarcimported 9 records | |
16:18 | when doing a search in the opac for a word in one of these records I get a 404 error | |
16:18 | and whendoing the same search in staff it's an error 500 | |
16:18 | pianohacker | mib_451idk: Harriet Tubman? http://en.wikipedia.org/wiki/Harriet_Tubman |
16:19 | |Lupin| | can anybody see what I could have done the wrong way, please |
16:19 | I reinstalled Koha this morning because of the very same problem. | |
16:19 | pianohacker | |Lupin|: I'm not sure if this limitation applies to nozebra, but in zebra, at least one record has to be suppressed when OpacSuppression is on, or everything breaks |
16:20 | |Lupin| | pianohacker: yep I'm aware of this one and all the imported records have their suppression field to 1 |
16:20 | owen | pianohacker: No JS error |
16:21 | pianohacker | Hmm. |
16:21 | Does anything pop up in your error log? | |
16:22 | |Lupin| | yes |
16:22 | a parsing error | |
16:22 | let me paste it somewhere | |
16:22 | pianohacker | pastebin? |
16:23 | owen: It looks like the 003 plugin doesn't do anything when ... is clicked; it just fills in MARCOrgCode when the field is clicked | |
16:23 | owen: 005 is similar, filling in the correctly formatted date/time when the field is clicked | |
16:23 | owen | Ah, of course. So we just have a usability problem. |
16:23 | |Lupin| | http://pastebin.com/f44f638f1 |
16:24 | pianohacker | owen: Yup. Have to figure out some way to remove ... for fields that don't need it |
16:24 | |Lupin| | http://pastebin.com/f2c908c0d |
16:24 | these are the complete logs | |
16:24 | but just the last lines are enough | |
16:24 | munin | 04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=3211 normal, P5, ---, oleonardmyacpl.org, NEW, cataloging value plugin forms should be valid XHTML |
16:24 | |Lupin| | and IMO not very inspiring |
16:25 | pianohacker | |Lupin|: Not really, no... |
16:26 | |Lupin|: You might try running opac-search from the console | |
16:26 | QUERY_STRING='q=<search string>' perl opac/opac-search.pl | |
16:26 | |Lupin| | pianohacker: ah, this works ? didn't know |
16:27 | pianohacker: okay, thanks ! | |
16:27 | pianohacker | |Lupin|: It's easiest for opac stuff, as you have to turn on authnotrequired to do it on the staff side |
16:27 | np | |
16:27 | mib_451idk | Harriets Had Enough is a picture book about a rabbit, not Harriet Tubman, though. |
16:28 | pianohacker | mib_451idk: True. But the "Harriets" in your search string may have dug up a reference to Harriet Tubman in that slavery book |
16:28 | full-text search has its pluses and its minuses :) | |
16:29 | |Lupin| | Use of uninitialized value in numeric eq (==) at opac/opac-search.pl line 221. |
16:29 | it's the only thing I get on stderr | |
16:30 | pianohacker | Yeah, and that doesn't look very important, from a quick run-through of the code |
16:30 | |Lupin| | and on stdout it's the webpage I got in the browser... |
16:31 | pianohacker: indeed | |
16:31 | pianohacker | Could you pastebin the entire output, stdout and stderr? There's a slight chance I might be able to extract something meaningful |
16:32 | |Lupin| | pianohacker: so you want the mixure all redirected at once, right ? |
16:32 | pianohacker | Yup, please |
16:33 | |Lupin| | http://pastebin.com/f4bfca594 |
16:34 | pianohacker | Bleh, apparently my cgi-fu isn't as good as I thought. Could you try perl opac/search.pl q=<query string> instead? |
16:35 | Sorry... | |
16:36 | |Lupin| | sure ! |
16:36 | no problem !! | |
16:37 | http://pastebin.com/f1d0d778c | |
16:37 | pianohacker | opac/opac-search.pl , rather |
16:38 | |Lupin| | yep sorry |
16:38 | I should have schecked | |
16:38 | pianohacker | Hey, my fault |
16:38 | |Lupin| | http://pastebin.com/f2e74f68e |
16:39 | ah this gives back the same error as the syslog... | |
16:40 | shall I strace to see which files it reads ? | |
16:40 | looks a bi gorry tome but can't come up with a better idea | |
16:40 | pianohacker | That might be worth a shot. It sounds like it might be choking on marcxml from your database, though |
16:40 | |Lupin| | hmm |
16:41 | shall I pastebin themarcxml ? | |
16:41 | it has been produced by koha itself though | |
16:41 | pianohacker | You could try, in a MySQL console, SELECT marcxml FROM biblioitems WHERE marcxml NOT LIKE '<%'; |
16:41 | It could be empty, for some odd reason | |
16:41 | |Lupin| | pianohacker: or maybe publishing the 9 marc records would be the right way to go ? |
16:42 | pianohacker: ok | |
16:42 | Empty set (0.00 sec) | |
16:43 | nice try... | |
16:43 | pianohacker | Grr |
16:43 | |Lupin| | the other clue I can give |
16:43 | is that when a search has no result | |
16:43 | there are no errors | |
16:44 | pianohacker | Hmm. So it's something with the record display |
16:44 | Oh, hey | |
16:44 | |Lupin| | hmm ? |
16:44 | pianohacker | Do you have the XSLTResultsDisplay or XSLTDetailsDisplay system preferences on? |
16:45 | |Lupin| | I don't thing so but I'll check |
16:46 | both are 0 | |
16:48 | pianohacker | AmazonContent? pazpar2? I'm getting desperate |
16:49 | |Lupin| | none of these two |
16:49 | pianohacker: may be I did something wrong with the OpacSuppress sspref ? | |
16:50 | pianohacker: if I show you my NoZebraIndexes, would that help ? | |
16:50 | pianohacker | Possibly, yes |
16:50 | |Lupin| | k |
16:51 | http://pastebin.com/f49f7a7c0 | |
16:52 | pianohacker | No, that looks right... |
16:52 | |Lupin| | pianohacker: ias far as I can tell, my only change to this syspref was to add 'Suppress' => '994e', |
16:53 | pianohacker: wanna see the marc records ? | |
16:53 | pianohacker | Do searches work with OpacSuppression off, that Suppress line removed, or both? |
16:53 | |Lupin| | (I'll have to leave soon, becus a friend of mine is waiting for me) |
16:53 | I'm sorry about that | |
16:53 | pianohacker | Hey, no problem |
16:54 | |Lupin| | that's the thing I'll try ASAP |
16:54 | and let you know pianohacker | |
16:54 | pianohacker | k |
16:54 | |Lupin| | thanks a lot for your help sor far |
16:54 | pianohacker | Have fun |
16:54 | np | |
16:54 | |Lupin| | very much appreciated |
16:54 | bye bye and thanks again | |
17:15 | owen | Does anyone know under what circumstances the marc21_leader_book value builder is used? |
17:29 | gmcharlt | owen: I don't its ever invoked; certainly not in the default frameworks |
17:32 | jwagner | owen, to confirm, that's something different from the marc_21.leader.pl? What you get if you click the 3 dots next to the leader field when editing a record? |
17:32 | owen | Yes, it's different |
17:32 | jwagner | OK. Then I have no clue myself :-) |
17:33 | owen | There's also a marc21_leader_computerfile.pl |
17:57 | Snow_Fox | is there a easy simple way of finding overdues? |
17:57 | pianohacker | There's the overdues report, in Circulation |
17:58 | Snow_Fox | im hesitent to press that with it having our sample data |
17:58 | oh well to late | |
17:58 | barf wittle server barf | |
18:17 | owen | Hmmm.... "//#TODO - ADD syspref (AllowPostDatedCheckouts)." |
18:18 | I wonder if anyone periodically checks their inline #TODOs and #FIXMEs? | |
18:21 | ebegin | @wunder where are the people looking at #todo and #FIXMEs |
18:21 | munin | ebegin: Error: No such location could be found. |
18:21 | ebegin | munin is right... again ;) |
18:21 | munin | ebegin: I suck |
18:21 | ebegin | no, you are pretty good actually ;) |
18:29 | jdavidb | Probably, ebegin, but no one around here would notice, much. |
18:30 | pianohacker | Programmers and librarians? Yeah, probably not |
18:31 | Snow_Fox | id notice im neither |
18:31 | but my sanity cant really be vouched for either :\ | |
18:33 | ebegin | Does your library has a rss feed for new acquisitions? If so, what are you displaying in that feed as title and description? |
18:33 | Snow_Fox | no idea |
18:33 | i think we will | |
18:33 | im not the web developer | |
18:34 | ebegin | Snow_Fox, are you a developer or a librarian? |
18:34 | Snow_Fox | im the tech systems specialist for our ILS |
18:35 | technically im a system administrator | |
18:35 | ebegin | Snow_Fox, where are you based? |
18:35 | Snow_Fox | Salina Kansas |
18:35 | ebegin | @wunder salina, kansas |
18:35 | munin | ebegin: The current temperature in Salina.com -- Weather from the Salina Journal, Salina, Kansas is 30.0°C (1:33 PM CDT on July 22, 2009). Conditions: Clear. Humidity: 48%. Dew Point: 18.0°C. Pressure: 29.85 in 1010.7 hPa (Falling). |
18:39 | Snow_Fox | we had record lows in the state last night |
18:39 | for july kinda weird | |
18:40 | ebegin | well... 30 is not so bad... :) |
18:40 | @wunder montreal, quebece | |
18:40 | @wunder montreal, quebec | |
18:40 | munin | ebegin: Error: No such location could be found. |
18:40 | ebegin: The current temperature in Montreal / Dorval International, Que, Quebec is 21.0°C (2:00 PM EDT on July 22, 2009). Conditions: Light Rain. Humidity: 66%. Dew Point: 16.0°C. Pressure: 30.16 in 1021 hPa (Rising). | |
18:40 | Snow_Fox | not when your expecting 100+ |
18:41 | pianohacker | I think that's about 70 â?°F |
18:41 | @gcalc 21 degrees C in degrees F | |
18:41 | munin | pianohacker: 21 degrees Celsius = 69.8 degrees Fahrenheit |
18:43 | jdavidb | @wunder Rockville, md |
18:43 | munin | jdavidb: The current temperature in Woodley Gardens, Rockville, Maryland is 31.7°C (2:40 PM EDT on July 22, 2009). Conditions: Overcast. Humidity: 41%. Dew Point: 17.0°C. Pressure: 30.00 in 1015.8 hPa (Rising). |
18:43 | Snow_Fox | @wunder Death Valley, NV |
18:43 | munin | Snow_Fox: Error: No such location could be found. |
18:43 | Snow_Fox | @wunder Death Valley, CA |
18:43 | munin | Snow_Fox: An error has occurred and has been logged. Please contact this bot's administrator for more information. |
18:43 | Snow_Fox | my bad :-P |
18:43 | @wunder Austin, TX | |
18:43 | munin | Snow_Fox: The current temperature in UT Campus, Austin, Texas is 35.7°C (1:43 PM CDT on July 22, 2009). Conditions: Clear. Humidity: 41%. Dew Point: 20.0°C. Pressure: 29.26 in 990.7 hPa (Falling). |
18:44 | pianohacker | @wunder Amman, Jordan |
18:44 | munin | pianohacker: The current temperature in Amman Airport, Jordan is 29.0°C (9:00 PM EEST on July 22, 2009). Conditions: Haze. Humidity: 21%. Dew Point: 10.0°C. Pressure: 29.67 in 1004 hPa (Rising). |
18:45 | pianohacker | Well, 85 degrees at 9:00 PM is fairly warm. |
18:45 | jdavidb | @wunder Iqaluit, NU |
18:45 | munin | jdavidb: Error: No such location could be found. |
18:46 | jdavidb | Since no one in their right mind would actually *want* to be in Iqaluit, it doesn't surprise me the bot doesn't know about it... |
18:52 | sekjal | I'm looking at the issues table right now, and I assume that issues.returndate is holds the date the patron returned a borrowed book |
18:53 | but what does the issues.return field [varchar(4)] mean? | |
18:54 | pianohacker | sekjal: as far as I know, absolutely nothing |
18:55 | sekjal | okay, I can live with that |
18:55 | I'm trying to figure out my circulation 'snapshot' for our migration next month | |
18:59 | pianohacker | sekjal: I can't find any references to it in the code. You'd be safe to ignore it |
18:59 | sekjal: What are you migrating from? | |
18:59 | sekjal | Innovative's Millennium |
19:00 | pianohacker | Eesh. I haven't heard good things about that system's ease of export |
19:01 | sekjal | its a challenge. I've written a script that will let us get our bibs, items and authorities out with relative ease |
19:01 | assuming my data mapping is correct enough | |
19:01 | pianohacker | How does it store its data? SQL database? |
19:01 | sekjal | but the patron data, and the current circulation state, are going to be a bit rougher |
19:02 | apparently so | |
19:02 | we can't actually see the guts of the thing | |
19:02 | gmcharlt | sekjal: you might want to look up Terry Reese and Kyle Banerjee for help getting data out of III |
19:02 | sekjal | thanks, gmcharlt! I shall do that |
19:03 | my script makes use of the XML form of the bib and item records via the OPAC. | |
19:04 | it then applies a stylesheet to get MARCXML, and imports that into Koha. | |
19:05 | pianohacker | brb, lunch |
19:11 | chris | morning peeps |
19:11 | jdavidb | Morning, chris! |
19:12 | sekjal | Good morning, chris |
19:12 | gmcharlt | morning chris |
19:15 | nengard | sorry jdavidb was setting up x-xhat on new computer and kept having troubles |
19:15 | still don't know if i have notices set up right .... | |
19:15 | and morning chris | |
19:20 | hello all - trying out IRC in Adium | |
19:20 | chris | better? |
19:20 | nengard | I do think so :) |
19:20 | we'll see when the room gets real busy how much I like it | |
19:21 | indradg | chris, morning! |
19:21 | chris, what ended up happening to the OpenCataloger project? | |
19:21 | cait | morning chris, indadb and #koha |
19:21 | gmcharlt | hi cait, indradg |
19:22 | indradg | gmcharlt, all the best at Equinox when you move :) |
19:22 | gmcharlt | thanks! |
19:25 | cait | hi galen, all the best from me too |
19:25 | gmcharlt | thanks, cait |
19:25 | cait | but im also a little bit sad that you are leaving :) |
19:25 | chris | it became biblios |
19:26 | in a round about way | |
19:29 | nengard: :) | |
19:29 | biblios was a google summer of code project | |
19:29 | nengard | chris: okay - it does nothing to make it stand out like in other programs ... |
19:29 | chris | the brief was to extend opencataloguer |
19:30 | but it became a rewrite instead ... turned out pretty well in the end :) | |
19:30 | but antoine farnault, under the direction of biblibre had done a lot of work on opencataloguer, and a lot of the ideas were incorporated afaik | |
19:37 | which client now? | |
19:46 | Snow_Fox | If the Circ console is set to be unable to view a patrons reading history is there a way to pull a report about the checkout history of a Item? |
19:52 | ebegin | someone that can access the report page can get any data from the database |
19:54 | Snow_Fox | thats what i figured |
19:54 | indradg | chris, i see, thanks :) |
19:54 | chris | np |
20:00 | Snow_Fox | hey Chris |
20:00 | did dinasaurs eat Koha or vice versa | |
20:01 | gmcharlt | Koha is wily; it ate the dinosaurs |
20:01 | chris | hehe well technically Koha is the small furry mammal, and III is the dinosaur |
20:01 | ebegin | Kohasaurus killed all other species. |
20:01 | chris | :) |
20:01 | Snow_Fox | lol |
20:01 | ebegin | Sounds good, isn't... kohasaurus... ;) |
20:01 | chris | ok gotta go catch my bus bb in about 40 mins |
20:02 | sekjal | later, chris. have a good ride |
20:02 | ebegin | ciao chris! |
20:02 | owen | Koha is the small mammal, this economy is the asteroid collision. |
20:03 | pianohacker | I think Sirsi might make a better dinosaur in that analogy |
20:03 | (At least I hope) | |
20:05 | Snow_Fox | KILL IT KILLS IT NWO |
20:05 | :-P | |
20:05 | sekjal | III is probably more like an alligator or shark; it'll be around, unchanged, for a very long time |
20:05 | Snow_Fox | wahahaha |
20:05 | nice sekjal | |
20:06 | sekjal | thanks, Snow_Fox |
20:07 | pianohacker | owen: Around? The latest firebug is acting oddly while loading Koha, I was wondering if you were having similar problems |
20:07 | owen | The latest firebug is acting oddly for me in general. |
20:07 | What are you seeing? | |
20:07 | pianohacker | It freezes Firefox 3.5 for about five seconds on page load, whether it's open or closed. |
20:09 | owen | Hmmm... I'm not getting that here on my Windows machine. That sounds like how it was acting on my Mac the other night though |
20:09 | Version 1.4.0? | |
20:09 | pianohacker | Yup |
20:10 | owen | No freezing for me, at least today. I'm still getting used to the whole on/off button |
20:10 | pianohacker | Yeah, that's quite the mental shift |
20:13 | sekjal | gtg. there is sushi in my near future; I just have to cover some 80 miles |
20:13 | ::puts on walkin' shoes:: | |
20:36 | Snow_Fox | im guessing if i want to pull all patrons who have checked out a specific item i may have to create the report via SQL? |
20:37 | pianohacker | Most likely, yes |
20:37 | Snow_Fox | ok, who has a copy of the data dictionary |
20:37 | pianohacker | ? |
20:38 | Snow_Fox | data dictionary: a explination of the various fields and data types of a database |
20:38 | example | |
20:38 | pianohacker | Ah |
20:38 | Snow_Fox | Bar_Code Integer table location: Category |
20:38 | hdl_laptop | Snow_Fox: Zeno Tajoli posted sort of this recently |
20:38 | Snow_Fox | etc |
20:38 | hdl_laptop | on koha-devel and on the wiki |
20:39 | Snow_Fox | kk |
20:39 | pianohacker | http://wiki.koha.org/doku.php?[…]elopment:dbschema |
20:39 | Jo | morning all |
20:39 | Snow_Fox | morning |
20:42 | chris | back now at work |
20:45 | Snow_Fox | piano i may well regret asking for this information |
20:46 | chris | lol |
20:46 | ive learnt my lesson there | |
20:47 | just coffee for me today | |
20:47 | hdl_laptop | hi chris |
20:47 | chris | hi hdl_laptop |
20:47 | Snow_Fox | what |
20:47 | pianohacker | Snow_Fox: Hahaha. What, is the Koha database layout a bit strange? |
20:48 | Snow_Fox | i havnt even figured out how to process what im seeing yet ":| |
20:48 | richard | hi |
20:48 | Snow_Fox | yo |
20:48 | pianohacker | hi |
20:48 | chris | hiya richard |
20:50 | Snow_Fox | i have to admit, this db is a bit more beastily then i thought it would be |
21:02 | anyone know what the return in the koha.old_issues value looks like, says its alphanum just wonder what its used for | |
21:05 | and how is the date stored | |
21:05 | ##/##/#### etc | |
21:06 | pianohacker | Snow_Fox: return seems to be a now-unused artifact of earlier versions |
21:07 | Snow_Fox | kk |
21:14 | silly question for the name of tables with us uploading to liblime are they gonna change the names like, koha.old_issues to say whateverourlibnameis.old_issues? | |
21:15 | pianohacker | Umm. Maybe, maybe not, but it doesn't really matter |
21:15 | Snow_Fox | how so? |
21:16 | ah i see | |
21:25 | chris | yeah there is so much cool about git |
21:26 | Snow_Fox | i know your speaking english but im not understanding you |
21:27 | chris | http://www.kernel.org/pub/soft[…]docs/git-add.html |
21:27 | scroll down to interactive mode | |
21:27 | very very cool | |
21:30 | stick around long enough, and you'll be sending patches too :-) | |
21:31 | gmcharlt | give in! you know you wanna! |
21:31 | Snow_Fox | chris i prob would but i would likely make people committ suicide |
21:31 | so unless you guys are looking at restructuring | |
21:31 | i best not | |
21:31 | pianohacker | You start out submitting templates, then minor code changes, then entire new modules |
21:31 | And then we own your SOUL | |
21:31 | chris | heh |
21:32 | Snow_Fox | sorry Soul already sold and outsourced |
21:32 | pianohacker | Heh. Seriously though, I look at some of the first code I wrote for my library's Koha installation and shiver. Only one way to improve... |
21:33 | Snow_Fox | heh |
21:33 | well the problem isnt with understanding a program language just my brain is hardwired a little differently | |
21:33 | im a bit too much intuitive of a thinking instead of a logical | |
21:33 | great for problem solving bad for programing | |
21:33 | chris | perfect for UI |
21:34 | Snow_Fox | aye |
21:34 | chris | get cracking fixing templates :-) |
21:34 | (there is no escape) | |
21:34 | Snow_Fox | oh ya! |
21:34 | i can escape anytime i want to | |
21:34 | watch | |
21:34 | chris | he'll be back |
21:34 | they always are | |
21:35 | see | |
21:35 | :) | |
21:35 | Snow_Fox | I hate you...... |
21:35 | :-P | |
21:35 | oh well like i didnt warn you | |
21:35 | chris | hehe |
21:36 | Snow_Fox: you are brightening up an otherwise grey morning | |
21:36 | Snow_Fox | i tend to do that |
21:36 | pianohacker | chris: What's going on? |
21:36 | Snow_Fox | nothing like bitter rays of sunshine |
21:37 | hrm theres a deleted section in the DB | |
21:37 | does it have a TTL on records in there? | |
21:37 | chris | Snow_Fox: nope |
21:37 | pianohacker: lots of work, tons of email etc | |
21:37 | Snow_Fox | oh so the dbase slowly grows until it consumes all |
21:37 | chris | yeah, in 50 years :-) |
21:38 | Snow_Fox | ok gotcha 5 |
21:38 | chris | i think people do cron jobs to clear it out every so often |
21:38 | Snow_Fox | i can understand keeping stuff on hand for a period of time would come in handy |
21:39 | but eventually it needs to be blasted out so to speak | |
21:39 | pianohacker | A UI for restoring deleted records would actually be quite nice (allow undo for various actions) |
21:39 | Snow_Fox | as well as a UI to clear that out or set a TTL |
21:40 | lemme guess since i suggested it.... | |
21:41 | chris | pianohacker: we had that |
21:41 | in 1.2 | |
21:41 | HLT need it back | |
21:41 | so it will come soonish | |
21:47 | cait | good night everybody |
21:57 | CGI866 | . |
21:57 | pianohacker | gmcharlt: If you're fairly certain that the code behind the new syspref will be committed to koha.org soon, I can add it to the new editor |
21:58 | gmcharlt | pianohacker: sure, go ahead |
21:58 | pianohacker | k |
22:28 | bbl | |
22:45 | Snow_Fox | well piano |
22:45 | for the most part the setup makes sense | |
22:45 | there are still some tables that make absolutly no sense to me | |
22:45 | but must serve some pourpose | |
22:46 | like what does the accountlines table do | |
23:31 | pianohacker | Ahh, the accountlines table. |
23:31 | It records fines and fine payments | |
23:31 | amount is the initial amount, amountoutstanding is the what still remains to be paid | |
00:50 | 'night | |
00:51 | gmcharlt | hi IrmaCalyx |
01:00 | chris | hiya IrmaCalyx |
01:00 | thank you so much for the presents for Atarau | |
03:34 | Amit | hi chris, richard |
03:34 | good morning #koha | |
03:34 | richard | hi amit |
03:39 | Amit | @wunder New Delhi India |
03:39 | munin | Amit: The current temperature in New Delhi, India is 32.0°C (8:30 AM IST on July 23, 2009). Conditions: Scattered Clouds. Humidity: 66%. Dew Point: 25.0°C. Pressure: 29.53 in 1000 hPa (Steady). |
03:40 | Amit | @wunder Dehradun India |
03:40 | munin | Amit: The current temperature in Dehradun, India is 26.0°C (8:30 AM IST on July 23, 2009). Conditions: Partly Cloudy. Humidity: 82%. Dew Point: 24.0°C. Pressure: 29.55 in 1000 hPa. |
03:40 | Amit | @wunder Bangalore India |
03:40 | munin | Amit: Error: No such location could be found. |
03:47 | Amit | hi indradg_ |
06:01 | indradg_ | Amit, hi |
06:14 | Amit | hi nicomo |
06:15 | nicomo | hi Amit |
06:15 | morning #koha | |
06:27 | mason | morning all |
06:28 | Amit | hi mason |
06:53 | chris | hi kf |
06:59 | kf | good morning chris :) |
06:59 | chris | heya kf |
07:00 | heh, i just realised i already said hi hehe | |
07:00 | kf | did another ubuntu installation on laptop yesterday and installed everything needed for Koha - finding out how to use GIT is next and get a working dev installation (I hope it will work this time) |
07:01 | decided to work on this, as I have to wait for the official MARC21 translation to be published | |
07:02 | chris | excllent :) |
07:03 | kf | will ask questions soon - but now at work, working on documenting all those new enhanced content features and figure out what I can activate :) |
07:23 | chris | hi Kivutar, nahuel, laurence and indradg |
07:24 | nahuel | hi chris |
07:24 | laurence | hi chris |
07:24 | indradg | chris, y0! |
07:26 | chris | great comment nicomo |
07:26 | nicomo | hi chris |
07:26 | you're welcome :-) | |
07:27 | hdl_laptop | hi chris |
07:27 | chris | it was nice that one of the evergreen developers beat you :) |
07:27 | nicomo | indeed |
07:27 | and funny too | |
07:27 | chris | hi hdl_laptop |
07:28 | Kivutar | hi chris |
07:34 | chris | hi paul_p |
07:34 | paul_p | hi chris |
07:34 | big fire in country in Marseille yesterday, and it's not finished | |
07:42 | chris | oh no |
07:42 | no one hurt? | |
07:49 | paul_p | chris: nope. A few houses were evacuated, but none burnt. |
07:49 | 6 firemen were lightly injured | |
07:50 | chris | glad to hear no serious injuries |
07:56 | paul_p | 2 planes (canadairs) starting attacking the remaining fire area just passing in the sky near us |
07:57 | (and the office is full of ash/cinder | |
08:08 | chris | is it still very smoky? |
08:22 | nahuel | lesser today |
08:22 | but yesterday night... | |
08:22 | :( | |
08:23 | paul_p, they said 4 canadair yesterday | |
08:23 | and 1200ha of "callanque" burned | |
08:24 | the fire started due to military training :( | |
08:24 | assholl | |
08:29 | chris | :( |
08:31 | nahuel | If I remeber well, 5 fives burned |
08:32 | http://www.laprovence.com/diap[…]des-quartiers.php | |
08:32 | look at the photos | |
08:39 | chris | wow |
08:42 | heres my news for the day | |
08:42 | http://www.stuff.co.nz/technol[…]z-wins-Web-Awards | |
08:51 | nahuel | :p |
08:57 | |Lupin| | hello |
08:58 | chris | hi |Lupin| |
08:59 | |Lupin| | hi chris :) |
08:59 | chris: remember the problem we talked about yesterday ? | |
09:00 | chris | yes, did you solve it? |
09:00 | |Lupin| | chris: no, not yet. |
09:00 | chris: since yesterday I have re-installed Koha (not the code, the DB) | |
09:00 | added a few MARC fields / subfields and linked them to the Koha subfield | |
09:01 | turned on opac suppresion and bulkmarcimported a few records with a field saying they should not belisted at OPAC | |
09:01 | and the problem was the same | |
09:02 | so I turned off OpacSuppress, removed the Suppress index from NoZebraIndexes and re-imported the records without the suppression field | |
09:02 | and the problem remains the same | |
09:03 | chris | before you imported the records the search worked? |
09:03 | |Lupin| | pianohacker showed me how to reproduce the error while running the opac-search script from command line |
09:03 | chris: my error was that I didn't try that | |
09:04 | chris: but before the records were imported thaere was no record at all in Koha | |
09:04 | chris: more precisely I should have checked that every thing worked before playing with OpacSuppress, I think | |
09:06 | chris | yep |
09:09 | |Lupin| | ahah actually I have found out something interesting |
09:09 | chris | ? |
09:09 | |Lupin| | http://pastebin.com/f76751eda |
09:09 | I have added a use diagnostics to opac-search.pl | |
09:09 | chris: there may be some error in the MarcXML records, right ? | |
09:10 | chris | thats certainly what it looks like |
09:11 | ahhhh | |
09:11 | i think i might know the problem | |
09:11 | |Lupin| | hmm ? |
09:13 | chris | can you do a select marcxml from biblioitems; |
09:13 | and pastebin the output please | |
09:13 | koha has its own pastebin btw http://koha.pastebin.com/ :) | |
09:13 | |Lupin| | certainly |
09:14 | I was precisely looking at it | |
09:15 | http://pastebin.com/f459cb734 | |
09:17 | chris | hmm they look ok |
09:17 | i cant see any missing < can you? | |
09:18 | |Lupin| | no I can't either |
09:19 | chris | hmmmm |
09:19 | can you do select marc from biblioitems; | |
09:19 | and pastebin that too | |
09:19 | |Lupin| | perhaps I should modify the script that calls the marc creation function and add an eval block print additional info... |
09:20 | chris: yep, sure | |
09:20 | chris | it looks to me |
09:20 | like it is trying to parse the marc, as if it was marcxml | |
09:21 | 01192cam a2200337 | |
09:21 | |Lupin| | http://pastebin.com/f2a3e6482 |
09:21 | chris | <leader>01192cam a2200337 4500</leader> |
09:21 | |Lupin| | right |
09:21 | chris | yes thats it |
09:22 | |Lupin| | I also briefly thought about it... |
09:22 | chris | for some strange reason, it is trying to parse the marc, instead of the marcxml |
09:22 | thats why it cant find any < | |
09:22 | there are none in the marc | |
09:22 | |Lupin| | sur |
09:22 | +e | |
09:23 | chris | but why .. that is the question |
09:23 | |Lupin| | I'm normally sng HEAD git version |
09:23 | chris | hi rachel |
09:23 | |Lupin| | hi rachel |
09:23 | chris: is it enough to do reglularly git pull to ensure that one has the most recent version, or is there something else to do ? | |
09:24 | chris | that should be enough |
09:24 | |Lupin| | how can I check that I'm on the right branch ? |
09:24 | chris | git branch |
09:25 | will tell you what branch you are on | |
09:25 | |Lupin| | ok |
09:25 | gmcharlt_away | or first couple lines of git status |
09:25 | |Lupin| | * master |
09:26 | and in the git diff I can see that the only difference is the use diagnostics just added. | |
09:26 | gmcharlt_away: hello, thanks ! | |
09:27 | chris | wow, you are awake early |
09:28 | gmcharlt | too much caffeine last night, couldn't sleep |
09:28 | chris | hehe didnt learn from my mistake :) |
09:31 | |Lupin| | :) |
09:31 | gmcharlt: good luck for your day about to start, that may be hard | |
09:32 | gmcharlt | thanks |
09:32 | hdl_laptop | gmcharlt: hi |
09:32 | gmcharlt | hi hdl_laptop |
09:38 | |Lupin| | chris: I'm unsure how to proceed now to find the cause of this error... |
09:39 | chris | yeah, so am i, i havent run across it before |
09:41 | |Lupin| | chris: just looking at the code for NZgetRecords which is, I hink, the one that is called on my system to find out the records |
09:42 | chris | right, it may be because i use zebra that ive never bumped into this |
09:42 | gmcharlt | hmm, I have an idea |
09:42 | |Lupin|: try the following | |
09:42 | |Lupin| | yeah actually I presume the nozebra code ismuch less tested than the zebra one, is that correct ? |
09:42 | gmcharlt | git checkout -b temp |
09:42 | git revert 7a3bdce23dd | |
09:43 | |Lupin| | gmcharlt: ? |
09:43 | gmcharlt | would undo a recent commit that may have broken thngs for you |
09:43 | |Lupin| | gmcharlt: oh ok sorry I didn't see the first line |
09:46 | paul_p | hi gmcharlt. Early wake up today... |
09:47 | gmcharlt | hi paul_p |
09:48 | |Lupin| | gmcharlt: hmmm koha doesn't work at all now... |
09:48 | gmcharlt | hmm |
09:48 | do git checkout master then | |
09:49 | |Lupin| | done |
09:49 | doesn't work better, looking to the logs | |
09:50 | ah my mistake | |
09:50 | I'm always forgetting to re set the right permissions | |
09:50 | sorry gmcharlt | |
09:51 | I'll sitch back to the temp branch | |
09:51 | chris | ahh yes |
09:51 | i did a git show on that commit, it does look like the culprit | |
09:52 | |Lupin| | okay it works indeed ! |
09:52 | chris | nice work gmcharlt ! |
09:52 | gmcharlt | isgh |
09:52 | |Lupin| | yeah ! |
09:53 | gmcharlt | poor fredericd |
09:53 | this will be the second time I've pushed a revert of a version of that commit | |
09:53 | chris | hehe |
09:53 | |Lupin| | :) |
09:53 | thanks to all | |
09:54 | it is obvious that I couldne't have found out the solution without your help guys | |
09:55 | chris | community++ |
09:56 | |Lupin| | yeah |
09:56 | gmcharlt: I suppose you'll re-integrate the corrections to the master branch at some point ? | |
09:57 | gmcharlt | |Lupin|: yeah |
10:07 | kf | guten morgen lupin, good morning gmcharlt |
10:08 | gmcharlt | buenos dias, kf :) |
10:08 | fredericd | hi all |
10:08 | gmcharlt | hi fredericd |
10:08 | fredericd: sorry to do this to you again, but I'm going to have to revert your latest 3226 patch; turns out it breaks NoZebra | |
10:10 | fredericd | gmcharlt: hello |
10:10 | wouldn't it be better to revert no-zebra :-) | |
10:11 | gmcharlt | fredericd++ |
10:11 | |Lupin| | bonjour kf |
10:11 | fredericd | Is there a way to reproduce this bug and to fix it (in 5 minutes)? |
10:12 | |Lupin| | fredericd: are you talking about the nozebra one ? |
10:12 | fredericd | yes |
10:12 | |Lupin| | fredericd: on a non |
10:12 | zebra install yes | |
10:12 | fredericd: there is just one perl script to run | |
10:12 | gmcharlt | fredericd: it boils down to NoZebra always returns MARC, not MARCXML |
10:13 | fredericd: so probably not too hard to fix, but then must test | |
10:14 | |Lupin| | gmcharlt: I'd be happy to be the tester |
10:15 | gmcharlt | |Lupin|: ok, maybe you and fredericd can work something out to test a fix before it's submitted |
10:18 | |Lupin| | gmcharlt: what does it imply ? receiving a patch, applying it and seeing whether it fixes the problem or not ? |
10:18 | gmcharlt | yeah |
10:18 | |Lupin| | fine then |
10:19 | shall I subscribe to koha-patches to receive it ? | |
10:19 | gmcharlt | yes that, or else fredericd could send to you direct |
10:19 | |Lupin| | fredericd: if you could send it directly that would be excellet... would that be possible ? |
10:23 | fredericd | Ok, I see that directly with |Lupin| |
10:55 | chris | hi nengard |
10:57 | nengard | hiya |
11:15 | chris | busy day today nengard ? |
11:17 | paul_p | nengard so busy that she can't stay here :D |
11:17 | back from lunch. Canadair still rotating in the sky... | |
11:18 | gmcharlt | paul_p: ? |
11:18 | paul_p | yep gmcharlt ? |
11:19 | gmcharlt | was wondering about "Canadair still rotating in the sky" |
11:19 | paul_p | big fire in the border of Marseille. |
11:19 | gmcharlt | ah |
11:20 | paul_p | smoke cloud on the city, and ash everywhere (includind in the office: stupid me => we are on 3rd floor, I let the windows open for the night, to cool the office... very bad idea yesterday) |
11:21 | gmcharlt | :( |
11:23 | paul_p | my home is just facing the sea. it's VERY impressive to see canadairs (yesterday 4) "falling" on the sea, staying 10second to fill themselves, then running to the fire place, then come back 5mn later...) |
11:25 | http://www.laprovence.com/diap[…]p?idx=6#top-diapo | |
11:25 | http://www.laprovence.com/diap[…]p?idx=5#top-diapo | |
11:25 | Yesan | I would like to know if someone out there to help. |
11:25 | paul_p | http://www.laprovence.com/diap[…]p?idx=9#top-diapo |
11:25 | Yesan | jwagner. |
11:25 | paul_p | hello Yesan & jwagner |
11:25 | gmcharlt | paul_p: wow |
11:25 | Yesan | Yes. Pall |
11:25 | paul p | |
11:25 | paul_p | there are some ppl here, throw your question, we will see if we can do something for you ! |
11:26 | Yesan | My question, I would like to remove those records in my database |
11:26 | as there are several records dublicates | |
11:26 | i wuld like to start over again for data importing. | |
11:27 | need help to clean database | |
11:27 | paul_p | Yesan: you use bulkmarcimport.pl to import your datas ? |
11:27 | Yesan | Should i use phpadmin to remove db?? :( |
11:27 | paul_p | if yes => option -d will delete everything before doing the import |
11:28 | Yesan | i use stage the records in |
11:28 | reservoir | |
11:28 | and import them | |
11:28 | paul_p | how many records do you have ? if it's for migrating datas, you'd better use misc/bulkmarcimport.pl command line script |
11:28 | Yesan | I am not too good in squl commands |
11:29 | sql | |
11:29 | appx 300+ | |
11:29 | records | |
11:29 | paul_p | the reservoir is here for librarian "small" imports once live (for records coming from vendors for example) |
11:30 | there is nothing to empty your DB on Koha web interface. The way to go is the command line bulkmarcimport, (i'm sure) | |
11:30 | Yesan | My db has records, I would like them to be deleted from the Database. |
11:31 | jwagner | Good morning all |
11:32 | gmcharlt | hi jwagner |
11:32 | Yesan | Paul, |
11:33 | jwagner | hi gmcharlt. Say it isn't so :-) |
11:34 | Yesan | Yes. |
11:34 | Paul, before I do the bulkmarcimport.pl | |
11:34 | i want the existing recordst to removed. | |
11:34 | can this be possible | |
11:35 | paul_p | Yesan: everytime you run bulkmarcimport.pl with -d the DB will be cleaned before doing anything |
11:36 | as easy as that ! | |
11:36 | Yesan | great |
11:36 | thanks for your reply | |
11:36 | paul_p | just run bulkmarcimport -d -t to DELETE and TEST (and do nothing on the DB in fact, so just empty the DB) |
11:41 | Yesan | sorry to trouble you once again |
11:46 | gmcharlt | jwagner: yes, 'tis |
11:49 | Yesan | Paul, |
11:49 | should i use ssh access | |
11:49 | for bulkmarcimport -d -t | |
11:51 | paul_p | Yesan: (you should use my nick if you want that I'm warned. My irc client is not always on top) |
11:51 | to answer your question : yes, you need ssh access for bulkmarcimport | |
11:51 | (it's a command line tool, like everything in misc directory) | |
11:53 | |Lupin| | hi again |
← Previous day | Today | Next day → | Search | Index