Implemented

Feature request CSV reader checks input

  • 7 April 2020
  • 3 replies
  • 80 views

Using the csv reader (https://how-to.aimms.com/Articles/csv/read-write-csv.html), I noticed that you don’t receive a warning in case a column is missing/spelled wrong, etc, when reading in the data with the CSV reader.

This can lead to major issues in larger projects, where you cannot check input manually before runs.

I understand that you can build checks manually, however it would be very helpful if these checks would be integrated.

 

Btw:
Is this the right section for feature requests?

Stephan ten Hagen 9 months ago

@dht 

You can now (version 1.1.1.21) get warnings for missing columns. It is controlled by the MissingValue attribute (which basically tells “what to say to the user when the source doesn’t give the data”). The default is to warn, but you can choose to get an error or just ignore it.

There is one exception. When the columns is essential, like for domain columns, then you will always get at least a warning even if MissingValue is set to ignore.

View original

3 replies

Currently DataLink does give an error when the column for a domain is missing. These columns contain values that are needed for every row, and without it we cannot read anything. For columns containing parameter values we don't check, because they are sort of "non essential".

We'll have a look to see if we can extend the check for domains to these columns as well. 

Userlevel 4

And yes @dht , this is the right category for FR! Thanks

@dht 

You can now (version 1.1.1.21) get warnings for missing columns. It is controlled by the MissingValue attribute (which basically tells “what to say to the user when the source doesn’t give the data”). The default is to warn, but you can choose to get an error or just ignore it.

There is one exception. When the columns is essential, like for domain columns, then you will always get at least a warning even if MissingValue is set to ignore.

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator