[Gretl-devel] Re: dbnomics error
On Wed, 26 Jun 2019, Sven Schreiber wrote:
I got this error when trying to fetch something from the Belgian
central
bank via the dbnomics add-on:
Datentypen nicht passend bei Operation [datatypes not matched]
*** error within loop in function fix_dimensions_bundle
> b.value_label = dvl[key][value]
called by function process_series_bundle
*** error in function process_series_bundle, line 38
> fix_dimensions_bundle(json, &b)
called by function dbnomics_get_series
This is gretl 2019b and dbnomics add-on 0.33.
I've just committed a work-around to git (updating the version to
dbnomics 0.34). This involves replacing unreadable "value labels"
with "<unknown value-label>".
The problem arose from the fact that in dbnomics JSON certain
aspects of series "dimensions" are represented as nested arrays, and
gretl doesn't have nested arrays. That sounds like a limitation of
gretl -- but IMO the problematic things should not be arrays in
JSON: they should be objects, since they have the form {key, value}
rather a bunch of values at par with each other. Here's an example:
"dimensions_values_labels" : {
"FREQUENCY" : [
[
"A",
"Annual"
]
],
...
}
My complaint is that ["A", "Annual"] is really a key/value thing,
artificially forced into JSON array form.
But this is unlikely to change so I guess we should try to develop a
better work-around.
Allin