Message Boards » Website Suggestions/Feedback

TOPIC: Export Data

« Prev 1 3 4 5
« Prev 1 3 4 5
 
January 11, 2011 7:17 AM
Hello,

I searched through the site and couldn't find this option anywhere.

I would love to be able to export my data (as xml, or csv) so that I can import it into my own database.

Any chance of having this feature added?
January 11, 2011 7:33 AM
even as a text file so I could import it to my excel spreadsheet......
  1063641
January 11, 2011 2:20 PM
I agree, I would also like to be able to export my data into a CSV file (or comparable file).
January 14, 2011 6:33 AM
I was just going to post a topic on this! So glad I did the search function first. I definitely agree. I would love to be able to export my information to Excel. Currently I keep a separate excel file. But since all the info is stored on MFP, would be much easier to just export it. Specifically for my check-ins, measurements, and daily food totals.
  2721361
January 14, 2011 4:01 PM
Like
January 14, 2011 5:03 PM
Like
  3152974
February 8, 2011 12:43 PM
I also think the export function would be a great feature.
February 8, 2011 5:20 PM
I'd also love this!
February 8, 2011 10:44 PM
Yes that would be great.
  3331595
February 10, 2011 11:16 PM
It is relatively easy to get the information into Excel.

Step 1. Go to http://www.myfitnesspal.com/reports/printable_diary/eupfhoria except replace eupfhoria with your user name

Step 2. Select the date range you want to export

Step 3. Select everything from before the first date to the very end of the page

Step 4. Copy

Step 5. Open up excel and click in A1

Step 6. Paste

Now you have your data in Excel. It's not in a particularly useful format and you can't use any pivot tables or anything, but at least it's in Excel.

I will probably write a short PHP script that converts data from this format into a database style pivot table compatible format sooner or later.
Edited by eupfhoria On February 10, 2011 11:20 PM
February 12, 2011 3:53 AM
If what you're trying to do is to gather, say, the last couple of week's worth of daily totals, then there are more steps.

Step 7 - copy and paste, one at a time, the date from its position at the top of each set of data to the "total" line.

Step 8 - go back and delete all the rows that aren't total rows, again one set at a time.

Step9 - realise that if your daily net calorie target changes due to different amounts of exercise each day, that data is not captured here so you have to manually add it in.

Step 10 - quietly mutter something about the inability to export data in a simpler fashion from what is, after all, a database.

Step 11 - add your voice to those others on this forum requesting an easier way to do this.

I agree with the earlier commenters - it is a slow process extracting data from this site and whilst it's "relatively easy" to scrape data into Excel it's a cumbersome and inadequate approach.
February 14, 2011 8:19 AM
Yes please - and I should also say, add an import feature for exactly the same formats - CSV, excel, XML
NB: This would bring you extra customers, because a lot of people want to play with their own data, and it would be a USP for this site. Google is open and makes money, be open too!
February 14, 2011 9:18 AM
bump
February 15, 2011 8:11 PM
Alright, I wrote the simple script I was talking about earlier. It still takes too many steps and, considering that I was able to write this in an hour, is something the MyFitnessPal should be able to do after a few hours worth of meetings and debates.

It will return the daily summaries of your diet as Date,Calories,Carbohydrates,Fat,Protein,Exercise,Net

http://www.deanlife.com/MFPtoCSV.php

If anyone wants any other information from this report, let me know. I'll see if I can accommodate you.


The Instructions are as follows:
This is an extremely simplistic PHP script that will translate your MyFitnessPal data into a somewhat useful format. You can do it all using 10 easy but rather frustrating steps.

Step 1. Go to http://www.myfitnesspal.com/reports/printable_diary/[your_user_name] except replace [your_user_name] with your user name

Step 2. Select the date range you want to export. Uncheck Food Notes and Exercise Notes but leave Food Diary and Exercise Diary checked. Click Change Report.

Step 3. Select everything from just before the first date to the very end of the page

Step 4. Copy

Step 5. Open up excel (or Google Docs, which is free at docs.google.com) and click in A1

Step 6. Paste

Now you have your data in Excel. It's not in a particularly useful format and you can't use any pivot tables or anything, but at least it's in Excel. The following steps will get your information

Step 7. Save as Windows Comma Separated (.csv)

Step 8. Open the new file you have just created in a text editor. I suggest something like notepad or textedit.

Step 9. Select all, then copy.

Step 10. Paste everything into the textbox above and click submit.

The script will return data in .csv format. You should know what to do with it if you have gotten this far.
February 15, 2011 8:46 PM
Still, despite the number of steps, it's always good to have the data in a useful format.

I was able to determine, for example, that my calories come from 58% carbs, 24% fat, and 18% protein using 449 calculation.
May 15, 2011 10:35 PM
Pretty cool, eupfhoria! Thanks!

One glitch: If a food's name begins with a number (e.g. 365 Organic - Cage-Free Large Brown Egg (Grade A)), your script puts it in the date column, preceded by a line with the actual date and 0's for all the totals.

Also, that seems to do something to the lines that come inbetween, so that I found that the days that came between one day when I had a 365 egg and another when I had 21 Choices yogurt had disappeared.
Edited by maxfreund On May 15, 2011 10:39 PM
  4972977
May 15, 2011 10:41 PM
In any case, a user-generated workaround like this is a poor substitute for what should be a simple feature built into the site itself.

I haven't seen an indication that any staff from MFP has read and acknowledged this. There seems to be lots of user demand!
  4972977
May 20, 2011 1:15 PM
Like! Please add this feature - it really would be helpful.
May 29, 2011 8:53 PM
nice, it is skipping the 1st through 10th of every month.

Can you make the script available?
May 31, 2011 5:50 AM
I've been looking for this feature as well. I like MFP, but I would switch to another calorie/exercise program if it allowed data export. Just sayin'.
June 1, 2011 5:31 AM
bump!
June 12, 2011 9:33 AM
Bump - Bump. This is a required feature - will improve myfitnesspal.
June 13, 2011 9:15 PM
I totally agree. An export feature would be really nice.
June 17, 2011 1:28 PM
Export feature would be awesome :-)
June 17, 2011 5:56 PM
Hey MFP, Export feature. Say something.

Reply

Message Boards » Website Suggestions/Feedback

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