[frontend] menu_update.py

[frodrigo]

cc @jocelynj menu_update.py it just for updating the menu. What is the primary way to load categ_menu.txt and item_menu.txt or insert new entry ?

[jocelynj]

categ_menu.txt and item_menu.txt are used to add translations, and are manually modified each time a new categ/item is added.
These english sentences from *_menu.txt are pushed to transifex via po/Makefile, and we get back translations from transifex with the same Makefile. Then menu_update.py is used to update menu entries with the new translations.

To add new items to the database, it is done manually, by running tools/add-markers.py, and adapting the proposed SQL requests.

Another solution is to import http://osmose.openstreetmap.fr/export/osmose-menu.sql.bz2 to the database.

[prhod]

Tank you for the infos. If those two txt files are used for translation, I assume using them as a data source to initiate the BDD is correct.
Using an export from production to initiate a new instance is not what i'm looking for -_^

[jocelynj]

The two files used for translation doesn't contain enough information to generate marker color and shape, that are necessary in database. These could be generated by a new script, that we don't have at the moment.