Importing Data into DefenseReady Webinar

Today’s webinar provided a practical walkthrough of the data import process within DefenseReady, highlighting key tools, common pitfalls, and strategies for ensuring clean, structured data. We covered how to use the import checklist, map source fields effectively, and troubleshoot validation issues—empowering users to streamline workflows and support accurate readiness reporting.

Webinar Video

• Data Import Preparation and Best Practices: Jessica led a comprehensive discussion on preparing data for import into Defense Ready, emphasizing the importance of file formats, data validation, security roles, and documentation, with examples from fictional managers Harmony, Tammy, and Manuel.
  • Supported File Types: Jessica explained that Defense Ready supports importing CSV, XML, text, and compressed files, and highlighted the need to match file formats to system requirements before starting the import process.
  • Security Role Management: Jessica described the hierarchy of security roles, including system admin, system customizer, and manager roles, and advised against directly modifying out-of-the-box roles, recommending that organizations submit work items to Bermuda for custom role creation to avoid future overrides.
  • Test Environment Usage: Jessica stressed the importance of conducting small batch imports in a test environment before moving to production, ensuring data integrity and minimizing failures.
  • Data Cleaning and Validation: Jessica outlined the need to clean and validate data by removing duplicates, filling required fields, and standardizing lookup formats, noting that missing or incorrect data will cause import failures.
  • Documentation and Resources: Jessica provided resources such as an import checklist and a data mapping inventory, encouraging participants to document their processes thoroughly to prevent single points of failure and facilitate smooth handovers.
• User Use Cases and Import Methods: Jessica presented use cases featuring fictional managers Harmony, Tammy, and Manuel to illustrate different import scenarios and methods, including view-based imports, native spreadsheet imports, and batch processing for large datasets.
  • View-Based Import Process: Harmony, the HR manager, uses system views to organize and import contact data efficiently, ensuring required fields are completed and leveraging templates for consistent mapping.
  • Native Spreadsheet Import: Tammy, the training manager, consolidates data from various sources into standardized registration forms, mapping fields manually in the system and using CSV files for class student imports.
  • Batch Processing for Large Data: Manuel, the manpower manager, handles large-scale imports by breaking up datasets into manageable workbooks or using add-ins, and considers scheduling imports outside work hours to avoid system interruptions.
  • Error Handling and Troubleshooting: Jessica demonstrated how to review import failures, identify issues such as incorrect field mapping or duplicate detection, and correct errors before re-importing data.
• Advanced Import Features and Automation: Jessica introduced advanced import features available in SaaS environments, including AI-powered tools like Form Assist, data flows for automated imports, and integration with Power Apps, highlighting future capabilities for streamlining data management.
  • Form Assist AI Mapping: Jessica demonstrated Form Assist, an AI tool in SaaS environments that allows users to bulk paste data and automatically map fields, streamlining the import process and reducing manual effort.
  • Data Flows for Automation: Jessica explained how data flows can connect external sources like Excel or SharePoint to Defense Ready, enabling automated imports and scheduled refreshes based on data updates.
  • Power Apps Integration: Jessica noted that SaaS environments support Power Apps, including Copilot AI and Power Automate, which can further automate data imports and workflows for enhanced efficiency.
• Best Practices, Troubleshooting, and Training Resources: Jessica concluded with a review of best practices for data import, troubleshooting common errors, and promoting available training resources such as self-paced courses, video tutorials, and the Bermuda knowledge base.
  • Troubleshooting and Error Handling: Jessica advised participants to use the import checklist and system logs to diagnose and resolve import failures, emphasizing the importance of reviewing error messages and correcting data before re-importing.
  • Training and Support Resources: Jessica highlighted available training options, including virtual and on-site knowledge transfers, video tutorials, quick guides, and the Bermuda knowledge base, encouraging participants to utilize these resources for ongoing learning.

• Data Mapping Inventory Distribution: Send the data mapping inventory document via email to participants who did not receive it and requested it in the chat. (Jessica)
• Survey and Poll Participation: Share the survey link and ensure all participants complete the survey and poll for feedback on the session. (Jessica)
   

© 2025 Permuta. All rights reserved.

DefenseReady is a registered trademark of Permuta Technologies Inc. Microsoft Dynamics Customer Relationship Management (CRM) is a trademark of Microsoft Corporation. Other Trademarks and trade names may be used in this document. Permuta disclaims any proprietary interest in any trademark other than its own.