For input string: "1 ano"

[Anonymous]

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?

[Anonymous]

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

[akumar2301]

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 ?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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