topic Re: For input string: "1 ano" in Talend Studio

For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 13:50:14 GMT

Hello, i have a large document in tfileinputExcel that pass trough an tMap

in metadata all the fields are String with only two exceptions(prices)

This is my metadata, and when i run my job i got this stupid issue "For input string"

The Field "1 ano" is inside [Garantia_Balcao]

You can check this out in my xls file above

Anyone can help me in this issue?

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 14:00:08 GMT

Is the data returned properly or is it blank? Do you get any other messages other than that one?

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 15:23:10 GMT

Yes the data return properly,
I only got this "For input string" in other fields too in others Sheets

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 15:46:57 GMT

Hi,

I believe the metadata in the schema defined and your actual file are not matching.

There are some previous posts in our Talend community on the same issue. Could you please refer them too?

https://community.talend.com/t5/Design-and-Development/resolved-error-talend-For-input-string/td-p/108406

https://community.talend.com/t5/Design-and-Development/Error-on-run-shows-For-input-string-quot-599-75-quot-in-red-but/td-p/49042

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 15:52:48 GMT

Hi,
I Already read all of these topics, but this is an alternative solution.
For one, or two fields this methods works properly
I got like 863 lines of this error "For input string" in differente Inputs of Excel.

" I believe the metadata in the schema defined and your actual file are not matching."
How my actual file have different schema ? could u please explain better?
I am using the Schema, and loading the same XLS.

Kinds Regards

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 16:11:34 GMT

Hi,

Could you please take a good record and bad record (which is giving this error) and compare them with text tool like notepad++ instead of Excel? Excel will auto format lot of details and may not be giving right results. Most probably you will find that the schema will have error where "1 ano" is going to Double datatype Street_price column (or even worse Gross price).

It might be for only certain records where the schema mismatch is happening.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 16:17:55 GMT

Hello,

You mean to compare fields? Copy and Paste in Notepad ++ (or some text editor) two columns, one which error appears and another that works properly?

Please be more specified what u want me to do, with examples will be better to understand.

Regards,

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 16:22:45 GMT

Hi,

I was trying to say to open the input data file with textpad or notepad++ instead of excel. You do not have to use the entire data set and you can use a sample of 10 records for verification.

There could be layout changes in the data file. If you can share the current data file (after removing any sensitive information) and your job, I can also look the flow from my end.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: For input string: "1 ano"

Anonymous — Wed, 06 Feb 2019 17:19:16 GMT

Hi,

I did not understand how to open the input data in Notepad.

I Uploaded a sample of the Content in XLS for u and a Sample Job, in this job "1 ano" doesnt appear the error of For input string, but appears in other field

For input string: "UPC"

Also an image of my current job

You can check that the content of error changed, but still the same issue.

If u cant solve the problem, i will upload my full job and sheet.

Regards

dataforum.zip

Re: For input string: "1 ano"

akumar2301 — Wed, 06 Feb 2019 22:48:50 GMT

for UPC , it is not able to parse 1st record which is header.Please add header as 1 in tfileinputexcel.

I guess '1 ano issue' is resolved as it is parsed well in your sample job.

Also You can select die on error in tfileinputexcel to see where parsing fails actually.

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 10:41:46 GMT

Yes, UPC is the header i understand, but my error persists in my big Job, the error appears random form, i cant spread my full current Job

To Remind, my data parse correctly, but this console is annoying "For input for string" like 1 hundred times

I also uploaded my Sample Input in "Zip" with my current Test Job

Re: For input string: "1 ano"

akumar2301 — Thu, 07 Feb 2019 11:22:12 GMT

Did you try "Die on Error" option on Input file component?
did it fail during Parsing ?

Is the column position is same in all sheets ?

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 11:58:40 GMT

I will try the Die on Error, but the data parse correctly, but this console still saying this annoying message

And the columns doesnt still the same in all sheets

But i have a Metadata for every Sheet, i think this isnt the problem

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 12:10:14 GMT

When i use t Die Error on Input, nothing happen, the console still the same and the job complete normally

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 18:10:05 GMT

Hi @iansoares is it possible for you to post a copy of your file that causes this so that I can take a look at it? Please don't post it if it contains any personal or confidential data. If it does contain personal or confidential data, could you remove that data or create a version of the file that is safe to share, but still exhibits the same problem? I *think* I might know why this is happening, but I need to see the file to test my theory.

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 18:12:00 GMT

I sent to your inbox the Input File, feel free to test your theory

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 18:25:24 GMT

Forget the previous post, I see that you have already uploaded your data. I have tested it and the only way I get anything like the UPC error is if I do not filter out the header row. Once I do that, the data runs OK. My config looks like this....

Can you share a file which does exhibit the original problem. If the file you shared is supposed to exhibit the original problem, it didn't when I imported it through the metadata ---> File Excel import and used that metadata for the component's schema. Can you try that?

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 18:28:03 GMT

Did u enter the Schema?
Yes i sent you the file whose contains error

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 18:29:00 GMT

I sent you in your Private Message the whole Input file, check it!

Re: For input string: "1 ano"

Anonymous — Thu, 07 Feb 2019 18:45:18 GMT

Sorry, you sent me that message while I was writing my last response. I will check it now 🙂