General

How to Sync FTP CSV Files to a PostgreSQL Database

Poll an FTP CSV file with Python to MQTT and store typed rows in PostgreSQL.

Dataflow

How it flows

Actions, models, routes and the topics that link them. Click a node to trace its flow.

What this template does

Build a zero-middleware historian for legacy devices that drop CSV files on FTP. A Python reads the latest non-empty row from the file, detects changes, and new readings are published to MQTT and stored in PostgreSQL with a typed model.

When to use it

Use this template when you need to ingest file-based telemetry from older systems.

The notebook

What’s inside

Browse the markdown and code cells before you download.

LoT Notebook:ftp-csv-historian-to-postgresql.lotnb
Related use cases

Similar templates

Templates chosen for overlap in routes, tags, and category.

View all in General

Get this template

1 file · 5 downloads