Subject: | |
From: | |
Reply To: | |
Date: | Fri, 10 Dec 2021 14:50:51 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
I think you have gotten some good suggestions. The problem with sql is data is likely spread across multiple tables -- making simple conversion difficult. The approach I would likely take would be something like the following:
1. Determine if I can write a query that will pull, via joins, all the info I need into a single results table and export that in a tab delimited format. You can use MarcEdit's tab delimited tools to create MARC records from that.
2. If the data actually has a MARC blob in the field (which sometimes happens when using systems that have to store MARC data) - -you can use the SQL Explorer in MarcEdit to export the data directly from the SQL table (assuming mysql or sqlite).
3. If data is across multiple fields and you can easily pull them together, export the keys and data then use the delimited text translator to create records from all files -- using the primary key as the match point, then use the merge tool to reassemble the data.
--tr
-----Original Message-----
From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of Lori Fenton
Sent: Thursday, December 9, 2021 3:01 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] How do I convert SQL to MARC?
Our Music Department is sunsetting their old Linux MySQL database/"circulation system." We want to integrate their holdings into our Innovative Sierra catalog. I feel like MarcEdit is probably capable of doing this; I just have no clue where to begin. Can someone point me in a useful direction to accomplish this?
Thank you,
Lori
Lori R. Fenton, MLS
Collection Development Manager/Serials Librarian Washburn University Mabee Library
1700 SW College Ave
Topeka, KS 66621
785-670-1984
________________________________________________________________________
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]
|
|
|