25
edits
Changes
Jump to navigation
Jump to search
Line 47:
Line 47: − + + + + + + + + + + +
Reusing Open Food Facts Data (view source)
Revision as of 20:40, 29 April 2020
, 20:40, 29 April 2020→CSV daily export: adding about importing CSV to SQLite
</code>
</code>
==== Import CSV in PostGRE SQL ====
==== 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 ====