Benjamin Dauvergne
6273e01a5c
bijoe: fix bad indenting in EngineDimension.members()
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
3bc9af648b
bijoe: improve style of data tables
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
6d7041c376
bijoe: style improvement
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
ad831cb427
bijoe: display total count of facts in each warehouses
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
62089e7951
wcs_olap: improve display of decimal values (for french users)
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
ddfc6c468a
bijoe: order warehouses by name when displayed
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
3e9db1eae5
bijoe: fix naming of local setting file environment variable
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
9e127bd700
bijoe: add a count method to EngineCube
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
cf539e86a7
bijoe: add a cubes iterator to engine
2016-06-18 09:36:26 +02:00
Benjamin Dauvergne
0b597edde7
wcs_olap: improve logging in cmd
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
2fb3355568
wcs_olap: formatting
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
90a36a5f95
wcs_olap: reomove year, month, day and dow tables
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
d12cb2a7ae
wcs_olap: improve generic status mapping using new startpoint flag on statuses
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
3a6303095d
wcs_olap: add a backoffice channel
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
247df4bce9
wcs_olap: temporary work-around to indicate startpoint statuses
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
b972629182
wcs_olap: improve comments on pg objects
2016-06-18 09:26:46 +02:00
Benjamin Dauvergne
af6a453ffb
wcs_olap: change label of generic statuses
2016-06-18 09:25:35 +02:00
Benjamin Dauvergne
2b62e9b059
wcs_olap: encode unicode value
2016-06-18 09:23:54 +02:00
Benjamin Dauvergne
e156e13cf4
3m: be verbose on errors
2016-06-18 09:21:01 +02:00
Benjamin Dauvergne
ce235ceac8
3m: fix typo, exit on error
2016-06-18 09:20:38 +02:00
Benjamin Dauvergne
b313b03884
wcs-olap: handle unicode in exceptions when printing traceback
2016-05-25 10:54:17 +02:00
Benjamin Dauvergne
0522eacaf4
bijoe: generate isoweek dimension for date dimension
2016-05-25 10:33:57 +02:00
Benjamin Dauvergne
36f350cc01
wcs-olap: lowercase most dimension labels
2016-05-25 10:24:51 +02:00
Benjamin Dauvergne
8133de03ba
wcs-olap: fix dimension definition for item fields
2016-05-25 10:13:17 +02:00
Benjamin Dauvergne
c027865618
bijoe: flatten Decimal to unicode in JSON export
2016-05-25 10:12:50 +02:00
Benjamin Dauvergne
de130eec89
bijoe: hide chart when there is no data
2016-05-25 10:12:26 +02:00
Benjamin Dauvergne
f4f1dfc9b1
bijoe: improve table style
2016-05-25 10:12:15 +02:00
Benjamin Dauvergne
07d8e61bb9
bijoe: fix z-index of ODS export button
2016-05-25 10:11:51 +02:00
Benjamin Dauvergne
577c56d1ab
bijoe: make psycopg2 return unicode strings
2016-05-25 10:11:12 +02:00
Benjamin Dauvergne
153ccdbe0c
add ods package from w.c.s.
2016-05-25 01:48:04 +02:00
Benjamin Dauvergne
f9bd3fb0cc
bi-joe: BI engine and frontend for PostgreSQL
2016-05-25 01:24:07 +02:00
Benjamin Dauvergne
da768271bf
wcs-olap: use wcs-olap section in .INI for default values
2016-05-24 21:44:57 +02:00
Benjamin Dauvergne
f0f22b1d28
wcs-olap: make config path optional
2016-05-23 20:22:20 +02:00
Benjamin Dauvergne
285bc85758
wcs-olap: skip formdata wihtout a receipt_time, they are lost drafts
2016-05-23 20:22:20 +02:00
Benjamin Dauvergne
5836641e90
wcs-olap: hash formdata and status table names when they are too long
2016-05-21 13:13:08 +02:00
Benjamin Dauvergne
f2f80cc6f2
wcs-olap: allow setting requests verify in config
2016-05-19 15:18:57 +02:00
Benjamin Dauvergne
ad4ba3ea4d
wcs-olap: print traceback to stderr
2016-05-19 15:13:55 +02:00
Benjamin Dauvergne
ca9d23821c
wcs-olap: skip delay computation when status resolving fails
2016-05-19 14:40:21 +02:00
Benjamin Dauvergne
0e2968f36f
wcs-olap: do not resolve unassigned functions
2016-05-19 14:37:08 +02:00
Benjamin Dauvergne
b8dc094270
remove debugging statement
2016-05-19 14:36:07 +02:00
Benjamin Dauvergne
f70c83aa08
add debian packaging
2016-05-19 11:13:12 +02:00
Benjamin Dauvergne
9c44bb9711
wcs-olap: build a start schema from data exported by w.c.s. API
...
Given such an .INI file:
[https://demarches.triffouilly.fr/ ]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-19 11:13:12 +02:00
Benjamin Dauvergne
c8209c9c94
3m: convert bi_all_forms to a table
2016-05-19 11:12:59 +02:00
Benjamin Dauvergne
773eede548
fix bi_assainissement view in 3m_test.sql
2016-04-28 18:10:30 +02:00
Benjamin Dauvergne
d19233d2b7
fix typo
2016-04-28 15:13:30 +02:00
Benjamin Dauvergne
fef4726e92
remove eau potable and assainissement from global stats
2016-04-28 14:51:55 +02:00
Benjamin Dauvergne
3301318cef
3m: minimize downtime when updating bi database
2016-02-25 11:52:11 +01:00
Benjamin Dauvergne
d8de03a580
3m; remove encombrants from bi_all_forms view
2016-02-25 11:39:55 +01:00
Benjamin Dauvergne
9ed042e31c
3m: add missing line for Montpellier in poles.csv
2016-02-25 10:54:23 +01:00
Benjamin Dauvergne
c217cc2079
3m: update poles.csv
2016-02-22 10:29:48 +01:00