topic Re: Null int's causing For Input String " " error in Talend Studio

Null int's causing For Input String " " error

Anonymous — Sat, 16 Nov 2024 12:12:05 GMT

Talend/Java newbie so I am sure this is a problem of basic understanding -- thanks in advance for your help.
I am just learning Talend so my first job is a basic one but causing me trouble.
- downloading Football schedule .csv file from the internet using tFileFetch: http://www.repole.com/sun4cast/stats/cfb2011lines.csv
- tFileInputDelimited (pic attached) using CFBMetadata file I created
- tFileOutputExcel output file
Couple of problems.
1) it appears that even though I am downloading the file using tFIleFetch tFileInputDelimited is just passing along the data in the metadata file I have defined not the .csv file I downloaded. I got this job structure from one of the tutorials so I thought it was right, but apparently not.
2) I am only getting 42 rows when I run the job because it is giving me an empty string or For Input String " " error on the rows that have an empty value in the incoming CSV file. There is obviously some issue with the columns that I have defined as int's and floats in the metadata being treated improperly, but I don't know how to accommodate for that. I have tried several expressions to catch these, but to no avail.
thanks for the help.

Re: Null int's causing For Input String " " error

Anonymous — Tue, 11 Sep 2012 07:00:37 GMT

Hi,ClintMc
Thanks for using The talend, from your description i got that you want to use 3 components to finish the flow of data
-tFileFetch
-tFileInputDelimited using CFBMetadata file
- tFileOutputExcel output file
First, for the compont -tFileFetch you can see the pic attachment i have add. there are some hint in the pic
Second, from the Repository, and find the metadata--Filedelimited. Right click and create a new file delimited. In the wizard, you can upload the file you have got by the -tFileFetch. the hint also have been marked in the following pic
Third,drag the metadata we have created before, (we called cfb2011lines) into the job designer and make a row1 with the tFileOutputExcel.
I'm afriad that you are newbie cannot catch me, so i provide the detailed pic to you to understand that. Hope it will help you.
BTW, for the issue of or Input String " " error , there must be something wrong in the schema. If you using CFBMetadata file , the schema should be set by default.

Best regards
Sabrina

Re: Null int's causing For Input String " " error

Anonymous — Tue, 11 Sep 2012 07:08:17 GMT

Hi,ClintMc
Sorry for the failture of uploading pic, the size is overload.....i change it again. it works well now!

Best regards
Sabrina

Re: Null int's causing For Input String " " error

Anonymous — Tue, 11 Sep 2012 09:14:27 GMT

Hi,ClintMc
And for your issue(your pic attached), we point out where you make a mistake and give the description in the following pic. To reslove the problem, read the Line column as string type, and then convert the value to null or 0 if it is a empty string " " on tMap. please see my screenshot

Best regards

Re: Null int's causing For Input String " " error

Anonymous — Tue, 11 Sep 2012 22:25:03 GMT

valueOf worked like a charm on the float but I can't get it to compile on an Integer (row1.Visitor_score), which in the 2012 schedule has some zeros; am I doing something else wrong?

Re: Null int's causing For Input String " " error

alevy — Wed, 12 Sep 2012 04:13:00 GMT

The Test! button in Expression Builder doesn't work; you need to actually run the job. As long as row1.Visitor_Score is in the correct format for an integer it should be fine, although Integer.parseInt is more efficient than Integer.valueOf.

Re: Null int's causing For Input String " " error

Anonymous — Wed, 12 Sep 2012 04:42:07 GMT

Wow, you are exactly right...now I feel silly. Thank you for the reply!!