Talend community forum / tSugarCRMOutput don't insert in custom fields, why???

jb · 2009-07-07 13:07:06

hi of new, i have other problem with sugarcrmoutput, this time the problem is with custom fields in the modules.
when i choose a module (prospect_lists for example), the schema appear, ok, if i modify the schema, and i add a new field (i added this field in table in database), when i run the job, all is "ok", but the job writes only in standard fields, and the field that i added is empty.

someone know this??

thanks

jb · 2009-07-07 21:18:22

help please!!

shong · 2009-07-08 04:37:27

Hello
How do you add a new field to SugarCRM? I don't think it is enough just to add this field in its table in database. Currently, Talend doesn't support customize your SugarCRM application, include modify the look and feel of SugarCRM, add new fields to SugarCRM etc...

Best regards

shong

jb · 2009-07-08 09:23:32

hi, if i add new field (in prospect_list for example) using studio (of sugarcrm), this new field appears in a new table prospect_list_cstm, and i thought that it was the problem for talend. Then, i added new field manually in the table "prospect_list", but talend don't write in this fields.

I need write this new field, because talend (and sugarcrm) generates the field "id" (primary key) randomly, and i need somes custom ids

one thing more....if talend doesn't support customize insert in sugar...which is the utility of "Edit schema" (where we can add/delete fields)??

Regards, and thanks

Last edited by jb (2009-07-08 09:36:31)

mhirt · 2009-07-08 09:37:58

I'm still in 5.1, but as far as I know, SugarCRM web service doesn't support custom fields.

Here is the process :
Insert your records with tSugarCRMOutput component
Get the id inserted from the component with the global variable : ((String)globalMap.get("tSugarCRMOutput_1_ID"))
Then insert the elements in the _cstm tables manually with the correct id.

HTH,

jb · 2009-07-08 09:55:16

mhirt wrote:
Get the id inserted from the component with the global variable : ((String)globalMap.get("tSugarCRMOutput_1_ID"))
Then insert the elements in the _cstm tables manually with the correct id.

HTH,

hi, sorry, can you explain better this??? :S thanks

besides, though i get the id inserted, i don't know how detect which is which to insert the correct id....^^

Last edited by jb (2009-07-08 10:15:12)

jb · 2009-07-08 11:25:31

well, i use tMap, and i get the values of id, and custom id, how can i update table? with tMysqlRow use "UPDATE contacts SET id = a.id2 WHERE id = a.var1;", but talend says that "Unknown column 'a.var1' in 'where clause'", when a is a tmap's row

i don't know if this serves to change the id for each row, i hope that yes.

thanks

Last edited by jb (2009-07-08 11:30:43)

mhirt · 2009-07-08 12:39:04

I don't know what you try to do.

contacts has been created by SugarCRM WebService.
Now you just need to create a contact_cstm with an id_c equals to the id from tSugarCRM component.

Use tMySQLOutput insert on your contacts_cstm table with id_c filled by your tMap....

jb · 2009-07-08 13:28:30

hi, in this moment, i'm trying to read a.var1 and a.if2 (of tMap) for use these for update (with tMysqlRow) contact table.

Now i have this query, and this works ok:

"UPDATE contacts SET id = 'yes_or_no' where id = '"+((String)globalMap.get("tSugarCRMOutput_1_ID"))+"';"

i can read a.var1 using ((String)globalMap.get("tSugarCRMOutput_1_ID")), but i don't know how to read a.ide (file's fields) and use this in tmsqlrow's query

i used ((String)globalMap.get("a.id2")) and ((String)globalMap.get("tMap_1_id2")) and ((String)globalMap.get("tFileInputDelimited_2_id2")) but they don't work.

sorry for all this i don't know where to read and to learn about this, only i have help of TOS.

Last edited by jb (2009-07-08 13:34:49)

jb · 2009-07-09 09:13:53

nobody know how to capture value of column "id2" from tMap_1 to use this into sql query???

Last edited by jb (2009-07-09 10:22:09)

jb · 2009-07-09 10:21:36

nobody????

is impossible to get fields's values of the rows (row1, row2, etc)??

well, i was looking for in java code, and provisionally i can use (String) fid_tFileInputDelimited_1.get(37)), to access at field "id2" of the file...but, can't i access using row1.id2 or similar?

regards

Last edited by jb (2009-07-09 10:56:55)

Announcement

Unanswered posts

#1 2009-07-07 13:07:06

tSugarCRMOutput don't insert in custom fields, why???

#2 2009-07-07 21:18:22

Re: tSugarCRMOutput don't insert in custom fields, why???

#3 2009-07-08 04:37:27

Re: tSugarCRMOutput don't insert in custom fields, why???

#4 2009-07-08 09:23:32

Re: tSugarCRMOutput don't insert in custom fields, why???

#5 2009-07-08 09:37:58

Re: tSugarCRMOutput don't insert in custom fields, why???

#6 2009-07-08 09:55:16

Re: tSugarCRMOutput don't insert in custom fields, why???

mhirt wrote:

#7 2009-07-08 11:25:31

Re: tSugarCRMOutput don't insert in custom fields, why???

#8 2009-07-08 12:39:04

Re: tSugarCRMOutput don't insert in custom fields, why???

#9 2009-07-08 13:28:30

Re: tSugarCRMOutput don't insert in custom fields, why???

#10 2009-07-09 09:13:53

Re: tSugarCRMOutput don't insert in custom fields, why???

#11 2009-07-09 10:21:36

Re: tSugarCRMOutput don't insert in custom fields, why???

Board footer