Скачать или смотреть Transforming MARC21-XML to CSV Made Easy: A Step-By-Step Guide

Learn how to effectively transform and filter a MARC21-XML file into CSV format using XSLT. This easy-to-follow guide breaks down the process and provides a working example!
---
This video is based on the question https://stackoverflow.com/q/63693325/ asked by the user 'lukascbossert' ( https://stackoverflow.com/u/8584652/ ) and on the answer https://stackoverflow.com/a/63693648/ provided by the user 'michael.hor257k' ( https://stackoverflow.com/u/3016153/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to transform and filter a MARC21-xml into csv?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Transforming MARC21-XML to CSV: A Step-By-Step Guide

In the world of data management, converting one format to another can often be a daunting task. One such transformation is converting a MARC21 XML file, which is commonly used in library catalogs, into a more user-friendly CSV format. This guide will walk you through the process of transforming and filtering a MARC21 XML file into CSV format seamlessly!

The Challenge

The task at hand is to convert a MARC21 XML file structured as shown below:

[[See Video to Reveal this Text or Code Snippet]]

To a CSV file that looks like this:

[[See Video to Reveal this Text or Code Snippet]]

In the desired output, if a PubID value is missing in a subfield, it should be replaced with "NOPUBID".

The Solution Using XSLT

To achieve this transformation effectively, we will employ XSLT (eXtensible Stylesheet Language Transformations), an excellent tool for transforming XML documents into other formats.

Step-by-step Guide

Step 1: Set Up the XSLT Stylesheet

Create an XSLT stylesheet with the following content:

[[See Video to Reveal this Text or Code Snippet]]

Explaining the Components

Namespace Declaration: We declare the MARC XML namespace to process the MARC data correctly.

Output Settings: We specify that the output method is text, meaning the result will simply be a formatted text string.

Templates:

The template matches the collection of records.

It loops through each record, retrieving both control fields and certain data fields (tags 100 and 700).

Variables: The variable for the control field’s value allows us to reference it later, while the variable for PubID checks for missing data gracefully.

Conditional Logic: The xsl:choose statement ensures that if there is no PubID, "NOPUBID" is output instead.

Conclusion

With just a few lines of XSLT code, you can easily transform and filter a MARC21-XML file into a structured CSV format. This process not only simplifies data management tasks but also makes it easier for librarians and researchers to manipulate their databases effectively.

Feel free to utilize and modify the example XSLT provided to fit your specific needs!

Happy transforming!