Talend community forum / tSugarCRMInput missing fields

azurtem · 2012-03-28 14:16:14

Tags: [bug, database, email_opt_out, invalid_email, mysql, sugarcrm, tsugarcrminput]

Hi

I wanted to interrogate a SugarCRM input table (Prospects) in order to request
all records for which the fields [invalid_email] and [email_opt_out] were positive (true)
I tried with another table (contacts) but obtained the same result

It would seem that even though these fields are present in the tSugarCRMInput
object, we can't actually obtain their current values from the source tables

We can on the other hand interrogate the [do_not_call] field which is very
similar in nature to the two previous ones

Is this a bug ? Is there something that I can do to obtain the data for these
two fields or is this not possible with the community version of TOS ?

Thanks for your response

ysh

pedro · 2012-03-29 08:16:19

Hi

There isn't any limit in TOS about SugarCrm.

Code:

we can't actually obtain their current values from the source tables

Do you get any error?

Regards,
Pedro

ysh · 2012-03-29 11:23:42

Thank you for your response Pedro

No, I don't get an error.

The fields remain null whatever I do

Even if I enable the value of these fields for specific records,
TOS doesn't extract their corresponding values as it does for
the other fields in the same record such as : ID, first name,
primary street address, description, ...

Am I to assume that this is a bug ?

yann

pedro · 2012-03-29 11:41:47

Hi

Before we confirm it, could you upload a screenshot to show the all fields of Prospect or Contacts(System Management-->Workroom)?

Regards,
Pedro

Uploaded Images

ysh · 2012-03-29 12:51:45

Hi Pedro

I think you hit the nail on the head with this one

the fact that the schema contains the fields doesn't apparently
imply that the table contains the data. A little misleading in my
opinion.

I searched the MySQL database and found the table that contains
invalid_email and opt_out fields : email_addresses

cheers

yann

ysh · 2012-04-03 12:07:30

Hi

So after tinkering around a little, I discovered as mentioned previously that my
two sought after fields belong to a table called email_addresses

The snag is that this table isn't visible from Talend tSugarCRMInput
Furthermore there is actually a third table that sits in between
email_addresses and my contacts or prospects tables called
email_addr_bean_rel

contacts <->email_addr_bean_rel<->email_addresses

I tried to use the "use custom module" option but this was destined
to fail since we aren't refering to any custom modules here

So even though tSugarCRMInput lists my two sought after fields
(invalid_email and opt_out) in contacts or prospects, these are
actually stored in a separate table

So my question really is this : How is it that tSugarCRMInput
can query the contact or prospect's email address, but not these
two other fields ?

So again I ask is this a bug, or limitation or tSugarCRMInput ?

thanks for your responses

yann

Last edited by ysh (2012-04-03 12:07:57)

pedro · 2012-04-05 11:15:27

Hi Yann

I have read sugarcrm/soap.php?wsdl, delved into the code of tSugarCrmInput and connected to mysql.
If tSugarCrmInput can't get data of invalid_email and opt_out, the columns shouldn't be in Prospects and Contacts module.
It's a bug. Please report it on BugTracker.

Regards,
Pedro

ysh · 2012-04-06 17:38:30

Once again, thank you Pedro for taking the time
to look into this in such a thorough manner

I will as suggested open a bug request

Thanks

yann

Announcement

Unanswered posts

#1 2012-03-28 14:16:14

tSugarCRMInput missing fields

#2 2012-03-29 08:16:19

Re: tSugarCRMInput missing fields

Code:

#3 2012-03-29 11:23:42

Re: tSugarCRMInput missing fields

#4 2012-03-29 11:41:47

Re: tSugarCRMInput missing fields

#5 2012-03-29 12:51:45

Re: tSugarCRMInput missing fields

#6 2012-04-03 12:07:30

Re: tSugarCRMInput missing fields

#7 2012-04-05 11:15:27

Re: tSugarCRMInput missing fields

#8 2012-04-06 17:38:30

Re: tSugarCRMInput missing fields

Board footer