MARCEDIT-L Archives

June 2012

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Reese, Terry" <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Fri, 15 Jun 2012 06:30:00 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (59 lines)
I would work directly from the MS Excel sheet or use tab delimited (csv isn't my favorite format).
You set indicators when you want them -- \\ are blank indicators.
You check UTF8 when you are working directly with Excel - it primarily is a key to tell MarcEdit that the data may be in UTF8 or UTF16 or UTF32 format (so normalize).

There are some tutorials on youtube to demonstrate different functions.

--tr

-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Kathy Rippel
Sent: Wednesday, June 13, 2012 4:11 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] MarcEdit 5.8 updated

I've been trying the Delimited Text Translator to prepare a small, sample file for exporting in to our ILS (Koha 3.6).

The spreadsheet I begin with (I've tried both OpenOffice Calc and MS
Excel) has two columns, one for barcode and one for title.

I believe I used the Translator all right. I then did some modification (added 008 fields) and then created the .mrc file and imported it into Koha.

Everything staged just fine, but the final import does not happen.

OK, this may be a Koha problem (I'm pursuing that), but I'm afraid that I may be setting things up incorrectly in MARCEdit, too.

    * I saved the spreadsheet as a .csv file
    * Output file was .mrk
    * Delimiter: comma
    * I've tried the text qualifier with " and without (depending whether it's OO or MS)
    * Indicators for 952$p-- should I leave the // or make that box blank?
    * Do I mark UTF-8, since that's what I will be using in Koha, or is that supposed to apply to the original import?

I feel like I'm missing something; is there a tutorial or something on this function?

Kathy

PS- Although I've used MARCEdit for basic purposes with success, I feel that this one is getting the better of me.
Kathleen D. Rippel
Dept. Head/Consultant--Resource Access and Sharing Central Kansas Library System
1409 Williams
Great Bend, KS 67530

(620-792-4865) phone
(800-362-2642) toll-free, KS
(620-792-5495) fax

[log in to unmask]
********************************************************************************************
I'm currently reading: With amusement for all: a history of American popular culture since 1830, by LeRoy Ashby.
I'm currently listening to: Water for elephants, by Sara Gruen.

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

ATOM RSS1 RSS2