On 10/09/2020 20:38, NY wrote:
> Yes I'd already identified that cron would be a good way of triggering
> the upload. It's a matter of working out what can be run (via cron) at
> the Pi which makes a remote web server add data to an SQL database held
> on its server, preferably searching for each row of data that is about
> to be added to check that it doesn't already have it - to make the
> process resilient to temporary outages which would otherwise cause it to
> miss data if there was no catchup mechanism.
As I said, 'curl' will send data to the server, as long as you can get
data to the command line of curl...

server side PHP to access an SQL database is tedious, not hard.

>
> It's on the "round tuit" list - a nice little refinement to what I can
> do locally at present by searching the local CSV files that Cumulus
> creates.
>
>
> I'll probably write the query-and-display software first, manually
> uploading each month's data into the SQL table, and leave the automatic
> cron-driven uploading with resilience until later.

Seriously the cron driven stuff is trivial.

And a PHP script to load the data into a database is also pretty damned
trivial.

Takes a lot longer to design a pretty UI with knobs on..


--
You can get much farther with a kind word and a gun than you can with a
kind word alone.

Al Capone

--- SoupGate-Win32 v1.05