Versions Compared

Key

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

...

Unit: Automation and Metadata Management (LTS)

Date last updated: 01 2024 

Date of next review:  

...

Problem

You received an error message when uploading records a file into FOLIO via Data Import. 

  • After uploading your file the status column shows the upload was ‘completed with errors’. 

View file
nameData import - FOLIO - Google Chrome 2024-07-18 12-06-49 - Converted_Other.mp4
pageDraft: Data Import troubleshooting
spaceLTSP
height400
(click on video to see screen recording)Image Added


  • Click on the uploaded file. You should see a summary at the top of the screen. Next, click on the hyperlinked number in the ‘Error’ row or column

Image RemovedImage Added


  • Clicking on the number will display the list of records affected by the error. 

Image RemovedImage Added


  • Click on one of the records listed. Then click on the resource type you attempted to upload at the top of the screen. This should show you The resource type affected by an error will have an asterisk next the name. Click on this to see the error message in JSON format.

Image RemovedImage Added


  • The error message should provide you with a place to start on identifying the cause of the error. 

Finding the Issue 

Below are a few places that can help verify the cause and/of your issue or the location of the error:

  • Your first step should always be to check the logs in FOLIO. 
    • The errors in FOLIO are written in JSON, but usually have an error message that is clear and easy to understand.  
  • MARCEdit has a tool called MARCValidator that is very useful for identifying issues with MARC records. 

...

  • In MARCEdit click on Reports…

Image RemovedImage Added


  • Next, click on  MARCValidator

Image RemovedImage Added


  • Make sure “Check MARC Using Rules File’ “Validate Record Structure" is checked. You can check additional boxes, depending on the error  you are investigating.

Image Added



  • Separately, you can also try selecting "Check MARC Using Rules File".

Image AddedImage Removed


  • MARCEdit will provide you with an explanation of the potential issues with your records as well as a list of the affected records. 

Image RemovedImage Added

Other Notes/Recommendations

  • If you do NOT get an error, but records from your file upload are not imported, check the ‘Inventory’ section in FOLIO. Sometimes records already exist, so you will not receive an error message. Be sure to use the records identifiers when checkingsearching for the item
  • If you see a message that says ‘No record’ like the example listed; the record was record’  the record may have been kicked out to deduplicate.

...

  •  
  • If you are loading records with a vendor in the 980 $v it must match exactly or FOLIO will kick the record back. 
  • If you are still unable to identify the cause of the error please email bulkload@cornell.edu with a summary of the problem. Please be sure to include the file name.