somenergia-dataexports's Introduction

somenergia-dataexports

Several scripts to retrieve information from OpenERP data.

`distribucio_de_socies.py`

Generates a csv file (tab separated) counting members for each municipality.

Usage:

$ distribucio_de_socies.py [<iso-date>]  >  <output.csv>

Example:

$ distribucio_de_socies.py 2015-02-01 > DistribucioSocies-2015-02.csv

TODO's

Historical unaccuracies
- deactivated members are not counted when they were still members
- Members who started as owner or payer, are counted as member since then

`mapa_socies.py`

Generates svg maps of the distribution of the members.

`mchimp-generationsocis.py`

Generates csv to feed mailchimp mailings from OpenErp data

somenergia-dataexports's People

Contributors

Watchers

somenergia-dataexports's Issues

Polish the members distribution map by states (provinces)

A first version of the map is implemented but some svg work is needed in order to have it fully working:

A descriptive caption
Texts inside the province
Legend with templated intervals

Create a guide for those that want to generate a municipality level map

We are open to collaboration to add member distribution maps of smaller regions (local groups, counties) and detailed to municipality level.

Find an SVG map of the region with the divisions of the municipalities (try in wikipedia)
Turn the SVG into a template so that the script is able to change the colors of each polygon and the captions and texts.

Turning an SVG into a template is not a straight forward task so a quick guide is required.

Add contracts distribution maps

Contract distribution maps should be easier than member distribution as the contracts are more precisely located (members may have many addresses and often is hard to choose the one to pick, while contracts have a unique location).