issue changing [Type] in dbo.ContactMainTable/ contacts seem to be deleted

Status
Not open for further replies.

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Dear BCM users,

we have a newer issue with our BCM contacts:

accounts seem to be deleted.

when looking in the dbo.ContactMainTable the account dataset is still there, but with the wrong Type. Instead of Type 2 (account contact) the Type is changed to 1 (business contact). Outlook does not show this contact, nor as account neither as business contact.

After changing the field to value '2' the account is correctly shown again by BCM Outlook Addin.

I can't understand the cause of the change. In BCM there is no way to change an account to a bussiness contact or the other way round.

Any ideas?

thx

Tobias
 

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
yes indeed, we use "Outlook Sync DB" by "Andreas Schultz Software" to sync the BCM contacts (type '7'/ projects excluded) with the "my contacts" folder of the exchange accounts. He assured us that the type field isn't been synchronised within the sql statement.
Is there any type filed at all in the exchange contact?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
In a contacts folder, there isn't a 'type' field, outlook uses message class to separate it's two types- contacts and distribution list. It also supports custom fields, so software could add it and Exchange would ignore it.

Are you syncing accounts and contacts? If he isn't syncing the field but you are syncing both types, i can see that it could be possible that it's being changed during the sync.
 

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
thanks Diane,

but why it does that only in a few cases (not more than 2-3 contacts are being changed in a month in that way)? we sync every 30 minutes...

For excluding the cause you mentioned I change the sql statement for only syncing the type '1' datasets.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
but why it does that only in a few cases (not more than 2-3 contacts are being changed in a month in that way)?

That is the $64M question. :) Is it always the same ones or is there a pattern? Like maybe only ones you edit on a device or outside of BCM are affected. If so, the editing process does something that makes the sync see it as a contact instead of an account.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R Issue in changing the default account Using Outlook 4
J Outlook changing from inbox/trash/sent, etc. is EXTREMELY slow since updating Windows a couple of days ago. Is there an issue with Outlook as to the Using Outlook 2
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 4
A Clipboard Resize Issue Using Outlook 7
J O365 - Adding Shared Google Calendar ICS link issue in O365 Using Outlook 0
P Outlook 2013 "Item could not be moved - still an issue for Outlook 2013 Using Outlook 0
E Mail sorting view issue Using Outlook 1
D hide messege issue Using Outlook 1
B Outllok 2007 License Expired issue Using Outlook 0
ManaarZakaria I'm afraid of this issue, cause of strange error Exchange Server Administration 2
e_a_g_l_e_p_i Another reinstall of Outlook 2010 issue Using Outlook 10
Justo Horrillo Issue with rules in Outlook 2010 Using Outlook 4
G Icloud Contacts With Outlook Issue Using Outlook 4
J Outlook.com Contact Sync Issue Using Outlook.com accounts in Outlook 9
M Calendar Time Zone issue Using Outlook 0
B My outlook calendar edit issue Outlook VBA and Custom Forms 0
D Unusual calendar issue Exchange Server Administration 0
D Multiple Accounts Issue Receiving Emails in 2016 Using Outlook 0
B Winmail.dat Issue Using Outlook.com accounts in Outlook 0
tswatek Issue with where Outlook saves new contacts Using Outlook 3
K Outlook with MDaemon Connectivity Issue Using Outlook 4
G .ost file corrupted / solved the issue with some posts already said, but .ost file is corrupted agai Using Outlook 2
D Resizing issue for message field Outlook VBA and Custom Forms 0
P Outlook hanging issue Using Outlook 0
K Outlook 2013 calendar issue with Outlook.com Using Outlook.com accounts in Outlook 2
J Favorites in Public Folders issue Outlook VBA and Custom Forms 0
K Insert screenshots issue Using Outlook 2
B Sub Calendar-Color Coding Issue Using Outlook 4
T Using Outlook 2007 with Comcast (.pst inbox issue) Using Outlook 1
Brendan.Z Outlook 2013 signature editing issue Using Outlook 3
F Custom contact form icon issue Using Outlook 1
A Autocomplete issue Using Outlook 6
wallisellener Synch issue BCM (Business Contact Manager) 2
H Outlook 2013 size issue Using Outlook 1
C Voting Issue with Shared Inbox Using Outlook 1
J Outlook 2013 Forms Issue Using Outlook 1
M BCM remote database connection issue BCM (Business Contact Manager) 1
A How are you handling Outlook.com category issue and syncing Using Outlook.com accounts in Outlook 2
J Outlook.com EAS Issue Using Outlook.com accounts in Outlook 6
santheocles Issue in Outlook 2013 - cannot reschedule single task Using Outlook 0
P Outlook ruler issue Using Outlook 3
K Different kind of issue related to creation of archive after one has been deleted Exchange Server Administration 1
JR Ryan Outlook marks all as "Read" issue Exchange Server Administration 2
SirFishAlot SIGNATURE EMBED ISSUE OUTLOOK 2013 BCM (Business Contact Manager) 10
J Please help to clarify an IMAP issue Using Outlook 7
S Passive Mailbox database Resynchronization issue Exchange Server Administration 1
J Outlook using colors issue Using Outlook 7
B Outlook 2013 & BCM Issue Using Outlook 2
E OL2013 Notes Form Issue - Menus Using Outlook 6
N Please help....winmail.dat issue...slowly going insane..... Using Outlook 1

Similar threads

Top