2012-01-08T01:18:34 trying to get this script working, turn a list of ISBNs into MARCXML records, I got the LoC working but I'm getting an error in the OCLC part of it. Here is what I got so far http://pastebin.com/FmL1Zqxt 2012-01-08T01:18:56 with the correct username and password it gives ZOOM error 10005 "Init rejected" from diag-set 'ZOOM' 2012-01-08T01:30:04 dumb question: what happens if you leave out username and password altogether? 2012-01-08T01:32:13 same error, at least here 2012-01-08T01:33:47 yeah same error 2012-01-08T01:33:47 hmm 2012-01-08T01:39:30 apparently on OCLC's website they only support usmarc so maybe change that...still the same error, it has to do with authentication. i'm trying it with and without dashes...I'm starting to wonder if it needs to be encrypted at all 2012-01-08T01:43:10 are you sure ZOOM::Connection->new() supports username and password params? 2012-01-08T01:44:06 or can you try doing create() and connect() as separate steps? 2012-01-08T01:46:19 http://www.indexdata.com/yaz/doc/zoom.html#zoom-connections i've been trying to read from this documentation. The anchor that I linked you to has Table 3.1 right below it 2012-01-08T01:46:29 that has the stuff it supports...i guess it's user but that still doesn't seem to work 2012-01-08T01:47:29 I could try putting it on the Option function 2012-01-08T01:47:35 but I think Connection supports options 2012-01-08T01:48:28 yeah I was looking at different documentation that didn't mention it 2012-01-08T01:48:52 took me a few googlings to find that one 2012-01-08T01:48:59 i've been at this for...most of the day I guess 2012-01-08T01:49:29 not super familiar with perl, but very much so with php and c++ so it's not too bad. 2012-01-08T01:52:25 http://zoom.z3950.org/bind/perl/ here is the example of how they bind it to perl 2012-01-08T01:52:38 the first doc is the bare...source 2012-01-08T01:53:47 http://search.cpan.org/~mirk/Net-Z3950-ZOOM/lib/ZOOM.pod and here is the cpan docs for it 2012-01-08T01:57:00 you tried not md5_hex'ing the pw? 2012-01-08T01:57:15 yeah. i think i've found something in that cpan doc in the Options area 2012-01-08T01:57:19 i'm modifying the script 2012-01-08T01:57:33 (sorry that I don't have any actually useful suggestions :/ ) 2012-01-08T02:00:20 you're okay! i'm just excited that i'm finding things. maybe it could be a useful migration tool... 2012-01-08T02:06:36 yargh...i set the options ahead of time and it still rejected init 2012-01-08T02:44:11 *** wjr has quit IRC 2012-01-08T02:45:26 *** wjr has joined #evergreen 2012-01-08T03:24:45 http://pastebin.com/e1E4JURj here is the new version 2012-01-08T03:25:02 it only worked with LoC, but it catches the error when the record doesn't exist and passes it 2012-01-08T03:43:33 is there a way to modify the MARC record and add in a Location/volume/copy so we don't have to go do that? 2012-01-08T03:43:46 (i'm not a librarian so I don't know if they can do a batch holding maintenence) 2012-01-08T04:00:17 no automatic way to create a volume and item with an entry? =/ 2012-01-08T04:03:27 *** youdonotexist has quit IRC 2012-01-08T04:06:49 i hope someone finds that useful. 2012-01-08T04:06:53 *** enhancin has quit IRC 2012-01-08T05:37:05 *** natschil_ has joined #evergreen 2012-01-08T05:50:49 *** natschil_ has quit IRC 2012-01-08T05:52:00 *** natschil has joined #evergreen 2012-01-08T05:52:24 *** natschil has joined #evergreen 2012-01-08T08:30:07 *** _bott_ has quit IRC 2012-01-08T08:30:42 *** _bott_ has joined #evergreen 2012-01-08T09:14:02 *** dbs has joined #evergreen 2012-01-08T09:26:41 *** Dyrcona has joined #evergreen 2012-01-08T11:00:14 *** rsinger has quit IRC 2012-01-08T11:03:29 *** rsinger has joined #evergreen 2012-01-08T11:09:05 *** rsinger has left #evergreen 2012-01-08T11:36:42 *** enhancin has joined #evergreen 2012-01-08T11:38:52 So, when I am trying to run a marc2bre.pl on a marc file I get a "TCN is already in use, using TCN (s93) derived from System ID." however I only go up to 92 in my database 2012-01-08T11:42:39 I've tried changing the number and they're all in use it says. 2012-01-08T12:19:46 eg-server# /openils/bin/marc2bre.pl --used_tcn_file used_tcns MarcTest2.marc \ \ !!! TCN is already in use, using TCN (s93) derived from System ID. 2012-01-08T13:05:20 *** agJohn has quit IRC 2012-01-08T13:08:26 *** Amos_ has joined #evergreen 2012-01-08T13:10:23 hi all. i'm doing a study looking at the role of consortia management in supporting OSS projects. could you please tell me where i could get info on the role played by PINES in the Evergreen project? 2012-01-08T13:14:31 Amos_: maybe http://www.georgialibraries.org/gpls/call_list.php - "PINES Governance" ? 2012-01-08T13:19:04 I guess that should help since I can mail some of the folks listed there. I'd be even more grateful if you'd have another OSS example besides Evergreen. Thanks so much and bye for now. 2012-01-08T13:45:26 *** youdonotexist has joined #evergreen 2012-01-08T13:51:18 I'm having an issue with the marc_cleanup script found in migration-tools that ht documentation talks about...I've tried running it with different options and all of them say 0 in; 0 dumped 2012-01-08T14:55:32 *** enhancin_ has joined #evergreen 2012-01-08T15:23:03 *** enhancin_ has quit IRC 2012-01-08T15:34:12 *** fredericd has left #evergreen 2012-01-08T15:36:05 *** enhancin_ has joined #evergreen 2012-01-08T15:45:11 on the marc_cleanup the subroutine buildrecord , while defining $l = causes it to become undefined 2012-01-08T15:45:25 which then causes it to return and end the program, doing nothing... 2012-01-08T15:45:40 *** Amos_ has quit IRC 2012-01-08T16:07:54 *** natschil has quit IRC 2012-01-08T16:36:16 *** enhancin_ has quit IRC 2012-01-08T16:36:39 *** enhancin has quit IRC 2012-01-08T18:05:53 *** enhancin has joined #evergreen 2012-01-08T18:06:16 I'm having a hard time figuring out which MARC entry is the holdings entry? 2012-01-08T18:08:18 is there an easy way to tell? i've been googling for some docs but i'm not sure 2012-01-08T18:57:24 barcode? I can figure out the barcode on existing ones but I don't see it in the MARC record...the evergreen documentation is telling me to use extract holdings but i can't even figure out how to make it work, it can't ever find anything 2012-01-08T19:16:19 enhancin: i think you may be able to check the MARC Batch Import/Export "Import Item Attributes" and build something based on that - probably a different set of APIs if you go that route, though 2012-01-08T19:28:47 *** edoceo has quit IRC 2012-01-08T19:38:19 dbs: i've been going through Migrating Bibliographic Records Using the ESI Migration Tools in chapter 20 on the docs 2012-01-08T19:38:33 enhancin: oh, I know nothing about the ESI tools 2012-01-08T19:38:42 darn 2012-01-08T19:39:27 my biggest question is about marc records relaly 2012-01-08T19:39:28 really 2012-01-08T19:41:05 dbs: do you know if I do a batch MARC import if I can do an automatic item add? that's what I need to do..I have one but it doesn't really have a location, at least I can't really tell what the location is 2012-01-08T19:51:18 it is complaining that it has no 903 record...burd I don't see that in any of the existing entries...i've been trying to refernece them to other entries and not getting anything really 2012-01-08T19:54:38 enhancin: yeah, that's the idea of the MARC Batch Import/Export, and I would imagine the ESI tools too. it's common to encode holdings info in a 9xx field, with owning lib in one subfield, copy location in another, call number in another, and barcode in another, yada yada 2012-01-08T19:55:12 right...the barcodes of the other ones seem to just be like 110 171 (of a couple I grabbed randomly) 2012-01-08T19:55:25 110 and 171 are separate sorry 2012-01-08T20:06:12 how about a way to batch edit holdings maintenence....? =/ 2012-01-08T20:06:16 i just need a solution today... 2012-01-08T20:15:06 would it be the index number of the owning lib or the short name? 2012-01-08T20:20:58 dbs: sorry to bug you i'm just having a hard time identifying which one is being used for holdings... 2012-01-08T20:21:24 al the 9xx ones seem to not really indicate anything about what library it's in and whatnot 2012-01-08T20:39:12 Hmm, do you think I could just add them all and then use something like http://docs.evergreen-ils.org/2.1/html/migratingbibrecordcopies.html to add copies? 2012-01-08T20:41:16 somehow manually create the holdings... 2012-01-08T20:41:19 er with a script... 2012-01-08T20:46:47 enhancin: sorry, putting the kids to bed 2012-01-08T20:46:55 you're okay..i need to take a break sometime 2012-01-08T20:46:57 http://docs.evergreen-ils.org/2.1/html/migratingbibrecordcopies.html is basically how we migrated our holdings 2012-01-08T20:47:25 could I just increment the barcode or does the barcode have to be something special? 2012-01-08T20:49:58 the barcode normally matches whatever has been stuck on the book 2012-01-08T20:50:14 but if you're just making up barcodes and call numbers... one sec 2012-01-08T20:51:10 it looks like the call numbers kind of get generated by the author's name 2012-01-08T20:51:27 http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/tests/datasets/concerto.sql;h=68cafb1901a6ff0715b12249d5e8cce22023924e;hb=refs/heads/master gives an example of creating call numbers and copies (and more) 2012-01-08T20:52:26 hmmmm alright. going to have to read this through 2012-01-08T20:53:38 I guess I could just write a script that goes through the MARC file and makes a staging table for holdings 2012-01-08T20:54:00 then use some pgsql magic like this 2012-01-08T20:58:35 it appears that the barcode is just incrementing...(i'm the admin not the librarian..so I don't know what they want to do there..) the call number is just the first 4 of the author...but I'm not sure if that will cause issues if they share a call number 2012-01-08T21:10:55 I need to take a break i'll think of something -.-...i've been working on this for so long 2012-01-08T21:31:09 *** Dyrcona has quit IRC 2012-01-08T21:47:30 *** youdonotexist has quit IRC 2012-01-08T23:26:10 If anyone has ever done a migration from an MSSQL ILS...I could use some pointers, i'm mostly just trying to pull MARC records from a Z3950 script and then do some holdings magic through postgresql, but i'm having a hard time with the database entries..each book has multiple rows in it and i'm not sure what ILS it came from before