After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 537279 - Add countries to database
Add countries to database
Status: RESOLVED FIXED
Product: chronojump
Classification: Other
Component: chronojump-server
unspecified
Other All
: Normal enhancement
: ---
Assigned To: Xavier de Blas
Xavier de Blas
Depends on:
Blocks:
 
 
Reported: 2008-06-08 16:28 UTC by Xavier de Blas
Modified: 2008-06-13 18:25 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Xavier de Blas 2008-06-08 16:28:49 UTC 
Add countries to database for jumper and for evaluator

take countries from here:
http://en.wikipedia.org/wiki/List_of_countries_by_continent

process like this:

with vim:
1 selected all
2 substitution

:'<,'>s/\(..\) \(..\) \(...\) \(...\) \(.*$\)/\1:\5:\3
eg.     from:   AF AO AGO 024 Angola, Republic of
        to:     AF:Angola, Republic of:AGO

3 !sort

countries table inegrates like this:
http://svn.gnome.org/svn/chronojump/trunk/sqlite_diagrams/chronojump_sqlite.png