Conver Koha 2.2.5 database to 3.2.2
Hello I am looking for a little direction/instruction. We currently have a very old Koha server (2.2.5) running on Ubuntu 6.06.1 LTS. I have built a new Ubuntu 14.04.4 LTS server and would like to install Koha there and import my databases from the old server. The version of Koha that I have installed is now 3.2.2 on this new server. How do I get the database information imported there to get the new server up and running? I tried following the instrcutions here but it did not work (http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html). When I upgrade the database schema everything seems to go well. When I run the reindex of Zebra everything seems to fail. When I then goto the intra login page I can sign in with any old credentials, and when I sign in with the new ones created during installation I see: Software error: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064. Any help would be appreciated. I'm new to Koha, just trying to get things up to date. -- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com.
*Can't sign in* i mean. -- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com.
On 18/02/16 08:16, jre18 wrote:
Hello I am looking for a little direction/instruction.
We currently have a very old Koha server (2.2.5) running on Ubuntu 6.06.1 LTS.
I have built a new Ubuntu 14.04.4 LTS server and would like to install Koha there and import my databases from the old server. The version of Koha that I have installed is now 3.2.2 on this new server.
How do I get the database information imported there to get the new server up and running?
I tried following the instrcutions here but it did not work (http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html).
When I upgrade the database schema everything seems to go well. When I run the reindex of Zebra everything seems to fail.
When I then goto the intra login page I can sign in with any old credentials, and when I sign in with the new ones created during installation I see:
Software error: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064.
Any help would be appreciated. I'm new to Koha, just trying to get things up to date. That's a big upgrade. You will get different opinions on this, but my advice is to export your bibliographic and patron data from the old koha and re-import the data to a new Koha (3.20 or 3.22). You might lose some historic data, but its often not valuable data anyway. You will need to amend your item records in a MARC editor - check the Koha to Marc Mapping for the Items table in your new Koha. I believe this will be much easier than going through the several stages required to achieve an upgrade.
Be sure to install your new Koha from the Debian packages. There are instructions for Ubuntu on the wiki. (You are much better advised to seek instruction from the Koha wiki and this list rather than stuff you find on the internet, which can rapidly become outdated. The Koha project moves very quickly.) My opinion. I hope it helps. Bob Birchall Calyx
I second Bob's opinion. Last month I migrated a 2.2.9 db to 3.20.x. Had to take that route. cheers, -idg On Thu, Feb 18, 2016 at 8:54 AM, Bob Birchall <bob@calyx.net.au> wrote:
On 18/02/16 08:16, jre18 wrote:
Hello I am looking for a little direction/instruction.
We currently have a very old Koha server (2.2.5) running on Ubuntu 6.06.1 LTS.
I have built a new Ubuntu 14.04.4 LTS server and would like to install Koha there and import my databases from the old server. The version of Koha that I have installed is now 3.2.2 on this new server.
How do I get the database information imported there to get the new server up and running?
I tried following the instrcutions here but it did not work (http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html).
When I upgrade the database schema everything seems to go well. When I run the reindex of Zebra everything seems to fail.
When I then goto the intra login page I can sign in with any old credentials, and when I sign in with the new ones created during installation I see:
Software error: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064.
Any help would be appreciated. I'm new to Koha, just trying to get things up to date.
That's a big upgrade. You will get different opinions on this, but my advice is to export your bibliographic and patron data from the old koha and re-import the data to a new Koha (3.20 or 3.22). You might lose some historic data, but its often not valuable data anyway. You will need to amend your item records in a MARC editor - check the Koha to Marc Mapping for the Items table in your new Koha. I believe this will be much easier than going through the several stages required to achieve an upgrade.
Be sure to install your new Koha from the Debian packages. There are instructions for Ubuntu on the wiki. (You are much better advised to seek instruction from the Koha wiki and this list rather than stuff you find on the internet, which can rapidly become outdated. The Koha project moves very quickly.)
My opinion. I hope it helps.
Bob Birchall Calyx _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
I give a third to that idea. I moved a 2.2 to 3.16 by trying to upgrade the database. It wasn't the prettiest thing to do and the results were so-so. On Thu, Feb 18, 2016 at 3:48 AM, Indranil Das Gupta <indradg@gmail.com> wrote:
I second Bob's opinion. Last month I migrated a 2.2.9 db to 3.20.x. Had to take that route.
cheers, -idg
On 18/02/16 08:16, jre18 wrote:
Hello I am looking for a little direction/instruction.
We currently have a very old Koha server (2.2.5) running on Ubuntu
6.06.1
LTS.
I have built a new Ubuntu 14.04.4 LTS server and would like to install Koha there and import my databases from the old server. The version of Koha that I have installed is now 3.2.2 on this new server.
How do I get the database information imported there to get the new server up and running?
I tried following the instrcutions here but it did not work ( http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html).
When I upgrade the database schema everything seems to go well. When I run the reindex of Zebra everything seems to fail.
When I then goto the intra login page I can sign in with any old credentials, and when I sign in with the new ones created during installation I see:
Software error: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064.
Any help would be appreciated. I'm new to Koha, just trying to get
On Thu, Feb 18, 2016 at 8:54 AM, Bob Birchall <bob@calyx.net.au> wrote: things
up to date.
That's a big upgrade. You will get different opinions on this, but my advice is to export your bibliographic and patron data from the old koha and re-import the data to a new Koha (3.20 or 3.22). You might lose some historic data, but its often not valuable data anyway. You will need to amend your item records in a MARC editor - check the Koha to Marc Mapping for the Items table in your new Koha. I believe this will be much easier than going through the several stages required to achieve an upgrade.
Be sure to install your new Koha from the Debian packages. There are instructions for Ubuntu on the wiki. (You are much better advised to seek instruction from the Koha wiki and this list rather than stuff you find on the internet, which can rapidly become outdated. The Koha project moves very quickly.)
My opinion. I hope it helps.
Bob Birchall Calyx _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Indranil Das Gupta
Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards.
For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson Director of Migrations ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>
Wow, it is good to hear these stories of positive MASSIVE upgrade scenarios in Koha. - that there are work-arounds with the data - that the new instances are responsive I personally need to investigate the Koha to MARC mapping more ( http://translate.koha-community.org/manual/3.20/en/html-desktop/#kohamarcmap... ). We're running 3.20 currently and hopefully will not have such a severe upgrade when we do. But still... Thank you for sharing. Happy Almost Friday! Jesse On Thu, Feb 18, 2016 at 9:58 AM, Joy Nelson <joy@bywatersolutions.com> wrote:
I give a third to that idea. I moved a 2.2 to 3.16 by trying to upgrade the database. It wasn't the prettiest thing to do and the results were so-so.
On Thu, Feb 18, 2016 at 3:48 AM, Indranil Das Gupta <indradg@gmail.com> wrote:
I second Bob's opinion. Last month I migrated a 2.2.9 db to 3.20.x. Had to take that route.
cheers, -idg
On 18/02/16 08:16, jre18 wrote:
Hello I am looking for a little direction/instruction.
We currently have a very old Koha server (2.2.5) running on Ubuntu
6.06.1
LTS.
I have built a new Ubuntu 14.04.4 LTS server and would like to install Koha there and import my databases from the old server. The version of Koha that I have installed is now 3.2.2 on this new server.
How do I get the database information imported there to get the new server up and running?
I tried following the instrcutions here but it did not work ( http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html ).
When I upgrade the database schema everything seems to go well. When I run the reindex of Zebra everything seems to fail.
When I then goto the intra login page I can sign in with any old credentials, and when I sign in with the new ones created during installation I see:
Software error: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064.
Any help would be appreciated. I'm new to Koha, just trying to get
On Thu, Feb 18, 2016 at 8:54 AM, Bob Birchall <bob@calyx.net.au> wrote: things
up to date.
That's a big upgrade. You will get different opinions on this, but my advice is to export your bibliographic and patron data from the old koha and re-import the data to a new Koha (3.20 or 3.22). You might lose some historic data, but its often not valuable data anyway. You will need to amend your item records in a MARC editor - check the Koha to Marc Mapping for the Items table in your new Koha. I believe this will be much easier than going through the several stages required to achieve an upgrade.
Be sure to install your new Koha from the Debian packages. There are instructions for Ubuntu on the wiki. (You are much better advised to seek instruction from the Koha wiki and this list rather than stuff you find on the internet, which can rapidly become outdated. The Koha project moves very quickly.)
My opinion. I hope it helps.
Bob Birchall Calyx _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Indranil Das Gupta
Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards.
For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Joy Nelson Director of Migrations
ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Office: Fort Worth, TX Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Jesse A Lambertson Librarian Sultan Qaboos Cultural Center <http://www.sqcc.org/> Ph: (202)-677-3967 x104 jlambertson@sqcc.org عالم الانجازات ينحاز دوماً مع المتفائلين
Ok so I went and talked to the librarian a bit. (I am not librarian, but the network/system administrator hence my being new to Koha). Correct me if I'm wrong here. I had the last process I sent a bit mixed up do to some misinformation. 1) Do the "MARC Biblio Export" on Koha 2.2.5 2) Open this file in the MARC Editor. 3) Update the "item" lines in this file to make sure they match the new MARC settings from the 3.2.2 server. 4) Import this file into the new Koha 3.2.2 5) Export the Borrowers table to csv 6) Import into new Koha 3.2.2 Does this sound correct? Anything I'm missing or thoughts on this? -- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com.
I *believe* I had to reset one of the borrowers fields after I imported my borrowers over to our new system....but the error was a simple sql fix, and the solution was posted on-line. On Thu, Feb 18, 2016 at 10:19 AM, jre18 <jre18@yahoo.com> wrote:
Ok so I went and talked to the librarian a bit. (I am not librarian, but the network/system administrator hence my being new to Koha).
Correct me if I'm wrong here. I had the last process I sent a bit mixed up do to some misinformation.
1) Do the "MARC Biblio Export" on Koha 2.2.5 2) Open this file in the MARC Editor. 3) Update the "item" lines in this file to make sure they match the new MARC settings from the 3.2.2 server. 4) Import this file into the new Koha 3.2.2 5) Export the Borrowers table to csv 6) Import into new Koha 3.2.2
Does this sound correct? Anything I'm missing or thoughts on this?
-- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
I was able to get all the borrowers imported successfully. I had to setup the library making sure the branch code matched the old system. I also had to setup all the patron codes to match the old system and then the import went without issue. -- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com.
Maybe check your "borrowers debarred" .... IIRC this was what threw me an error. it needs to be "NULL" and not a "0000-00-00" date format. On Thu, Feb 18, 2016 at 11:14 AM, jre18 <jre18@yahoo.com> wrote:
I was able to get all the borrowers imported successfully.
I had to setup the library making sure the branch code matched the old system.
I also had to setup all the patron codes to match the old system and then the import went without issue.
-- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Alright. So the beginning of success. 1) successfully exported/imported all of the patrons. 2) the librarian just finished exporting, updating, cleaning the first of several MARC databases. Imported it and was successfully able to query items from it! The rest of the databases are probably going to take several days to get through. So I'll update when that is complete. I've been reading that I should also export/import the accountlines and issues tables. Are there any others I should consider doing? Will do those once the MARC databases are all imported. Thanks all for your help so far! I'll post a follow up when I'm done of how we made out and include the procedure we followed in case anyone else stumbles across this post in a similar predicament to us. (Apparently the librarian had built a new koha sever but had been manually trying to rebuild the databases. She's been at it for a couple years apparently so she is very happy now)
On Feb 18, 2016, at 12:01 PM, Scott Owen [via Koha] <ml-node+s1045719n5875127h17@n5.nabble.com> wrote:
Maybe check your "borrowers debarred" .... IIRC this was what threw me an error.
it needs to be "NULL" and not a "0000-00-00" date format.
On Thu, Feb 18, 2016 at 11:14 AM, jre18 <[hidden email]> wrote:
I was able to get all the borrowers imported successfully.
I had to setup the library making sure the branch code matched the old system.
I also had to setup all the patron codes to match the old system and then the import went without issue.
-- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org [hidden email] https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org [hidden email] https://lists.katipo.co.nz/mailman/listinfo/koha
If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... To unsubscribe from Conver Koha 2.2.5 database to 3.2.2, click here. NAML
-- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com.
On 19/02/16 10:33, jre18 wrote:
snip
I've been reading that I should also export/import the accountlines and issues tables. Are there any others I should consider doing? Will do those once the MARC databases are all imported. accountlines contains the fees and payments history. If you charge fines or other fees and there are any number outstanding, then yes, importing this table could help you. Perhaps pick a truncation date? You may need to map to your old borrowernumbers assuming they changed in your transfer.
issues holds the items currently on loan. How many are there? The reading history is in the oldissues table. Does your librarian want to preserve that? You might check here for other stuff you may wish to keep (if anything): http://schema.koha-community.org/ Bob Calyx
Thanks for the response guys! It is appreciated. I hope I can pick your brains just a bit more. I have a couple follow up questions (or if you know a wiki that would just answer these questions for me that would be great). I have koha installed by following these instructions. https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages I have run through the web install and now it is up and running. For the rest of the process (just to clarify for my own sanity after staring at this stuff for a few days). 1) On the old Koha server (2.2.5) login to administration and do the "MARC biblio export" 2) Open this in a MARC editor and update the MARC tags (or do i just need to do this for items?) 3) Import this into the Koha (3.2.2) 4) Export Patrons. I dont see a way to do this in the administration page. I assume I will need to run a sql command to dump the borrowers table to CSV or mysqldump of the table? If you know a better way please let me know. 5) Do the same as 4 for the items and itemtype table? You mention amending my item record in a Marc editor, so i feel like i'm missing something here. Any other tables i should consider moving over? Any commands i need to run after doing this or simply reboot the server for good measure? -- View this message in context: http://koha.1045719.n5.nabble.com/Conver-Koha-2-2-5-database-to-3-2-2-tp5875... Sent from the Koha-general mailing list archive at Nabble.com.
participants (6)
-
Bob Birchall -
Indranil Das Gupta -
Jesse Lambertson -
Joy Nelson -
jre18 -
Scott Owen