Message Boards » Technical Support/Need Help

TOPIC: excel export?

 
Ic_disabled_photos
Topic has been inactive for 30 days or more and images have been disabled.
Display All Images
January 2, 2012 6:40 PM
can I download my report data to an excel file (or another application)? thanks.
January 13, 2012 11:24 AM
myfitnesspal does not have an export utility to review your health data you have entered into.

BUT I DID IT!

I just completed an excel macro that goes in and extracts all of the data out of each web page and puts together an excel report of your data. I have completed the food diary and weight history exports. I need to add the exercise reports.

I don't think myfitnesspal servers will like all of the web queries if everyone starts running these type of macros all of the time -- maybe they will see it worth while for people to export their personal data and will then provide a utility. Until then, my macro does some fast web queries in succession to get and copy all of the data just as if you did it manually yourself.
January 13, 2012 12:25 PM
GIVE IT A TRY!

http://www.fileswap.com/dl/OC2kwyOwrD/mfp.xls.html
January 18, 2012 10:16 AM
Hi! I just tried it and got an error .. "Run time error 91" . Object variable or with block variable not set

Any advice?
January 18, 2012 10:19 AM
bump! I am interested too. thanks
January 18, 2012 10:22 AM
That would be nice...I just print mine off and save them in a notebook...a spreadsheet would be much nicer!
January 18, 2012 10:37 AM
I tried it and the above error is on the line "Set fc = find_cell("Totals").Offset(0, 0)"
January 23, 2012 6:56 PM
I found a few bugs in my previous posting on my excel spreadsheet. Here is the updated one.

http://www.fileswap.com/dl/rEJFvAR50L/mfp.xls.html

Simple to use. Just go to the setup tab and put in your username. Update any fields if you have customized otherwise the defaults are there. Then go back to the summary tab. Enter the dates you want to extract from mfp. The default is 1.1.12 to the current date. Then run the web query. mfp.xls will open up a browsing window. Log in with your username and password. After successfully logging on, go back to excel and click OK on the dialog box that has popped up there. Then it will run through and collect your calorie history, food diary, and weight checkin data.

Please let me know your experiences with it! I did this for myself but decided to make it usable for others since mfp hasn't shared tools to save and review your health data in other programs or formats (probably the weakest part of this otherwise fantastic app).

Good Luck!
January 24, 2012 10:45 AM
Thanks gavians for the macro tool. I just tried it out and was very pleased with the results.

Good Work.
January 24, 2012 11:11 AM
Hi,

I tried this and it came up empty...how do I get my data to show?
January 24, 2012 11:19 AM
I also made one lol.... i think theres a large number of people want to do things like this, but cant get the data.

heres a link to mine: http://www.fastgm.com/travis/MyFitnessPalDataScraper/publish.htm

just hit the install button and it should go.
January 24, 2012 12:05 PM
You can also just copy and paste from the printable version (button at the bottom of food dairy) into Excel.

No offense to any who have offerred their macros, but I never trust macros from unknown people.
Edited by ZyheeMoongazer On January 24, 2012 12:07 PM
  13683591
January 24, 2012 2:20 PM
QUOTE:

You can also just copy and paste from the printable version (button at the bottom of food dairy) into Excel.

No offense to any who have offerred their macros, but I never trust macros from unknown people.


lol no offense taken. thats a fairly smart thing to do. mines an actual program too, not a macro... so its even "worse"... although theres nothing bad in what i made i dont trust random programs online either...
January 24, 2012 4:54 PM
Obviously it is buyer beware so to speak. I looked over the macro code before running the tool and was satisfied it was clean.

Tim
January 25, 2012 7:17 AM
I am with you guys with malicious code. There is no funny business in this one. Like I said, I made it for myself then decided to spend a bit more time for others since I had seen a lot of people request such a thing.

@ZyheeMoongaze - OMG! I never noticed that before. I guess that would be simpler for the food logs. Even for my macro to borrow from. I haven't seen the same for the check in data, though. What baffles me, though, is why wouldn't this "printable report" be available under "REPORTS"??? I love a lot about this site, but there are a few things that cause me to shake my head.

@cshun - Make sure you have office 2003 or greater and make sure you enter your username on the setup page instead of mine (where is says gavians). Otherwise you will be logged into your account but trying to access my pages because some pages have your username in the URL. Also make sure you log in onto the pop up browser but don't close it afterwards -- just go back to excel and select OK on the dialog box.
January 25, 2012 10:16 AM
Gavians -- I replied to another thread with the same info, but seems this is more appropriate thread. Anyway, I just tried the new version of your macro and it doesn't seem to work. After logging in and clicking OK, the dates fill in, but the diary data does not come through. I also went into the "SETUP" worksheet and replaced your username with mine, and it still did not work. I'm using Excel 2003 and I'm on IE 8 (32-bit).
January 25, 2012 10:22 AM
peterpandanyc - Make sure you log onto the internet browser that pops up before clicking on "OK" in the excel dialog box. You need to log into this window for the excel session to get the "cookies" needed to be able pull up all the pages necessary.
January 25, 2012 10:40 AM
I did do that each time that I tried and kept the browser session open while Excel was doing its thing.
March 17, 2012 1:01 AM
bump
  12491774

Message Boards » Technical Support/Need Help

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