SQL Dayfile table

kocher · Post by **kocher** » Fri 16 Oct 2015 4:00 pm

Currently the Dayfile table is updated at the end of each day.

How can you get to the table Dayfile actualize every 5 minutes?

Post by **steve** » Fri 16 Oct 2015 4:16 pm

Can I ask why you want to do that? Dayfile.txt is only updated once a day (it contains daily summaries), so updating the corresponding SQL table every 5 minutes would result in 288 copies of the same data.

kocher · Post by **kocher** » Fri 16 Oct 2015 4:25 pm

Thanks for your quick reply Steve.

I have explained wrong
I would like the last record (only 1 record) corresponds to the current day updated (overwrite) every 5 minutes

Post by **steve** » Fri 16 Oct 2015 4:31 pm

The last record is for yesterday. It doesn't change once written.

If you want a table with today's highs and lows so far, you could create a custom table and use today's web tags to populate it with data.

kocher · Post by **kocher** » Fri 16 Oct 2015 4:41 pm

OK

Thank you very much Steve

sfws · Post by **sfws** » Fri 16 Oct 2015 7:15 pm

You could write a php script using an appropriate combination of SQL calculations on dayfile columns and/or calculation using today web tags. So that is a variation on Steve's suggestion.

kocher · Post by **kocher** » Fri 16 Oct 2015 8:37 pm

Greetings sfws

Is it possible to know your script?

Cumulus Support

SQL Dayfile table

SQL Dayfile table

Re: SQL Dayfile table

Re: SQL Dayfile table

Re: SQL Dayfile table

Re: SQL Dayfile table

Re: SQL Dayfile table

Re: SQL Dayfile table