date:20200514

Re: [Koha] invalid marcxml

2020-05-14 Thread tuxflow.de


Ah, wonderful, very nice. Do existing entries need to be repaired?

Or is there a converter? Thanks for the info!

Am 14.05.20 um 13:28 schrieb Marcel de Rooy:

Please have a look at bug 21708.

Op do 14 mei 2020 om 12:52 schreef :


Hi Joy,

there is no direct error message from Koha, the error is only in the
data structure. We only noticed this error because we're sending the
data to a company so that it can be entered into the Discovery Service
(search engine). This company pointed us to the wrong data structure. We
need the corrected data to fully set up the Discovery Service.

Koha-Version:   18.11.04.000

greetings,
tunix

Am 13.05.20 um 19:41 schrieb Joy Nelson:

Hello-
Can you elaborate a bit more on this?  Is the order of the tags causing
errors in Koha?  Or is it just 'wrong' per the standard?

I am unable to recreate the order you show in your example via the basic
editor or the advanced cataloging editor.  Can you explain what your
process is that creates this order?  Also what version of Koha are you
using currently?

Thanks
joy


On Wed, May 13, 2020 at 10:25 AM  wrote:


We have a problem with our MARCXML data in KOHA. The order of the fields
must be changed for many records. The problem affects all records that
are newly created or changed by us. All  elements must appear
after the  elements. So far the  element with
the unique ID of the record (MARC field 999 $c) is placed before the
 elements. The wrong order violates the MARCXML

guidelines.



before editing:

00996xxx x22002417x 4200
23330
DE-1278
t|
161220s2002 xxu|  00| 0 ger
d

3-89012-956-0
51,00 


after editing:

01059xxx x2200265x 4200

9911
9911

23330
DE-1278
20190604142304.0
t|
161220s2002 xxu|  00| 0 ger
d

3-89012-956-0
51,00 

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha






--
tuxflow.de, das andere Hosting!
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha





___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

2020-05-14 Thread tuxflow.de


oh wrong thread, sorry

Am 14.05.20 um 18:07 schrieb tu...@tuxflow.de:

Ah, wonderful, very nice. Do existing entries need to be repaired?

Or is there a converter? Thanks for the info!

Am 14.05.20 um 16:16 schrieb Quỳnh Vũ Đỗ:

Hello everyone

Our library has been using a Vietnamized version of Koha 3.18 since mid
2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has 
been
made since and the server had a hardware problem (mainboard) last 
February.


We have a mysqldump of the Koha database (size about 1,8 GB).

So what we are trying to do is to install the latest Koha version (19.11)
on a fresh Ubuntu 16.04.6 LTS (Desktop) and then to replenish the empty
Koha tables through SQL inserts in the tables using sql exports of the
related fields from the old database. For that we have been comparing the
structure of the tables of Koha 3.18 and 19.11 with the tool provided at
http://schema.koha-community.org/

Can this way of proceeding, although tedious it might be, be 
successful or

not ?
If not, could someone have suggestions ?
Thanks for your attention.
Quynh
=
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha



___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


--
tuxflow.de, das andere Hosting!
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

2020-05-14 Thread tunix


Ah, wonderful, very nice. Do existing entries need to be repaired?

Or is there a converter? Thanks for the info!

Am 14.05.20 um 16:16 schrieb Quỳnh Vũ Đỗ:

Hello everyone

Our library has been using a Vietnamized version of Koha 3.18 since mid
2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been
made since and the server had a hardware problem (mainboard) last February.

We have a mysqldump of the Koha database (size about 1,8 GB).

So what we are trying to do is to install the latest Koha version (19.11)
on a fresh Ubuntu 16.04.6 LTS (Desktop) and then to replenish the empty
Koha tables through SQL inserts in the tables using sql exports of the
related fields from the old database. For that we have been comparing the
structure of the tables of Koha 3.18 and 19.11 with the tool provided at
http://schema.koha-community.org/

Can this way of proceeding, although tedious it might be, be successful or
not ?
If not, could someone have suggestions ?
Thanks for your attention.
Quynh
=
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha



___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] invalid marcxml

2020-05-14 Thread tunix


Hi Joy,

there is no direct error message from Koha, the error is only in the 
data structure. We only noticed this error because we're sending the 
data to a company so that it can be entered into the Discovery Service 
(search engine). This company pointed us to the wrong data structure. We 
need the corrected data to fully set up the Discovery Service.


Koha-Version:   18.11.04.000

greetings,
tunix

Am 13.05.20 um 19:41 schrieb Joy Nelson:

Hello-
Can you elaborate a bit more on this?  Is the order of the tags causing
errors in Koha?  Or is it just 'wrong' per the standard?

I am unable to recreate the order you show in your example via the basic
editor or the advanced cataloging editor.  Can you explain what your
process is that creates this order?  Also what version of Koha are you
using currently?

Thanks
joy


On Wed, May 13, 2020 at 10:25 AM  wrote:


We have a problem with our MARCXML data in KOHA. The order of the fields
must be changed for many records. The problem affects all records that
are newly created or changed by us. All  elements must appear
after the  elements. So far the  element with
the unique ID of the record (MARC field 999 $c) is placed before the
 elements. The wrong order violates the MARCXML guidelines.


before editing:

00996xxx x22002417x 4200
23330
DE-1278
t|
161220s2002 xxu|  00| 0 ger
d

3-89012-956-0
51,00 


after editing:

01059xxx x2200265x 4200

9911
9911

23330
DE-1278
20190604142304.0
t|
161220s2002 xxu|  00| 0 ger
d

3-89012-956-0
51,00 

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha






--
tuxflow.de, das andere Hosting!
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

2020-05-14 Thread Philippe Blouin


I would not do such partial loading, it won't work.

You're much better just loading the whole dump, replacing whatever 
default database your 19.11 installation created.


Then manually run updatedatabase.pl or even simpler, follow the 
instructions when connecting to Koha, it'll run the update from the UI.


This will be very fast.

Regards,

Philippe Blouin,
Directeur de la technologie

Tél.  : (833) 465-4276, poste 230
philippe.blo...@inlibro.com 

inLibro | pour esprit libre | www.inLibro.com 
On 2020-05-14 10:16 a.m., Quỳnh Vũ Đỗ wrote:

Hello everyone

Our library has been using a Vietnamized version of Koha 3.18 since mid
2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been
made since and the server had a hardware problem (mainboard) last February.

We have a mysqldump of the Koha database (size about 1,8 GB).

So what we are trying to do is to install the latest Koha version (19.11)
on a fresh Ubuntu 16.04.6 LTS (Desktop) and then to replenish the empty
Koha tables through SQL inserts in the tables using sql exports of the
related fields from the old database. For that we have been comparing the
structure of the tables of Koha 3.18 and 19.11 with the tool provided at
http://schema.koha-community.org/

Can this way of proceeding, although tedious it might be, be successful or
not ?
If not, could someone have suggestions ?
Thanks for your attention.
Quynh
=
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Call for news: April 2020 Koha Newsletter

2020-05-14 Thread Koha Newsletter

I'm collecting news for the April newsletter. Send anything noteworthy to:

k o h a news AT gmail dot com

News criteria:
---

** For events **:
  - Please include dates for past events. If I can't find dates I may not add 
it.
  - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon
  - For past events ,  one month back is the cut-off .

* News items can be of any length.
* Images are fine
* Anything and everything Koha.
* Submit by the 26th of the month.

If you are working on an interesting project or development related to
Koha, please let me know and I'll include it in the development section.

Thank you!

-- 
Chad Roseburg
Editor, Koha Community Newsletter
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

2020-05-14 Thread Jonathan Druart

How lucky you are to have gotten this hardware problem, you will have
the lastest Koha version :)

You only need to reinstall the system, install Koha using the debian
packages, drop and recreate the DB, inject your dump into the empty
DB.
Restart the koha-common service, hit the intranet page and you will
get through the upgrade process.

Please don't do anything else than that, you don't need do! :)
Enjoy

Le jeu. 14 mai 2020 à 16:16, Quỳnh Vũ Đỗ  a écrit :
>
> Hello everyone
>
> Our library has been using a Vietnamized version of Koha 3.18 since mid
> 2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been
> made since and the server had a hardware problem (mainboard) last February.
>
> We have a mysqldump of the Koha database (size about 1,8 GB).
>
> So what we are trying to do is to install the latest Koha version (19.11)
> on a fresh Ubuntu 16.04.6 LTS (Desktop) and then to replenish the empty
> Koha tables through SQL inserts in the tables using sql exports of the
> related fields from the old database. For that we have been comparing the
> structure of the tables of Koha 3.18 and 19.11 with the tool provided at
> http://schema.koha-community.org/
>
> Can this way of proceeding, although tedious it might be, be successful or
> not ?
> If not, could someone have suggestions ?
> Thanks for your attention.
> Quynh
> =
> M. Vũ Đỗ Quỳnh (Ph.D)
> Trường Đại học Thăng Long - Université de Thang Long - Thang Long
> University (Hanoi, Vietnam)
> Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
> internationale - Vice-Rector in charge of International Cooperation
> Web: http://thanglong.edu.vn/
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Migrating Koha database from version 3.18 to 19.11?

2020-05-14 Thread Quỳnh Vũ Đỗ

Hello everyone

Our library has been using a Vietnamized version of Koha 3.18 since mid
2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been
made since and the server had a hardware problem (mainboard) last February.

We have a mysqldump of the Koha database (size about 1,8 GB).

So what we are trying to do is to install the latest Koha version (19.11)
on a fresh Ubuntu 16.04.6 LTS (Desktop) and then to replenish the empty
Koha tables through SQL inserts in the tables using sql exports of the
related fields from the old database. For that we have been comparing the
structure of the tables of Koha 3.18 and 19.11 with the tool provided at
http://schema.koha-community.org/

Can this way of proceeding, although tedious it might be, be successful or
not ?
If not, could someone have suggestions ?
Thanks for your attention.
Quynh
=
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] invalid marcxml

2020-05-14 Thread Marcel de Rooy

Please have a look at bug 21708.

Op do 14 mei 2020 om 12:52 schreef :

> Hi Joy,
>
> there is no direct error message from Koha, the error is only in the
> data structure. We only noticed this error because we're sending the
> data to a company so that it can be entered into the Discovery Service
> (search engine). This company pointed us to the wrong data structure. We
> need the corrected data to fully set up the Discovery Service.
>
> Koha-Version:   18.11.04.000
>
> greetings,
> tunix
>
> Am 13.05.20 um 19:41 schrieb Joy Nelson:
> > Hello-
> > Can you elaborate a bit more on this?  Is the order of the tags causing
> > errors in Koha?  Or is it just 'wrong' per the standard?
> >
> > I am unable to recreate the order you show in your example via the basic
> > editor or the advanced cataloging editor.  Can you explain what your
> > process is that creates this order?  Also what version of Koha are you
> > using currently?
> >
> > Thanks
> > joy
> >
> >
> > On Wed, May 13, 2020 at 10:25 AM  wrote:
> >
> >> We have a problem with our MARCXML data in KOHA. The order of the fields
> >> must be changed for many records. The problem affects all records that
> >> are newly created or changed by us. All  elements must appear
> >> after the  elements. So far the  element with
> >> the unique ID of the record (MARC field 999 $c) is placed before the
> >>  elements. The wrong order violates the MARCXML
> guidelines.
> >>
> >>
> >> before editing:
> >>
> >> 00996xxx x22002417x 4200
> >> 23330
> >> DE-1278
> >> t|
> >> 161220s2002 xxu|  00| 0 ger
> >> d
> >> 
> >> 3-89012-956-0
> >> 51,00 
> >> 
> >>
> >> after editing:
> >>
> >> 01059xxx x2200265x 4200
> >> 
> >> 9911
> >> 9911
> >> 
> >> 23330
> >> DE-1278
> >> 20190604142304.0
> >> t|
> >> 161220s2002 xxu|  00| 0 ger
> >> d
> >> 
> >> 3-89012-956-0
> >> 51,00 
> >> 
> >> ___
> >>
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> >
>
> --
> tuxflow.de, das andere Hosting!
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] invalid marcxml

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

Re: [Koha] invalid marcxml

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

[Koha] Call for news: April 2020 Koha Newsletter

Re: [Koha] Migrating Koha database from version 3.18 to 19.11?

[Koha] Migrating Koha database from version 3.18 to 19.11?

Re: [Koha] invalid marcxml

9 matches

Site Navigation

Mail list logo

Footer information