Message Boards » Eat, Train, Progress. » Discussion

TOPIC: MFP's new reports function

« Prev 1
« Prev 1
 
Ic_disabled_photos
Topic has been inactive for 30 days or more and images have been disabled.
Display All Images
July 9, 2013 5:16 AM
A public service announcement for the numbers-minded: it looks like MFP just recently updated their reports function. (Not sure exactly when it happened since I was away for a while; hope it's not old news for everyone here.) The 7-day barplots for macros and intake are a tad more informative now, with each day's column labeled with the number for that day, and there is a goal intake line on the graph, too. There is also some fun stuff that appears when you hover the mouse over a column in graphs for longer time spans. There are still some kinks to work out--I reported a problem to MFP already--but it should save us all some work when trying to work out average intake at a glance.
July 9, 2013 6:14 AM
I didnt realize they updated that either! Thanks for the heads up.
July 9, 2013 8:13 AM
*runs off to check it out*
  18358448
July 9, 2013 8:18 AM
Awesome, thanks! *bolting because I love charts*
  1351274
July 9, 2013 8:54 AM
Holy Crap!! This is awesome, just spending 15 minutes hand writing & calculating (no abacus), my averages for last 6 months. Call me excited!!
Thank you!
  10560894
July 9, 2013 8:57 AM
Much better, but now I have to figure out how to export that data again since that function is still not available over 2 years later...
  4579652
July 9, 2013 9:05 AM
QUOTE:

Much better, but now I have to figure out how to export that data again since that function is still not available over 2 years later...


I was really baffled by how people did their averages (seeing them a lot in this group) because I thought there was some hidden function on the site that allows you to export your data. Then I realized that people actually do it by hand by looking at their diaries. Right? Is that how people work it out?

"Export to .csv" should just be a function on MFP.
July 9, 2013 9:36 AM
I was able to get the XML data that the Flash based charts pulled from and import it into Excel, but now it appears they are Javascript based. I'll have to do some research on what query to run to get the data, I already figured out how to get to the weight data.

http://www.myfitnesspal.com/reports/results/progress/1/#.json

Where # is the # of days it pulls data from. e.g. weight data for the last 60 days:

http://www.myfitnesspal.com/reports/results/progress/1/60.json

*Not a web developer, at all. Just a nerd who can research and figure out stuff.
  4579652
July 9, 2013 9:40 AM
QUOTE:

QUOTE:

Much better, but now I have to figure out how to export that data again since that function is still not available over 2 years later...


I was really baffled by how people did their averages (seeing them a lot in this group) because I thought there was some hidden function on the site that allows you to export your data. Then I realized that people actually do it by hand by looking at their diaries. Right? Is that how people work it out?

"Export to .csv" should just be a function on MFP.


I saw right away that MFP didn't have an export data function, so I have always copied out my caloires/macros each day. I would use this great little tool if I needed to, though:

http://www.designbyvh.com/myfitnesspal-export-data/#.Udw8rzvI58E
  6687236
July 9, 2013 9:48 AM
QUOTE:

I was able to get the XML data that the Flash based charts pulled from and import it into Excel, but now it appears they are Javascript based. I'll have to do some research on what query to run to get the data, I already figured out how to get to the weight data.

http://www.myfitnesspal.com/reports/results/progress/1/#.json

Where # is the # of days it pulls data from. e.g. weight data for the last 60 days:

http://www.myfitnesspal.com/reports/results/progress/1/60.json

*Not a web developer, at all. Just a nerd who can research and figure out stuff.


Oh, that's brilliant! It's a short step from a json file to a csv file, or you can put that stuff straight into R and not mess around with spreadsheets.

There must be a way to do something similar with macros and calories...
July 9, 2013 9:51 AM
Oh, I might as well mention the issue I found with the new reports: the numbers on the columns are slightly off from what your diary has. For example, yesterday, my protein was 143, and the graph says 144. Two days ago, it was 122, yet the graph says it was 121. So it's off by 1 g, but not in a consistent direction.
July 9, 2013 9:52 AM
QUOTE:

I saw right away that MFP didn't have an export data function, so I have always copied out my caloires/macros each day. I would use this great little tool if I needed to, though:

http://www.designbyvh.com/myfitnesspal-export-data/#.Udw8rzvI58E


I heart you!! Thanks!
  1351274
July 9, 2013 9:55 AM
QUOTE:

QUOTE:

QUOTE:

Much better, but now I have to figure out how to export that data again since that function is still not available over 2 years later...


I was really baffled by how people did their averages (seeing them a lot in this group) because I thought there was some hidden function on the site that allows you to export your data. Then I realized that people actually do it by hand by looking at their diaries. Right? Is that how people work it out?

"Export to .csv" should just be a function on MFP.


I saw right away that MFP didn't have an export data function, so I have always copied out my caloires/macros each day. I would use this great little tool if I needed to, though:

http://www.designbyvh.com/myfitnesspal-export-data/#.Udw8rzvI58E


Crap, there goes my planned afternoon of actual work. I gots data to analyze now. Thanks!
July 9, 2013 9:56 AM
In to have this on my feed so my FL can get the news :)

Also, that is awesome to hear and will have to play around. Thanks for the heads up :)
July 9, 2013 10:20 AM
It looks like the XML data is still available smile

http://www.myfitnesspal.com/reports/results/nutrition/Net Calories/90?report_name=Net+Calories

edit: You'll have to copy and paste, the space breaks the link and using %20 for the space does not create a clickable link that works.
Edited by The_Enginerd On July 9, 2013 10:25 AM
  4579652
July 9, 2013 11:09 AM
I love you guys for all these geeked-out tricks! What do I do once I have the XML file to make it human usable?
  33519010
July 9, 2013 11:15 AM
QUOTE:

I love you guys for all these geeked-out tricks! What do I do once I have the XML file to make it human usable?


I've been playing with the CSV file instead of working--it might be easier for most people to deal with, as it is human-readable right away and is organized into a table.

Go to this link:

http://www.designbyvh.com/myfitnesspal-export-data/#.Udw8rzvI58E

Make sure your diary is either private or public, export the CSV for whatever date range you want, and you can open the resulting file in Excel or other spreadsheet program. If you want to do something fancier with it, like a time series analysis, you can import it into R or another stats program, too.

Fun fact: you can analyze the data of any MFP user who has a public diary. You can now rebuff annoying posters on the forum by saying things like, "well, I am not going to take protein advice from someone who averages at 55.7 g a day for the past three months."
July 9, 2013 11:36 AM
QUOTE:

QUOTE:

I love you guys for all these geeked-out tricks! What do I do once I have the XML file to make it human usable?


I've been playing with the CSV file instead of working--it might be easier for most people to deal with, as it is human-readable right away and is organized into a table.

Go to this link:

http://www.designbyvh.com/myfitnesspal-export-data/#.Udw8rzvI58E

Make sure your diary is either private or public, export the CSV for whatever date range you want, and you can open the resulting file in Excel or other spreadsheet program. If you want to do something fancier with it, like a time series analysis, you can import it into R or another stats program, too.

Fun fact: you can analyze the data of any MFP user who has a public diary. You can now rebuff annoying posters on the forum by saying things like, "well, I am not going to take protein advice from someone who averages at 55.7 g a day for the past three months."


This is incredible. THANK YOU! Tagging so I never lose the link.
  8648431
July 10, 2013 3:15 AM
I can't believe the amount of unnecessary addition and division I have done over the last six months. tongue Tagging!
July 10, 2013 4:15 AM
oh, yum! thanks

<<idly wondering if datapoints as % of LBM will go down or up as weight is lost>>
August 5, 2013 9:46 PM
QUOTE:

QUOTE:

I was able to get the XML data that the Flash based charts pulled from and import it into Excel, but now it appears they are Javascript based. I'll have to do some research on what query to run to get the data, I already figured out how to get to the weight data.

http://www.myfitnesspal.com/reports/results/progress/1/#.json

Where # is the # of days it pulls data from. e.g. weight data for the last 60 days:

http://www.myfitnesspal.com/reports/results/progress/1/60.json

*Not a web developer, at all. Just a nerd who can research and figure out stuff.


Oh, that's brilliant! It's a short step from a json file to a csv file, or you can put that stuff straight into R and not mess around with spreadsheets.

There must be a way to do something similar with macros and calories...

Bumping this since I figured out a way to get the data for every report out.

Weight
http://www.myfitnesspal.com/reports/results/progress/1/180.json?report_name=1
Neck
http://www.myfitnesspal.com/reports/results/progress/13685780/180.json?report_name=13685780
Waist
http://www.myfitnesspal.com/reports/results/progress/13685788/180.json?report_name=13685788
Hips
http://www.myfitnesspal.com/reports/results/progress/13685796/180.json?report_name=13685796
Net Calories
http://www.myfitnesspal.com/reports/results/nutrition/Net Calories/180.json?report_name="Net Calories"
Calories
http://www.myfitnesspal.com/reports/results/nutrition/Calories/180.json?report_name=%E2%80%9DCalories%E2%80%9D
Carbs
http://www.myfitnesspal.com/reports/results/nutrition/Carbs/180.json?report_name=%E2%80%9DCarbs%E2%80%9D
Fat
http://www.myfitnesspal.com/reports/results/nutrition/Fat/180.json?report_name=%E2%80%9DFat%E2%80%9D
Protein
http://www.myfitnesspal.com/reports/results/nutrition/Protein/180.json?report_name=%E2%80%9DProtein%E2%80%9D
Saturated Fat
http://www.myfitnesspal.com/reports/results/nutrition/Saturated Fat/180.json?report_name="Saturated%20Fat"
Polyunsaturated Fat
http://www.myfitnesspal.com/reports/results/nutrition/Polyunsaturated Fat/180.json?report_name="Polyunsaturated Fat"
Monounsaturated Fat
http://www.myfitnesspal.com/reports/results/nutrition/Monounsaturated Fat/180.json?report_name="Monounsaturated Fat"
Trans Fat
http://www.myfitnesspal.com/reports/results/nutrition/Trans Fat/180.json?report_name="Trans Fat"
Cholesterol
http://www.myfitnesspal.com/reports/results/nutrition/Cholesterol/180.json?report_name=%E2%80%9DCholesterol%E2%80%9D
Sodium
http://www.myfitnesspal.com/reports/results/nutrition/Sodium/180.json?report_name=%E2%80%9DSodium%E2%80%9D
Potassium
http://www.myfitnesspal.com/reports/results/nutrition/Potassium/180.json?report_name=%E2%80%9DPotassium%E2%80%9D
Fiber
http://www.myfitnesspal.com/reports/results/nutrition/Fiber/180.json?report_name=%E2%80%9DFiber%E2%80%9D
Sugar
http://www.myfitnesspal.com/reports/results/nutrition/Sugar/180.json?report_name=%E2%80%9DSugar%E2%80%9D
Vitamin A
http://www.myfitnesspal.com/reports/results/nutrition/Vitamin%20A/180.json?report_name=%E2%80%9DVitamin%20A%E2%80%9D
Vitamin C
http://www.myfitnesspal.com/reports/results/nutrition/Vitamin%20C/180.json?report_name=%E2%80%9DVitamin%20C%22
Iron
http://www.myfitnesspal.com/reports/results/nutrition/Iron/180.json?report_name=%E2%80%9DIron%22
Calcium
http://www.myfitnesspal.com/reports/results/nutrition/Calcium/180.json?report_name=%E2%80%9DCalcium%22
Calories Burned
http://www.myfitnesspal.com/reports/results/fitness/Calories Burned/180.json?report_name="Calories Burned"
Exercise Minutes
http://www.myfitnesspal.com/reports/results/fitness/Exercise Minutes/180.json?report_name="Exercise Minutes"
Edited by The_Enginerd On August 5, 2013 9:58 PM
  4579652
August 5, 2013 9:51 PM
Awesome, all the links appear to work! For a different number of days, change the 180 in "180.json" to a different number.
Edit: The links with spaces still do not work. You will have to copy and paste those still.

It will take some data manipulation to get it into a spreadsheet, but if you are comfortable with Excel and Word, doing find/replace and text to columns functions. I'll try to make some macros to automate this and post them if I'm successful.
Edited by The_Enginerd On August 5, 2013 9:59 PM
  4579652
August 6, 2013 6:59 AM
Ooh that is awesome, rallyengr. The CSV export widget was doing me nicely until they changed something in the app (I think) so now it exports a fixed selection of parameters instead of whatever your diary is set to display. So the CSV shows calories, carbs, protein, fat, cholesterol, sodium, fiber, and sugar, but if you wanted to know your iron or saturated fat intake, you're SOL. Not to mention that the CSV widget does not include your weight data. The json files allow a workaround.
August 6, 2013 9:16 AM
This is amazing you all -- thank you!! Tagging so I can go through it more carefully when I have time.
August 7, 2013 3:03 AM
tagging
  38408567

Message Boards » Eat, Train, Progress.

Posts by members, moderators and admins should not be considered medical advice and no guarantee is made against accuracy.