25
edits
Reusing Open Food Facts Data: Difference between revisions
→CSV daily export: adding about importing CSV to SQLite
m (+ minor additions) |
(→CSV daily export: adding about importing CSV to SQLite) |
||
| Line 47: | Line 47: | ||
</code> | </code> | ||
==== Import CSV in | ==== Import CSV in PostgreSQL ==== | ||
See this article: https://blog-postgresql.verite.pro/2018/12/21/import-openfoodfacts.html (in french, but should be understandable with Google Translator). | See this article: https://blog-postgresql.verite.pro/2018/12/21/import-openfoodfacts.html (in french, but should be understandable with Google Translator). | ||
==== Import CSV to SQLite ==== | |||
The repository [https://github.com/fairdirect/foodrescue-content foodrescue-content] contains Ruby scripts that import Open Food Facts CSV data into a [https://www.sqlite.org/index.html SQLite] database with full table normalization. Only a few fields are imported so far, but this an be extended easily. Data imported so far includes: | |||
* barcode number | |||
* product name | |||
* product categories | |||
* product countries | |||
* full categories hierarchy imported from the <code>categories.txt</code> taxonomy ([https://github.com/openfoodfacts/openfoodfacts-server/tree/master/taxonomies see]) | |||
==== Python ==== | ==== Python ==== | ||