Prev: unicode conversion
Next: BCP Import
From: obiron via SQLMonster.com on 19 Apr 2010 12:36
Guys, Using Microsoft Exchange (not sure which version) and SQL2008(x64)

We have a profile set up which can send emails out to users.

I would like to have the facility for users to send emails directly to the
server profile address and for the server to be able to strip the information
from the body of the email. Is this possible and if so, what do I need to
configure

The ultimate aim is for SSRS to serve up a report and for users to be able to
add comments against a particular cell in the tablix by clicking on the cell
and having an email pop up where they can populate the information required.
This will then be queued in the database ready for processing.

Obviously I am going to have to validate and sanitise the data before storing
it in the database.

Obiron

--
Message posted via http://www.sqlmonster.com

From: Jay on 20 Apr 2010 13:21
I don't know that much about SSRS, but why would you want to use something
like email to write back to the database when you're using a client/server
model? All you need is a client to write directly back to the database.

"obiron via SQLMonster.com" <u56148(a)uwe> wrote in message
news:a6c58ab18e856(a)uwe...
> Guys, Using Microsoft Exchange (not sure which version) and SQL2008(x64)
>
> We have a profile set up which can send emails out to users.
>
> I would like to have the facility for users to send emails directly to the
> server profile address and for the server to be able to strip the
information
> from the body of the email. Is this possible and if so, what do I need to
> configure
>
> The ultimate aim is for SSRS to serve up a report and for users to be able
to
> add comments against a particular cell in the tablix by clicking on the
cell
> and having an email pop up where they can populate the information
required.
> This will then be queued in the database ready for processing.
>
> Obviously I am going to have to validate and sanitise the data before
storing
> it in the database.
>
> Obiron
>
> --
> Message posted via http://www.sqlmonster.com
>


From: John Bell on 20 Apr 2010 16:42
On Mon, 19 Apr 2010 16:36:29 GMT, "obiron via SQLMonster.com"
<u56148(a)uwe> wrote:

>Guys, Using Microsoft Exchange (not sure which version) and SQL2008(x64)
>
>We have a profile set up which can send emails out to users.
>
>I would like to have the facility for users to send emails directly to the
>server profile address and for the server to be able to strip the information
>from the body of the email. Is this possible and if so, what do I need to
>configure
>
>The ultimate aim is for SSRS to serve up a report and for users to be able to
>add comments against a particular cell in the tablix by clicking on the cell
>and having an email pop up where they can populate the information required.
>This will then be queued in the database ready for processing.
>
>Obviously I am going to have to validate and sanitise the data before storing
>it in the database.
>
>Obiron

Hi

You can do this with SQL Mail i.e sp_processmail although SQL Mail may
not be available in future versions.

John
From: obiron via SQLMonster.com on 27 Apr 2010 07:28
@ Jay,

the requirement is for a report for senior management that will be exported
as Excel (don't ask why they can't run it directly from Reporting services....
.) or as an mhtml.

I need the end users to be able to add comments about why certain items on
the report are outside their tolerance range and I don't have access to our
intranet or client desktops to install software that can update the database.


I know the email server is always available and that I can create emails from
the hyperlink option in the reports.

r.

@ John,

as far as I am aware XP_readmail is called by sp_processmail and this feature
(specifically xp_readmail IS deprecated in the 64 bit version of SQL2008)

I have a possible solution but it is not nice.

We have office 2003 installed on our 2008 server....

a) run outlook on the server, ensuring that it always starts up on the
default account
b) set a client side rule that will open an Access database
c) set a macro in the access database that runs on opening that fetches the
emails from the exchange server and pushes them into an SQL2008 table
d) set a trigger on the table to do something when a record is created.

This relies on outlook always starting correctly and the rule running
correctly when this process cannot be monitored by the information department
because they do not have admin rights on the database serve


John Bell wrote:
>>Guys, Using Microsoft Exchange (not sure which version) and SQL2008(x64)
>>
>[quoted text clipped - 14 lines]
>>
>>Obiron
>
>Hi
>
>You can do this with SQL Mail i.e sp_processmail although SQL Mail may
>not be available in future versions.
>
>John

--
Message posted via http://www.sqlmonster.com

From: John Bell on 27 Apr 2010 13:33
On Tue, 27 Apr 2010 11:28:30 GMT, "obiron via SQLMonster.com"
<u56148(a)uwe> wrote:

>@ Jay,
>
>the requirement is for a report for senior management that will be exported
>as Excel (don't ask why they can't run it directly from Reporting services....
>) or as an mhtml.
>
>I need the end users to be able to add comments about why certain items on
>the report are outside their tolerance range and I don't have access to our
>intranet or client desktops to install software that can update the database.
>
>
>I know the email server is always available and that I can create emails from
>the hyperlink option in the reports.
>
>r.
>
>@ John,
>
>as far as I am aware XP_readmail is called by sp_processmail and this feature
>(specifically xp_readmail IS deprecated in the 64 bit version of SQL2008)
>
>I have a possible solution but it is not nice.
>
>We have office 2003 installed on our 2008 server....
>
>a) run outlook on the server, ensuring that it always starts up on the
>default account
>b) set a client side rule that will open an Access database
>c) set a macro in the access database that runs on opening that fetches the
>emails from the exchange server and pushes them into an SQL2008 table
>d) set a trigger on the table to do something when a record is created.
>
>This relies on outlook always starting correctly and the rule running
>correctly when this process cannot be monitored by the information department
>because they do not have admin rights on the database serve
>
>
>John Bell wrote:
>>>Guys, Using Microsoft Exchange (not sure which version) and SQL2008(x64)
>>>
>>[quoted text clipped - 14 lines]
>>>
>>>Obiron
>>
>>Hi
>>
>>You can do this with SQL Mail i.e sp_processmail although SQL Mail may
>>not be available in future versions.
>>
>>John

How about publishing a report to sharepoint?

John
 | 
Pages: 1
Prev: unicode conversion
Next: BCP Import