Page Comparison

Anchor
top top

Summary: These instructions describe how to export FOLIO MARC fields into an Excel spreadsheet. The reports are used to send MARC information to Librarians or Staff, or to compiled lists for missing books, collection statistics, or collection information such as a list of Chevez, Juvenile, Music books, DMC materials, or Monthly GPO lists ...

---

Table of Contents
printable false

---

FOLIO Export

• FOLIO > Instance tab - Limit records according to what you need, ex. limit by location code.

• Click Actions > Save Instance UUID’s > Uploads file to csv file (

• Export the csv file through FOLIO Data Export (converts to an mrc file): 

  •  

    Find the csv file in the Download file > drag or drop into Data Export bo.

  •  

    Select Job Profile, "CATMAN export entire SRS record.

  •  Select "Instance" from the "UUIDs provided for this export*" popup box.
  •  Saves as a mrc file in the download file.
  •  Save the file and rename it if needed.

Back to top 

Step 2

---

MarcEdit to Data Export

• Open MarcEdit from the mrc file > Click Tools > select Delimited Text Translator.
  • 
• At Export Tab Delimited Records box click on the file folder to . 
• To find the mrc file.Change , change the File name type to ALL files.Change file type to MARC Text File (*.mrc).
• Select the mrc file
• Copy the first file path link into the second path > Change the second file to a txt file instead of mrc.

•  After the files are linked in the file path > set select field Delimiter to comma > Click NEXT.

• 

Back to top

---

Define Fields/Subfields to Export

• Add In the box labeled "Field" type or dropdown to add the marc fields that are needed in the Excel spreadsheet.
• Click Export and then after the export OK note pops up, open Excel.Type the marc code in the Field box > click Add Field. Field Add Field (The field will display in the Step 2 box.)
• If needed, drag fields to place in the preferred order.
• Click Export.
• Image Removed
• To save the fields/subfields list, click Click OK on the exported complete popup note.
• Open Excel to find the file.
• Image Added
• If this file is going to be repeated, save the fields listed > Click SETTINGS to save the file.
  •  Remember where you saved it.
  •  The MARC export list is saved in the gd file named “MARC fields_Define fields to Export." The next time the same file is run click Setting > Load to find the file to populate the   (This populates the fields without having to add them one by one again.)
  •  OR Save setting to save a new list.
  •  GPO marc lists are saved in the gd file named “MARC fields_Define fields to Export."
• Rename the file if needed. (On renaming GPO MARC files, add LOAD to the end).

Back to top

---

Step 4

• Substep a
• Substep b
• Substep c

Back to top

---