
Open
Posted
•
Ends in 2 days
Paid on delivery
Printflow V2.3 — Simplified Specification Version 2.3 · Purpose: Telegram-based production tracking, material control and reporting for one printing / paper-bag manufacturer. 1. Principles • PostgreSQL is the system of record. The LLM only extracts and answers; it never writes SQL or changes data directly. • Every extraction and every operator entry is confirmed by a human with Edit / Approve / Reject before it is saved. • Never invent missing data. Anything the PO does not state stays blank/UNKNOWN until a person fills it in. Colours stay free text. • History is append-only: corrections are new events, never silent overwrites. • No features beyond this document. Simple, deterministic, auditable. 2. Architecture Telegram (long polling) → ONE LLM → typed Python tools → validation → PostgreSQL (+ event log). No web UI, no agents, no OCR, no webhooks. 3. Tech Python 3.12 · PostgreSQL · python-telegram-bot (long polling) · one LLM · PDF text extraction (digital PDFs only) · ReportLab · Docker Compose (app + Postgres). 4. Roles (allow-list of Telegram IDs) Owner: uploads PDFs, types orders, approves extractions, records deliveries, asks questions, requests reports, assigns operators to stations, corrects operator entries. Operator: no PDFs, no questions, no reports, no inventory balances. Only the production entry flow for their assigned station. About 6–10 operators; several can share a station. Stations: printing, laminating, foiling (optional), die cutting, finishing (finishing includes gluing). Every action is logged with the user's name. 5. Universal confirmation pattern 1. Input arrives (PDF, typed order, operator entry, delivery). 2. LLM extracts to a draft (status PENDING). 3. Bot replies with a readable summary and Edit / Approve / Reject. 4. Approve saves and logs an event. Reject discards and logs. Edit asks which field, takes the new value, redraws the summary. 5. Drafts expire after 7 days. Customer/supplier matching: MATCH (shown), POSSIBLE MATCH (pick a candidate or New), NO MATCH (button New customer / New supplier, created from extracted details after one more confirm). Never merge silently. 6. Owner flows Customer PO PDF or typed order → extract customer, quantity, dimensions, lamination type, printing, foiling, handle type, handles per bag (usually 2, sometimes 3), unit price, delivery time, VAT no., and every material the PO states for each station → match customer → confirm → creates one Job per product line (each with its own Job ID, stations and planned materials, all sharing the PO number) and sends one Work Order PDF per job (A4: Job ID, customer, product, quantity, tolerance, order date, due date, specs). A PO with one product creates one job. Source recorded as CUSTOMER_PO or TELEGRAM_TYPED_ORDER. Line value = quantity × unit price; no VAT/discount assumed. The job's station list and order come from the PO (e.g. plain job: printing → die cutting → finishing; laminated: printing → laminating → die cutting → finishing; foiled: add foiling). The owner can edit stations and planned materials at the confirm step. Planned handles = bags × handles per bag (calculated by the app, shown for confirmation). Supplier delivery note / waybill PDF → extract (supplier, VAT, number, date, material lines) → match supplier → confirm → goods-received record that adds to inventory. Supplier invoice PDF → extract → confirm → stored for reporting only. No matching, payables workflow or payments. Customer invoice PDF → extract → link to job → confirm → stored for reporting. Duplicate check on document number + supplier/customer before the buttons appear. One file at a time. 7. Operator production flow 1. Operator sends a Job ID. Bot checks the job exists and includes the operator's station. 2. Bot asks one at a time: Starting quantity? Good quantity? Waste quantity? (whole numbers, sheets or bags as applicable). 3. App checks start = good + waste. On failure: message and re-ask. 4. Materials step (skipped if the station has none): the bot shows the planned materials for this job and station and asks "Is this correct?" with Correct / Edit. Edit changes a quantity or picks a different inventory item from the list allowed for that station. If nothing was planned, the operator types the quantities (flagged for the owner). 5. Summary (job, station, operator, numbers, materials) with Edit / Approve / Reject. Approve saves a production entry.
Project ID: 40745677
184 proposals
Open for bidding
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
184 freelancers are bidding on average €585 EUR for this job

⭐⭐⭐⭐⭐ Build Telegram Production Tracker for Printflow V2.3 with Python & PostgreSQL ❇️ Hi My Friend, I hope you are doing well. I checked all of your project requirements and I can see you are looking for a Telegram‑based production tracking system. You have no need to look any further as Zohaib is here to help you! My team is already doing 50+ similar projects for production monitoring. I will build a clean python‑telegram‑bot that extracts PDF data, creates draft events, and logs every approval in PostgreSQL. I will also add Docker Compose setup and free testing help in the same budget. ➡️ Why Me? I can easily do your tracker as I have 5 years of experience in Python, PostgreSQL, Docker, telegram‑bot, PDF extraction, and event logging. Not only this, I have a strong grip on data validation, audit trails, and API design. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing with you in chat. ➡️ Skills & Experience: ✅ Python 3.12 ✅ python‑telegram‑bot ✅ PostgreSQL ✅ Docker Compose ✅ PDF Text Extraction ✅ ReportLab ✅ Event Logging ✅ Data Validation ✅ Audit Trail Design ✅ Long Polling ✅ Typed Python Tools ✅ Production Workflow Waiting for your response! Best Regards, Zohaib
€350 EUR in 2 days
8.0
8.0

Hi, This is Elias from Miami. I checked your Printflow V2.3 specification and understand you need a simple, auditable Telegram production system using Python, PostgreSQL, one LLM, and deterministic typed tools, with human approval before anything is saved. I’ve worked with Python, PostgreSQL, Telegram bots, LLM integrations, PDF extraction, Docker, and workflow systems where validation, permissions, and audit history are critical. I’d implement the database and append-only event model first, then build the owner/operator flows with strict role permissions, draft confirmation, duplicate checks, inventory/production logic, and PDF work orders. I’d keep the LLM limited to extraction and answering, with all database changes going through typed Python tools and validation exactly as specified. I have a few questions for clarification: Q1 – Do you already have the exact PostgreSQL schema, or should I design it from this specification? Q2 – Which LLM provider/model do you want to use, or should I recommend one? Q3 – Do you have sample customer POs, supplier documents, and Telegram production workflows available for testing? Looking forward to hearing from you.
€500 EUR in 7 days
7.8
7.8

The principle that shapes this whole build is that the LLM extracts but never touches the database — so I'd enforce that in the architecture, not just by convention: the model returns a typed, structured object, that passes through Python validation, and only committed, parameterised tool calls write to Postgres, which means the LLM physically cannot emit SQL or invent a row. Every extraction and operator entry goes to a human Edit/Approve/Reject step before it's saved, and I'd make "Never invent missing data" concrete by having the extractor emit explicit UNKNOWN for anything the PO doesn't state, with colours kept free text, rather than letting the model guess to fill a field. History stays append-only — corrections are new events linked to the original, never overwrites — so the event log is a true audit trail. Roles are an allow-list of Telegram IDs checked on every handler, so an operator simply cannot reach PDFs, reports or inventory. Long polling, digital-PDF text extraction only, ReportLab for reports, all in Docker Compose with Postgres. And strictly nothing beyond the spec. I'd build it station by station so you can approve each flow. Available to start immediately.
€250 EUR in 1 day
7.0
7.0

Hi, I can build the Printflow V2.3 system as specified. I understand the Telegram-based workflow, owner/operator permissions, PDF extraction, confirmation steps, PostgreSQL records, production tracking, inventory control, reporting, and Docker setup. I’ll keep it simple, reliable, and fully aligned with your specification, with proper validation and audit history. I’m ready to start.
€250 EUR in 1 day
7.2
7.2

Hi there, I can build Printflow V2.3 as a controlled production system where Telegram is the operator interface, PostgreSQL is the unquestionable system of record, and the LLM is strictly limited to extraction and answering. Every change will pass through validation and explicit human approval, giving you a traceable system with no silent overwrites, invented values or uncontrolled AI writes. The implementation will be built around Python 3.12, python-telegram-bot long polling, PostgreSQL, typed Python tools, ReportLab and Docker Compose. I’ll enforce the business rules in application logic, not rely on the LLM to enforce them. Customer/supplier matching will never silently merge records, drafts will remain PENDING until approval, corrections will create new append-only events, and role/station permissions will restrict exactly what each Telegram user can do. Production entries will validate starting = good + waste, while jobs, planned materials, inventory, documents and every approval/rejection remain auditable. You will receive a production-ready Telegram bot, PostgreSQL data model, LLM extraction pipeline, confirmation workflows, job/material/inventory management, production tracking, document processing, Work Order PDFs, reporting, audit trail and Docker deployment. Can you provide 2-3 anonymized sample PO and supplier delivery PDFs so I can design the extraction schema and confirmation flow around the documents you actually receive? Warm Regards, Aneesa.
€250 EUR in 2 days
7.0
7.0

Hello, Printflow V2.3 Developer {{{ I HAVE CREATED SIMILAR TELEGRAM, PRODUCTION TRACKING AND DOCUMENT EXTRACTION SYSTEMS BEFORE AND I CAN SHOW YOU }}} I have 11+ years of software development experience and can build this deterministic Telegram-based production system using Python 3.12, PostgreSQL, python-telegram-bot, one LLM, ReportLab and Docker Compose. I understand the key rules: PostgreSQL remains the system of record, the LLM only extracts/answers, every action requires human confirmation, nothing is invented, and all corrections are append-only events. I can implement the Owner/Operator permissions, PDF and typed-order extraction, customer/supplier matching, job creation, Work Order PDFs, inventory receiving, invoice records, production station workflow, quantity validation, material checks and full audit logging. The Telegram flow will follow the Edit / Approve / Reject pattern throughout, with 7-day draft expiry and strict station-based operator access. I will keep the implementation limited to the supplied V2.3 specification without adding unnecessary features. I will provide Docker Compose setup, PostgreSQL schema/migrations, source code, tests, documentation and deployment support. Thanks, Christina
€250 EUR in 7 days
6.7
6.7

Hi, I understand you need a simple and auditable Telegram production tracker for one printing and paper-bag manufacturer. I will build the Python service around PostgreSQL as the only source of truth, with typed API tools, strict validation, append-only event history, role-based Telegram access, and clear human confirmation before anything is saved. Data Processing will cover PDF text extraction, order and delivery drafts, production entries, inventory updates, duplicate checks, reports, and generated Work Order PDFs. SQL will be kept inside controlled application functions so the LLM cannot write queries or change records directly. I will use long polling with python-telegram-bot, Docker Compose, draft expiry, station permissions, and Edit / Approve / Reject flows exactly as specified. The operator flow will enforce whole-number checks and start = good + waste before approval. Which PDF samples and report formats should be used first to verify extraction fields, inventory calculations, and generated Work Order PDFs? I will keep the implementation limited to the documented features, with no web UI, agents, OCR, or webhooks.
€750 EUR in 17 days
6.4
6.4

Hello Mate!Greetings , Good evening! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in Database Design, Docker, Data Management, Chatbot, Database Development, Database Administration, API, PostgreSQL, Data Processing and Python. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. "Is this correct?" Looking forward to hearing you back and discussing all details.. Appreciate your prompt response
€555 EUR in 5 days
6.2
6.2

I can build your Telegram-based production tracking and material control system for your paper-bag manufacturing workflow using Python 3.12, PostgreSQL, and python-telegram-bot with long polling. I understand the core requirements, including the strict append-only history, the universal human confirmation pattern with Edit, Approve, and Reject options, and handling role-based access for the owner and operators. I will implement the extraction pipeline for customer POs, supplier delivery notes, and invoices, ensuring everything is verified before saving to the database. The system will handle the complete operator production flow, validating quantities where start equals good plus waste, tracking planned materials, and generating the necessary ReportLab PDFs for work orders. My background includes building robust backend systems, integrating LLMs for data extraction, and working with PostgreSQL and Docker Compose setups. Let's discuss the details of your specification and get started.
€500 EUR in 7 days
6.1
6.1

Hi, I'm Denis, a full-stack developer with experience building production tracking systems and Telegram bots handling real-time data collection with strict audit requirements. I understand Printflow V2.3: a production tracker where Telegram is the interface, PostgreSQL is the source of truth, and every data point requires human confirmation before saving. The system tracks jobs across stations, manages inventory, and maintains a complete append-only history with full traceability. I've built similar systems where multiple operators log production data at different stages with complete auditability. The key challenge is making the confirmation flow fast enough to avoid frustration while keeping data clean. My approach: start with the database schema and event log structure, then build the Telegram bot with your universal confirmation pattern. Next, add LLM extraction and Python tools, followed by role-based access control and PDF generation for work orders and reports. Docker Compose handles deployment. One critical focus: customer and supplier matching logic. Getting MATCH, POSSIBLE MATCH, and NO MATCH right keeps the operator experience simple—confirm once and move on. The main risk is scope creep on LLM extraction. PDFs vary widely, and pursuing perfect field extraction will slow everything down. I recommend starting with core fields (customer, quantity, materials, dates) and letting operators handle edge cases. This keeps the system reliable and fast. I can start im
€250 EUR in 3 days
6.2
6.2

Hi, I built a secure ingestion pipeline where extraction stayed deterministic and every step ran in Docker, close to the PENDING draft and Edit/Approve/Reject pattern you want here. Secure CI Pipeline & Deterministic Ingestion: 5-star, client said we got the app to a great start. One thing I want to pin down: the start = good + waste check on operator entries. Do you want the bot to hard-reject and re-ask the whole flow, or let the operator correct just the failing number and keep the rest? That decision changes how the event log reads later. For the PDF side, we've used the OpenAI API to extract from digital PDFs and answer from them without touching the data store, same principle as your "LLM extracts, Postgres is the record" rule. AI Chatbot for University Portal: built on PDF manuals and OpenAI. I'd start with a milestone on the PO extraction plus one Work Order PDF so you only release on working output. Which station should materials-planning cover first? Adil
€250 EUR in 7 days
6.0
6.0

Hello, I went through your project description and understand you need a deterministic Telegram-based production system where PostgreSQL will remain the system of record and every AI extraction or operator entry will pass through explicit human confirmation. I’ll build the application in Python 3.12 using python-telegram-bot with long polling, PostgreSQL, a single LLM, digital PDF text extraction, ReportLab, and Docker Compose. I’ll implement typed tool functions between the LLM and database so the model will never write SQL or modify records directly. Every PDF extraction, typed order, delivery, and production entry will follow the PENDING → Edit/Approve/Reject workflow, with validation, seven-day draft expiry, duplicate checks, append-only event history, and no silent data invention. Customer and supplier matching will remain explicit, while jobs, station assignments, planned materials, inventory receipts, invoices, and production quantities will be enforced through PostgreSQL-backed rules. A project blueprint will be shared within 24–48 hours of award. To scope your project clearly, I would like to ask: do you already have the PostgreSQL schema defined, or will I design it from this specification? I’ll keep the implementation strictly within V2.3, auditable, maintainable, and production-ready. Best Regards, Imran
€250 EUR in 2 days
6.2
6.2

Hi, I can build Printflow V2.3 as a deterministic Python 3.12 Telegram bot with PostgreSQL as the sole system of record, following the defined confirmation, validation and append-only event rules. I’d implement the owner/operator role separation, PDF extraction for digital documents, typed orders, job/station/material workflows, inventory receipts, production entries, duplicate checks, Work Order PDFs and reporting through typed Python tools, with the LLM restricted to extraction and answering only. Docker Compose would package the application and PostgreSQL for a reproducible deployment. Question 1: Do you already have the initial PostgreSQL schema/data model defined, or should the implementation derive it directly from this V2.3 specification? Question 2: Which LLM provider/model should be used for the extraction and question-answering layer, and do you already have the required API credentials? Regards, Houssame.
€250 EUR in 3 days
6.5
6.5

I got you! I can build Printflow V2.3 exactly as specified: a Telegram-based production tracking system with PostgreSQL as the source of truth, human approvals, append-only event history, operator station flows, PDF extraction, reporting, and Docker deployment. I’m ready to handle the full project specifics, keep it simple and auditable, and I’m young, a fast learner, and available 24/7. Get the demo first before you pay. Two quick questions: Which LLM provider do you prefer for extraction, or should I choose the most reliable/cost-effective option? Also, do you already have sample customer POs, supplier delivery notes, and invoice PDFs for testing the extraction flow? Let’s chat and discuss these answers so I can start with the right structure. Kind regards, Haroon Z
€750 EUR in 1 day
5.8
5.8

Hi, PostgreSQL should remain the source of truth. I’d build the bot so the LLM produces typed drafts and answers questions, while deterministic Python validation and explicit human approval control every database write. The full V2.3 scope includes owner/operator permissions, digital-PDF and typed-order flows, customer/supplier matching, duplicate checks, append-only history, job and work-order creation, inventory receipts, station production entries, reports and Docker Compose deployment. Fixed price: €18,000. Timeline: 10 weeks. Milestones: bot, access control, database and event log, 2 weeks/€3,500; document, customer and supplier flows, 3 weeks/€5,000; jobs, inventory and operator workflows, 3 weeks/€5,000; reports, testing and deployment, 2 weeks/€4,500. Assumes digital PDFs follow the supplied layouts and one LLM provider and its API costs are client-funded. OCR and features outside V2.3 are excluded. Before finalizing, I’d confirm whether approved production entries deduct materials from inventory.
€18,000 EUR in 70 days
5.8
5.8

The first implementation pass would lock PostgreSQL as the audit-safe system of record, with the single LLM returning typed drafts only—never SQL—and every PDF, typed order, delivery, and operator entry passing through Edit / Approve / Reject before persistence. I’ll deliver the Docker Compose app with Python 3.12, long-polling bot flows, role/station permissions, customer and supplier matching, digital PDF extraction, append-only event history, inventory and production records, Work Order PDFs, invoices, and owner reporting in 7 days. I’ll keep the logic deterministic: unknown PO fields remain blank, duplicate documents are blocked, and production quantities enforce start = good + waste. My SwiftKhata product includes shared inventory and POS workflows across web, desktop, and mobile, which maps well to your material-control requirements. Should operators be allowed to select any inventory item approved for their station, or only the items planned on each job? Muhammad Saad
€250 EUR in 7 days
5.5
5.5

I can build the Printflow V2.3 Telegram production tracker as a deterministic, auditable Python 3.12 application backed by PostgreSQL. The implementation will follow your specification closely: long polling with python-telegram-bot, typed tool boundaries, human-confirmed extraction and entries, append-only event history, role and station permissions, customer/supplier matching, duplicate checks, inventory receipts, production validation, and report generation. I’ll keep PostgreSQL as the sole system of record and ensure the LLM only extracts and answers, never writes SQL or modifies data directly. I’ll structure the system with clear workflows for PO and delivery-note PDFs, typed orders, operator production entries, material controls, job creation, Work Order PDFs, invoices, and owner corrections. Docker Compose will provide a reproducible app and PostgreSQL environment, with validation for quantities, station access, unknown values, draft expiry, and every approval decision. The result will be simple, testable, and aligned exactly with the documented scope, without adding a web UI, agents, OCR, webhooks, or unrequested features. I’m ready to turn this specification into a reliable production workflow with focused milestones and thorough testing.
€555 EUR in 4 days
5.4
5.4

Hello, Your real challenge is not merely connecting Telegram to PostgreSQL, it is preserving trust in every production number, material movement, and correction across a busy paper-bag operation. I can build this deterministic Python system around typed tools, human confirmation, append-only events, PostgreSQL validation, and clear role-based Telegram flows. I’ll implement the long-polling bot, PDF text extraction, draft approval lifecycle, customer and supplier matching, job/station workflows, inventory records, production reconciliation, ReportLab work orders, and Docker Compose deployment. SQL and Database Development will support an auditable data model, while Python and Database Administration practices will keep validation, permissions, backups, and event history dependable. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. We can begin by confirming the PostgreSQL schema, Telegram interaction screens, and document field rules, then deliver the core flows in reviewable milestones. For inventory, should each approved station entry immediately reserve and consume stock, or should the owner review material usage before balances change? Best regards, Asad I’d also like to clarify how inventory consumption should be represented when an operator edits planned materials, whether digital PDFs follow a consistent layout, and which reports are required for the fi
€250 EUR in 10 days
5.4
5.4

Printflow V2.3’s strict human-in-the-loop and append-only rules are exactly how production systems should be built. The LLM extracts, but PostgreSQL remains the single source of truth with zero silent overwrites. My Approach & Deliverables: Phase 1: Core Architecture & Owner Flows -> Build Python 3.12, PostgreSQL and Docker Compose foundation using python-telegram-bot long polling -> Engineer the universal Edit/Approve/Reject confirmation pattern and append-only event logging -> Implement Owner flows: PDF/text PO extraction, customer matching, Job creation and ReportLab Work Order PDF generation Phase 2: Operator Flows & Validation -> Build strict Operator production entry: Job ID verification, quantity math validation (start = good + waste), and material confirmation -> Implement supplier delivery/invoice extraction with duplicate document checks -> Deploy via Docker Compose and hand over documented source code Relevant Experience: - @VisualCrossingWeatherBot (Telegram bot handling structured data extraction, API integration, and deterministic user flows) Questions: 1. For digital PDF text extraction, do you prefer pdfplumber or PyPDF2 for the most reliable raw text output? ▪ 15+ years of Python, PostgreSQL and automation experience. ▪ Provide guide doc on completion. ▪ 30 days tech support included. Ready to start immediately. Let's discuss the details. Best, Raj
€600 EUR in 14 days
5.4
5.4

Your Printflow V2.3 specification is clear: deterministic execution where PostgreSQL remains the sole source of truth, the LLM strictly handles structured data extraction via typed tools, and all state mutations require explicit operator/owner confirmation. ✅ Build the complete Python 3.12 bot using python-telegram-bot long polling, role-based Telegram ID access, and Pydantic schemas for LLM extraction validation. ✅ Implement PostgreSQL schema with append-only event logging, draft expiration (7-day TTL), duplicate document checks, and strict inventory calculation logic. ✅ Develop the operator station workflows with numeric validation (start = good + waste) and dynamic material adjustment steps. ✅ Configure ReportLab generator for clean A4 Work Order PDFs and containerize the entire stack cleanly with Docker Compose. ✅ 10+ years production experience | 400+ completed projects | 320+ five-star reviews ✅ Microsoft® Certified: MCSA | MCSE | MCT & cPanel Certified (CWSA-2) Which LLM provider/model API do you plan to plug in for the tool-calling extraction (e.g., OpenAI gpt-4o-mini, Anthropic, or a self-hosted endpoint)? I can deliver this in 3 day(s) for 385 EUR and can jump on it right now.
€385 EUR in 3 days
5.1
5.1

Montreal, Canada
Member since Aug 20, 2025
$750-1500 CAD
$750-1500 CAD
₹150000-250000 INR
€250-750 EUR
$30-250 SGD
$750-1500 USD
$30-250 USD
$250-750 USD
$30-250 USD
₹1500-12500 INR
$250-750 USD
$750-1500 USD
₹12500-37500 INR
£750-1500 GBP
₹12500-37500 INR
₹12500-37500 INR
$30-250 USD
₹1500-12500 INR
$250-750 USD
$30-250 USD
$5000-10000 USD
$15-25 USD / hour