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

Revision history [back]

click to hide/show revision 1
initial version

Use weather converter to convert TMY3 to epw and ddy

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?

Use weather converter to convert TMY3 to epw and ddy

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?

Use weather converter to convert TMY3 to epw and ddy

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 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"

"d/m/y"

How can I fix it? it?