0xnf / ellen Goto Github PK

dbpath and xlspath do not use path.join like they should and instead default to ./

the MAX_SIZE config option doesn't do anything. It's goal was to delete rows or cycle the store after a size limit was reached, but was never impelmented

User should be able to specify the running port, defaulting to 5000.

need proper dependency installation

• openyxl
• pillow
• pyinstaller

use pyinstaller to create the exe

See also #12

Instead of keeping a rolling excel file updated and pruned according to the config keep settings, the file should be rolled over like how nlog does log rotations.

Example:
Config.Max_Keep_Days = 30
Ellen.xlsx last entry = 31 days ago

Result:
Ellen.xlsx -> Ellen_2020_08_18.1.xlsx
Format is: "Ellen_{YYYY}{mm}{DD}.{num_backups_with_same_date+1}.xlsx"

If multiple rollovers happen on the same day, the final number increments, for example, to: Ellen_2020_08_18.2.xlsx.

Any new incoming data will be placed into Ellen.xlsx like normal.

Proposal to add config option for storing Timezones in either the received format, or UTC time

TIMESTAMP_TZ=[UTC, Received]

Each of the 3 rows in the file are past the Max Keep Days Date, too.

See the attached xlsx file:
ellen.xlsx

This page should be a dead simple interface over the config settings.
If config has been deleted, saving the config should write the defaults + whatever changes the user selected

There are Server Settings, Maintenance Settings, and Save Setting, each should have their own section.

See also: https://flask.palletsprojects.com/en/1.1.x/tutorial/deploy/#run-with-a-production-server