search

derdilla / blood-pressure-monitor-fl

A cross platform app to save blood pressure values with export function
MIT License
66 stars 11 forks source link

Exporting medication data #326

Closed Nanacho closed 2 months ago

Nanacho commented 3 months ago

Thanks for the work on the app so far! I recently started using it since my doctor asked me to start keeping track of my BP, but I couldn't find a way to export medication usage along with the actual readings. Is there currently a way to do that?

derdilla commented 3 months ago

Unfortunately not.

When I build the feature it was a rather special case (it's not even in the main db) that didn't integrate with the export mechanism and at the time I didn't see a clear way to export it. This feature is planned nonetheless: The first step of unifying the db is well underway in #257. This will already show it in db export. In a second step intakes will be added to CSV export, either as a optional column or by exporting JSON (lots of boilerplate) or ZIP/TAR archives (harder to work with) as proposed by xandro0777. Any further input on this is highly appreciated. Implementing custom export might take longer as I would implement it in a more decoupled fashion to improve maintainability (#305)

Nonch commented 3 months ago

Awesome! I'm glad to hear this is planned, and that the ability to record it is there to begin with. I look forward to the ability to export so I have something to show my doctor at some point.

I did look through a database export to see if I could create a spreadsheet from that using a script or something, but I wasn't really able to find the medication entries. I might have to take another look. I may also just be misunderstanding that this is an upcoming feature rather than something already implemented, in which case I will happily wait. This app has already been invaluable to me as it is!

As for exporting to .csv, I think it would be fine to have a column for each medication, defaulting to null or 0, for each timestamp. And if the medication is the only input, to leave the BP and HR readings as null would also be fine. I don't know how that would affect a spreadsheet program's statistics calculations though. Another way to do it would be to add a column for medications in general, and just pile them all in as text:

Suggestion 1: Timestamp SYS DIA HR thinneryl anemaway
1449777600 null null null 20 10
1436295600 120 75 75 null 10
Suggestion 2: Timestamp SYS DIA HR Medications
1343674800 null null null thinneryl(20),anemaway(10)
1610136000 120 75 75 anemaway(10)

I think I would prefer the first approach, but I would just like something convenient to give my doctor.

Seriously, I cannot thank you enough for your work here; I've been using this app every day. So many other apps I found were riddled with ads and microtransactions, or wanted me to set up an account with something.

Cheers!