Internal server error on Ethiopia population data

[szeke]

Internal server error on Ethiopia population data

[bhatiadivij]

There's an error in specifying the region. The right attribute should be E instead of D
@szeke

[szeke]

Ah, thanks, what I get for doing things late.

I am stuck on another problem. I want to define one YAML file that works for all the files in the folder, tabula-UNDPEUE_WEREDA2000-0.csv, to -14.csv. The problem is that in column D, where the data is, the data does not always start in the same row, or ends in the same row. I got the bottom to work correctly, but can't get the top to work. I want the top to be the row after C = "Wereda" as in

statementMapping:
  region:
    - left: C
      right: E
      top: value(C/$top+n) = "Wereda" -> $top+n+1
      bottom: value(C/$top+n) = "" -> $top+n 
      skip_row:
        - value(C/$row) = "Sub Total" 
  template:
    item: item(C/$row)
    property: P1082
    value: value($col/$row)

[bhatiadivij]

I don't think it is a good idea to specify top in terms of top. This problem can be easily solved if we specify row 0 as the base row instead of $top.
Also, specifying bottom: value(C/$top+n) won't work as in some of the data files, the cell just below C= "Wereda" is empty which makes this condition true.
Following T2WML spec will work on all the files:

statementMapping:
  region:
    - left: C
      right: E
      top: value(C/0+n) = "Wereda" -> 0+n
      bottom: value(A:C/$top+n) = "" -> $top+n 
      skip_row:
        - value(C/$row) = "Sub Total" 
  template:
    item: item(C/$row)
    property: P1082
    value: value($col/$row)

[szeke]

Thanks