As Carlos suggested, the solution would be to use MySQL queries to produce a table of the fields you want and save it as a tab- or comma-delimited text file, then use the Delimited Text Translator functionality in MarcEdit to convert to MARC. Each subfield needs a separate column.

The biggest complication will be repeatable fields.  If you know some records have as many as ten notes that you want to put into 500 fields, you will need ten sets of fields in your output to handle the data.

					Steve McDonald
					[log in to unmask]


-----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]