Benjamin Dauvergne
18b023e91b
add --slug parameter to command line ( fixes #13665 )
2016-10-19 09:47:28 +02:00
Benjamin Dauvergne
ef41c85e6b
fix conversion of geolocation to SQL ( fixes #13666 )
2016-10-19 09:46:13 +02:00
Benjamin Dauvergne
d6d19c0326
exit with non-zero result on failure ( fixes #13664 )
2016-10-19 08:09:43 +02:00
Benjamin Dauvergne
2eb3cd2f6c
revert geolocation support for now
2016-10-12 10:44:15 +02:00
Benjamin Dauvergne
215ad230f2
README.rst: document creation of the dates table
2016-10-12 10:41:01 +02:00
Benjamin Dauvergne
aef72868f6
add support for workflow fields ( fixes #13170 )
2016-09-13 16:40:55 +02:00
Frédéric Péters
f77e752ec1
get formdatas in batches of 1000 ( #12724 )
2016-08-27 16:05:54 +02:00
Benjamin Dauvergne
97b4230997
order categories, forms and agents by their label ( fixes #12739 )
2016-08-27 15:12:35 +02:00
Benjamin Dauvergne
9777ac8f05
ignore item fields having the anonymise flag
2016-08-01 17:12:35 +02:00
Benjamin Dauvergne
fb610e82f7
export item fields without .options or .items array in their schema ( fixes #12800 )
...
It allows doing BI request on field feeded from a data source; beware that it
it will not work if the field's choice are in fact open and not closed (like a
list of things related to the user).
2016-07-29 17:49:29 +02:00
Benjamin Dauvergne
64a2204303
use the computed generic_status_id value
2016-07-29 17:46:45 +02:00
Benjamin Dauvergne
eb8b36fd0f
create a temporary schema and rename it to the final schema name if everything goes well ( fixes #12801 )
2016-07-29 17:46:17 +02:00
Benjamin Dauvergne
7ad91df789
fix percent expression when total count is 0
2016-07-22 14:54:23 +02:00
Benjamin Dauvergne
df513c659b
debian: add README.rst to docs
2016-07-11 17:10:38 +02:00
Benjamin Dauvergne
39c90af009
debian: add dh-python to Build-Depends
2016-07-11 17:05:35 +02:00
Benjamin Dauvergne
7f46a1b8a8
standalone debian packaging
2016-06-24 15:47:37 +02:00
Benjamin Dauvergne
2fc56d8059
wcs_olap: import first intervening agent
2016-06-20 15:18:43 +02:00
Benjamin Dauvergne
3e1485dae9
wcs_olap: improve logging in cmd
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
7a37e951aa
wcs_olap: formatting
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
04dc5d8535
wcs_olap: reomove year, month, day and dow tables
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
e7c3508786
wcs_olap: improve generic status mapping using new startpoint flag on statuses
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
f2eaa2c00e
wcs_olap: add a backoffice channel
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
ba433bf9d8
wcs_olap: temporary work-around to indicate startpoint statuses
2016-06-18 09:36:16 +02:00
Benjamin Dauvergne
2b231244b1
wcs_olap: improve comments on pg objects
2016-06-18 09:26:46 +02:00
Benjamin Dauvergne
7d67fcded2
wcs_olap: change label of generic statuses
2016-06-18 09:25:35 +02:00
Benjamin Dauvergne
4151129944
wcs_olap: encode unicode value
2016-06-18 09:23:54 +02:00
Benjamin Dauvergne
b166fc0d52
wcs-olap: handle unicode in exceptions when printing traceback
2016-05-25 10:54:17 +02:00
Benjamin Dauvergne
6180e500fc
wcs-olap: lowercase most dimension labels
2016-05-25 10:24:51 +02:00
Benjamin Dauvergne
383b4d8535
wcs-olap: fix dimension definition for item fields
2016-05-25 10:13:17 +02:00
Benjamin Dauvergne
9314d9b9c6
bi-joe: BI engine and frontend for PostgreSQL
2016-05-25 01:24:07 +02:00
Benjamin Dauvergne
45538f5d2f
wcs-olap: use wcs-olap section in .INI for default values
2016-05-24 21:44:57 +02:00
Benjamin Dauvergne
be6a0fc9ff
wcs-olap: make config path optional
2016-05-23 20:22:20 +02:00
Benjamin Dauvergne
a583a1b4f2
wcs-olap: skip formdata wihtout a receipt_time, they are lost drafts
2016-05-23 20:22:20 +02:00
Benjamin Dauvergne
25bc671a9d
wcs-olap: hash formdata and status table names when they are too long
2016-05-21 13:13:08 +02:00
Benjamin Dauvergne
33aa8456c7
wcs-olap: allow setting requests verify in config
2016-05-19 15:18:57 +02:00
Benjamin Dauvergne
fb29a0b330
wcs-olap: print traceback to stderr
2016-05-19 15:13:55 +02:00
Benjamin Dauvergne
439925ca5e
wcs-olap: skip delay computation when status resolving fails
2016-05-19 14:40:21 +02:00
Benjamin Dauvergne
8ce8dbef3f
wcs-olap: do not resolve unassigned functions
2016-05-19 14:37:08 +02:00
Benjamin Dauvergne
ab1828862d
remove debugging statement
2016-05-19 14:36:07 +02:00
Benjamin Dauvergne
fc7993a9dd
add debian packaging
2016-05-19 11:13:12 +02:00
Benjamin Dauvergne
ac3dc40a7a
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
e23c50f8ac
remove eau potable and assainissement from global stats
2016-04-28 14:51:55 +02:00
Benjamin Dauvergne
467334fb2d
start of wcs olap importer
2016-01-09 22:06:12 +01:00
Benjamin Dauvergne
b6b28a96cd
add cubes configuration for 3m
2016-01-09 22:06:12 +01:00