Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top
Summary: These instructions describe how to export FOLIO MARC fields into an Excel spreadsheet
Table of Contents
printablefalse


Export Records from FOLIO to Excel

These steps are only done if the records are being pulled from FOLIO.

These first steps are not needed if there is already a Marc (mrc) file.

  • Search FOLIO > Instance tab - Limit search according to what you need, ex. Example: limit by location and or statistical code and create date.

  • Click Actions > Save Instance UUID’s or holdings/item UUID's (depending on needs) > Uploads file to a csv file and saves it in your Download files.
  • Find the file in the download drive to run the csv file against FOLIO Data Export:

    •  

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

    •  

      Select Job Profile, "CATMAN export entire SRS record.

    •  Select "Instance" from the "UUIDs provided for this export*" popup box > Run.
    •  Save to Desktop as mrk file type.
      •  Rename it if needed.
    •  Compile mrk file into an mrc file.
    •  Watch the YouTube video for instructions on "Converting a MARC file to Excel with MarcEdit."


Back to top 


Open MarcEdit to Create an Excel file

  • Open MarcEdit file on your desktop > find Tools > Export > select "Export Tab Delimited Records."
    •  Image Modified
    •  Click on the file folder 
      • Image Modified
      • If the mrc file does not appear, change the File name to ALL files.
    Set
    •  Select the mrc File Path for the first
    file, use the mrc
    • file.
     

    Select the
      • The mrc file, is usually found on your desktop or in the download files.
  • Copy the first file path link into the second file path > Change , and then change the second file type from mrc to txt file type.

    • Or click on the open file to choose the mrc file from your computer, but you will need to change the file to a txt file.

  •  After the files are linked in the file path > change "Select field Delimiter" to comma > Click NEXT.

    • If you choose a different tab-delimited character, remember to choose the same character when opening the Excel file.

  • Back to top

Define the Fields that will be exported into an Excel Spreadsheet

  • In the box labeled "Field" type or dropdown to , or in the drop-down menu add the Marc fields needed in the Excel spreadsheet.
  • Click Add Field (The field marc fields will display be listed in the Step 2 box.)
  • If needed, within the list drag fields up or down to place them in the preferred order.
  • Click Export.
  • Click OK on the exported complete popup note.Open Excel to find the file.
    •  If you think you
    might need to
    • will repeat these marc fields into another Excel file, save the fields
    in a file on your computer
    • within the the MarcEdit export box > Click SETTINGS to save
    the file.
  • Setting used to be at the bottom right, but it has moved to the top left corner.  
  • Image Removed
    The next time you need to find the saved export file click Setting > Load Setting f> find
    • .
      •  A saved export file will populate the fields without having to add the  marc fields one by one.
    •  Setting is located in the top left corner, but was on the bottom right so can move.  
  • Open Excel .
  • To find the file: Click file > Open > Browse.
  • Find the saved file (if needed file is not found, change the file types to ALL files.)The saved export file will populate the fields without having to add the  marc fields one by one.)
  • GPO Marcive lists are saved in the gd (\\GROUP) drive, file .
    • File name, “Excel export SAVED marc field-MarcEdit-Tab Delimited"
    • Rename the file if needed. (When If renaming a GPO MARC file, add LOAD to the end of the name).
  • When finished click "EXPORT" file.
  • Note where the file is saved then click OK to exit this the popup box.
  • Image Modified
  • Open the file as normal in Excel. Match the tab delimited that you picked in MarcEdit.


Back to top



Panel
borderColorblack
bgColor#F8F8F8
borderWidth1
borderStylesolid
titlePolicies


Page Properties
idpage-info


ContactDon Depoorter or Lisa English
TeamCatMan
Updated04/13/23
Created03/28/23



...

  • file
  • filed
  • files
  • filers
  • filer
    Lang: English (US)
  • nee
  • Nero
  • need
  • Neo
  • nee o