Re: [IUG] Excel files

["Carol Ou" <Carol dot Ou at ColoradoCollege dot edu>]

Actually, MarcEdit can convert directly from a tab-delimited text file to
MARC.  It even lets you determine how you want to map certain columns to
certain MARC tags, so you don't have to pre-edit the file in Word (or
whatever) to insert those MARC tags.  In the version of MarcEdit I have
(4.6.63), this feature is the second option under "Add-ins" called
"Delimited Text Translator."  Pretty slick, I say.

-Carol

--
Carol Ou
Systems Librarian
Colorado College Tutt Library
(719) 389-6895
carol dot ou at coloradocollege dot edu


-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Finnerty, Ryan
Sent: Monday, December 10, 2007 1:31 PM
To: IUG INNOPAC List
Subject: Re: [IUG] Excel files

Hi Pamela,

 

I've done this several times with Excel files. Unfortunately I don't have
the process documented but here it is in a nutshell:

 

Edit the Excel file so you put a column in front of every existing column.
Put the appropriate MARC tag in each cell of the new columns.
Save the Excel file as a tab delimited text file. Open it in Word and
doing tons of find and replace passes, make it look like a MarcEdit text
file. Open in MarcEdit and convert to Marc. Load into Millennium using
Data Exchange

 

 

Ryan J. Finnerty | Head, Database Management & NACO Coordinator

UC San Diego Libraries | Metadata Services Department

9500 Gilman Drive 0175K | La Jolla, CA 92093

T 858 822 3138 | F 858 822 0349

rfinnerty at ucsd dot edu | libraries.ucsd.edu

 

 

 

 

 

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Smith, Pamela J.
Sent: Friday, December 07, 2007 10:36 AM
To: IUG INNOPAC List
Subject: [IUG] Excel files

 

Is there any way to import an Excel text file into Millennium? I'm

looking for a way to create brief records in the system from an Excel

file. Probably not possible, but if anyone would know it would be the

list members. Thanks

 

Pamela J. Smith

Technical Services Manager

Albuquerque/Bernalillo County Library System

501 Copper Avenue NW

Albuquerque, NM 87102

psmith at cabq dot gov

(505)768-5137

(505)768-5116 fax

 

 

 

--- StripMime Report -- processed MIME parts ---

multipart/alternative

  text/plain (text body -- kept)

  text/html

---

--

This message was distributed through the Innovative Users Group INNOPAC
list

Public replies:  INNOPAC at innopacusers dot org

Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac



--- StripMime Report -- processed MIME parts --- multipart/alternative
  text/plain (text body -- kept)
  text/html
---
--
This message was distributed through the Innovative Users Group INNOPAC
list Public replies:  INNOPAC at innopacusers dot org Update your subscription
options: http://innopacusers.org/mailman/listinfo/innopac