Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add USDA food import #1640

Closed
rolandgeider opened this issue Apr 21, 2024 · 1 comment · Fixed by #1666
Closed

Add USDA food import #1640

rolandgeider opened this issue Apr 21, 2024 · 1 comment · Fixed by #1666

Comments

@rolandgeider
Copy link
Member

We need an import script similar to the one for open food facts:

https://fdc.nal.usda.gov/download-datasets.html

  • Foundation Foods
  • Branded

There are currently some ingredients in the database that were originally imported from USDA, but we have neither the import script not the original dataset, so we would need to either remove all the ones not used in a nutritional plan or log, or try to match them by name in a first step.

We currently use the code field for OFF products as a foreign ID to later allow for easier updates of the entries. USDA has generic products as well as branded ones, do these also have a known barcode? In any case it might be a good idea to add a proper foreign_id field where we would store the fdcId

Also, since these exports are updated just twice a year, I don't think we need any automatic process

@Dieterbe
Copy link
Contributor

when these items show up in wger, will it be clear where the information comes from? e.g. will it mention USDA, or maybe a web link to the USDA item?

@rolandgeider rolandgeider linked a pull request May 19, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Done
Development

Successfully merging a pull request may close this issue.

2 participants