[Isis-users] manual Excel to ABCD

[Piet De Keyser]

Hi Peter,

I agree with Egbert: this is the way to do it. On the other hand, if you want to import this database into the MARC database of ABCD you must create the MARC leader, the fixed length field 008, the indicators etc.  You can find an example of this kind of conversion script (here from Weblis to MARC, but the same kind of conversion) at: 

http://www.personeel.khleuven.be/~pikey/abcd/abcd.html

Piet de Keyser
Belgium



-----Oorspronkelijk bericht-----
Van: isis-users-bounces at iccisis.org [mailto:isis-users-bounces at iccisis.org] Namens De Smet Egbert
Verzonden: woensdag 21 december 2011 16:53
Aan: Hessels, Peter; isis-users at iccisis.org
CC: Anja Douglas (a.douglas at una.an)
Onderwerp: Re: [Isis-users] manual Excel to ABCD

Peter,

if you can use 'mx' at the command-line, all manual you need is this :
- export the Excel-sheet to a csv-file, using one of the options to change the separator into '|' (the pipe)
- mx can read such a file directly with the command 'mx seq=mycsvfile.csv' create=mydatabase now -all'

If it is difficult to have the '|' as separator, the input-parameter seq= of mx can also read another one added behind the input-filename, e.g. for semi-colon :
mx seq=mycsvfile.csv; create=mydatabase now -all

Without mx things get much trickier indeed and a manual will be necessary.

Egbert de Smet
Universiteit Antwerpen
________________________________________
From: isis-users-bounces at iccisis.org [isis-users-bounces at iccisis.org] on behalf of Hessels, Peter [P.Hessels at kit.nl]
Sent: Wednesday, December 21, 2011 4:26 PM
To: isis-users at iccisis.org
Cc: Anja Douglas (a.douglas at una.an)
Subject: [Isis-users] manual Excel to ABCD

Dear all,

A question on behalf of a group of 16 libraries on the Dutch Antilles:
I know that conversion from an Excel sheet to ABCD has been done by many librarians. Someone must have made a step-by-step tutorial for this. Could anyone share a tutorial (preferably in English or Dutch)?

Thank you,
Peter Hessels
KIT - Royal Tropical Institute of the Netherlands

Van: isis-users-bounces at iccisis.org [mailto:isis-users-bounces at iccisis.org] Namens monica jimenez
Verzonden: maandag 12 december 2011 18:56
Aan: isis-users at iccisis.org
Onderwerp: [Isis-users] ayuda

Hola
Estoy trabajando en winisis local y tengo la informacion en 3 pc y quiero unirla a una sola, ¿cómo hago para pasar los archivos a una sola?
Gracias por la atención
Mónica Jiménez
_______________________________________________
isis-users mailing list
isis-users at iccisis.org
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl