Anabela, Your attachments haven't come through -- either the mailing list, or some overeager mail server, is stripping them. Paul. On Mon, Oct 29, 2018 at 03:43:12PM +0000, anabela semedo wrote:

I'm sorry, this is it.

________________________________ De: Koha <koha-bounces@lists.katipo.co.nz> em nome de anabela semedo <anabela556@hotmail.com> Enviado: 29 de outubro de 2018 14:40 Para: Koha list Assunto: [Koha] FW: Re: convert ISO to marc file with MarcEdit

Hi Paul, it's in anexo. ________________________________ De: Microsoft Outlook <postmaster@outlook.com> Enviado: 29 de outubro de 2018 14:36 Para: Paul Hoffman Assunto: Não entregue: Re: [Koha] convert ISO to marc file with MarcEdit

mx.google.com rejeitou a sua mensagem destinada aos seguintes endereços de correio eletrónico:

Paul Hoffman (paul@flo.org)<mailto:paul@flo.org> A mensagem não foi entregue porque o fornecedor de correio eletrónico do destinatário a rejeitou.

mx.google.com devolveu este erro: This message was blocked because its content presents a potential security issue. Please visit https://support.google.com/mail/?p=BlockedMessage to review our message content and attachment content guidelines. p1-v6si6690955wrp.52 - gsmtp

Informações de diagnóstico para administradores:

Servidor de origem: AM5EUR03HT202.mail.protection.outlook.com

paul@flo.org mx.google.com Remote Server returned '552-5.7.0 This message was blocked because its content presents a potential 552-5.7.0 security issue. Please visit 552-5.7.0 https://support.google.com/mail/?p=BlockedMessage to review our 552 5.7.0 message content and attachment content guidelines. p1-v6si6690955wrp.52 - gsmtp'

Cabeçalhos originais da mensagem:

DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=cIYxQ6QR5wHzkrcd7VWqZFqMKskLQPjUGPVd0BDLoN0=; b=PFqI2VIj+XtHqPhkos5DMamYOqKMufYhuW6pUw/qC/AeVQd9/1n/NsiUw/euiZqwpmI+BCRz2gZ9wiH3Flr2LPle5q1ylXX/+L3Dfu00wEQH7iGg7ifTQRKLGYIpPdipDQnLmmui/EdWQvWjipGYfcfIzUTwPo3jzptigwhinTUg0DIsng97Q3wm61tnvcrIsEU8llWHKaHkwqryHGmTnaOCCCLobGMcGwx1QDREdHokLxvfUBpSq+Fta9qQFOsGMEKVEU70kQTCzLDg7vFAX5HcMPnFEXtzqDEHD3s4e7wqKvBzh9wQ5+JRPQgJmrfDzoOT0j+6J1KmewODUWRMiQ== Received: from AM5EUR03FT037.eop-EUR03.prod.protection.outlook.com (10.152.16.60) by AM5EUR03HT202.eop-EUR03.prod.protection.outlook.com (10.152.17.17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1294.14; Mon, 29 Oct 2018 15:36:37 +0000 Received: from VI1PR05MB4317.eurprd05.prod.outlook.com (10.152.16.53) by AM5EUR03FT037.mail.protection.outlook.com (10.152.17.241) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1294.14 via Frontend Transport; Mon, 29 Oct 2018 15:36:37 +0000 Received: from VI1PR05MB4317.eurprd05.prod.outlook.com ([fe80::55e3:b22c:8bd1:4f3b]) by VI1PR05MB4317.eurprd05.prod.outlook.com ([fe80::55e3:b22c:8bd1:4f3b%2]) with mapi id 15.20.1273.027; Mon, 29 Oct 2018 15:36:37 +0000 From: anabela semedo <anabela556@hotmail.com> To: Paul Hoffman <paul@flo.org>, "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] convert ISO to marc file with MarcEdit Thread-Topic: [Koha] convert ISO to marc file with MarcEdit Thread-Index: AQHUbvX4EWltluCXgkCM+fIhVKYwZ6U2QcqAgAAahiE= Date: Mon, 29 Oct 2018 15:36:37 +0000 Message-ID: <VI1PR05MB4317FC6D90B41D88CB6D5AE39DF30@VI1PR05MB4317.eurprd05.prod.outlook.com> References: <VI1PR05MB4317DDAFFCAE7F29CEAC45479DF20@VI1PR05MB4317.eurprd05.prod.outlook.com>,<20181029140114.GA4986@trot> In-Reply-To: <20181029140114.GA4986@trot> Accept-Language: pt-PT, en-US Content-Language: pt-PT X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:3D730D87DF4E929CF9F1C78CEBC1ADEB118FEE01AF5A67F2D47B8BE47FCAC3A0;UpperCasedChecksum:7589DA788BA469F16972147D2EAD47866BEC61F258D5A004EF191F538BB836A2;SizeAsReceived:7129;Count:46 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [rhHYELAjgS4i/zVQg9N58HxHjWM3f4Lf] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;AM5EUR03HT202;6:+EQHmd8e69IENLGwgq2tLV/rwLeRrJ+snvOoYWW/eGmtMomH3ACI/kbSq9zwA2VvUXv2Hh8WrLy+bjEooOQwlsw3XfmW5E4RjvJIiqSAXBAtwWlAd75sLw3jWMAoRF9y0fIbFeusEFARP3HxrKDvuQCX/puiavnBcOMLw1/RT5/Y5HREkONrukPx9sAEBmjMW605ECFWrQM4k2HYxq0O73ffsTcfZLSe077gqySnkcxqXKNKlAol+kbACeYkdPdilOHK2ZfeiestaUonbMdRHDp+SSJgvEdIx8hdT5lFSV3LvSODeyrPuJa9gpYoZnzn1zNTy8nCVPIeTkeV4UBiwX/u/a0LI/GVXa8BpP9SC5kXBs1SarapwyPGw/FPYyh0fqH7Gkq1oiCnq6ery1A+GK2IfcbmNs3LdcFelJt7V4QpbzL35EVG535QehE0aAJl/0TO18UYwHOFqkt7eW2zEw==;5:UdeucfjkmcpdVXuJu3cXNJZZoBDbptYx1btg5Pj8hN9oqN/pYxXf9tC8lkVTqcVCkWteNSH7BaH0tp0zwk3t0hAEFgW0joN89kwcTskX7pE0slzNHB06yCRVuK9z4VFCFTZJOQIJW6e+Nt3/JI8z/wUla/+X3JJI1rXp8Z9RBW4=;7:ijKagkwWyQ3I0yUeBeqMn7j53p3/KEerqVjXEHOEstV0fseQ/+RMG5jkHHp5y4aC/nlq7Q3qB8Tetc8tcxkgwjNwBZEeYC0JdCGw61H4bYetsFeEul8x2j4M5vmVO8uI8v9ScZUVZBxzqm2REJrEog== x-incomingheadercount: 46 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(7020095)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322404)(1601125500)(1603101475)(1701031045);SRVR:AM5EUR03HT202; x-ms-traffictypediagnostic: AM5EUR03HT202: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(4566010)(102415395)(82015058);SRVR:AM5EUR03HT202;BCL:0;PCL:0;RULEID:;SRVR:AM5EUR03HT202; x-microsoft-antispam-message-info: z/ZDAaZ+ESKrEEipkQE0LYm9hPPp8s9qikGPazk91/ESOkXLTdfpK5sLlkj+VEW2 Content-Type: multipart/mixed; boundary="_006_VI1PR05MB4317FC6D90B41D88CB6D5AE39DF30VI1PR05MB4317eurp_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 5dab7a8a-ebdc-4bd9-9cfd-67cde50b170b X-MS-Exchange-CrossTenant-Network-Message-Id: ab45f822-7849-49c2-5ba9-08d63db45064 X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 5dab7a8a-ebdc-4bd9-9cfd-67cde50b170b X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Oct 2018 15:36:37.0585 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM5EUR03HT202

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

-- Paul Hoffman <paul@flo.org> Software Services Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 (617) 442-2384

thank you OWEN, yes I tried converting with MarcEdit, but it does not convert. reading many tutorials, I think my problem is even in the data. I export and convert with marcedit, I open with the marc editor, I get the message that my file is not a valid marc. this is an example of the exported record of ABCD base 00789000000000409000450006000080000012000010000813000010000931000010001079000010 00118100001000128200001000138300001000149020005000159040003000209080003000239090 00200026950000400028010000500032002000300037004000200040006000200042009000600044 01600160005001801080006604300110017403800470018502000060023207600130023807600280 02510760031002790760018003100370013003280370010003419810018003519820005003690100 00500374#Doação.########1986#PT#en#m#MON#true#21#M#m#Livro#Schasse^bUlrich#"Male -female wage differences in west germany: empirical evidence, causes and implica tions"/ Ulrich Schasse#016 SCH ma#Lisboa: Centro de Estudos da Dependencia, 1986 #44 p.#Bibliografia#Politica de desenvolvimento#Mulheres-Equidade de géneros#M ulheres-Alemanha#2 exemplares#Inv. 2016#20140601 08:49:45#abcd#true## I try with exported winisis data and I can edit with marcedit. but I have 30,000 ABCD registration to convert. thanks for listening. Ana Bela ________________________________ De: Koha <koha-bounces@lists.katipo.co.nz> em nome de Owen Leonard <oleonard@myacpl.org> Enviado: 30 de outubro de 2018 12:50 Para: koha Assunto: Re: [Koha] FW: Re: convert ISO to marc file with MarcEdit

Your attachments haven't come through -- either the mailing list, or some overeager mail server, is stripping them.

This mailing list does not allow attachments. If you want to share a file you must post it somewhere where it can be downloaded and share the link here. Do I understand correctly that you tried to open these files in MarcEdit but it didn't work? If so, what did you try and what problem did you encounter? We may be able to help here, but there is also a mailing list specific to MarcEdit (also in English): https://listserv.gmu.edu/cgi-bin/wa?A0=marcedit-l -- Owen -- Web Developer Athens County Public Libraries https://www.myacpl.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Try with a PFT with marc21 tags in ISIS. Then import in MarcEdit to convert to Marc21. Before the process work to fix any issues you find in your ISIS records (1). Edit and convert in MarcEdit (2). Then import to Koha(3). Personally prefer the web interface to import records in batch (100, 200...500 or 1,000. -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Paul Hoffman Sent: martes, 30 de octubre de 2018 11:37 a. m. To: koha@lists.katipo.co.nz Subject: Re: [Koha] FW: Re: convert ISO to marc file with MarcEdit Ana Bela, On Tue, Oct 30, 2018 at 05:01:59PM +0000, anabela semedo wrote:

thank you OWEN, yes I tried converting with MarcEdit, but it does not convert. reading many tutorials, I think my problem is even in the data.

Is there a mailing list for ABCD? If so, I would ask them how to export records in MARC21 format. Or perhaps in UNIMARC, since Koha seems to support that as well.

I export and convert with marcedit, I open with the marc editor, I get the message that my file is not a valid marc.

What this means is that the file is not valid MARC21 (or any other variety of ISO-2709 that MarcEdit is able to parse).

this is an example of the exported record of ABCD base

0078900000000040900045000600008000001200001000081300001000093100001000 1079000010 0011810000100012820000100013830000100014902000500015904000300020908000 3000239090 0020002695000040002801000050003200200030003700400020004000600020004200 9000600044 0160016000500180108000660430011001740380047001850200006002320760013002 3807600280 0251076003100279076001800310037001300328037001000341981001800351982000 5003690100 00500374#Doação.########1986#PT#en#m#MON#true#21#M#m#Livro#Schasse^bUl rich#"Male -female wage differences in west germany: empirical evidence, causes and implica tions"/ Ulrich Schasse#016 SCH ma#Lisboa: Centro de Estudos da Dependencia, 1986 #44 p.#Bibliografia#Politica de desenvolvimento#Mulheres-Equidade de géneros#M ulheres-Alemanha#2 exemplares#Inv. 2016#20140601 08:49:45#abcd#true##

Hmm, that does look like ISO-2709 data, but not MARC21 or UNIMARC. Do you know which variety of ISO-2709 it is? Here are the various parts of the leader (a.k.a. record label) that convince me that it's not MARC21 or UNIMARC: Offset Contents Description ------ -------- ---------------------------------------------------------- 00-04 00789 Record length = 789 bytes 05-09 00000 ??? 10 0 Indicator count (MARC21 and UNIMARC have 2 here) 11 0 Subfield code count (MARC21 and UNIMARC have 2 here) 12-16 00409 Base address of data 17-19 000 ??? 20 4 Length of the length-of-field 21 5 Length of the starting-character-position 22 0 Length of the implementation-defined 23 0 Undefined in MARC21

I try with exported winisis data and I can edit with marcedit. but I have 30,000 ABCD registration to convert. thanks for listening.

You'll have to find a way to convert the exported records to MARC21 or UNIMARC, or to some other ISO-2709 format that Koha supports. Either that, or convince ABCD to export in one of those formats. Good luck! Paul. -- Paul Hoffman <paul@flo.org> Software Services Manager Fenway Library Organization 550 Huntington Ave. Boston, MA 02115 (617) 442-2384 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha