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

[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.

[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

Post by 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.

[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

Post by 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

Post by 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.

[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

Post by 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

Post by 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

Post by 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.

[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

Post by 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

Post by 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

Post by 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

Post by 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.