topic Re: Help with "Type Mismatch" errors in Talend Studio

Help with "Type Mismatch" errors

_AnonymousUser — Thu, 10 Nov 2016 17:00:39 GMT

I'm new to Talend and needing help getting past the following "Type Mismatch" errors:
Warning! Some errors exist in job. Would you like to continue?
Type mismatch: cannot convert from Float to String
Type mismatch: cannot convert from Float to String
Type mismatch: cannot convert from Integer to Double
Type mismatch: cannot convert from String to Date
Type mismatch: cannot convert from String to Date
Type mismatch: cannot convert from Integer to Double
Type mismatch: cannot convert from String to Date

Here is my tMap:

Re: Help with "Type Mismatch" errors

_AnonymousUser — Thu, 10 Nov 2016 17:05:37 GMT

How do I login in order to post an image of my tMap?
- I created an account
- I click on login, but I'm already logged in? It shows my account info, but forum page does not show that I'm logged in?

Re: Help with "Type Mismatch" errors

_AnonymousUser — Thu, 10 Nov 2016 17:13:18 GMT

Keeps saying: You are not logged in.

Re: Help with "Type Mismatch" errors

_AnonymousUser — Thu, 10 Nov 2016 17:19:46 GMT

Here is my tMap:

Re: Help with "Type Mismatch" errors

_AnonymousUser — Thu, 10 Nov 2016 22:01:20 GMT

Ok, I was able to resolve all of the errors by going into the "input" side of the tMap columns and match their "data Type" & "Date Pattern" columns to the "output" side.
Now that the data is uploading into Salesforce, I have one last issue:
[list=1]

Company Name is being loaded into Salesforce as a long ID? (for example: "Keepes Funeral Home" comes in as "a0W0P00000C1f5w"?)

In Salesforce, this field is the "Name" field (Text(80)

Re: Help with "Type Mismatch" errors

_AnonymousUser — Thu, 17 Nov 2016 15:13:03 GMT

Fixed my issue.
I had the wrong field mapped in Talend.

[list=*]

I added in the Name field on the tMap (on the Salesforce side)

Then mapped it to the ActDes field (on the MySQL side)

The MBS Name field is now updating correctly.

Re: Help with "Type Mismatch" errors

_AnonymousUser — Thu, 17 Nov 2016 15:38:25 GMT

Now ready to try and schedule this job in Talend.