Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question
1

Use weather converter to convert TMY3 to epw and ddy

asked 2025-07-20 07:09:25 -0600

Calvin's avatar

updated 2025-07-21 09:40:39 -0600

Hi, I'm trying to use weather converter to convert TMY3 file which is in csv format to epw and ddy. I read the documents Auxiliary Programs and wrote the .def to adapt the format but I keep got date error during the process. My energyplus version: 25.1 Weather converter: 8.1.0 My def file:

&wthdata
NumInHour = 1
InputFileType = 'CUSTOM'
InFormat = 'DELIMITED'
DataElements = Date,Time,ExtHorRad,ExtDirRad,GloHorRad,ignore,ignore,DirNorRad,ignore,ignore,DifHorRad,ignore,ignore,GloHorIllum,ignore,ignore,DirNorIllum,ignore,ignore,DifHorIllum,ignore,ignore,ZenLum,ignore,ignore,TotSkyCvr,ignore,ignore,OpaqSkyCvr,ignore,ignore,DryBulb,ignore,ignore,DewPoint,ignore,ignore,RelHum,ignore,ignore,Atmos_Pressure,ignore,ignore,WindDir,ignore,ignore,WindSpd,ignore,ignore,Visibility,ignore,ignore,Ceiling_Hgt,ignore,ignore,Precip_Wtr,ignore,ignore,Aerosol_Opt_Depth,ignore,ignore,Albedo,ignore,ignore,Liq_Precip_Depth,Liq_Precip_Rate,ignore,ignore
DataUnits = 'mm/dd/yyyy','hh:mm','Wh/m2','Wh/m2','Wh/m2','x','x','Wh/m2','x','x','Wh/m2','x','x','lux','x','x','lux','x','x','lux','x','x','Cd/m2','x','x','tenths','x','x','tenths','x','x','C','x','x','C','x','x','%','x','x','Pa','x','x','deg','x','x','m/s','x','x','m','x','x','m','x','x','cm','x','x','{.001}','x','x','{.01}','x','x','mm','hr','x','x'
DataConversionFactors = 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,100,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1
DelimiterChar = ' '
DateSeparator = '/'
/

My real data in date field:

01/01/2004

My .audit file:

Note ** Definitions taken from associated "def" file.
Warning ** Did not find WMO for matching with Design Conditions, looking for WMO= 46692
Custom File Processing Details
Custom File, Number of Fields=  68
Delimited input, Delimiter Character=" "
Input Name  Skip Field (t/f)    Used by EnergyPlus  Conversion Factor   Field (from) First Record (before conversion    minimum value   maximum value   missing value
date    F   c   1.000   [1/]    N/A N/A -999999.0
Severe ** Error in Date field input, for Custom file=c:\xxxx\xxxx\downloads\466920_tmy3_csv\466920_tmy3_csv\test.csv
Invalid Date field specification= mm/dd/yyyy
Valid date fields are: "mm/dd/yyyy" or "mm/dd/yy" or "m/d/y" or "yyyy/mm/dd" or "yy/mm/dd" or "y/m/d" or "dd/mm/yyyy" or "dd/mm/yy" or "d/m/y"

How can I fix it?

edit retag flag offensive close merge delete

Comments

Hi Calvin, can you tell me whether the energyplus weather converter is available online for download?

Anurag_G's avatar Anurag_G  ( 2025-07-26 07:23:50 -0600 )edit

It's included in the energyplus installation. Simply installing energyplus and you shall see it in preprocess folder.

Calvin's avatar Calvin  ( 2025-07-27 20:14:00 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
3

answered 2025-07-21 11:39:06 -0600

MatteoMerli's avatar

I've never entered the date in that format, so I've never encountered that severe error. In my case, it's always worked by putting four separate columns in the CSV file: year, month, day, and hour. Then, in the .def file, I use:

DataElements = year, month, day, hour,...
DataUnits = 'x','x','x','x',...

And since it's a CSV, I also use:

DelimiterChar = ','
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops

Question Tools

1 follower

Stats

Asked: 2025-07-20 07:09:25 -0600

Seen: 202 times

Last updated: Jul 24