Version: 2.0-beta2 (using KDE 4.6.5) OS: Linux I'm trying to find 'red wine vinegar' in the nutrition information. Unfortunately, only two vinegars are listed—cider and distilled. But, it should be there: http://www.nal.usda.gov/fnic/foodcomp/cgi-bin/list_nut_edit.pl?NDB_NO=02068&FDGP_CD=0200&FOOD_NAME=Vinegar%252c%2520red%2520wine&SCI_NAME=&COM_NAME=&MSRE_NO0=100grams&GRAMS_100=1.00&1=1.00&2=1.00&3=1.00&NUMBER_OF_CHECKBOXES=3 Its NDB ID 02068, so I tried sorting by ID in the dialog, and 2068 (I guess leading 0s are stripped?) is "HORMEL CANADIAN STYLE BACON". I think this is because you need to update abbrev.txt. No idea if the format has changed, hopefully not. The ID numbers definitely have. Reproducible: Always Steps to Reproduce: N/A Actual Results: N/A Expected Results: N/A OS: Linux (x86_64) release 3.1.0-1-amd64 Compiler: gcc
Actually, looking at the old abbrev.txt file, I have no idea where that ID (for the Canadian bacon) came from—it doesn't appear in the NDB file. Updating abbrev.txt seems to have mostly worked, but it looks like there are several other data files I need to update as well.
Also, it appears that there is an 'ingredient-data-en-US' which I guess was done by hand? Unfortunately, it contains incorrect data, for example: tomatoes, stewed:11693 but 11693 is crushed tomatoes. Stewed tomatoes are 11533 ("Tomatoes, red, ripe, canned, stewed" I'm going to replace it with data from FOOD_DES.txt; will upload all the new files once I finish them...
Created attachment 66870 [details] Patch to update to SR24 This updates the weights.txt file as well, even though krecipes is (unfortunately!) not using it. The number of fields in abbrev.txt changed, updated a define. (xz'd; Bugzilla refused the patch for being too large. USDA data files are large. Not much I can do about that. gzip and bzip both exceeded 1MB)
It appears that the ingredient-data-en-US.txt file also controls which are loaded by default, and also the common names help in recipe matching. I'm going through it, fixing it, but its going to take a bit. I'm a third of the way through, there are a *lot* of mistakes in it.
Created attachment 67007 [details] Program to aid in verifying ingredient-data-en_US.txt
Created attachment 67008 [details] Patch to update ingredient data file (instead of generate from USDA data as in other patch) Some entries were plain wrong—they pointed to the wrong food. Many of them were close matches, so may have come from before the correct food existed in the USDA database. But that strategy doesn't really work, as it leave incorrect data imported. So where I couldn't find a match, I just deleted the entry. I also fixed some names, to use what they're normally called in the US. Though where that leads to confusion, I've added more to the name to clarify. I may have missed some... At this point, I'm done with spamming this bug for a while. Hope to actually use krecipes now...