Subject: How to arrange data in excel csv fromat Posted: 12/11/2015 Viewed: 10734 times
This is Naveed and I am using WEAP since last 2 years, I have run my model for demand based irrigation requirement. I have reinstalled my new windoa nd latest model of WEAP and facing a problem. I have copied my previously developed model in the new WEAP Model directory and when I run my model it gives error with following indication
some time it indicate "your first row is empty"
some time it says "first row will be a year"
and I want to ask how I may arrange my data in CSV format?
I have dd-mm-yyyy in the first colum and in the second column data required.
I have to arrange data in this format (YYYY in first column, Month in second column, date in thired column and data in fourth column) or some other format. Please let me know.
I have not made any change in the model developed in older version and new version and in the older version this model have not gave any problem and why it is indicating error now??
Is there any restriction or special format to be adop in this new version???
Mr. Jack Sieber
Subject: Re: How to arrange data in excel csv fromat Posted: 12/11/2015 Viewed: 10729 times
WEAP's ReadFromFile function can read CSV files either in daily format or monthly.
Daily data file start each line with the date, e.g., 1/31/2015. Monthly data files start each line with year, month, e.g., 2015, 1.
Your problem might be that WEAP does not recognize your date format. By default, WEAP will use the Windows system "Short date" format (set in the "Regional and Language Options" Windows Control Panel) for interpreting daily dates, e.g., mm/dd/yyyy or dd/mm/yyyy. However, because you may want to share your WEAP area with someone in another country (whose regional settings are different), it is best practice to include in the file a line that specifies the date format used. To do this, place a $DateFormat directive into the CSV file, on a line at the top before the data values. For example, to specify dd-mm-yyyy as the date format, include the following line at the top of the file:
$DateFormat = dd-mm-yyyy
Some other examples:
$DateFormat = mm/dd/yyyy
$DateFormat = d-m-y
$DateFormat = m d y
$DateFormat = d/m/y
$DateFormat = yyyy/m/d
Subject: Re: How to arrange data in excel csv fromat Posted: 10/18/2016 Viewed: 9404 times
Hi Jack. This is Paul, and I'm having similar problems with the CSV formats required by the WEAP. In my particular case im trying to add daily climate data to my model, but while I'm using the "readfile wizard" an error occurs whit the following indication:
Duplicate monthly data for year= XXXX, month=XXXX.
My data are organized YYYY/mm/dd, because when I tryed to use dd/mm/YYYY weap just said me, that I have to use year first. I tryed to use the $DateFormat directive as you suggest in the last message, but It didn't work to me. Could you please tell me what I'm doing wrong.
Ms. Stephanie Galaitsi
Subject: Re: How to arrange data in excel csv fromat Posted: 10/19/2016 Viewed: 9394 times
Are you sure you don't have duplicate dates somewhere in your spreadsheet? For instance, the year 2009 might accidentally extend into January 2010, and then you would have 2 January-2009 on your spreadsheet. Have you checked for any problems like this?