Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[Bob Birchall]

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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[Scott Owen]

Maybe check your "borrowers debarred"  IIRC this was what threw me an
error.

it needs to be "NULL" and not a "-00-00" date format.






On Thu, Feb 18, 2016 at 11:14 AM, jre18  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-tp5875022p5875114.html
> 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
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[jre18]

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-tp5875022p5875114.html
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

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[Jesse Lambertson]

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/#kohamarcmapping
).
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 
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 
> 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 Thu, Feb 18, 2016 at 8:54 AM, Bob Birchall  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
> > ___
> > 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 
> Support and Consulting for Open Source Software
> Office: Fort Worth, TX
> Phone/Fax (888)900-8944
> 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 
Ph: (202)-677-3967 x104
jlambert...@sqcc.org
عالم الانجازات ينحاز دوماً مع المتفائلين
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[jre18]

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-tp5875022p5875110.html
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

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[Joy Nelson]

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 
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 Thu, Feb 18, 2016 at 8:54 AM, Bob Birchall  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
> ___
> 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 
Support and Consulting for Open Source Software
Office: Fort Worth, TX
Phone/Fax (888)900-8944
What is Koha? 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[Indranil Das Gupta]

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  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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[Bob Birchall]

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

Re: [Koha] Conver Koha 2.2.5 database to 3.2.2

[jre18]

*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-tp5875022p5875023.html
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

[Koha] Conver Koha 2.2.5 database to 3.2.2

[jre18]

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-tp5875022.html
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