deeemm/acqua

Acqua - Data Acquisition and Processing unit

DeeEmm

Waxing lyrical about life, the universe and everything software related since lunchtime 2006.

https://DeeEmm.com
https://deeemm.github.io/DeeEmm/

Latest Blog Posts

Open Hardware Licensing
Fusion 360 Plasma Post Processor - Combining Files
ESPduino + Protoneer CNC Shield
Installing FlatCAM on OSX Big Sur
Sienci Mill One Upgrades
Proma THC Setup
Plasma Upgrade
Robot Laser Scanner
[RANT] Bloatware
Acqua - Implimenting Datatables

Stats

Donations / Sponsors

If you have found anything that I do of use, note that I don’t ask for beer, coffee or patreon donations, I just ask that you pay it forwards with a random act of kindness.

Last Updated Sunday, 11 August, 03:52 GMT+9:30

acqua's Issues

Implement Error Handlers

Need to test for errors (Out of range etc)

Populate datagrid and chart with data when trend in list clicked

List of trends in sidebar need to be displayed on chart and datatable when requested

• Click on title to activate
• datatable populated
• chart populated
• can be run from on-click event

Add Notes field to Nodes

Ability to make notes against nodes

Example Notes:

• location
• cost
• service date
• etc

Basic text field required as place to make notes

Implement note data type

Include ability to make a note

• is included in history log
• can be filtered to view list of notes
• or viewed alongside other log entries in history
• possibility of attaching notes to other data?!
• Reliant on Log / History function #7

Improve sidebar template

Sidebar template does not scale well or work over range of screen sizes.

Needs to be looked at!!

• Should work for loooooong trend names
• admin functions need to be hidden
• List of trends only in sidebar

Chart display to show filtered datatable data

When datatable view is filtered. Chart should be updated to match filtered data.

• datatable is filtered
• visible datatable data is used to update chart

Implement log / history function

All actions recorded as entry into log / history database table.

• Could possibly be an extension of the trend table (timestamp / type / value)
• Log should show both automated and manual results and log entries side-by-side #6

Package for deployment

Package project for deployment

Need to set up environment

• Auto Run when started (contab -e)
• Install dependencies (dependencies.txt)

Develop basic Nano code library to integrate simple sensors

Establish basic boilerplate for nano.

Configuration file:

• determines sensor type
• enables features

--Serial API to: --

• Return sensor data
• Watchdog response
• Identify itself on network search
• Provide status via Arduino Serial debug interface

Develop basic time based controls

Create basic CRON based actions

• Activate periodically (timebase)
• Activate on future date

Advanced:

• implement circadian cycles for lighting control
• also advanced lunar cycles

Add basic RPi Control

Reboot / Shutdown / Reload

Add additional CRUD actions to chart data on trend page

Ability to Create / Update / Delete records shown in data table view.

Notification - Control Schema action

Creation of a manual reminder system by allowing creation of a 'notification' Control Schema action

Control Schema can be triggered by CRON

This can provide a calendar style reminder system that will allow reminders to be set for any future time/date combination

Future reminders can also be associated with other actions by creating the relevant 'Control Schema'

• Basic notification can display within app via notifications window
• Notifications can also be sent via email
• Notifications can be repeated at a set frequency

Notification comprises of

• Title
• Text body
• DateTime
• Repeat Frequency

Establish communication between RPi and Nano

• Define I2C connections
• Establish communications
• Add setup to admin page

Develop basic communication protocol between RPi and Nano (API layer)

Serial API for comms.

• Determine basic protocol
• handshake
• checksum
• datapacket format

Create CRON Function

Creation of CRON helper function for managing trends

• CRON entry needs to be created for all trends with automatic update

• CRON entry needs to be modified when trend update frequency changed (trend admin)

• CRON entry needs to be deleted when trend deleted

• CRON not run if trend update frequency is set to 'never'

• Portable CRON selector form which can be integrated into other administration functions

• DateTime (future date)

• Periodic Repeat

• Output from form creates relevant CRON function / action

Develop basic event based controls

Monitor for:

• change in sensor data

• Sensor value exceeding limits

• other system events

• Poll criteria periodically via hardcoded CRON

• CRON needs to be created as part of system setup, which means that it needs to be added by code.

Branding image not showing on sub pages

Suspect path issue for branding image

• check and update path / template variables

Multiple trends on chart

Ability to display more than one trend on chart

• Auto scaling of chart required.
• Removal of limits required

Trend limits

Ability to display limits on charts - eg maximum and minimum target values

• Limits should be displayed as green opaque 'safe band' overlay
• Additional fields will need to be added to 'trends' data table

Popover dialog for entering and editing trend data

Form data should be hidden until needed.

• Add form data to hidden div.
• Display div when button clicked
• Display div in faux dialog