topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 3:32 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Information Manager / Database for daily record of mood and health  (Read 5798 times)

Ampa

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 592
  • I am cute ;)
    • View Profile
    • MonkeyDash - 2 Player strategy boardgame
    • Donate to Member
Hey DCers,

I'm looking for an information manager in which to record health information such as temperature, diet, weight, mood, symptoms etc.

I know such things exist for specific conditions (eg Depression) but I'd rather use something generic that allows me to define the fields I'm interested in, and to specify them as check boxes, combo drop downs, multiple choice lists, free text, numeric etc.

I know that I could roll my own in a database such as MySQL or Access but that feels like overkill, and would involve building everything from scratch.

After a month or two of recording I'd like to output and analyse in Excel / Matlab.

My Google-fu has deserted me and I've not found the ideal piece of software yet - any thoughts?
Should be Windows based, ideally for free (or donation).

Thanks for any suggestions.

rgdot

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 2,192
    • View Profile
    • Donate to Member
How about Smart Diary http://www.sdiary.com/ ? The free version is limited but the full version is often on BdJ. Export to csv, etc. was planned last checked, might be available by now.


Ampa

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 592
  • I am cute ;)
    • View Profile
    • MonkeyDash - 2 Player strategy boardgame
    • Donate to Member
Thanks for the suggestion - I'll take a look.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
InfoQube might be overkill for your needs, and it's not free**
But -keeping in mind I'm a basic user- I think it would cover all your needs.
Here are the options when creating a new field:

Screenshot - 2013-03-29 , 11_20_38.pngInformation Manager / Database for daily record of mood and health

I'm not sure what you mean by combo-drop downs. In IQ you can have a drop-down list that isnt editable (just select an entry) or one where you can add new entries on the fly.
Export to Excel (.xls) works fine in my experience; also to html.
Then there's pivot tables via Excel, but that's world I know nothing about ;-)


** The developer has said that "While in Beta, InfoQube personal licenses are now free [on request]"
http://www.sqlnotes....e/2729#comment-12648
Tom

Ampa

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 592
  • I am cute ;)
    • View Profile
    • MonkeyDash - 2 Player strategy boardgame
    • Donate to Member
@tomos InfoQube looks ideal and I like the fact that it is generic. Shame it is going to be a bit pricey once it is out of beta.

I'll have to investigate the free personal license.

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 11,959
    • View Profile
    • Donate to Member
Ampa, you could try the IQ author on dc. Here's his profile link
https://www.donation...ion=profile;u=101296

If you need help there's also an IQ thread on dc somewhere (search 'sqlnotes') or try the IQ forums - or post here, I'll help as much as I can.

The 'Grids' just give you a view/window on your items. Items displayed depend on 'source' and other filters.
I generally keep it (IQ) fairly simple, but you can make it pretty complex if you want :)
Tom
Tom