Ticket #384 (closed: fixed)
Import TS still requires TimeSeries Dummy Variable put on the end
Reported by: | shermanl | Owned by: | administrator |
---|---|---|---|
Priority: | normal | Milestone: | Ecopath 6: build 6.0.7 |
Component: | Ecosim | Version: | |
Severity: | minor | Keywords: | |
Cc: |
Description
The import still cannot import values without commas in the end of the CSV file. (mdb will be in an email)
Try import Gruper.csv into Grouper.mdb. This gives errors in the analyze because a , is missing in one of the row. Unfortunately, this is because Excel doesn't always give you a , at the end of each row, bombing the program. It happened a few times in the workshop.
Work around is to create a dummy variable ensuring that all comas exist.
Change History
comment:2 Changed 17 years ago by carieh
version 6.0.3.11
So I just imported a time series with missing values, and it does not look as though the missing values are assumed to be zero, they are just missing. I don't think assuming a value of 0 for a missing value is correct. I just wanted you to realize this.
csv files do import without a dumy row, so this is working. I just sent this to you so you would read the note
Ok, changed the way the importer works. It is now more forgiving; if year values are missing it presumes a value of '0'. This grace test is only added for year values; all other fields for each time series need to be provided!
Fixed after build 6.0.3.10