Skip to main content
Question

Excel Reader issue reading dates

  • September 21, 2018
  • 3 replies
  • 52 views
rudy_v
Contributor
Forum|alt.badge.img+6

I am reading an excel file, and seems most datetime fail to read

It shows for example HH:MM:SS for 5PM as 166000, and therefore it fails converting it, because 60 minutes is not valid.

'20181007166000' is not an FME datetime. YYYYMMDD, HHMMSS[.X+][(+/-)zz] or YYYYMMDDHHMMSS[.X+][(+/-)zz] expected. Use a DateFormatter transformer to adjust the format of datetime strings.

any ideas

3 replies

takashi
Contributor
Forum|alt.badge.img+19
  • takashiContributor
  • Contributor
  • September 21, 2018

Hi @rudy_v, I was not able to reproduce the same symptom as yours.

  • What version of FME are you using?
  • Could you please share a minimal Excel file which contains the question date/time value?
  • As an interim workaround, the DateTimeConverter (set 'Yes' to the 'Repair Overflow' parameter) could be used to repair the invalid date/time.
rudy_v
Contributor
Forum|alt.badge.img+6
  • rudy_vContributor
  • Author
  • Contributor
  • September 21, 2018
takashi wrote:

Hi @rudy_v, I was not able to reproduce the same symptom as yours.

  • What version of FME are you using?
  • Could you please share a minimal Excel file which contains the question date/time value?
  • As an interim workaround, the DateTimeConverter (set 'Yes' to the 'Repair Overflow' parameter) could be used to repair the invalid date/time.
using 2018.1, and has set it to yes - will upload file soon
rudy_v
Contributor
Forum|alt.badge.img+6
  • rudy_vContributor
  • Author
  • Contributor
  • October 9, 2018
takashi wrote:

Hi @rudy_v, I was not able to reproduce the same symptom as yours.

  • What version of FME are you using?
  • Could you please share a minimal Excel file which contains the question date/time value?
  • As an interim workaround, the DateTimeConverter (set 'Yes' to the 'Repair Overflow' parameter) could be used to repair the invalid date/time.
@takashi got it to work, but i had a 2003 xls file before, that worked ok, but i have changed the file in the reader to 2010 version xlsx, that failed on even with repair

 

But i have deleted the reader and create from scratch, by using the xlsx file, then it worked OK

 

Reply


Helpful Members This Week

Community Stats

30,940
Posts
117,251
Replies
38,742
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.