Page MenuHomePhabricator

Empty fields instead of 0 in geowiki files
Closed, DeclinedPublic

Description

Instead of listing "0" for fields without any active editor, geowiki csvs
have the field empty.

E.g.: the 2014-03-17 line of

https://stats.wikimedia.org/geowiki-private/ca_top10.csv

has empty fields. The scheme is (actual numbers modified due to the confidentiality of the data):

2014/03/17,,3.0,2,6,8,10,5,31,15,9,11,,,5.0,33,,,8,1.0

, while someone might expect

2014/03/17,0,3.0,2,6,8,10,5,31,15,9,11,0,0,5.0,33,0,0,8,1.0

instead.

I've had a report that the missing 0s make it hard to have google graphs
library understand the csvs.


Version: unspecified
Severity: minor

Details

Reference
bz62867

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 3:05 AM
bzimport set Reference to bz62867.
bzimport added a subscriber: Unknown Object (MLST).

Seems geowiki always produced files that way.
Limn and LibreOffice can consume the CSVs without problems.

Leaving it to Toby to prioritize.

Until a fix is in place, one can always just add 0 to the empty
fields. E.g.:

sed -e 's/,/,0/g' -e 's/,0\([0-9]\)/,\1/g' ~/ca_top10.csv

Thanks Christian. I'm not feeling the priority at the moment.

If others feel differently, please say so here.

-Toby

I could figure out a temporary work around, so this bug is not urgent. But if it's something that is generally beneficial and doesn't require a lot of time to resolve/update the existing data, It would be great to see it resolved.

bingle-admin wrote:

Prioritization and scheduling of this bug is tracked on Mingle card https://wikimedia.mingle.thoughtworks.com/projects/analytics/cards/cards/1489