The legacy .SIF importer lived as a VBA/Access application that users triggered from a shared machine. It frequently crashed with no actionable error message, leaving the sales team unsure whether design quotes were imported into the ERP. The root cause was tight database constraints inside the ERP that would reject malformed or out-of-order data, but the desktop app gave no feedback or recovery path.

Because of this, quotes piled up, staff manually re-entered data, and teams wasted time double-checking whether imports succeeded.

I rebuilt the importer as a modern web app that guides users through a reliable, one-click import experience. Instead of silent crashes, the app validates quotes up front, surfaces clear messages when data needs attention, and automatically retries transient failures. Users can see progress, understand what succeeded, and know exactly what to fix when something does fail.

The end result is a predictable import process that saves rework and gives the business confidence that ERP data is accurate.

Frontend and UX

• Blazor Server + MudBlazor for responsive UI and consistent components.
• Inline validations and status indicators so users see real-time progress and actionable errors.

Backend and Processing

• .NET core services hosted on IIS to replace the VBA/Access executable.
• Imports .SIF design quote files and maps them to Syteline ERP schemas.
• Implements retry policies for transient failures (DB locks, network blips) with exponential backoff.
• Centralized logging to capture ERP constraint violations and surface them as user-friendly guidance.

Resilience and Feedback

• Clear success/failure receipts for each import batch.
• Guardrails to prevent partial imports and ensure data stays consistent with ERP constraints.

• One-click .SIF file import into Syteline ERP.
• Front-loaded validations with descriptive feedback instead of silent crashes.
• Automatic retries for transient errors; safe abort for hard failures.
• Detailed activity log so support teams can audit each import.

The importer no longer crashes without explanation, and users get immediate guidance when data needs correction. Import throughput increased because transient issues are retried automatically, and support teams spend less time chasing down failed loads. The ERP maintains data integrity while the business gains a reliable path to move quotes from design tools into production workflows.