Real-Time MES-LIMS Data Integration

I run a lab with 8 separate pieces of equipment, each writing its test results to a local PC in Excel format. I need a lightweight, always-on service that watches those Excel files, validates every new line of data, and streams the approved values over our LAN to one central server. On that server I want a browser-based MES dashboard that shows every equipment’s live feed and historical records, while enforcing three clear roles: Admin, User, and Guest.

The data also has to reach our LIMS. A scheduled job should call the LIMS API at set intervals, package the latest validated records, and push them automatically; a manual “send now” button on the dashboard is a useful fallback but the schedule is the primary trigger.

Key deliverables
• Windows-friendly collector that monitors the eight source PCs and moves Excel data in near real time
• Validation layer (range checks, missing field detection, bad timestamp rejection) before anything is stored or forwarded
• Central server application with dashboard, role-based authentication (Admin/User/Guest), and search/filter of historical runs
• Scheduler that formats and posts data to the LIMS API, plus a manual push option
• Installation scripts, config guide, and brief user manual so my in-house team can adjust schedules or add more equipment later

Feel free to propose your preferred stack—Python, .NET, or Node are all acceptable as long as the final solution is stable on Windows, plays well with Excel, and is easy for us to support.