Signals Notebook: Troubleshooting Failed records during SNB Materials Bulk Import

Overview

This procedure helps you identify, troubleshoot, and resolve errors that occur during bulk import of materials into Signals Notebook materials libraries.

Prerequisites

• Access to Signals Notebook
• Completed bulk import attempt with errors
• Excel or text editor for reviewing reports

Phase 1: Accessing Import Reports

Step 1: Locate the Import Report

• After bulk import completion, look for a purple bar at the bottom of your screen
• Click "View Report" to open the import results window
• Review the summary of successful and failed imports

Step 2: Download the Failure Report

• If failures are present, click the download option in the report window
• Alternative method: Access reports through username menu → "Material Bulk Reports"
• ⚠️ Note: Reports older than 60 days are automatically deleted

Phase 2: Analyzing the Report

Step 3: Open the Report File

• For CSV files (Equipment, Reagent libraries):
  • Open Excel → Data tab → "Get Data From Text/CSV"
  • Select the report file → Import → Load
• For SDF files (Compound libraries):
  • Open with text editor (Notepad, Notepad++)

Step 4: Identify Failure Reasons

• Locate the "Import failure reason" column
• Review each error message to understand the specific issues

Phase 3: Common Error Types and Resolutions

Step 5: Resolve Missing Required Fields

• Error example: "Validation errors found while validating mandatory fields"
• Resolution: Fill in the empty required fields in the report file
• Save the corrected file

Step 6: Fix Field Mapping Issues

• Error type: Wrong field mapping during import
• Resolution: Verify field names match your library's record definition
• Correct any mismatched field names

Step 7: Correct Data Format Errors

• Text in number fields: Replace with valid numeric values
• Incorrect date formats: Use the required date format for your system
• Invalid list values: Use only values defined in your attribute lists

Step 8: Fix Unit/Format Issues (SDF files)

• Error example: "Value '10 gg' cannot be parsed to a valid value for 'MASS' type field"
• Resolution: Correct the units and format (e.g., change "10 gg" to "10 mg")
• Save the file with corrections

Phase 4: Re-importing Corrected Data

Step 9: Import the Corrected Report File

• Use the same bulk import process with your corrected report file
• The system will process only the previously failed records
• No duplicates will be created from successful imports

Step 10: Verify Successful Import

• Check the new import report for any remaining errors
• Confirm all materials are now properly loaded in your library

Phase 5: Advanced Troubleshooting

Step 11: Handle Complex Errors

• For persistent errors, review your library's record definition
• Consider if field types or requirements need modification
• Document any systematic issues for future imports

Step 12: Seek Additional Support

• Contact Revvity Signals Support Team for unresolved issues
• Access product documentation within Signals Notebook: Help Center > Signals One & Signals Notebook > Create and Record > Materials Management > Bulk Import, Bulk Export and Bulk Update of Materials.
• Review additional instructional videos in the application

Key Reminders

• Always review the failure report before attempting corrections
• The report file type matches your import file type (CSV or SDF)
• Reports are available for both failures and duplicates based on your import settings
• Keep backup copies of your original import files