Production equipment and line programming
PLC programming, line commissioning, motion control and recipe handling — greenfield projects and extensions to existing systems.
Manufacturing IT · Industrial automation
Your production line is talking.
I translate it for management.
Pálfi Attila István E.V. — programming and optimisation of production equipment and lines, OEE data collection, industrial PC/PLC/SQL integration, plus design and operation of database servers.
- OEE
- 87.4%
- Downtime
- −31%
- PLC cycle
- 12 ms
- Data points / day
- 2.4 M
Machine status · liveOnline
OEE
87,4
SQL
1,2 TB
App
iOS
Shift performance · 7 days
› S7-1500 · DB100.OEE_ACTUAL → OK
› SELECT plant, shift, oee FROM kpi_factory WHERE ...
› OPC-UA · NodeId=ns=3;s="Line1.Counter" → 4 812
› INSERT INTO downtime_log (reason, minutes) VALUES ...
Services
From the machine to the database, from one hand
Not a set of separate projects: the machine signal, the server and the management report run on the same chain. That keeps the numbers current instead of back-calculated.
Optimisation and OEE data collection
Cycle-time and loss analysis, building OEE measurement at machine signal level, with real-time feedback for the shift.
Industrial PC / PLC / SQL connection
OPC-UA, Modbus, Profinet and custom protocols interfaced to an industrial PC, writing straight into the database.
Reports and analytics
Production planning, shift and machine level reports, automated monthly and annual management summaries.
Database servers
Design, installation, indexing and performance tuning, backup strategy and continuous operation.
iOS / Android applications
Shop-floor mobile apps for downtime logging, maintenance tickets and remote machine status checks.
Downtime and maintenance tickets
Capturing reasons and reporting them back to maintenance, with a fully traceable lifecycle.
Statistics from maintenance tickets
Recurring faults, MTTR and availability analysis — decision support for improvements.
Approach
Four steps to a measurable plant
The work starts on the production line and ends with the management report. No stage is handed over to someone else — the program, the server and the application all come from the same hand.
Data security
All data stays on the company's own infrastructure. No external cloud dependency, solutions running on your own SQL server.
01
Assessment at the machine
We walk the line: what can be measured today, what is missing, where the time is lost. Written findings and a priority order.
02
Building the connection
Extending the PLC program, OPC-UA / industrial PC interfacing, so signals arrive clean and time-stamped.
03
Database and server
Data model, server installation, indexing and backup. The collected data is stored in a structured, queryable form.
04
Reports and apps
Technical and management reports, a mobile app for downtime logging. Live operation with ongoing support.
Manufacturing IT tools
What is worth measuring at the end of the shift
Not a reporting spreadsheet but a working system: data coming from the machines and the maintenance tickets meet in the same database. All three tools are live demos you can try with your own data.
Real-time measurement Live demo
Live demo
OEE report
OEE for three production lines calculated from a real database: hourly, daily, monthly and yearly breakdowns.
- Availability, performance and quality separately
- Ranked downtime reasons, shift-by-shift comparison
- Management report in one click
Live demo
Maintenance app
iOS and Android maintenance ticketing: reporting from the machine, execution, closing and confirmation.
- Report in 30 seconds, ordered by urgency
- Downtime reason and lost time captured on site
- The same database as the OEE report
Live demo
Power BI report
A management dashboard in Power BI style: aggregated OEE, monthly trend, downtime reasons and a shift comparison in a single view.
- Monthly OEE trend and line-by-line comparison
- Downtime reasons and shifts in one view
- Print-ready, multi-page report
Sample websites
Sample websites, live
Every sample runs with its own AI assistant and appointment booking saved to a database. Bookings never collide: only one guest can take a slot.
AI assistant Booking to database
Auto Service
Dark, high-contrast workshop interface
AI digital mechanic for fault diagnosis, service appointment booking without collisions.
Open the sample
Hair Salon
Light, minimalist aesthetic
AI style advisor that offers a free slot based on the service and the stylist.
Open the sample
Technical Webshop
Technical datasheet logic
AI parts finder based on technical parameters, with fitting appointment scheduling.
Open the sample
Jewelry Boutique
Dark boutique with gold light
AI jewelry advisor for material and sizing choices, private viewing one guest at a time.
Open the sample
Garden & Landscape
Light, green garden mood
AI garden advisor for plant choices, on-site survey booked without collisions.
Open the sample
Medical Booking
Clean, clinical blue interface
AI patient routing to the right specialty, with free slots updating in real time.
Open the samplePartners
What the shift and the management say
These are not numbers measured in a showroom: they come from live plants where machine signals, the database and the reports run on one chain.
Optimisation results
+21%
OEE in one year
−34%
Unplanned downtime
3×
Faster reporting
Until then we only saw the lines at the end of the shift. Now we see where we stand at the machine, and the management report builds itself.
+21%OEE in one yearProduction manager
Plastics plant · 3 production lines
Maintenance requests stayed on paper. With the app the report comes straight from the machine, and downtime reasons finally became measurable.
−34%Unplanned downtimeMaintenance lead
Food packaging plant
Queries used to run for minutes on the old server. After the rebuild the daily and monthly reports are ready in seconds.
3×Faster reportingPlant engineer
Automotive supplier
Contact
Introductory meeting
A 45-minute conversation is enough to see where production time is lost and what is worth measuring first. You can book the slot right here.
Automatic scheduling
The booking goes into the calendar and I confirm it by email.
AI assistant
If you are not sure which service you need, ask the assistant on the site — it guides you all the way to booking.
- info@new-smart-factory-flow.com
- +36 30 303 3350
- Hungary · on-site assessment with travel