Howdy, I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it. With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books. How do I do this in Koha? So far, it appears that I can do this, but only one ISBN at a time? -- John Wesley Simpson Hibbs <john@swajime.com> SwaJime's Cove
John -- Koha allows you to add an arbitrary number of z3950 sources and search them individually or in arbitrary groups. But the type of "shotgun" approach you describe is not currently supported by Koha. I suspect it is not the kind of workflow a professional cataloger would undertake, mainly because there is no oversight of the quality or accuracy of data injected into the database. Occasionally ISBN's do get reused, so without other criteria or human review, you could conceivably import bogus data. That being said, I like the idea of a mass import by ISBN from text file, breaking it apart into two results: - a group of staged records where ISBN is confidently matched, and - a text file with the subset of unmatched or ambiguous ISBNs For now though, it'll have to be something for developers to mull over. You may want to check if there is any similar functionality in ‡biblios<http://biblios.org/>(or plans for it). -- Joe On Mon, Dec 29, 2008 at 2:46 PM, John Wesley Simpson <john@swajime.com>wrote:
Howdy,
I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it.
With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books.
How do I do this in Koha?
So far, it appears that I can do this, but only one ISBN at a time? -- John Wesley Simpson Hibbs <john@swajime.com> SwaJime's Cove
On Tue, Dec 30, 2008 at 10:17 AM, Joe Atzberger <ohiocore@gmail.com> wrote:
John --
Koha allows you to add an arbitrary number of z3950 sources and search them individually or in arbitrary groups. But the type of "shotgun" approach you describe is not currently supported by Koha.
I suspect it is not the kind of workflow a professional cataloger would undertake, mainly because there is no oversight of the quality or accuracy of data injected into the database. Occasionally ISBN's do get reused, so without other criteria or human review, you could conceivably import bogus data. That being said, I like the idea of a mass import by ISBN from text file, breaking it apart into two results:
a group of staged records where ISBN is confidently matched, and a text file with the subset of unmatched or ambiguous ISBNs
Hi All I seem to remember Mason has done something like this for a client in the past, he may have a script handy that will work as a base for this Chris
Hi everyone, I've recently got a SydPlus system which has about 20000 non-MARC records and runs on SQL Server. I've been able to export all tables into CSV format. Now I want to get these records loaded into KOHA and need some help. Also, I need to figure out database structure to associate (map) each one to MARC fields. Unfortunately, I'm not familiar with SydPlus as we just recently inherited the collection and system. So, essentially my questions are: 1- Is anyone familiar with SydPlus record structure and tables? 2- How to convert non-MARC records and load them into KOHA. I'd really appreciate any help and suggestion.... Thanks H. Sam Davoodifar Systems Admin/IT Services IRU - Educational Resources Manitoba Education, Citizenship & Youth 1181 Portage Ave., Winnipeg, MB R3G OT3 Tel: 204-945-4904 Toll free: 800-282-8069 (ext. 4904) Fax: 204-945-8756 New email: h.sam.davoodifar@gov.mb.ca
I suppose now that you have the data in a readable format you can convert the records to MARC, and then use the existing Koha tools to import the MARC records. I'm new to Koha as well; are there tools to import records without passing through a MARC stage? Assuming you want to convert the records to MARC, and then import... I have no idea how to map SydPlus database structure to MARC. You say you have successfully exported the SydPLUS data to CSV. Unless you can get some help from SydPlus, I suspect you'll simply have to reverse-engineer the database. I would begin with the Koha-to-MARC mapping, identifying each MARC tag in the Koha database with a table/column of the SydPlus database. The Koha-to-MARC mapping is easy. To see the mapping from Koha to Marc, go to the Koha Staff Client, Administration->Koha to Marc Mapping (http://<your server name>/cgi-bin/koha/admin/koha2marclinks.pl). There are 3 tables that store details about books: biblio, biblioitems, items. Do you know any perl? To get the data in the right format I would use the Perl MARC library, available at http://marcpm.sourceforge.net/ To manipulate data in CSV files I would suggest the Perl library Text::CSV_XS To see a very simple example of Perl MARC in action, see my script at http://contribs.koha.org/revision_view.php?rid=15 -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html --- On Mon, 1/5/09, Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar@gov.mb.ca> wrote: From: Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar@gov.mb.ca> Subject: [Koha] Converting non-MARC records To: "Koha" <koha@lists.katipo.co.nz> Date: Monday, January 5, 2009, 10:52 AM Hi everyone, I've recently got a SydPlus system which has about 20000 non-MARC records and runs on SQL Server. I've been able to export all tables into CSV format. Now I want to get these records loaded into KOHA and need some help. Also, I need to figure out database structure to associate (map) each one to MARC fields. Unfortunately, I'm not familiar with SydPlus as we just recently inherited the collection and system. So, essentially my questions are: 1- Is anyone familiar with SydPlus record structure and tables? 2- How to convert non-MARC records and load them into KOHA. I'd really appreciate any help and suggestion.... Thanks H. Sam Davoodifar Systems Admin/IT Services IRU - Educational Resources Manitoba Education, Citizenship & Youth 1181 Portage Ave., Winnipeg, MB R3G OT3 Tel: 204-945-4904 Toll free: 800-282-8069 (ext. 4904) Fax: 204-945-8756 New email: h.sam.davoodifar@gov.mb.ca _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
hello, another tool you can try is marcedit at http://oregonstate.edu/~reeset/marcedit/html/index.php it has a feature to take csv file and generate a file (.mrk) that it now makes into marc. I've used this to convert a csv file into marc for import. Of course i dont know perl :-(, so i found this route easier. Olugbenga Adara Ibadan, Nigeria. Mobile: 234-803-3220288 --- On Mon, 1/5/09, Jeffrey LePage <jeffrey_lepage@yahoo.com> wrote:
From: Jeffrey LePage <jeffrey_lepage@yahoo.com> Subject: Re: [Koha] Converting non-MARC records To: "Koha" <koha@lists.katipo.co.nz>, "Davoodifar, H. Sam (EDU-ECY)" <H.Sam.Davoodifar@gov.mb.ca> Date: Monday, January 5, 2009, 12:34 PM I suppose now that you have the data in a readable format you can convert the records to MARC, and then use the existing Koha tools to import the MARC records. I'm new to Koha as well; are there tools to import records without passing through a MARC stage?
Assuming you want to convert the records to MARC, and then import...
I have no idea how to map SydPlus database structure to MARC. You say you have successfully exported the SydPLUS data to CSV. Unless you can get some help from SydPlus, I suspect you'll simply have to reverse-engineer the database. I would begin with the Koha-to-MARC mapping, identifying each MARC tag in the Koha database with a table/column of the SydPlus database.
The Koha-to-MARC mapping is easy. To see the mapping from Koha to Marc, go to the Koha Staff Client, Administration->Koha to Marc Mapping (http://<your server name>/cgi-bin/koha/admin/koha2marclinks.pl). There are 3 tables that store details about books: biblio, biblioitems, items.
Do you know any perl?
To get the data in the right format I would use the Perl MARC library, available at http://marcpm.sourceforge.net/
To manipulate data in CSV files I would suggest the Perl library Text::CSV_XS
To see a very simple example of Perl MARC in action, see my script at http://contribs.koha.org/revision_view.php?rid=15
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--- On Mon, 1/5/09, Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar@gov.mb.ca> wrote: From: Davoodifar, H. Sam (EDU-ECY) <H.Sam.Davoodifar@gov.mb.ca> Subject: [Koha] Converting non-MARC records To: "Koha" <koha@lists.katipo.co.nz> Date: Monday, January 5, 2009, 10:52 AM
Hi everyone,
I've recently got a SydPlus system which has about 20000 non-MARC records and runs on SQL Server. I've been able to export all tables into CSV format. Now I want to get these records loaded into KOHA and need some help. Also, I need to figure out database structure to associate (map) each one to MARC fields. Unfortunately, I'm not familiar with SydPlus as we just recently inherited the collection and system. So, essentially my questions are:
1- Is anyone familiar with SydPlus record structure and tables? 2- How to convert non-MARC records and load them into KOHA.
I'd really appreciate any help and suggestion....
Thanks
H. Sam Davoodifar Systems Admin/IT Services IRU - Educational Resources Manitoba Education, Citizenship & Youth 1181 Portage Ave., Winnipeg, MB R3G OT3 Tel: 204-945-4904 Toll free: 800-282-8069 (ext. 4904) Fax: 204-945-8756 New email: h.sam.davoodifar@gov.mb.ca _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Joe, Please forgive my persistence ... My library is rather small, only about 1500 books. I am still hoping not to have to enter them all in one at a time... I decided to try Google's MyLibrary, and after deciding it had too few features, am still kicking myself... Deleting the books one by one, I'm about half way through removing them from there. Assuming that the ISBN's are correct in the first place, can I create the staged records with "only" the isbn, and then have the rest of the data filled in automatically from the z39.50 sources? john On Mon, 2008-12-29 at 16:17 -0500, Joe Atzberger wrote:
John --
Koha allows you to add an arbitrary number of z3950 sources and search them individually or in arbitrary groups. But the type of "shotgun" approach you describe is not currently supported by Koha.
I suspect it is not the kind of workflow a professional cataloger would undertake, mainly because there is no oversight of the quality or accuracy of data injected into the database. Occasionally ISBN's do get reused, so without other criteria or human review, you could conceivably import bogus data. That being said, I like the idea of a mass import by ISBN from text file, breaking it apart into two results: * a group of staged records where ISBN is confidently matched, and * a text file with the subset of unmatched or ambiguous ISBNs For now though, it'll have to be something for developers to mull over. You may want to check if there is any similar functionality in ‡biblios (or plans for it). -- Joe
On Mon, Dec 29, 2008 at 2:46 PM, John Wesley Simpson <john@swajime.com> wrote:
Howdy,
I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it.
With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books.
How do I do this in Koha?
So far, it appears that I can do this, but only one ISBN at a time? -- John Wesley Simpson Hibbs <john@swajime.com> SwaJime's Cove
Hello, Apologies for going back and responding to the original e-mail, but i just wanted to let John know there are tools that will do this for him (albeit in a two-step process). You can use a tool like the free MarcEdit that has a batch mode for searching Z39.50 servers given a list of authors/ISBN/titles, or even any custom field. You can then import the MARC records you get into Koha's reservoir. In fact, i created a video tutorial a few days back that illustrates how to do this for local people that asked me, but its still not upto scratch, so i haven't published it to the Wiki or other location yet. But if you are really interested, i can try and finish it off and send it to whatever audience is interested. All the other caveats from people on this thread still hold true. In other words, the quality of your catalog is as good as what you make it or what you allow into it. regards, krishnan Pune, India ________________________________ From: John Wesley Simpson <john@swajime.com> To: Koha <koha@lists.katipo.co.nz> Sent: Tuesday, 30 December, 2008 1:16:27 AM Subject: [Koha] Importing records Howdy, I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it. With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books. How do I do this in Koha? So far, it appears that I can do this, but only one ISBN at a time? -- John Wesley Simpson Hibbs <john@swajime.com> SwaJime's Cove Bring your gang together. Do your thing. Find your favourite Yahoo! group at http://in..promos.yahoo.com/groups/
Krishnan, Thank you, thank you, thank you. I would definitely be interested in your video. Meanwhile I'll try your suggestion. I've been pulling my hair out trying to install ‡biblios as Joe suggested: The instructions at http://biblios.org/docs/install-embedded-koha say "‡biblios requires the following components: ... PazPar2 ... ) # cd pazpar2-1.0.9 # ./configure ... checking for yaz-config... NONE ... checking for YAZ... Not found ... configure: error: YAZ development libraries missing # aptitude install yaz ... The following packages are BROKEN: libyaz3 ... The following NEW packages will be installed: yaz ... The following packages have unmet dependencies: ... libyaz3: Depends: libicu36 but it is not installable ... The following actions will resolve these dependencies: ... Install the following packages: libyaz3 ... Keep the following packages at their current version: yaz [Not Installed] Score is -9909 ... Accept this solution? [Y/n/q/?] n ... ( last 4 lines repeated TWELVE times ... How many times have YOU rejected the same solution 12 times in a row without giving up and choosing [q]? ) ... The following actions will resolve these dependencies: ... Install the following packages: libyaz3 yaz Score is -9948 ... Accept this solution? [Y/n/q/?] y # ./configure ... checking for yaz-config... NONE ... checking for YAZ... Not found ... configure: error: YAZ development libraries missing # aptitude install libyaz-dev ... The following packages are BROKEN: libyaz3 ... The following NEW packages will be installed: libwrap0-dev libxml2-dev libxslt1-dev libyaz libyaz-dev yaz-doc ... The following packages have unmet dependencies: ... libyaz: Conflicts: libyaz but 2.1.54-1 is to be installed. ... The following actions will resolve these dependencies: ... Remove the following packages: yaz ... Downgrade the following packages: libyaz3 Score is 89 ... Accept this solution? [Y/n/q/?] y # ./configure ... checking for yaz-config... /usr/bin/yaz-config ... checking for YAZ... /usr/bin/yaz-config ... checking for YAZ version... 2.1.54 ... configure: error: 2.1.54. Requires YAZ 3.0.25 or later # sleep -- john On Wed, 2008-12-31 at 15:49 +0530, Krishnan M wrote:
Hello,
Apologies for going back and responding to the original e-mail, but i just wanted to let John know there are tools that will do this for him (albeit in a two-step process).
You can use a tool like the free MarcEdit that has a batch mode for searching Z39.50 servers given a list of authors/ISBN/titles, or even any custom field. You can then import the MARC records you get into Koha's reservoir.
In fact, i created a video tutorial a few days back that illustrates how to do this for local people that asked me, but its still not upto scratch, so i haven't published it to the Wiki or other location yet.
But if you are really interested, i can try and finish it off and send it to whatever audience is interested.
All the other caveats from people on this thread still hold true. In other words, the quality of your catalog is as good as what you make it or what you allow into it.
regards, krishnan Pune, India
______________________________________________________________________
From: John Wesley Simpson <john@swajime.com> To: Koha <koha@lists.katipo.co.nz> Sent: Tuesday, 30 December, 2008 1:16:27 AM Subject: [Koha] Importing records
Howdy,
I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it.
With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books.
How do I do this in Koha?
So far, it appears that I can do this, but only one ISBN at a time?
Well, I've been having just as much trouble with installing MarcEdit ... :-( It needs .NET 2, and the install for .NET 2 is failing under WINE. I'd rather put every single record in by hand than put MS on one of my machines. -- john On Wed, 2008-12-31 at 15:49 +0530, Krishnan M wrote:
Hello,
Apologies for going back and responding to the original e-mail, but i just wanted to let John know there are tools that will do this for him (albeit in a two-step process).
You can use a tool like the free MarcEdit that has a batch mode for searching Z39.50 servers given a list of authors/ISBN/titles, or even any custom field. You can then import the MARC records you get into Koha's reservoir.
In fact, i created a video tutorial a few days back that illustrates how to do this for local people that asked me, but its still not upto scratch, so i haven't published it to the Wiki or other location yet.
But if you are really interested, i can try and finish it off and send it to whatever audience is interested.
All the other caveats from people on this thread still hold true. In other words, the quality of your catalog is as good as what you make it or what you allow into it.
regards, krishnan Pune, India
______________________________________________________________________ From: John Wesley Simpson <john@swajime.com> To: Koha <koha@lists.katipo.co.nz> Sent: Tuesday, 30 December, 2008 1:16:27 AM Subject: [Koha] Importing records
Howdy,
I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it.
With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books.
How do I do this in Koha?
So far, it appears that I can do this, but only one ISBN at a time?
Well, I've been having just as much trouble with installing MarcEdit ... :-( It needs .NET 2, and the install for .NET 2 is failing under WINE. I'd rather put every single record in by hand than put MS on one of my machines. -- john On Wed, 2008-12-31 at 15:49 +0530, Krishnan M wrote:
Hello,
Apologies for going back and responding to the original e-mail, but i just wanted to let John know there are tools that will do this for him (albeit in a two-step process).
You can use a tool like the free MarcEdit that has a batch mode for searching Z39.50 servers given a list of authors/ISBN/titles, or even any custom field. You can then import the MARC records you get into Koha's reservoir.
In fact, i created a video tutorial a few days back that illustrates how to do this for local people that asked me, but its still not upto scratch, so i haven't published it to the Wiki or other location yet.
But if you are really interested, i can try and finish it off and send it to whatever audience is interested.
All the other caveats from people on this thread still hold true. In other words, the quality of your catalog is as good as what you make it or what you allow into it.
regards, krishnan Pune, India
______________________________________________________________________
From: John Wesley Simpson <john@swajime.com> To: Koha <koha@lists.katipo.co.nz> Sent: Tuesday, 30 December, 2008 1:16:27 AM Subject: [Koha] Importing records
Howdy,
I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it.
With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books.
How do I do this in Koha?
So far, it appears that I can do this, but only one ISBN at a time?
Sorry, i only checked this e-mail now in a couple of days. But, but, ...., MarcEdit is supposed to run under Linux as well (though i haven't tried it yet). I guess it needs Mono, and i have no experience with that. i can understand that you don't want to put MS on the machine. i did not do that. I only walked over to my laptop (which is Windows) with the file that contain the book information, ran the client, and imported the search results text file into Koha. That might be worth the trouble. i haven't had a great deal of success searching for MARC records, but then, i haven't used a very smart approach yet. regards, krishnan ________________________________ From: John Wesley Simpson Hibbs <john@swajime.com> To: Koha <koha@lists.katipo.co.nz> Sent: Thursday, 1 January, 2009 6:11:23 AM Subject: Re: [Koha] Importing records Well, I've been having just as much trouble with installing MarcEdit ... :-( It needs .NET 2, and the install for .NET 2 is failing under WINE. I'd rather put every single record in by hand than put MS on one of my machines. -- john On Wed, 2008-12-31 at 15:49 +0530, Krishnan M wrote: Hello, Apologies for going back and responding to the original e-mail, but i just wanted to let John know there are tools that will do this for him (albeit in a two-step process). You can use a tool like the free MarcEdit that has a batch mode for searching Z39.50 servers given a list of authors/ISBN/titles, or even any custom field. You can then import the MARC records you get into Koha's reservoir. In fact, i created a video tutorial a few days back that illustrates how to do this for local people that asked me, but its still not upto scratch, so i haven't published it to the Wiki or other location yet. But if you are really interested, i can try and finish it off and send it to whatever audience is interested. All the other caveats from people on this thread still hold true. In other words, the quality of your catalog is as good as what you make it or what you allow into it. regards, krishnan Pune, India ________________________________ From:John Wesley Simpson <john@swajime.com> To:Koha <koha@lists.katipo.co.nz> Sent:Tuesday, 30 December, 2008 1:16:27 AM Subject:[Koha] Importing records Howdy, I've been using Readerware from http://www.readerware.com/ to maintain my library. I have just installed Koha, and am having difficulty understanding how to get my library loaded into it. With Readerware, I can load a list of ISBN's from a text file and have Readerware automatically fill in the rest of the data for the books. How do I do this in Koha? So far, it appears that I can do this, but only one ISBN at a time? Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
participants (8)
-
Chris Cormack -
Davoodifar, H. Sam (EDU-ECY) -
Jeffrey LePage -
Joe Atzberger -
John Wesley Simpson -
John Wesley Simpson Hibbs
-
Krishnan M -
Olugbenga Adara