[open-economics] Yourtopia questions

Mon Feb 14 12:17:04 UTC 2011

On 14 February 2011 09:23, Dirk Heine <dirk at common-future.org> wrote:
> Dear all,
>
> If it is difficult to load the new questions without removing the
> previous data, should we then just go forward deleting that data? I
> think the price of giving up the data collected so far is worth paying
> if the questions can be exchanged soonish then.

It's fairly trivial to sync in the new data w/o overwriting -- it just
needs someone tech-y to spend the time. I'm sorry to not have done
this yet but I'm really swamped at the moment. I may be able to look
at this later this week though if someone (e.g. Dirk or your new techy
colleague) could look it might happen faster :)

Rufus

> What do you think?
>
> Best wishes,
>
> Dirk
>
>
>
> On Mi, 2011-02-09 at 23:02 +0100, Stefan Wehrmeyer wrote:
>> Hi guys,
>>
>> > Unfortunately I do not understand a few things. The new csv contains
>> > modified descriptions for the new description-boxes. Also it contains
>> > short labels for the piechart on the results page. So there are two new
>> > categories that we did not use to have. Hence the csv IS in a different
>> > format.
>> >
>> > Also, since you did not like when I deleted columns in the
>> > Google-Spreadsheet I did not delete them either in the csv but added new
>> > ones (new_label, new_description, new_piechart)
>>
>> I actually renamed the columns in indicator.csv from new_label to label and from label to old_label etc. so to not break the importer. I added the capability to write the piechart column to the importer (but piechart is not used yet in the templates).
>>
>> The import works, but as outlined in issue 25 (not issue 21), using the load feature of the importer without deleting indicators first puts too many indicators in the db and deleting everything first with delete_all deletes also the answers which would also be bad. So integrating the new indicator.csv needs a custom importer script as far as I can see.
>>
>> https://bitbucket.org/okfn/openhdi/issue/25/load-new-questions-from-indicatorcsv
>>
>> Apart from that, I integrated the new description in the templates in a hopefully decent way.
>>
>> Cheers,
>> Stefan
>>
>>
>>
>
>
>
> _______________________________________________
> open-economics mailing list
> open-economics at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/open-economics
>

-- 
Co-Founder, Open Knowledge Foundation
Promoting Open Knowledge in a Digital Age
http://www.okfn.org/ - http://blog.okfn.org/