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] koha opac customization urgent

[Eric Bégin]

Thilanka,
Can you provide us with an URL to look at ?

Eric BéginSolutions inLibro inc.

 Message d'origine 
De : Thilanka Gunasena  
Date : 18/02/2016  02:59  (GMT-05:00) 
À : koha@lists.katipo.co.nz 
Objet : [Koha] koha opac customization urgent 

Dear all,

When  I add a image to opac home page( login page)   and it is displaying but 
when I log in  and log out  opac logout page image is not displayed. Please 
help me

Regards,
Thilanka Gunasena
SLT TRPL



This message is intended only for the use of the individual or entity to which 
it is addressed and may contain information that is confidential and/or 
privileged. If you are not the intended recipient please delete the original 
message and any copy of it from your computer system. You are hereby notified 
that any dissemination, distribution or copying of this communication is 
strictly prohibited unless proper authorization has been obtained for such 
action. If you have received this communication in error, please notify the 
sender immediately. Although SLT attempts to sweep e-mail and attachments for 
viruses, it does not guarantee that both are virus-free and accepts no 
liability for any damage sustained as a result of viruses.
___
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

[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

[Koha] koha opac customization urgent

[Thilanka Gunasena]

Dear all,

When  I add a image to opac home page( login page)   and it is displaying but 
when I log in  and log out  opac logout page image is not displayed. Please 
help me

Regards,
Thilanka Gunasena
SLT TRPL



This message is intended only for the use of the individual or entity to which 
it is addressed and may contain information that is confidential and/or 
privileged. If you are not the intended recipient please delete the original 
message and any copy of it from your computer system. You are hereby notified 
that any dissemination, distribution or copying of this communication is 
strictly prohibited unless proper authorization has been obtained for such 
action. If you have received this communication in error, please notify the 
sender immediately. Although SLT attempts to sweep e-mail and attachments for 
viruses, it does not guarantee that both are virus-free and accepts no 
liability for any damage sustained as a result of viruses.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha