FacebookLinkedInPL

Data from different sources. Without the manual work.

I write integrations with station vendor APIs and automate downloading, converting and exporting data - so nobody has to do it by hand in Excel.

Every data source means a different format and manual work.

One vendor has an API, another drops CSV files on FTP, a third has its own format. Public archives are zipped and described with codes. Someone downloads all this by hand, unpacks it, turns codes into names and assembles it in Excel, and starts over with every change. It takes hours and mistakes come easily.

What you get

Data that gets where it should on its own.

01

Vendor API integrations

A separate parser for each vendor. In Wodowskaz, data from six vendors ends up in one database.

02

File import

Automatic retrieval and reading of FTP/CSV files, also from older devices and third-party stations.

03

Unified data

Codes and identifiers turned into readable names, one data structure for all sources.

04

Applications and exports

Ready CSV files or a small application with a table and chart, if you do not need a whole platform.

Technologies.

Data sources[01]
  • Station vendor APIs
  • FTP/CSV files
Processing[02]
  • Node.js
  • TypeScript
  • SQL
Deployment[03]
  • Docker
  • VPS
HydroScope
Desktop applicationEnvironmental dataAutomation

HydroScope

A desktop application that downloads data from IMGW stations on its own, decodes the codes and saves analysis-ready CSV files - with a built-in trend chart.

See the full case study
Wodowskaz
Data analysisSystem architectureIoT

Wodowskaz

Vendor API integrations in practice: data from six vendors, including FTP/CSV files from third-party stations, ends up in one database and on one map.

See the full case study

Common questions

Questions and answers.

Station vendor APIs, FTP/CSV files and public data archives. In real projects these include YSI EXO, In-Situ TROLL 500, Keller, Aqualabo, Aqua TROLL, Meteobot, IMGW and eDWIN.

First I check what data can actually be retrieved and in what format. If it can be done, I write the integration. If not, I tell you right away.

The integration then needs an update. If the system is under my ongoing care, I do it as part of maintenance.

No. HydroScope is a standalone desktop application that runs without a server. I match the scope to the problem.

A major strength of Silentbits is their deep technical expertise and ability to translate complex challenges into business-oriented solutions. The system operates reliably, is fast, and very well designed from a user experience perspective.

Ksawery Skąpski
Ksawery SkąpskiManaging Director, ENVISUM Consulting
5/5

Want the data from all your stations in one place?

Instead of several panels from different vendors - one system you can trust. Book a call: I will check what data your hardware provides and tell you what can be built.