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

% issue & panel data importation issue #270

Closed quciet closed 4 months ago

quciet commented 4 months ago

Seems the ghost of % is still there to be taken down. I'm using version 8.18 with this file Validation_PIP.xlsx. Importing sheet SeriesIncBelow2D15c%PIP gives me following issue. image

Another issue happens when importing sheet SeriesIncMedPIP. Year columns are eliminated after import.

image

PardeeCenterIFs commented 4 months ago

The error seems to happen when trying to drop an existing table in ifsDataImport.db, so it seems to me that a workaround could be to delete manually the table. Anyway, I have now fixed the "%" for the Drop statement, and it will be included in version 8.19.

Regarding the years not loading, that's because this is not in our regular "Long" format. The format is supposed to have Countries in the first column, and years in the second, but in this case FIPS_CODE is in the 2nd column and the year in the third, so that causes the problem, fix the file and it works.

quciet commented 4 months ago

The error seems to happen when trying to drop an existing table in ifsDataImport.db, so it seems to me that a workaround could be to delete manually the table. Anyway, I have now fixed the "%" for the Drop statement, and it will be included in version 8.19.

Regarding the years not loading, that's because this is not in our regular "Long" format. The format is supposed to have Countries in the first column, and years in the second, but in this case FIPS_CODE is in the 2nd column and the year in the third, so that causes the problem, fix the file and it works.

I think the Data Import interface provides an option for users to help IFs to identify the columns of country & year, is that not working?

PardeeCenterIFs commented 4 months ago

I have added code now to allow years to be in a different column, other than the first. This fix will be included in version 8.19.