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.

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