Health & Diet Manager Database

[canderson]

Hi,

I've just downloaded the trial version and on the whole I'm impressed with the product.

However, I want/need 2 things and it seems these 'features' aren't available as yet.

1, I'd like to be able to add my own exercise definitions to the list you choose from (someone else has already requested this).

2, I'd like to start with a blank list of food items. It's nice that you've started with over 4,000 items but to be honest my diet just isn't that varied and your list is getting in the way. I'd be much happier if I could just start with a blank list and add items as I go.

So my question is this, I'm a software engineer who's reasonably techy and I have CE Query Analyser already on my PDA. Is there anyway I could use this to connect to the database directly and a) clear out the food items list and b) add exercise definitions.

You're probably going to say no, I understand, but if you do I won't be buying your product! ;o)

Feel free to email me if you'd rather not disclose these details on the forum.

Many thanks.

CA.

[EP2005]

Hi,

I've just downloaded the trial version and on the whole I'm impressed with the product.

However, I want/need 2 things and it seems these 'features' aren't available as yet.

1, I'd like to be able to add my own exercise definitions to the list you choose from (someone else has already requested this).

2, I'd like to start with a blank list of food items. It's nice that you've started with over 4,000 items but to be honest my diet just isn't that varied and your list is getting in the way. I'd be much happier if I could just start with a blank list and add items as I go.

So my question is this, I'm a software engineer who's reasonably techy and I have CE Query Analyser already on my PDA. Is there anyway I could use this to connect to the database directly and a) clear out the food items list and b) add exercise definitions.

You're probably going to say no, I understand, but if you do I won't be buying your product! ;o)

Feel free to email me if you'd rather not disclose these details on the forum.

Many thanks.

CA.

Hello :)

Although I cannot directly answer your question, I can certainly bring it to the attention of some people that might be able to help.

I understand how you feel when you say the 4,000+ food database can be a bit cumbersome to navigate around when you don't eat many of the foods on the list (I am Vegan and most of the foods on the list I won't touch with a 10 foot pole!), but the list can be useful if you need to quickly add some food details that you might otherwise forget.

Have you considered creating a new Categories and then add foods you eat to that for quick access? It would take you about the same amount of time to do this than to manually enter each item on your own list.

[adriano]

canderson,

Health & Diet manager stores its data in a sqlite database -- check out www.sqlite.org for a variety of tools allowing to manipluate dbs based on this engine. Sqlite browser is a pretty good one and allows to direct-edit table rows and fields, as well as run queries for larger manipulations of data.

Of course, should you mess up the db and cause health & diet manager not to work anymore... you're on your own ;) -- easy way in case this takes place would be to just go back to the "default" db deployed with the app.

- Adriano