[EU-lobby-data] Fwd: urgent reminder of tasks before next session Thursday 10 January

Wed Jan 9 10:26:57 UTC 2013

Dear Olivier and all others,

I hope you had a relaxing break as well! For me it was really nice to
have some time doing things completely unrelated to work.

There are indeed some news from our web developers in Berlin/UK (see
email below). The curve guys ran into some problems with duplicate
entries. Friedrich, can you talk to them regarding this?

The good news is: there seems to be something we can have a look at.
Unfortunately, the log-in details provided by Mathilde don't seem to
work for me. Do you have better luck?

Best, Timo

-------------------------------------------------

Hello both of you!
Happy new year!! I hope you had a great Christmas period and start to
the year.

So I have a couple of questions

First, and most urgent - the guys at Curve agency have had problems with
the data. They have spent 3 days on sorting it, duplicates etc.
It would seem that it was assumed the API export would be the full
database, but in fact does not correspond to the full data. The easiest
at this stage (and sorry, I assumed had been the case already) is if
they can have access to the database itself... Friedrich, is this
possible? and if not, how come...?

This is a few words they sent to describe their problem:

We’ve tried to pull content from the API as best we can and we have
succeeded in getting the correct amount of content from the API in all
instances - so for example we succeeded in pulling out 11,233 people
from the system, but when importing data this data set seems to miss
lots of people out. To combat this, we also tried to pull a list of
‘heads’ and ‘legal’ straight from the representatives, but again there
seems to be data missing. We’ve concluded that without direct database
access we’re not confident in the data that is being returned by the API
and how complete this data is. In summary the API is returning
incomplete data.

Another issue we’re facing (which you’re obviously aware of is duplicate
content). There are several rows of duplicate data in the system, but
there are also many rows of data where the ID’s are the same (we’re
using the IDs as unique identifiers in our system), but other data might
be slightly different. It’s difficult to know which data we should trust
in this instances as obviously we’re less knowledgeable about this data
than yourselves.

This is quite a problem, because the agreement with them, was not to
spend time on data cleaning and sorting etc... and unfortunately they
have had to do this... and this means spend time that has not been
accounted for (yet..) They know we are very tight on budget.. but they
are asking that additional budget can be considered. Timo, I don't know
how much is there and possible.. but it is true that this has caused
them a lot of extra work.. to be discussed...

They have given me access to design start they have which I give you
here to login
They are otherwise happy with how it is advancing and the progress.

Please click on the following link to activate your account:
http://curveagency.hotgloo.com/activate/d5d3d3760eae9869a1bff48bffb399f701b360b1

Use the username and password provided below to sign in:
Username:mathilde at tacticaltech.org
Password: fdc386b9

Let me know on thoughts about this data question.. sorry to bother you
Friedrich, but maybe again it is better you talk to them directly so
that every body is clear on what is the situation...

Take care!

Mathilde

> 
> 
> 
> Dear lobbyfacts.eu collective! I hope you all had a great, relaxing
> winter break; happy new year to all of you. On Thursday afternoon we'll
> be chatting again as we have a collective cleaning session planned
> (thursday 10th January, 2-5PM). In the meantime it would be great to get
> updates on whatever progress has been achieved since we talked on 14
> December. I'm resending the notes from our last call, to remind all of
> us (incl myself) of the tasks we committed to do. I'm also very curious
> if there's any news from the Berlin-based web-designers.
> 
> One of the things we need to discuss in the next days is the launch
> date: 19 February turned out not to be available in the Residence
> Palace. Depending on how far we are with all the tasks, we m,ay anyway
> need a week extra (or more)... Shall we start the cleaning session
> Thursday at 14 o'clock with a short skype call about this issue?
> 
> friendly greetings
> 
> Olivier
> 
> -------- Original Message --------
> Subject:     Re: [EU-lobby-data] notes crunchers' call - 14122012
> Date:     Fri, 14 Dec 2012 18:02:36 +0100
> From:     Natacha Cingotti <natacha.cingotti at foeeurope.org>
> Reply-To:     Data crunching on EU lobby data
> <eu-lobby-data at lists.okfn.org>
> To:     Data crunching on EU lobby data <eu-lobby-data at lists.okfn.org>
> 
> 
> 
> hola folks, quick notes from our call today (below and attached)
> Have a nice weekend all
> 
> ****
> 
> *Notes lobby data crunching call - 14122012*
> 
> Present: Erik, Ester, Natacha, Olivier, Timo
> 
> 
> - Website update and launch date
> 
> 
> With time needed to negotiate new agreement with TacTech, Xmas break
> ahead, and time needed for feedback and testing website,
> 
> everyone nervous that timeline not realistic to launch working website
> on 22 January
> 
> *
> AP - decision to postpone launch to 19th Feb (week 8)*
> 
> *AP - CEO to change room booking at Residence Palace*
> 
> 
> - Friedrich's app for crowd-sourcing and issue sector-specific tags
> 
> 
> Few people started playing with it and found some strange things
> (classification of categories not matching with OpenSecrets' anymore;
> 
> unclarities with what some of the proposed cat. stand for; US
> spellingâ€¦). Categories will need to be adapted before launch of the
> appli.
> 
> 
> *AP - Erik to send Friedrich feedback and discuss with him which parts
> can be addressed*
> 
> 
> *AP - Erik to check with OpenSecrets how they deal with organizations
> that can be classified under multiple categories *(cf. Arms companies)
> 
> 
> *AP - all of us to think of which sectors we'd like to prioritize for
> the launch. Ester to send a list of proposals and everyone to comment on
> it by 15 Jan*
> 
> 
> - Decision on average-versus-maximum issue
> 
> 
> *Consensus to go for average value*
> 
> 
> - Background texts for website
> 
> 
> *AP - everyone to send comments to Ester's proposal for structure *
> 
> 
> *AP - Ester to send first drafts for everyone to comment by 15 Jan
> (Natacha offers to help -> Ester to send request for specific bits if
> needed)*
> 
> 
> - Launch: press invitations and outreach plan
> 
> 
> *AP - all of us to send comments to Ester by 7 January so that she can
> send first invit to journos on 10 January*
> 
> 
> *AP - Erik to write first draft for workshop structure by Friday 21
> December*
> 
> 
> *AP - Erik to ask Friedrich if needs more things from us
> (decisions/infoâ€¦) in terms of finishing the programming part *
> 
> *+ to suggest proposal on how to move on acronyms *(quite problematic
> for cleaning)
> 
> 
> - planning document and calendar
> 
> 
> *AP - Olivier to update planning doc and send around*
> 
> 
> -AOB
> 
> 
> *Next collective cleaning session: thursday 10th January, 2-5PM*
> 
> *
> *
> 
> On Friday, 14-12-2012 on 16:56 Timo Lange wrote:
> 
>    Just saw this new email from Mathilde. Didn't have a look at it yet.
> 
>    timo
> 
> 
>    -------- Original-Nachricht --------
>    Betreff: Lobby Europe
>    Datum: Fri, 14 Dec 2012 14:54:35 +0100
>    Von: Mathilde <mathilde at tacticaltech.org>
>    An: Timo Lange <timo.lange at lobbycontrol.de>
> 
>    To add to the questions I sent earlier, here is the site map and the
>    technical scoping that needs to be looked through.
>    I hope you are well!
> 
>    Mathilde
> 
> 
>    --    Timo Lange
>    LobbyControl e.V. - Berliner BÃ¼ro
>    Schiffbauerdamm 15
>    10117 Berlin
>    Tel: ++49 - (0)30 - 275 83 911
>    Fax: ++49 - (0)30 - 278 79 367
>    timo.lange at lobbycontrol.de <mailto:timo.lange at lobbycontrol.de>
>    www.lobbycontrol.de
>    _______________________________________________
>    eu-lobby-data mailing list
>    eu-lobby-data at lists.okfn.org <mailto:eu-lobby-data at lists.okfn.org>
>    http://lists.okfn.org/mailman/listinfo/eu-lobby-data
>    Unsubscribe: http://lists.okfn.org/mailman/options/eu-lobby-data
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> eu-lobby-data mailing list
> eu-lobby-data at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/eu-lobby-data
> Unsubscribe: http://lists.okfn.org/mailman/options/eu-lobby-data
> 

-- 
Timo Lange
LobbyControl e.V. - Berliner Büro
Schiffbauerdamm 15
10117 Berlin
Tel: ++49 - (0)30 - 275 83 911
Fax: ++49 - (0)30 - 278 79 367
timo.lange at lobbycontrol.de
www.lobbycontrol.de