I'm seeking a talented developer to build a browser-based web application that will frequently ingest and parse Excel files into a structured SQL database. This application will connect to a PLC via OPC UA to validate QR codes and exchange PASS/FAIL test results.
Key Requirements:
- Frontend: Using React + WebSockets, the frontend must display real-time, station-specific data on two monitor instances (Station 1 & Station 2).
- Backend: Leveraging Flask + Python OPC UA client, the backend will handle data synchronization, database updates, and OPC UA communication.
- Frequency: The application will check for new Excel files every minute.
- Data Validation: There will be strict formatting rules for data validation from the Excel files.
The solution should run on-premise, include a stubbed OPC UA server for testing, and deliver fully documented code, automated tests, and deployment scripts. Prior experience with SQL databases, React, Flask, and OPC UA is highly desirable.
---
Above is generated by AI of freelancer website. For more tech details , please find my PRD attached. Please check that and quote. To avoid spam, I have inserted a generic question, and request bidders to start their bid by answer to that question which would then help me filter for them.
I had similar but smaller requirement which I posted earlier earlier, but further conversation with client led to major changes, including major requirements of coordinating with PLCs as well. This PRD covers the IT part of total system. For OT part, I may post separately.
Hi there
We have 5+ years of experience in backend and frontend development, and your project aligns well with our expertise. We are well-versed in building real-time web applications using React, Flask, and WebSockets, and we have hands-on experience integrating with SQL databases and handling structured data ingestion from Excel files. Additionally, our experience with Python OPC UA client ensures smooth communication with PLCs for QR code validation and test result exchanges.
We’d love to go through your PRD to understand the finer details and discuss the technicalities, budget, and timeline. A one-on-one call would be the best way to ensure we are aligned on expectations and deliverables.
Thanks,
Binay
With extensive experience in software development and web development, I bring to the table solid expertise that aligns perfectly with the requirements of your project. My proficiency in React, Flask, MySQL and Python OPC UA client qualifies me to successfully build an efficient browser-based web application that will integrate seamlessly with your PLC system.
My familiarity with OPC UA will enable me to effectively implement data synchronization, handle database updates, and establish reliable and performant OPC UA communication. My development practices also prioritize automating tests which ensure quicker debugging and robustness in deployments. Being a diligent learner and quick troubleshooter, I can adapt to new challenges and hurdles efficiently, making certain the platform I create for you is bug-free, secure and fully documented.
In addition to the technical skills I bring to this project, it is important to mention my strong commitment toward delivering high-quality work within the agreed-upon timeframe. I understand the urgency for frequent Excel file ingestion as well as the need for strict data validation according to set formatting rules. I guarantee a real-time web app facilitating these functions aptly while providing station-specific data on two monitor instances for each station.
Hi,
I’m excited about the challenge of building a browser-based web application that ingests Excel files and interfaces with a PLC via OPC UA.
With over 5 years of experience in developing web applications using React and Flask, I can ensure that your application runs smoothly, with real-time data display on multiple monitors. I have a strong understanding of SQL databases, data validation, and API communication, which will streamline the integration with your existing systems.
Additionally, I will deliver well-documented code and automated tests to ensure maintainability. Let’s discuss your project in detail to tailor the solution to your needs.
Best Regards,
Irfan A
As an experienced web and mobile app developer with a strong background in backend using Node.js and databases such as MySQL, I am well-equipped to handle the challenges of your project. My proficiency in React.js for the frontend aligns perfectly with the desired WebSockets use for real-time data display for two stations.
I have previously worked on numerous projects involving data ingestion and parsing, which gave me the in-depth knowledge of writing robust code that can effectively connect, synchronize, update and communicate with databases. This would be valuable for your application which deals with strict Excel data validations while connecting with OPC UA to validate QR codes, receiving test result and updating SQL database.
Moreover, my understanding of automation and testing is well-founded - a critical need for your project. I can adeptly develop comprehensive documentation and deployment scripts ensuring easy operation even beyond completion. Lastly, I am committed to communication, timeliness, and most importantly YOUR satisfaction. Let's get started on actualizing your vision of a reliable, real-time web app! Contact me today!
With my comprehensive knowledge and experience in web development, I am confident that I am the ideal candidate to build your real-time web app for PLC validation. My expertise in JavaScript/ECMAScript, TypeScript, React.js, and Node.js perfectly align with your requirement for the frontend using React and the backend leveraging Flask + Python OPC UA client. I have a proven track record of flawlessly integrating front-end and back-end functionalities in applications such as yours.
Equally important, my familiarity with SQL databases and automated testing makes me well-equipped to handle large amounts of data from Excel files, validate them according to strict formatting rules efficiently, and maintain real-time synchronization with the database. My skills in utilizing WebSockets for the real-time display of station-specific data on multiple monitors further demonstrate my ability to meet your needs accurately.
Moreover, what sets me apart from others is not just my technical expertise, but also my solutions-driven approach to development. I am always looking for ways to improve efficiency and functionality while ensuring high performance. I believe this kind of commitment would be immensely valuable to your project. Let's discuss your unique requirements further so we can pave the way for a successful collaboration.
Greeting
I have carefully reviewed your requirements and am confident in delivering a robust browser-based web application that integrates React, Flask, SQL, and OPC UA for seamless Excel ingestion, real-time data display, and PLC communication.
✅ Why Choose Me?
Expertise in OPC UA & Flask – Strong background in Python OPC UA clients and real-time data exchange.
React + WebSockets Frontend – Ensuring smooth, real-time monitoring for Station 1 & Station 2.
SQL Database Handling – Efficient data structuring and validation from Excel files.
On-Premise & Fully Documented Code – Deployment-ready, scalable solution with automated testing.
Industry Experience – Familiar with PLC integration, strict data formatting rules, and real-time monitoring.
I've reviewed your PRD and am ready to discuss the IT-side implementation while considering future OT expansions. Let's connect and bring this project to life!
Looking forward to your response.
Best regards,
Parvesh Jangra
With great proficiency in software and web development, particularly in Node.js and React.js, my team and I would be an ideal choice for your important project. Your venture to build a real-time web application for PLC validation aligns perfectly with our skill set and experience. We have successfully developed similar applications that required frequent data ingestion, parsing, stringent data validation like the ones from the Excel files, and smooth OPC UA communication, accurately delivering PASS/FAIL test results.
In conclusion, our combination of competency in SQL databases, React on frontend along with Flask + Python OPC UA client at backend will help us craft the efficient, dynamic and user-friendly application that you're looking for. We are excited to contribute our technology-forward thinking to this project since we'd love valuable contributions we can make for digitisation of industrial automation processes. Let’s discuss further details from the .prd provided by you or any additional information so we could provide you precise estimation and timeline.
Hi Sir. My name is Hoan. I have a experience in PLC Siemens, Mitsubishi, Delta WPS, and devices config Modbus RTU/TCP, TCP, Profinet, Profibus in system, Weintek HMI, Siemens HMI,OPC UA, Excel. I hope we can cooperate with each other. Thanks sir
