Just wondering is there some way to do a database dump on the amee
staging database I have been given. I am doing a college project based
on the calculations AMEE performs and it would be really handy to know
what fields amee stores for each profile.
> Just wondering is there some way to do a database dump on the amee > staging database I have been given. I am doing a college project based > on the calculations AMEE performs and it would be really handy to know > what fields amee stores for each profile.
A database dump wouldn't really help, I'm afraid! The best way to find what data we store is to explore the web interface (you were sent a link with your key). We don't necessarily store all data for every profile, just what the API client puts in. As for how AMEE performs its calculations, the wiki (http://wiki.amee.com) has information on all that side of things.
Alternatively, if you mean you want to fetch all data for an existing profile, you can use our recursive GET call to fetch all data within a profile in one go. See http://my.amee.com/developers/wiki/AmeeProfileApi/BatchGet for details.
Hi James,
Thats ok so. The reason I wanted this is I cant make the database on my own
site using the db_init.php file in the calc so I was going to try manually
import this database and try reinstall. I will have to think around another
way to do this so.
> 2009/2/19 Jer <lane...@gmail.com>:
> > Just wondering is there some way to do a database dump on the amee
> > staging database I have been given. I am doing a college project based
> > on the calculations AMEE performs and it would be really handy to know
> > what fields amee stores for each profile.
> A database dump wouldn't really help, I'm afraid! The best way to find
> what data we store is to explore the web interface (you were sent a
> link with your key). We don't necessarily store all data for every
> profile, just what the API client puts in. As for how AMEE performs
> its calculations, the wiki (http://wiki.amee.com) has information on
> all that side of things.
> Alternatively, if you mean you want to fetch all data for an existing
> profile, you can use our recursive GET call to fetch all data within a
> profile in one go. See
> http://my.amee.com/developers/wiki/AmeeProfileApi/BatchGet for
> details.
> Thats ok so. The reason I wanted this is I cant make the database on my own > site using the db_init.php file in the calc so I was going to try manually > import this database and try reinstall. I will have to think around another > way to do this so.
Ah, you are using the PHP calculator on your own site? I understand a bit more now :)
You should be able to set up a local database using db_init.php. If it doesn't work, you need to check your MySQL settings in login_details.php - make sure you can use them on the command line to be sure they work. Note that this database doesn't store any carbon data however, that is all stored in AMEE itself. The local database just stores user registrations for the PHP frontend.
James,
I attached the spec of the project we recieved. From what you are saying so
we will have to query the amee database to achieve the results rather than
storing any information on our own database? Unfortunately we are very new
to php / mysql etc and the time for the project is minimal due to the
college changing to a symmesterised method.
If you can think of anything that would be good to know for the project in
general I would be delighted with any infomation you can pass on.
> 2009/2/19 Jerry Lane <lane...@gmail.com>:
> > Thats ok so. The reason I wanted this is I cant make the database on my
> own
> > site using the db_init.php file in the calc so I was going to try
> manually
> > import this database and try reinstall. I will have to think around
> another
> > way to do this so.
> Ah, you are using the PHP calculator on your own site? I understand a
> bit more now :)
> You should be able to set up a local database using db_init.php. If it
> doesn't work, you need to check your MySQL settings in
> login_details.php - make sure you can use them on the command line to
> be sure they work. Note that this database doesn't store any carbon
> data however, that is all stored in AMEE itself. The local database
> just stores user registrations for the PHP frontend.
|
