|
Home > Archive > BizTalk Server Orchestration > February 2006 > Attaching documents from Sharepoint site to SMTP message
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Attaching documents from Sharepoint site to SMTP message
|
|
|
| I want to attach a document from a Sharepoint library (knowing only the http
adres for the location of the document) to an SMTP message in my
orchestration.
I have tried using the http reference but that didn't work (I expect BizTalk
needs a more file based location). My second option would be write the
document to a temporary location first and add them as an attachment, but I'm
hoping there is a simpler solution.
Does anyone have any suggestions?
Thanks,
Ilske
| |
| Adrian Hamza [MSFT] 2006-02-01, 5:56 pm |
| Is this a BT 2004 or 2006 problem? BizTalk 2006 includes a native adapter
for Windows SharePoint Services 2003.
If the file is in a known fixed document library, then you can create a
receive location using Windows SharePoint Services adapter in order to
receive the file into BizTalk.
This works with XML and/or binary files.
BizTalk 2004 does not include a native WSS adapter but there is a free and
unsupported adapter on GotDotNet that you could use.
I think this is the GotDotNet URL for the adapter
http://www.gotdotnet.com/Community/...x?id=0d1aa85c-c
f8d-497e-84f4-3ffec8db115f
This posting is provided "AS IS" with no warranties, and confers no rights.
Adrian Hamza [MSFT]
http://blogs.msdn.com/ahamza/
My blog on BizTalk 2006
Windows SharePoint Services adapter
--------------------[vbcol=seagreen]
http[vbcol=seagreen]
BizTalk[vbcol=seagreen]
I'm[vbcol=seagreen]
| |
|
| Hi Adrian,
I'm using BT 2006. I'm not sure how I can use the SharePoint adapter in this
case. I only want to get the documents specified with the url I have received
from a webservice I called in the previous step in my orchestration. These
are references to different word documents at a specific locations in
SharePoint. I only want to retrieve these specific documents not all
documents that are located in that SharePoint folder. I considered using a
receive location for this but I don't know how to just get the specific files
because in each instance of the orchestration the SharePoint folder and the
document names can be different.
Ilske
"Adrian Hamza [MSFT]" wrote:
> Is this a BT 2004 or 2006 problem? BizTalk 2006 includes a native adapter
> for Windows SharePoint Services 2003.
> If the file is in a known fixed document library, then you can create a
> receive location using Windows SharePoint Services adapter in order to
> receive the file into BizTalk.
> This works with XML and/or binary files.
>
> BizTalk 2004 does not include a native WSS adapter but there is a free and
> unsupported adapter on GotDotNet that you could use.
> I think this is the GotDotNet URL for the adapter
> http://www.gotdotnet.com/Community/...x?id=0d1aa85c-c
> f8d-497e-84f4-3ffec8db115f
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Adrian Hamza [MSFT]
> http://blogs.msdn.com/ahamza/
> My blog on BizTalk 2006
> Windows SharePoint Services adapter
>
> --------------------
> http
> BizTalk
> I'm
>
>
| |
| Adrian Hamza [MSFT] 2006-02-02, 5:51 pm |
| Do you have a fixed number of document libraries from where you receive the
messages or this changes on the fly? Do you receive the messages from the
same document library but different folders in that document library?
You can do the following:
- for every document library create a receive location that receives
messages from that document library. All the receive locations can be
placed under the same receive port.
- in order to not receive all the messages you need to poll the document
library through a SharePoint View. In the WSS receive location, you can
specify the name of a View. Only documents that show up in that view will
be processed by the adapter. You will define the View in SharePoint in such
a way so that only the appropriate documents show up. For instance, you
could add a column to the document library and your View will show the
documents or not based on the column value. The column does not have to be
visible in UI, it can be a "hidden" column. You create the column and the
view from the page shown when clicking on "Modify settings and columns"
link inside the document library
- even if you have multiple folders in the document library, you still use
just one receive location. You will only have to change your view to be a
"Show all documents without folders" view (Folders settings of the view)
I'm not sure how this plays into your current design. The individual issues
that you mentioned can be addressed through adapter features, I'm not sure
about the matching of the document with your web service call. Can you
explain at a high level what you are trying to do and maybe I can suggest a
better design?
This posting is provided "AS IS" with no warranties, and confers no rights.
Adrian Hamza [MSFT]
http://blogs.msdn.com/ahamza/
My blog on BizTalk 2006
Windows SharePoint Services adapter
--------------------[vbcol=seagreen]
<s3$rAW2JGHA.3764@TK2MSFTNGXA02.phx.gbl>[vbcol=seagreen]
this[vbcol=seagreen]
received[vbcol=seagreen]
These[vbcol=seagreen]
a[vbcol=seagreen]
files[vbcol=seagreen]
the[vbcol=seagreen]
adapter[vbcol=seagreen]
and[vbcol=seagreen]
http://www.gotdotnet.com/Community/...x?id=0d1aa85c-c[vbcol=seagreen]
rights.[vbcol=seagreen]
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl[vbcol=seagreen]
microsoft.public.biztalk.orchestration:13735[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
but[vbcol=seagreen]
| |
|
| Thanks for the suggestions. Unfortunately I don't have a fixed number of
document libraries. The documents have to be retrieved from different sites
(personal dossier) and subsites within these sites (case based dossiers) from
a document library that always has the same name in these different sites. As
a site will be created when a dossier is created, I have to assume an
unlimited amount of sites. The webservice I call from the orchestration
creates a document and places it the correct document library in the correct
site and returns the url to the document created. I think I could use your
suggestion to filter out the documents I need, but I don't think it's an
option to create a receive location for each document library I might have to
receive documents from.
Ilske
"Adrian Hamza [MSFT]" wrote:
> Do you have a fixed number of document libraries from where you receive the
> messages or this changes on the fly? Do you receive the messages from the
> same document library but different folders in that document library?
>
> You can do the following:
> - for every document library create a receive location that receives
> messages from that document library. All the receive locations can be
> placed under the same receive port.
> - in order to not receive all the messages you need to poll the document
> library through a SharePoint View. In the WSS receive location, you can
> specify the name of a View. Only documents that show up in that view will
> be processed by the adapter. You will define the View in SharePoint in such
> a way so that only the appropriate documents show up. For instance, you
> could add a column to the document library and your View will show the
> documents or not based on the column value. The column does not have to be
> visible in UI, it can be a "hidden" column. You create the column and the
> view from the page shown when clicking on "Modify settings and columns"
> link inside the document library
> - even if you have multiple folders in the document library, you still use
> just one receive location. You will only have to change your view to be a
> "Show all documents without folders" view (Folders settings of the view)
>
> I'm not sure how this plays into your current design. The individual issues
> that you mentioned can be addressed through adapter features, I'm not sure
> about the matching of the document with your web service call. Can you
> explain at a high level what you are trying to do and maybe I can suggest a
> better design?
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Adrian Hamza [MSFT]
> http://blogs.msdn.com/ahamza/
> My blog on BizTalk 2006
> Windows SharePoint Services adapter
>
> --------------------
> <s3$rAW2JGHA.3764@TK2MSFTNGXA02.phx.gbl>
> this
> received
> These
> a
> files
> the
> adapter
> and
> http://www.gotdotnet.com/Community/...x?id=0d1aa85c-c
> rights.
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> microsoft.public.biztalk.orchestration:13735
> the
> the
> but
>
>
| |
| Adrian Hamza [MSFT] 2006-02-09, 5:59 pm |
| Maybe WSS adapter is not the right option for you. The functionality that
you need is very similar to dynamic send ports only that you need this for
receive.
Unfortunately BizTalk does not have a notion of "dynamic receive" ports.
On way to workaround this is to write your own .Net component that
retrieves the document using HTTP GET. You can also delete/move the
document using WebDAV extension to HTTP protocol.
You will have to implement your own error handling and retry mechanism to
handle errors (network errors, SharePoint site down, etc).
This posting is provided "AS IS" with no warranties, and confers no rights.
Adrian Hamza [MSFT]
http://blogs.msdn.com/ahamza/
My blog on BizTalk 2006
Windows SharePoint Services adapter
--------------------[vbcol=seagreen]
<s3$rAW2JGHA.3764@TK2MSFTNGXA02.phx.gbl>
<A1795E87-F366-4CF0-844B-32FDDA8F3EAA@microsoft.com>
<GPm9B2CKGHA.3696@TK2MSFTNGXA02.phx.gbl>[vbcol=seagreen]
sites[vbcol=seagreen]
from[vbcol=seagreen]
sites. As[vbcol=seagreen]
correct[vbcol=seagreen]
your[vbcol=seagreen]
have to[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
document[vbcol=seagreen]
will[vbcol=seagreen]
such[vbcol=seagreen]
be[vbcol=seagreen]
the[vbcol=seagreen]
use[vbcol=seagreen]
a[vbcol=seagreen]
issues[vbcol=seagreen]
sure[vbcol=seagreen]
suggest a[vbcol=seagreen]
rights.[vbcol=seagreen]
microsoft.public.biztalk.orchestration:13753[vbcol=seagreen]
in[vbcol=seagreen]
using[vbcol=seagreen]
specific[vbcol=seagreen]
and[vbcol=seagreen]
create a[vbcol=seagreen]
to[vbcol=seagreen]
free[vbcol=seagreen]
http://www.gotdotnet.com/Community/...x?id=0d1aa85c-c[vbcol=seagreen]
message[vbcol=seagreen]
only[vbcol=seagreen]
expect[vbcol=seagreen]
write[vbcol=seagreen]
attachment,[vbcol=seagreen]
|
|
|
|
|