Scope: Tips for troubleshooting Data Import issues in FOLIO. 

Contact: Whitney Christopher 

Unit: Automation and Metadata Management (LTS)

Date last updated:  

Date of next review:

Problem

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

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



  • 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. 


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


  • Click on one of the records listed. 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.


  • 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 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…


  • Next, click on  MARCValidator


  • Make sure “Validate Record Structure" is checked.



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


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

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 searching for the item. 
  • If you see a message that says ‘No 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.