search

EDIorg / ECC

ECC = EML Congruence Checker
5 stars 0 forks source link

parsing datetime strings 2002-09-30T16:00-08 #8

Open mobb opened 6 years ago

mobb commented 6 years ago

Not sure why I am getting this message: Data value '2002-09-30T16:00-08' could not be parsed using formatString 'uuuu-MM-DD'T'hh:mm-hh'.\n

ID: knb-lter-sbc.4012.9, where: portal-s report date: 2018-02-05

report link: https://portal-s.edirepository.org/nis/reportviewer?packageid=knb-lter-sbc.4012.9&localPath=%2Fhome%2Fpasta%2Flocal%2Fharvester%2FLTER-ecoinformatics-org%2FSBC-evaluate-2018-02-05-1517876611088%2Fknb-lter-sbc.4012.9%2FqualityReport.xml

mobb commented 6 years ago

Here is the offending file. It looks like it is this formatstring that is causing the problem: 'YYYY-MM-DDThh:mm-hh'

knb-lter-sbc.4012.9.txt

mobb commented 6 years ago

Better! still cannot parse the data, but now the dateTimeFormatString reported correctly in the warn: Here is the XML: knb-lter-sbc.5028.2.txt

Report: https://portal-s.edirepository.org/nis/reportviewer?packageid=knb-lter-sbc.5028.2&localPath=%2Fhome%2Fpasta%2Flocal%2Fharvester%2FLTER-ecoinformatics-org%2FSBC-evaluate-2018-02-12-1518482214141%2Fknb-lter-sbc.5028.2%2FqualityReport.xml

mobb commented 6 years ago

Here is another example, with almost the same problem. date format string in metadata is: YYYY-MM-DDThh:mm:ssZ here is the head of that column from the data file: 2012-07-30T06:40:00Z 2012-07-30T07:00:00Z 2012-07-30T07:20:00Z 2012-07-30T07:40:00Z 2012-07-30T08:00:00Z 2012-07-30T08:20:00Z 2012-07-30T08:40:00Z 2012-07-30T09:00:00Z 2012-07-30T09:20:00Z

Link to report: https://portal-s.edirepository.org/nis/reportviewer?packageid=knb-lter-sbc.6002.2&localPath=%2Fhome%2Fpasta%2Flocal%2Fharvester%2FLTER-ecoinformatics-org%2FSBC-evaluate-2018-02-13-1518563115732%2Fknb-lter-sbc.6002.2%2FqualityReport.xml

original XML is uploaded, with txt extension knb-lter-sbc.6002.2.txt