| Author |
Message |
Bob White
Guest
|
 Posted:
Sat Aug 13, 2005 8:44 am Post subject:
Automatically Saving Attachments |
|
|
One of our suppliers is sending us data on some of the products we purchase
as rows of data in an Excel workbook. We would like to automatically
process each of these workbooks and add the data to a SQL Server database.
I need to create a server-side rule that saves these attachments to a
folder, either on the network or as a public folder in Exchange. The rule
needs to be able to run without me being logged into the network. I didn't
see an option in the Rules Wizard for "Save attachments to specific
folder". Am I going to have to write a script to do this?
If the folder is one of Exchange's Public Folders, how to I refer to it
when I tell SQL Server to get the attachments?
Once I get the workbooks stored to a network folder somewhere, I know how
to handle the data from there.
Thanks for any advice or hints!
Bob
|
|
| Back to top |
|
 |
Henning Krause [MVP - Exc
Guest
|
| Posted:
Sat Aug 13, 2005 2:48 pm Post subject:
Re: Automatically Saving Attachments |
|
|
Hello,
which version of Exchange are you running?
Greetings,
Henning Krause
MVP - Exchange
http://www.infinitec.de
"Bob White" <bob@thecovey.homeip.net> wrote in message
news:Xns96B0F18075C4Arwhite4triadrrcom@207.46.248.16...
| Quote: | One of our suppliers is sending us data on some of the products we
purchase
as rows of data in an Excel workbook. We would like to automatically
process each of these workbooks and add the data to a SQL Server database.
I need to create a server-side rule that saves these attachments to a
folder, either on the network or as a public folder in Exchange. The rule
needs to be able to run without me being logged into the network. I
didn't
see an option in the Rules Wizard for "Save attachments to specific
folder". Am I going to have to write a script to do this?
If the folder is one of Exchange's Public Folders, how to I refer to it
when I tell SQL Server to get the attachments?
Once I get the workbooks stored to a network folder somewhere, I know how
to handle the data from there.
Thanks for any advice or hints!
Bob |
|
|
| Back to top |
|
|
Bob White
Guest
|
| Posted:
Sat Aug 13, 2005 4:58 pm Post subject:
Re: Automatically Saving Attachments |
|
|
"Henning Krause [MVP - Exchange]" <newsgroups.remove@this.infinitec.de>
wrote in news:#EzGFy#nFHA.2916@TK2MSFTNGP14.phx.gbl:
Hello,
Henning, I *believe* we're running 2000. I'm not in the IT group, so I
don't know for certain. We're in the process of implementing Sharepoint,
and are rolling out Office 2003 company-wide this fall, so it is possible
the server is already at 2003. How can I determine this?
Thanks,
Bob
| Quote: | Hello,
which version of Exchange are you running?
Greetings,
Henning Krause
MVP - Exchange
http://www.infinitec.de
|
|
|
| Back to top |
|
|
Henning Krause [MVP - Exc
Guest
|
| Posted:
Mon Aug 15, 2005 10:59 pm Post subject:
Re: Automatically Saving Attachments |
|
|
Hello Bob,
it is not important whether you have 2000 or 2003... as long as you do not
have 5.5 installed :-)
You can implement the OnSave Eventsink and register it on the public folder
or the inbox folder of the mailbox where you receive your workbooks. Within
the eventsink, you can open the saved message with CdoEx and save the
attachments to disk. See
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_exch2k_implementing_asynchronous_event_sinks.asp
and
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_esdk_reference_cdoex.asp
for more information on this.
Greetings,
Henning Krause
MVP - Exchange
http://www.infinitec.de
"Bob White" <bob@thecovey.homeip.net> wrote in message
news:Xns96B15D454FC53rwhite4triadrrcom@207.46.248.16...
| Quote: | "Henning Krause [MVP - Exchange]" <newsgroups.remove@this.infinitec.de
wrote in news:#EzGFy#nFHA.2916@TK2MSFTNGP14.phx.gbl:
Hello,
Henning, I *believe* we're running 2000. I'm not in the IT group, so I
don't know for certain. We're in the process of implementing Sharepoint,
and are rolling out Office 2003 company-wide this fall, so it is possible
the server is already at 2003. How can I determine this?
Thanks,
Bob
Hello,
which version of Exchange are you running?
Greetings,
Henning Krause
MVP - Exchange
http://www.infinitec.de
|
|
|
| Back to top |
|
|
Bob White
Guest
|
| Posted:
Thu Aug 18, 2005 7:17 am Post subject:
Re: Automatically Saving Attachments |
|
|
Henning,
"Henning Krause [MVP - Exchange]" <newsgroups.remove@this.infinitec.de>
wrote in news:eFkSiOcoFHA.2916@TK2MSFTNGP14.phx.gbl:
| Quote: | Hello Bob,
it is not important whether you have 2000 or 2003... as long as you do
not have 5.5 installed :-)
|
I asked, we're up to 2003.
Thanks for the references! I'll try to figure something out. Do you have
any sample code that you could point me towards?
Thanks,
Bob |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in