Skip to main content
Solved

Python Exception: Value Error

  • January 11, 2019
  • 5 replies
  • 78 views
K

I'm fairly new to FME so my apologies if this is a pretty straightforward question. I'm trying to create a GTFS Feed using FME by reformatting data I already have in a excel table. I'm getting an error from a reader and I'm not quite sure where to look, tried reformatting my table data again but no avail. I'm on Workbench 2017.1

Here's the error:

Python Exception <ValueError>: unconverted data remains: 4

Error encountered while calling function `convertDate'

f_95(PythonFactory): PythonFactory failed to process feature

 

Any help would be much appreciated

Thanks!

Kevin

Best answer by davidrich

Hi

I believe your issue is due to a rouge character "4" in your date data type columns. I would double check that all your date columns are all valid.

If unable to find the issue. change the data type for your date columns into string data type the use FME date converter to find the problem.

Dave

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • January 11, 2019

Hi @kevin_durkee

 

Could you share us your log file?

 

Thanks,

Danilo

Partner Solutial Brazil - www.solutial.com.br
K
  • kevin_durkee
  • Author
  • 2 replies
  • January 11, 2019

Here's the Logfile

logfile.pdf

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • 648 replies
  • January 11, 2019

Here's the Logfile

logfile.pdf

Hi @kevin_durkee

Thanks for the log file, would it be possible to provide a small sample your Excel dataset as well as your workspace? That may help in narrowing down the issue.
D
Forum|alt.badge.img
  • davidrich
  • 48 replies
  • Best Answer
  • January 12, 2019

Hi

I believe your issue is due to a rouge character "4" in your date data type columns. I would double check that all your date columns are all valid.

If unable to find the issue. change the data type for your date columns into string data type the use FME date converter to find the problem.

Dave

K
  • kevin_durkee
  • Author
  • 2 replies
  • January 14, 2019

Hi

I believe your issue is due to a rouge character "4" in your date data type columns. I would double check that all your date columns are all valid.

If unable to find the issue. change the data type for your date columns into string data type the use FME date converter to find the problem.

Dave

Thanks Dave, I used the date converter to find that all of the times with a 4 in it were being read incorrectly. After reformatting it worked.

Community Stats

32,083
Posts
121,831
Replies
39,718
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.