Auto-linking emails by default shared DB BCM 2007 on SQL 2008

Status
Not open for further replies.
K

k99ja04

Running shared db BCM 2007 on SQL server 2008 hosted on Windows 2008 server.

Would like to autolink emails by default. I came across a sourceforge

project that runs as a service and claims to do this but does not appear to.

Surely someone else has run in to this.

Is there a way to programmatically automate the autolinking process. Each

morning the users have to go to BCM Menu> Manage Email Auto-linking > Select

All > OK. It appears that this functionality comes from having a BCMUsername

record for each email address listin in EEAOptinEmailTable. I wrote a script

to find all bcm users in our organization and then create a record for each

email address in this table but that does not seem to quite replicate the

equivalent functionality of the checkbox procedure I described above.

I am an experience .NET developer but new to BCM. Any insights into the

table relationships are appreciated.
 
J

Jan Borup Coyle, GITS A/S

Hi There

I got the exact same problem. I have to find a replacement for our old email

journalizeing system, and on all parts the BCM is a very low price

alternative solution, except for the Email journalizing feature. It's very

important for us that all BCM users can read the auto linked emails, and it

seems to be an issue in BCM.

if you have found a solution on this issuse, please write back.

Maybe we should start an alternative SourgeForge project, to handle this

problem.

Best regards

Jan Borup Coyle

"k99ja04" wrote:


> Running shared db BCM 2007 on SQL server 2008 hosted on Windows 2008 server.
> Would like to autolink emails by default. I came across a sourceforge
> project that runs as a service and claims to do this but does not appear to.
> Surely someone else has run in to this.

> Is there a way to programmatically automate the autolinking process. Each
> morning the users have to go to BCM Menu> Manage Email Auto-linking > Select
> All > OK. It appears that this functionality comes from having a BCMUsername
> record for each email address listin in EEAOptinEmailTable. I wrote a script
> to find all bcm users in our organization and then create a record for each
> email address in this table but that does not seem to quite replicate the
> equivalent functionality of the checkbox procedure I described above.

> I am an experience .NET developer but new to BCM. Any insights into the
> table relationships are appreciated.
 
K

k99ja04

Jan,

The original sourceforge author sent me source code, but to be honest my

plate has been full with other tasks. I think a simpler more elegant

solution would be to create a stored procedure that performs the autolinking,

and fire that procedure each time the addcontacts stored procedure is fired

off. I dont' have the exact names in front of me. Thoughts?

Jared

"Jan Borup Coyle, GITS A/S" wrote:


> Hi There

> I got the exact same problem. I have to find a replacement for our old email
> journalizeing system, and on all parts the BCM is a very low price
> alternative solution, except for the Email journalizing feature. It's very
> important for us that all BCM users can read the auto linked emails, and it
> seems to be an issue in BCM.

> if you have found a solution on this issuse, please write back.

> Maybe we should start an alternative SourgeForge project, to handle this
> problem.

> Best regards

> Jan Borup Coyle

> "k99ja04" wrote:
>
> > Running shared db BCM 2007 on SQL server 2008 hosted on Windows 2008 server.
> > Would like to autolink emails by default. I came across a sourceforge
> > project that runs as a service and claims to do this but does not appear to.
> > Surely someone else has run in to this.
> > Is there a way to programmatically automate the autolinking process. Each
> > morning the users have to go to BCM Menu> Manage Email Auto-linking > Select
> > All > OK. It appears that this functionality comes from having a BCMUsername
> > record for each email address listin in EEAOptinEmailTable. I wrote a script
> > to find all bcm users in our organization and then create a record for each
> > email address in this table but that does not seem to quite replicate the
> > equivalent functionality of the checkbox procedure I described above.
> > I am an experience .NET developer but new to BCM. Any insights into the
> > table relationships are appreciated.
 
J

Jan Borup Coyle, GITS A/S

Hi Jared

Thanks for your answer.

I will agree with you conclution, but i don't know how complex the email

linking is.

If you got the Source code from the SourgeForge BCM Service, please email it

to me at janborup{at}hotmail.com, I would give it a try to do it otherwise.

Best regards

Jan

"k99ja04" wrote:


> Jan,
> The original sourceforge author sent me source code, but to be honest my
> plate has been full with other tasks. I think a simpler more elegant
> solution would be to create a stored procedure that performs the autolinking,
> and fire that procedure each time the addcontacts stored procedure is fired
> off. I dont' have the exact names in front of me. Thoughts?
> Jared

> "Jan Borup Coyle, GITS A/S" wrote:
>
> > Hi There
> > I got the exact same problem. I have to find a replacement for our old email
> > journalizeing system, and on all parts the BCM is a very low price
> > alternative solution, except for the Email journalizing feature. It's very
> > important for us that all BCM users can read the auto linked emails, and it
> > seems to be an issue in BCM.
> > if you have found a solution on this issuse, please write back.
> > Maybe we should start an alternative SourgeForge project, to handle this
> > problem.
> > Best regards
> > Jan Borup Coyle
> > "k99ja04" wrote:
> >
> > > Running shared db BCM 2007 on SQL server 2008 hosted on Windows 2008 server.
> > > Would like to autolink emails by default. I came across a sourceforge
> > > project that runs as a service and claims to do this but does not appear to.
> > > Surely someone else has run in to this.
> > > > Is there a way to programmatically automate the autolinking process. Each
> > > morning the users have to go to BCM Menu> Manage Email Auto-linking > Select
> > > All > OK. It appears that this functionality comes from having a BCMUsername
> > > record for each email address listin in EEAOptinEmailTable. I wrote a script
> > > to find all bcm users in our organization and then create a record for each
> > > email address in this table but that does not seem to quite replicate the
> > > equivalent functionality of the checkbox procedure I described above.
> > > > I am an experience .NET developer but new to BCM. Any insights into the
> > > table relationships are appreciated.
 
K

k99ja04

Jan,

there is a table where every user needs an entry for every email address

that needs to be linked. So you end up with a cross join. Don't have the code

in front of me but post your email and I'll ship it to you

thanks,

Jared

"Jan Borup Coyle, GITS A/S" wrote:


> Hi Jared

> Thanks for your answer.

> I will agree with you conclution, but i don't know how complex the email
> linking is.

> If you got the Source code from the SourgeForge BCM Service, please email it
> to me at janborup{at}hotmail.com, I would give it a try to do it otherwise.

> Best regards
> Jan

> "k99ja04" wrote:
>
> > Jan,
> > The original sourceforge author sent me source code, but to be honest my
> > plate has been full with other tasks. I think a simpler more elegant
> > solution would be to create a stored procedure that performs the autolinking,
> > and fire that procedure each time the addcontacts stored procedure is fired
> > off. I dont' have the exact names in front of me. Thoughts?
> > Jared
> > "Jan Borup Coyle, GITS A/S" wrote:
> >
> > > Hi There
> > > > I got the exact same problem. I have to find a replacement for our old email
> > > journalizeing system, and on all parts the BCM is a very low price
> > > alternative solution, except for the Email journalizing feature. It's very
> > > important for us that all BCM users can read the auto linked emails, and it
> > > seems to be an issue in BCM.
> > > > if you have found a solution on this issuse, please write back.
> > > > Maybe we should start an alternative SourgeForge project, to handle this
> > > problem.
> > > > Best regards
> > > > Jan Borup Coyle
> > > > "k99ja04" wrote:
> > > > > Running shared db BCM 2007 on SQL server 2008 hosted on Windows 2008 server.
> > > > Would like to autolink emails by default. I came across a sourceforge
> > > > project that runs as a service and claims to do this but does not appear to.
> > > > Surely someone else has run in to this.
> > > > > > Is there a way to programmatically automate the autolinking process. Each
> > > > morning the users have to go to BCM Menu> Manage Email Auto-linking > Select
> > > > All > OK. It appears that this functionality comes from having a BCMUsername
> > > > record for each email address listin in EEAOptinEmailTable. I wrote a script
> > > > to find all bcm users in our organization and then create a record for each
> > > > email address in this table but that does not seem to quite replicate the
> > > > equivalent functionality of the checkbox procedure I described above.
> > > > > > I am an experience .NET developer but new to BCM. Any insights into the
> > > > table relationships are appreciated.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
H Not all Email folders appearing in Manage E-mail Auto-linking BCM (Business Contact Manager) 1
L Out of memory errors and Auto-linking hangs BCM (Business Contact Manager) 2
K Run a script rule to auto 'send again' on undeliverable emails? Outlook VBA and Custom Forms 1
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
S Auto forward for multiple emails Outlook VBA and Custom Forms 0
DDB VBA to Auto Insert Date and Time in the signature Outlook VBA and Custom Forms 2
V Auto-complete stopped working Using Outlook 4
D auto forward base on email address in body email Outlook VBA and Custom Forms 0
M Replyall macro with template and auto insert receptens Outlook VBA and Custom Forms 1
R Auto Forwarding with different "From" Outlook VBA and Custom Forms 0
P auto-complete is hopelessly broken Using Outlook 0
R Auto Assign Category colours to Incoming Emails based on whom the email is addressed Outlook VBA and Custom Forms 3
C Auto Run VBA Code on new email Outlook VBA and Custom Forms 1
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
V Auto-Submitted: auto-replied in header Using Outlook 0
R Auto display of new email does not work on non-default account Outlook VBA and Custom Forms 0
B Outlook 2016 Auto-archive creates new folder Using Outlook 3
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
P Auto assign shared mailbox Outlook VBA and Custom Forms 1
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 16
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
Q Prompt button to auto turn on Out of Office Outlook VBA and Custom Forms 3
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
S Messages moved / deleted by auto-archive are not synchronized to exchange Exchange Server Administration 8
B Outlook 2010 is Auto Purging when not configured for that Using Outlook 1
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
A Auto Accept Meetings from the General Calendar Using Outlook 3
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
S auto-mapping mailboxes in outlook impacting an ost file? Exchange Server Administration 2
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
Ms_Cynic Auto-pasting email content in calendar appt? Using Outlook 2
R How Do I insert images in and Auto Reply Using Outlook 3
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
P Auto scroll to specific folder in Folder Pane Outlook VBA and Custom Forms 3
C Auto categorize duplicate subjects Outlook VBA and Custom Forms 11
N Auto-complete - block select emails Using Outlook 3
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
J HELP- Rule to auto strip prepend from external emails Using Outlook 0
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
G Auto accept meeting request for non primary account Outlook VBA and Custom Forms 1
J Outlook Rules - Changing auto-submit address in multiple rules, according to rule name Outlook VBA and Custom Forms 0
E Outlook Form - Voting Responses Not Auto Processing If Form Contains Any Code Outlook VBA and Custom Forms 0
J Auto Forward - Include Attachment and change Subject depending on original sender Outlook VBA and Custom Forms 3
K Extract email address from body and auto-reply outlook Using Outlook 1
S Auto move search results to folder Outlook VBA and Custom Forms 0

Similar threads

Top