rufuspollock-okfn / opd-product-browser-web Goto Github PK

A repository of code, documentation and database scripts for the Open Product Data project.

Home Page: http://www.product-open-data.com/

PHP 97.23% CSS 1.84% ApacheConf 0.94%

opd-product-browser-web's Introduction

Product Open Data

This is a repository of code, documentation and database scripts for the Product Open Data project currently hosted at http://product-open-data.com/. The goal of Product Open Data is to build a public database of product data. For more information, please visit http://product.okfn.org.

The code is written in PHP with a MySQL database backend.

Dockerized Development Instance

Prerequisites

Make sure you have Docker and Docker Compose installed.

Clone this repository

git clone https://github.com/okfn/product-browser-web.git

Run the setup script

cd product-browser-web/scripts/dockerfiles
wget -O - http://dfowler.sixbit.org/products.sql.gz | \
  gunzip -c > pod_mysql/products.sql
docker-compose --project-name pod up

Import the database

docker exec pod_db_1 sh -c \
  'mysql -uroot -p"$MYSQL_ROOT_PASSWORD" \
  "$MYSQL_DATABASE" < products.sql'

Access the local development instance

Your local copy of Product Open Data should now be running on port 18080 of your Docker host.

opd-product-browser-web's People

Contributors

Stargazers

Watchers

Forkers

gzapico alvarlaigna kbrian187 youngsteam mealteam archanasrinivas pkdevbox nagyistoce andzi zweid alexorbit dfiedlerx charlypoppins skuross mohammed-alkhobi

opd-product-browser-web's Issues

Identify initial areas where people can help

@PhilippePlagnol suggest you create "bite-sized" issues describing particular areas or tasks

Smartphone apps

The starting point of the smartphone apps is to be able to show the content of our database by entering (manually or by scan) a GTIN code.

Interfaces between manufacturers and our database

The paradigm of the project is the the data printed on packaging are public and that manufacturers should publish a digital catalogue including the GTIN code (unique identifier)

The fact to scrap data from e-commerce website was a way to create the first version of the database and to prove the concept,...

The big challenge that we have now is to get directly information from manufacturer because it's the real source, the trusted source of data.

We should be able to know which manufacturers we prioritize (food, beverage, cosmetics,...) the content of the dataflow we are expecting from them and to propose technical solutions to transfer data,...

Broken Links Bug

On this website, http://product-open-data.com/download all the download links are broken. I dont really know where to post this or its affiliated but everything seems to be dormant about this, so I am just trying my luck. I would grateful for any direction from here even if you dont know what to tell me about this website.

Image not displayed

Image GTIN_under_barcode.jpg is not displayed (template_search.php)

Because product-open-data.com is not valid referer for S3 ?

Logo is not sharp

Same issue as brand-manager (rufuspollock-okfn/opd-brand-manager#77).

I have started to redesign logo at multiples sizes (but not used yet...)

Design of a brand repository

In order to store a product into the database, a brand must be assigned.

The current data about brand and groups (id, name, picture, website, like to wikipedia articles,...) has been created manually).

A collaborative platform to manage this repository is critical for the project.

There's an important constraint : the brand identifier must be stable,...