search

PardeeCenterDU / IFs-Issues-Tracking

This repository only holds the list of bugs that have been reported for IFs. Anyone may add a bug report, but please look to see if your issue has already been added!
2 stars 0 forks source link

update values under MostRecent/Earliest columns #287

Closed quciet closed 3 months ago

quciet commented 3 months ago

The 3 features under the extended features, which update values under either the earliest or mostrecent columns, are not working correctly.

When we rebased our model's base year from 2017 to 2019, IFs ran an internal process that update the values under the MostRecent column, i.e., the feature highlighed in the screenshot below. image

However, this process is not correctly storing data values, probably due to a conversion between data types. You can see the comparison below, the upper graph is prior to the conversion.

image

image

Then I tried to test this feature alone through Extended Features by manually changing a country's value under the MostRecent column in the database and then running the option, but IFs is not letting me. I'm using version 8.19. image

PardeeCenterIFs commented 3 months ago

The blow up error was caused by an empty string inserted in a table, SeriesEdPriAdultGrads15Total% has "" instead of a Null in 2015 for the DRC.

The extra decimals were caused by using the Real type to pass the values to update SQLite, it was fixed by using Text parameters instead. The fix will be included in version 8.20.