[12519] in Public-Access_Computer_Systems_Forum
Importing Comma-delimited/Dbase, Exporting MARC
daemon@ATHENA.MIT.EDU (Public-Access Computer Systems For)
Fri Oct 23 20:04:57 1998
Date: Fri, 23 Oct 1998 17:49:03 -0500
From: Public-Access Computer Systems Forum <LIBPACS@UHUPVM1.UH.EDU>
To: PACS-L@LISTSERV.UH.EDU
Reply-To: Public-Access Computer Systems Forum <PACS-L@LISTSERV.UH.EDU>
4 Messages, 123 Lines
*-----
From: Karen Reichardt <Karen.Reichardt@Citadel.edu>
Subject: RE: importing comma-delimited/dbase,
exporting MARC communications format
The Library of Congress has software called MARCMaker that converts text
to MARC. Perhaps that would help. Check it out at
http://lcweb.loc.gov/marc/marcsoft.html
Karen Reichardt 1) Books are for use.
Systems Librarian 2) Every reader his book.
Daniel Library, The Citadel 3) Every book its reader.
171 Moultrie Street 4) Save the time of the reader.
Charleston, SC 29409 5) The library is a growing organism.
phone:(843)953-5837
fax: (843)953-5190 -Ranganathan's
email: reichardtk@citadel.edu Five Laws of Library Science
-----Original Message-----
From: Kerry Bouchard [SMTP:BOUCHARD@LIB.IS.TCU.EDU]
Sent: Thursday, October 22, 1998 7:26 PM
To: PACS-L@LISTSERV.UH.EDU
Subject: importing comma-delimited/dbase, exporting MARC communications
format
----------------------------Original message----------------------------
Does anyone know of software that will import non-MARC records (such
as comma-delimited or dbase format), let me assign various MARC fields to
the imported fields, and then export MARC communications records (records
formatted for loading into a MARC-based online catalog)? ProCite seems
to be pretty flexible in what it will import, but it doesn't have a
function
to export to MARC format.
Thanks,
Kerry Bouchard, K.BOUCHARD@TCU.EDU
Assistant University Librarian for Systems
Mary Couts Burnett Library, TCU
*-----
From: "Margaret A. Rioux" <mrioux@whoi.edu>
Subject: Re: importing comma-delimited/dbase,
exporting MARC communications format
Kerry -
I use a program called Data Magician. It can take dBase,
Inmagic, or delimited ASCII and export it as delimited ASCII,
Inmagic or MARC (plus a couple of other formats I never heard
of). I use it to convert dBase to MARC quite successfully. I'm
now using MS Access, but I can export from Access in dBase
format, then use that as input for Data Magician.
The producer is Folland Software Services, and the version I
have is 1.4 dated 1994. It's a DOS program and runs happily in a
DOS window under Win95. I'm not aware of a newer version.
The address I have for Folland is
6 Chartwell Crescent
Guelph Ontario N1G 2T7
phone 519-836-3453
fax 519-747-4262
email lfolland@ca.dynix.com
The address, phone and email are from the manual, so I don't know
if they're still good.
I really like the software. It takes a bit of struggling to
figure out how to export in MARC, especially the fixed field
string, but once you get one conversion going, the next one is
easy.
Good luck,
*********************************************************************
* Maggie Rioux | Email:
mrioux@whoi.edu *
* Information Systems Librarian | Voice:
508/289-2538 *
* MBL/WHOI Library | Fax:
508/457-2156 *
* Woods Hole Oceanographic Inst. | Foot: Clark Lab, Room
135 *
* Woods Hole, MA 02543 | Quissett Campus,
WHOI *
*********************************************************************
** Progress is wonderful, but it has gone on too long - Ogden
Nash **
*-----
From: Clinton Jones <Clinton@ttalk.com>
Subject: Re: importing comma-delimited/dbase,
exporting MARC communications format
Most good databases and applications will allow you to import CSV and DBF
formats however since MARC is a relatively proprietary structure the tools
generally have to be specialised
http://www.tdm.com.au/transfor.htm shows a MARC translator this may
achieve what you want
Clinton Jones
Tech Talk Broadcasting
http://www.ttalk.com
*-----
From: Gilles Poitras <gpoitras@ggu.edu>
Subject: Re: importing comma-delimited/dbase,
exporting MARC communications format
I think you need to find out the import requirements of the system you
are importing to.
Once you know that you can look at software that can export to meet those
requirements.
I would recommend looking at FileMaker Pro as a highly flexible and
relatively easy to use desktop program. You could create a database with
fields named after the MARC tags, import the data, check the data for any
needed corrections, and export in in any of a variety of ways.
One advantage of FileMaker Pro is that files created on Windows or Mac
machines transfer to the other platform with great ease.
I have used ProCite for years and would not expect it to do this very
well.
Gilles Poitras gpoitras@ggu.edu
Golden Gate University - University Library