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?
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.
And yes
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.
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
