Skip to main content
Solved

Python Exception: Value Error

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

View original
Did this help you find an answer to your question?

5 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • danilo_fmeEvangelist
  • Evangelist
  • January 11, 2019

Hi @kevin_durkee

 

Could you share us your log file?

 

Thanks,

Danilo

K

Here's the Logfile

logfile.pdf

debbiatsafe
Safer
Forum|alt.badge.img+20
  • debbiatsafeSafer
  • Safer
  • January 11, 2019
kevin_durkee wrote:

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
  • 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
davidrich wrote:

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.

Reply


Helpful Members This Week

Community Stats

31,372
Posts
118,988
Replies
39,003
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.