readCSV skips rows in CSV files that have all empty fields. Note that Excel writes such rows with comma delimiters but no data between delimiters, like this: ,,,. This throws off cell references in Vensim functions such as GET DIRECT CONSTANTS.
The attached model illustrates the problem.
csv-blank-line.zip
For this model, sde test prints:
_k time=0.00 vensim=3 sde=4 diff=33.333333%
readCSVskips rows in CSV files that have all empty fields. Note that Excel writes such rows with comma delimiters but no data between delimiters, like this:,,,. This throws off cell references in Vensim functions such asGET DIRECT CONSTANTS.The attached model illustrates the problem.
csv-blank-line.zip
For this model,
sde testprints: