Re: [Koha] Data migration: importing of anonymous checkout history

023 6:02 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Data migration: importing of anonymous checkout history Hi Igor, it depends a bit, you can either leave the borrowernumber with NULL or you can use the AnonymousPatrons's borrowernumber. old_issues and statistics are the tables yo

Re: [Koha] Data migration: importing of anonymous checkout history

Hello! Thank you for the answer! I will experiment. -Original Message- From: Koha On Behalf Of Katrin Fischer Sent: Saturday, July 8, 2023 6:02 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Data migration: importing of anonymous checkout history Hi Igor, it depends a bit, you can

Re: [Koha] Data migration: importing of anonymous checkout history

Hi Igor, it depends a bit, you can either leave the borrowernumber with NULL or you can use the AnonymousPatrons's borrowernumber. old_issues and statistics are the tables you might want to look at. Hope this helps, Katrin On 06.07.23 08:20, Сычев Игорь Алексеевич wrote: Hello! I have a

[Koha] Data migration: importing of anonymous checkout history

Hello! I have a checkout history over the past years. But some of the patrons have already been deleted. What do I need to do to import anonymizing the checkout history? In other words, if there is a user, then the story is personalized, if there is no user, then the story is impersonal. Good

Re: [Koha] Data migration from SOUL 1 to Koha (Overdue List)

Dixson, The answer to that depends on what you are trying to achieve - (a) just get the currently checked out items into Koha's issues table or (b) "a" + generate account lines entries for outstanding fines as well. No direct scripts per se is bundled with Koha. But using a .koc file is an

Re: [Koha] Data migration from SOUL 1 to Koha

Thanks Regards,Dixson On Mon, 2019-06-03 at 19:56 +0530, Indranil Das Gupta wrote: > Hi Dixson, > Based on last several years of experience of migrating plenty of both > SOUL v1 and v2 data to Koha, I would suggest that the cleanest way to > do it is to use the SQL Server database of SOUL v1 to

Re: [Koha] Data migration from SOUL 1 to Koha

Hi Dixson, Based on last several years of experience of migrating plenty of both SOUL v1 and v2 data to Koha, I would suggest that the cleanest way to do it is to use the SQL Server database of SOUL v1 to extract the data a table at a time, clean it up, then use joins to create the actual data

Re: [Koha] Data migration from SOUL 1 to Koha

Hi Dixson > Is there any option to export the data from SOUL 1 to Koha ? How to > export bulk CCF format data from soul 1. I haven't ever migrated any data from SOUL to Koha. But maybe the following link is useful to you:

[Koha] Data migration from SOUL 1 to Koha

Hi, Is there any option to export the data from SOUL 1 to Koha ? How to export bulk CCF format data from soul 1. Regards, Dixson ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] DATA MIGRATION

Hi Great ones, Thanks to each and every one of you for your immense contribution. DATABASE MIGRATION ISSUES RESOLVED. Murphy Igbudu Systems Librarian Benue State University Library & Information Services Makurdi, Benue State. Nigeria. On Wed, Nov 21, 2018 at 1:37 PM Eric Bégin wrote: >

Re: [Koha] DATA MIGRATION

Murphy, Have you tried with mysql instead mysqldump ? mysql -uroot -p koha_library < koha_library.sql Cheers ! ⁣Eric Bégin Solutions inLibro inc.​ Le 21 nov. 2018 à 05:18, à 05:18, Igbudu Tersoo a écrit: >Hi Great Ones, >Had a problem with my old koha server machine. i have currently

Re: [Koha] DATA MIGRATION

Hello, You may please refer here for proper operations http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website:

[Koha] DATA MIGRATION

Hi Great Ones, Had a problem with my old koha server machine. i have currently installed koha 18.04 with mysql 5.7 database on ubuntu 18.11. on the old server machine, koha 17.11 with mariadb database was running on ubuntu 16.11. now i have a backup of the old server and i used this command

Re: [Koha] Koha Data Migration and cover Image

Hi, Right now I'm not able to find out the document where I read about the tentative date of Q1 2018. It came up during one of the post on the PCC. activities. What I can share right now is - http://alcts.ala.org/ccdablog/wp-content/uploads/2017/06/PCC-2017-06.pdf See the section "The PCC is

Re: [Koha] Koha Data Migration and cover Image

Chinmoy: If you want a feature to come in into Koha the first step is to file a bug report in the Koha bugzilla - https://bugs.koha-community.org/bugzilla3/ Most features make it into Koha because some user institution somewhere is funding the development of the feature. Development does not

Re: [Koha] Koha Data Migration and cover Image

On 2017-09-14 04:09 AM, Indranil Das Gupta wrote: /snip/ Come Q1 2018 there is expected to start a pilot program to remove punctuation from MARC records Could you please give some references to this? I'll be happy to believe that it's a "good thing", but it sounds more like a catastrophe

Re: [Koha] Koha Data Migration and cover Image

Thanks a lot. "Betterment" word which I use to say my suggestions may be included in next version. Koha developers from various countries all over the world always do the job sincerely thats why we get 17.05 version from 1.00 version. But at the time of beginning of koha all the features of 17.05

Re: [Koha] Koha Data Migration and cover Image

Hi Chinmoy, On Thu, Sep 14, 2017 at 11:41 AM, Chinmoy wrote: > 1. How to migrate data from koha to excel format marc tagwise like 020a, > 020c, 041a, 082a,082b, 100, 245a, 245b, 245c, 250, 260a,260b, 260c, > 300a,440a, 500a, 650a, 700a,700b,700c,700d,700-4,942c etc.

[Koha] Koha Data Migration and cover Image

1. How to migrate data from koha to excel format marc tagwise like 020a, 020c, 041a, 082a,082b, 100, 245a, 245b, 245c, 250, 260a,260b, 260c, 300a,440a, 500a, 650a, 700a,700b,700c,700d,700-4,942c etc. 2. If a book not available in www.amazon.com but available in Amazon India(www.amazon.in) then

Re: [Koha] Data Migration from OLD koha 3.11 to new Koha 16.05

Hello Anuj, First of all, I don't think you want/need to uninstall Koha, but if you must, as per the documentation: 1) sudo koha-remove 2) apt-get remove koha-common On the issue at hand, would you please provide additional information? 1) After you run the upgradedatabase.pl script does the

[Koha] Data Migration from OLD koha 3.11 to new Koha 16.05

Sir, I have two queries:- 1) How to* transfer old data from koha 3.11 version to new Koha 16.05 version*, Sir I tried a lot but couldn't succeed. Please Help me. 2) How to completely *uninstall koha*. Sir, It is a request please don't give me links of websites, I already done that and

Re: [Koha] Data MIgration from NewGenLib to Koha

koha-common in Ubuntu 14.04 On Monday, 27 July 2015 2:59 PM, vikram zadgaonkar vikramczadgaon...@gmail.com wrote: Which koha ver., you are using? Vikram Zadgaonkar On Mon, Jul 27, 2015 at 2:54 PM, Balaji Ravichandran rbalajichen...@yahoo.com wrote: I need to transfer the Database

Re: [Koha] Data MIgration from NewGenLib to Koha

I need to transfer the Database in NewGenLib to Koha... A kind of import from NewGenLib to Koha.. Is there any possible way? On Monday, 27 July 2015 2:06 PM, vikram zadgaonkar vikramczadgaon...@gmail.com wrote: Hi Balaji, What help you are looking? Vikram Zadgaonkar On Sun, Jul

Re: [Koha] Data MIgration from NewGenLib to Koha

Hi Balaji, What help you are looking? Vikram Zadgaonkar On Sun, Jul 26, 2015 at 7:10 PM, Balaji Ravichandran rbalajichen...@yahoo.com wrote: Hi all,I am currently having a database associated with NewGenLib and I need it to migrate to a Koha association that I have now in my Ubuntu 15.04

[Koha] Data MIgration from NewGenLib to Koha

Hi all,I am currently having a database associated with NewGenLib and I need it to migrate to a Koha association that I have now in my Ubuntu 15.04 system.Is there any way of doing it ? Can anyone help on it? ___ Koha mailing list

[Koha] Data Migration from Alice for Windows to Koha

Recently I have installed Koha 3.18 in our Library. Previously we were using Alice for windows. Kindly guide me how can I migrate data from Alice for windows to Koha. I even tried using the Export to MARC option in Alice utility and selected various options available there such as MARC 21 Dewey

Re: [Koha] Data Migration from Alice for Windows to Koha

Greetings, I don't know, but here is my guess. Those two file formats (.dat or .rtf) probably could be renamed as .mrc or .mrk. If you open those files in wordpad and see something like: --- BEGIN SNIPPET --- =020 \\$a971-508-125-8 =100 1\$aVirgilio S. Almario$eauthor =245 10$aIbong

[Koha] Data Migration Libsys to koha

We have done successfully at BITS-Goa data migration from libsys to koha *without* manual data re-entry, using awk scripting combined with MARCEdit ( http://marcedit.reeset.net/), all on GNU/Linux mainly. Please send us some of the printable reports generated by your libsys (in the original form)

Re: [Koha] Data Migration Libsys to koha

@lists.katipo.co.nz Subject: [Koha] Data Migration Libsys to koha We have done successfully at BITS-Goa data migration from libsys to koha *without* manual data re-entry, using awk scripting combined with MARCEdit ( http://marcedit.reeset.net/), all on GNU/Linux mainly. Please send us some

Re: [Koha] Data Migration, TLC to Koha

MJ Ray schreef op vr 01-08-2014 om 07:45 [+0200]: I'd suggest that more records in the collection increases the chance of something strange or undocumented that causes problems in one record, which is one reason why migration quotes increase with collection size. In my experience, it seems to

Re: [Koha] Data Migration, TLC to Koha

On 1 August 2014 07:21:57 CEST, Chris Cormack chr...@catalyst.net.nz wrote: Collection size is actually pretty immaterial to how long a migration will take. Getting the data out in a good format is the hardest but and whether it's 1000 or 10 it takes about the same time. I'd suggest that more

[Koha] Data Migration, TLC to Koha

Hi everyone, I am new to the list here.  I am an electronic resources librarian at an independent public library in Florida.  We are interested in migrating from our current self-hosted TLC system to Koha.  Quotes we have received from vendors are higher than we had hoped, mainly because of

Re: [Koha] Data Migration, TLC to Koha

Hello, Yes you can convert your own data into marc format there are various methods to do that, If you can generate reports in Marc/iso/excel formats etc. from existing software than it can be converted. Please see the link below, if you don't mind may i know how much they quote and your data

Re: [Koha] Data Migration, TLC to Koha

On 1 August 2014 4:16:02 pm NZST, Vinod Kumar Mishra vinod_librar...@rediffmail.com wrote: Hello, Yes you can convert your own data into marc format there are various methods to do that, If you can generate reports in Marc/iso/excel formats etc. from existing software than it can be

[Koha] Data Migration from Millennium to Koha

Hi all, Is there anyone who can point me in the right direction. We are looking to replace our MillenniumILS with Koha. The main issue is removing our records from Millennium and importing them into Koha. Is there a company that can offer us this service? Thank you in advance. -- Nasiru

Re: [Koha] Data Migration from Millennium to Koha

Hello, Is there any provision to export data in MARC/ISO formats or can you take your data in Excel format if yes then it is possible. However, another methods are also their through the reports generated by ILMS. http://manual.koha-community.org/3.2/en/marceditexcel.html On Mon, 18 Nov 2013

Re: [Koha] Data Migration (Dennis Njuguna)

) -- Message: 1 Date: Wed, 24 Oct 2012 12:17:39 +0300 From: Dennis Njuguna cknjug...@gmail.com To: Mohamed zalabany mh_zalab...@hotmail.com Cc: koha list koha@lists.katipo.co.nz,manny_tama...@sil.org manny_tama...@sil.org Subject: Re: [Koha] Data Migration Message-ID

Re: [Koha] Data Migration

: Re: [Koha] Data Migration From: cknjug...@gmail.com To: mh_zalab...@hotmail.com CC: manny_tama...@sil.org; koha@lists.katipo.co.nz Hello Mohamed what about data migration from mandarin M3 especially the holdings? On Tue, Oct 23, 2012 at 2:51 PM, Mohamed zalabany mh_zalab...@hotmail.com

Re: [Koha] Data Migration

+0300 Subject: Re: [Koha] Data Migration From: cknjug...@gmail.com To: mh_zalab...@hotmail.com CC: manny_tama...@sil.org; koha@lists.katipo.co.nz it is marc compliant, but when I take it to marcedit i view the file but I cannot see/view the barcode, if I import the marc into koha I can only import

Re: [Koha] Data Migration (Dennis Njuguna)

mh_zalab...@hotmail.com Cc: koha list koha@lists.katipo.co.nz,manny_tama...@sil.org manny_tama...@sil.org Subject: Re: [Koha] Data Migration Message-ID: cah0m1x-abcrevvzfvol9oj4ne7nmd0o4-uytqtua0lfgxyo...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 it is marc

Re: [Koha] Data Migration

and Information systems Development and support mh_zalab...@hotmail.com Mobile: 202-0111291444 From: manny_tama...@sil.org To: koha@lists.katipo.co.nz Date: Tue, 23 Oct 2012 10:21:40 +0800 Subject: [Koha] Data Migration Good day to all, I'm Manny from Manila and in the process

Re: [Koha] Data Migration

To: koha@lists.katipo.co.nz Date: Tue, 23 Oct 2012 10:21:40 +0800 Subject: [Koha] Data Migration Good day to all, I'm Manny from Manila and in the process of data migration of the library from MAELISA to KOHA. Is there anyone who had done this process or has a script that may

Re: [Koha] Data Migration

information Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalab...@hotmail.com Mobile: 0111291444 Date: Tue, 23 Oct 2012 17:08:09 +0300 Subject: Re: [Koha] Data Migration From: cknjug

Re: [Koha] Millenium to Koha Data Migration

Annalise, I've had occasion to do a number of Millennium to Koha migrations; Millennium is one of the harder systems to migrate, particularly if you try to deal with acquisitions and serials. If you're doing biblios, items, borrowers, current checkouts, holds, and fines, that's not too terribly

Re: [Koha] data migration from libsys to koha~

@gmail.com To: amit bondwal bondwal.a...@gmail.com Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] data migration from libsys to koha Message-ID: CALkr8=Ke3HpmumCtW7LzOstgu1DeUhK4=ohuiqgozrw7ju-...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 Dear Amit sorry no idea for data

[Koha] Data Migration

I intend to migrate data from Koha 3.02.05.000 to Koha 3.8. The data is on machine running Ubuntu 10.10 (Koha3.2) and data will be migrated to machine running Debian Squeeze (Koha 3.8). I am requesting the Koha community to point me in the right direction on how to accomplish this mammoth task. A

Re: [Koha] Data Migration from Koha 2.2.9 to 3.6

Hi Felix, Recently I did a migration from 2.2 to 3.4. My experience had been to make a new installation of Koha and then make an import/export of data from the old the new installation. In this way I made some multiple correction to the marc records using MarcEdit and put clear data on the

[Koha] Data Migration from Koha 2.2.9 to 3.6

I have been using KOHA 2.2.9 (windows). However, I am determined to install 3.6 on Linux. Is it posible to migrate data to this new version. Thats my major concern. Please help. -- Felix Chisoni (College Librarian) St Luke's College of Nursing Midwifery P. O. Box, 21 Chilema Zomba Cell

Re: [Koha] data migration from libsys to koha

Hi Fabio, Thank you very much for all these information. I will contact you back after testing these things. Regards Amit Bondwal T On Sat, May 5, 2012 at 12:15 AM, Fabio T. [via Koha] ml-node+s1045719n5686681...@n5.nabble.com wrote: Amit, which are the source and destination formats

Re: [Koha] data migration from libsys to koha

You are welcome. Fabio 2012/5/5 amit bondwal bondwal.a...@gmail.com Hi Fabio, Thank you very much for all these information. I will contact you back after testing these things. Regards Amit Bondwal T On Sat, May 5, 2012 at 12:15 AM, Fabio T. [via Koha]

Re: [Koha] data migration from libsys to koha

Amit, which are the source and destination formats involved in the migration? MARC21? UNIMARC? Other? What kind of items? Books, serials...? MARCedit ( http://people.oregonstate.edu/~reeset/marcedit/html/index.php ) is a nice tool for editing MARC records. You can arrange your records there in

Re: [Koha] data migration from libsys to koha

Dear Amit sorry no idea for data migration. On Tue, Apr 24, 2012 at 1:07 PM, amit bondwal bondwal.a...@gmail.comwrote: Dear All, I want to data migration from libsys to koha, My current state is that I took backup from libsys in iso format and convert it in .mrk files. Now my problem is

[Koha] data migration from libsys to koha

Dear All, I want to data migration from libsys to koha, My current state is that I took backup from libsys in iso format and convert it in .mrk files. Now my problem is that it shows tag numbers like 999 964 etc. When I tried to import .mrc files in koha by script bulkmarcimport in

Re: [Koha] Data Migration

Bob,MarcEdit make mistakes when doing MARC records with repeatable fields:Instead of:700 $aName700 $aName2It does:700 $aName$aName2To solve this problem I made:700 $aName701 $aName2After this, I opened the notepad and replaced all 701 by 700... I made this for all fields with this

Re: [Koha] Data Migration

On 15/12/11 18:29, Zewar Khan wrote: Dear Colleagues, I am using Koha 341(Fedora) on trail bases and planning to import my Access data to koha with the help of MarcEdit. I have mapped all data except the repeatable fields such as Keywords etc. I wonder if any one can help me how a

[Koha] Data Migration

Dear Colleagues, I am using Koha 341(Fedora) on trail bases and planning to import my Access data to koha with the help of MarcEdit. I have mapped  all  data except the repeatable fields such as Keywords etc. I wonder if  any one can help me how a repeatable field is mapped using MarcEdit

Re: [Koha] Data Migration Issues...

Hi, The concatenation as suggested by you works while importing data into Koha and it generates only one item. In the initial marc file there are different entries for 952 sub fields. I edited the marc file using marc editor and concatenated the 952 subfields as one line

Re: [Koha] Data Migration Issues...

On 27/06/11 21:04, R Sunil Kumar wrote: Dear All, During migration all data is successfully migrated MARC Tag from 020$ to 830 but all errors. 942$c (BK- defined in the Item type - Basic Parameter - Administration) 952$a (OSL - Defined in the Library, Branches, Group - Basic Parameter -

Re: [Koha] Data Migration from Excel to Koha

Hi Vimal, Thanks. Can you please help me with the following? 1. May I know how to make sure the books imported use MARC Books frame work and not MARC default frame work. Today when I import it uses MARC default framework. 2. Call number: How to fill this in your excel sheet? 853 NEH and 823

[Koha] Data Migration from Excel to Koha

Dear All, Can anybody please send me the step by step process of data migration from Excel to Koha. I have already installed and downloaded the MARCEdit 5.5, but during the process of uploading the MARC format database, it says books not available in the library. Please advice.

Re: [Koha] Data Migration from Excel to Koha

Hi! Have you seen the chapter about Importing Excel data into Koha? http://koha-community.org/documentation/3-4-manual-en/?ch=x15374 Best regards, Magnus Enger libriotech.no 2011/6/1 R Sunil Kumar sunil.ku...@ecoleglobal.com Dear All, Can anybody please send me the step by step process of

Re: [Koha] Data Migration from Excel to Koha

2011/6/1 R Sunil Kumar sunil.ku...@ecoleglobal.com Dear All, Can anybody please send me the step by step process of data migration from Excel to Koha. I have already installed and downloaded the MARCEdit 5.5, but during the process of uploading the MARC format database, it says books not

Re: [Koha] Data Migration from Excel to Koha

Hi, For the data to arrange in excel sheet and to have proper mapping to MARC fileds, does Home - Administration - Koha to MARC mapping is the way to refer? I mean, for mapping fields of excel sheet to that of MARC21 fields (using MarcEdit Delimited Text Translator). Vimal: Then your excel