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. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trá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


[Koha] invalid marcxml

2020-05-13 Thread tunix
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