You are not logged in.
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
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 ?
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
I searched the MySQL database and found the table that contains
invalid_email and opt_out fields : email_addresses
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
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
Last edited by ysh (2012-04-03 12:07:57)
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.