Data Import & Export

February 2026 · 4 min

Overview

The Data Import & Export module helps hospitals migrate data from legacy systems, import master data in bulk, and export data for external reporting or backup. It supports CSV, Excel, and JSON formats with validation, mapping, and error handling.

Data Import

Import data using the guided wizard:

1. Select Entity -- Choose what you are importing (patients, staff, inventory items, rate list, etc.)
2. Upload File -- Drag and drop a CSV or Excel file
3. Map Columns -- Match your file columns to Bio Ecko fields (auto-mapping for standard headers)
4. Validate -- System checks for duplicates, required fields, format errors, and referential integrity
5. Review Errors -- Fix issues in the error preview or download the error report
6. Import -- Execute the import with progress tracking

Importable entities: Patients, Staff, Doctors, Departments, Services, Rate List, Inventory Items, Vendors, ICD Codes, Medicine Master, Test Master.

Data Export

Export data for reporting or backup:

• Entity-based export with filter options (date range, department, status)
• Scheduled exports (daily, weekly, monthly) with email delivery
• Custom report builder with drag-and-drop field selection
• Export formats: CSV, Excel, PDF, JSON
• Bulk export with zip packaging for large datasets
• FHIR R4 export for interoperability

Data exports respect role-based access -- users can only export data they have permission to view.

Legacy Migration

For full system migration from another HMS/ERP:

• Migration planning template with entity dependency order
• Bulk import with transaction support (all-or-nothing per batch)
• Data cleansing tools (duplicate detection, format standardization)
• Parallel run support (import historical data while using Bio Ecko for new transactions)
• Migration verification reports (record counts, checksum validation)
• Rollback capability within migration window

API-Based Integration

For ongoing data synchronization with external systems:

• REST API for programmatic import/export
• Webhook-triggered data push to external systems
• ETL job scheduling for periodic data exchange
• Integration logs with success/failure tracking

See the API Reference section for endpoint documentation.

Notes

Related topics