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

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

Generates svg maps of the distribution of the members.

Generates csv to feed mailchimp mailings from OpenErp data

Name		Name	Last commit message	Last commit date
Latest commit History 119 Commits
b2bdata		b2bdata
.gitignore		.gitignore
LICENSE		LICENSE
MapaContratos-template.svg		MapaContratos-template.svg
MapaProvincias-template.svg		MapaProvincias-template.svg
MapaSocios-template.svg		MapaSocios-template.svg
MapaSocios.svg		MapaSocios.svg
MapaSocios_pob.svg		MapaSocios_pob.svg
README.md		README.md
README.rst		README.rst
accept.sh		accept.sh
clients_no_socis.sql		clients_no_socis.sql
cron_distribution.sh		cron_distribution.sh
cron_energetica.sh		cron_energetica.sh
dbutils.py		dbutils.py
distribucio_de_altas.sql		distribucio_de_altas.sql
distribucio_de_polissas.py		distribucio_de_polissas.py
distribucio_de_polissas.sql		distribucio_de_polissas.sql
distribucio_de_polissas_aggregated.sql		distribucio_de_polissas_aggregated.sql
distribucio_de_socies.py		distribucio_de_socies.py
distribucio_de_socies.sql		distribucio_de_socies.sql
exclude.txt		exclude.txt
mapa.py		mapa.py
mchimp_amorendarrerides.py		mchimp_amorendarrerides.py
mchimp_generationsocis-sql.py		mchimp_generationsocis-sql.py
mchimp_generationsocis.py		mchimp_generationsocis.py
order.txt		order.txt
poblacio_ccaa.csv		poblacio_ccaa.csv
poblacio_provincies-20150101.csv		poblacio_provincies-20150101.csv
requirements.txt		requirements.txt
resum_energeticacoop.sql		resum_energeticacoop.sql
scale-classic.csv		scale-classic.csv
scale-somenergia.csv		scale-somenergia.csv
scale.csv		scale.csv
setup.py		setup.py
somenergia.css		somenergia.css
sort-csv.py		sort-csv.py
test.sh		test.sh
testcases.yaml		testcases.yaml