Problems with Sugar and/or Outlook Plugin

[wjohnson]

1. Out of 43,761 records in our emails table:
1,793 records from_addr and from_name are NULL
7 records where to_addrs is NULL

We do not email from Sugar, all of these emails were archived with the plugin. This seems to have spanned multiple versions of SugarOS as well as corresponding versions of the Outlook plugin. I'm hoping that others could check their databases and let me know if I alone have this problem.

2. This might be because we use Exchange (or it might be an Outlook thing) but I noticed that sometimes in the to_addrs field there are only names listed, no email addresses.

3. I'm sure this is because of Exchange but most of the time emails are archived with the internal Exchange mailbox in the from_addr field

/O=SERVER/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=USER:

I assume that if I want this to be the POP email addresses associated with the user on the Exchange server then I'll have to run a query manually to update those?

4. Is responding to an archived email or maybe syncing an email from Sugar back into Outlook something that will be possible in future versions of Sugar?

Problem one is the most pressing and I'd like to nip it in the bud before it grows completely out of hand. I fear that I'm going to have to go in and look at each of those emails manually to figure out who they were from and to. Once I figure out more about them I'll be submitting bugs on these if that is indeed what they are.

[wjohnson]

I created bug 16392 regarding the NULL from_addr and from_name fields in the email table.

[andydreisch]

Hi wjohnson, thanks for the bug entry. I'll work with Susie to make sure this is in the triage list for 451g.

Andy

[wjohnson]

This bug still exists in 5.0b! We now have 6,985 emails in database that have a NULL from_addr field. How is that possible?!?!

Is there a query we can run to get those populated or do we have to go through by hand and enter that information for each and every single one of those emails?

[wjohnson]

We just installed patch 5.0.0e which the fix for this bug is included in. We're going to give it over the weekend to confirm that.

Assuming that everything is fixed going forward, we are going to have to do something about the 14,127 emails that are in our database with NULL values where there shouldn't be. The patch did not go back and fill in that data. Can the Sugar team provide a query (or two or three) that we can run to populate those fields? Or is this something that we're going to have to do by hand fourteen thousand times?

Thanks.

[Angel]

I am not sure you are going to be able to retroactively correct this via some SQL scripts...

It doesn't look like the database contains the from/to information beyond the two fields in question, thus, there is no place to extract it from unless one were to read the original message again.

[wjohnson]

THIS STILL IS BROKEN!!!

Was there an update to the Outlook plugin that was not published when I checked on Friday?