Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Data not mapping from Talend to SugarCRM

#1 2009-10-26 19:54:02

wwhitman
Member
Registered: 2009-10-01
Posts: 13

Data not mapping from Talend to SugarCRM

Tags: [mapping, opportunity, sugarcrm]

I am attempting to create an opportunity in SugarCRM.
I am using the SugarCRMOutput object.
It looks like all but one data field is being transferred.
The account_name field is populated on the Talend side as seen in tracing.
When I check the Sugar Opportunities - the Account Name field is empty.
I also checked the table accounts_opportunities where the relationship is  held and it is not there as well.
I checked and the 'account name' does exist in the Sugar accounts table.
Any ideas why this field only does not map??

Offline

#2 2009-10-27 03:21:22

shong
Talend team
Registered: 2007-08-29
Posts: 10357
Website

Re: Data not mapping from Talend to SugarCRM

Hello
Which version of TOS  do you use?

Best regards

          shong

Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2009-10-27 13:20:12

wwhitman
Member
Registered: 2009-10-01
Posts: 13

Re: Data not mapping from Talend to SugarCRM

Sorry for the delay.
Version 3.1.4.r29781

I did notice that when I inspected the opportunity object in SugarCRM there was no 'account name' field. The other fields were defined along with my custom fields. Labels were there  tho.

Last edited by wwhitman (2009-10-27 17:06:29)

Offline

#4 2012-06-26 21:04:25

spinegar
Member
Registered: 2012-06-13
Posts: 23

Re: Data not mapping from Talend to SugarCRM

I am experiencing this same issue with Talend Open Studio for Data Integration 5.1.1

It looks like the accounts_opportunities table is not being populated in sugarcrm which is preventing the Account Name field from showing the data I am passing via the connector.

Has anyone figured out how to resolve this?

Offline

#5 2012-06-26 21:26:43

spinegar
Member
Registered: 2012-06-13
Posts: 23

Re: Data not mapping from Talend to SugarCRM

I resolved the issue by adding an account_id column to the schema for the opportunities module in the tSugarCRMOutput component.

Offline

#6 2013-04-07 14:31:51

peeterm
Member
Registered: 2011-11-26
Posts: 24

Re: Data not mapping from Talend to SugarCRM

Looks like you are using Related field to relate them. Related field is pretty limited solution for creating relationships between modules in some cases. If you need to create real relation between modules via API then default Sugar CRM component in Talend doesn't support it and you need Advanced Sugar CRM Component

Cloudbee

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Data not mapping from Talend to SugarCRM

Board footer

Powered by FluxBB