|
Home > Archive > BizTalk Server General > April 2005 > biztalk, email, excel
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 |
biztalk, email, excel
|
|
|
| is it possible to create an orchestration that would use data from excel file
that is attached to an email? i found a free pop3 adapter
(http://www.muranosoft.com/products/...op3Adapter.aspx) and is it
possible for biztalk to extract an attachment (excel file) from an email, use
data in that attachment for an orchestration, and on the send port put some
of that data in a database?
should i do it with web services or...
| |
| Saravana Kumar 2005-04-01, 5:54 pm |
| Out of the box you don't have all this functionality. You need to do custom
coding to achieve this.
Cheers,
Saravana
http://saravanakumarmv.blogspot.com
"Nedim" <Nedim@discussions.microsoft.com> wrote in message
news:7ED8948C-5829-47EF-9AD0-E3BBF43F3BDD@microsoft.com...
> is it possible to create an orchestration that would use data from excel
file
> that is attached to an email? i found a free pop3 adapter
> (http://www.muranosoft.com/products/...op3Adapter.aspx) and is it
> possible for biztalk to extract an attachment (excel file) from an email,
use
> data in that attachment for an orchestration, and on the send port put
some
> of that data in a database?
>
> should i do it with web services or...
>
| |
| Mike Watson 2005-04-03, 7:47 am |
| Hi,
It is not possible out of the box. However, you have a few options that you
could use in Excel.
1. Save the Excel sheet as a CSV file. This can then be read into BizTalk.
2. Excel 2003 gives you the option to save the file as an Xml file. Both
Custom and the SpreadsheetML standards.
3. Custom, code to build the Xml (as per Saravana posts).
- Mike Watson
"Nedim" wrote:
> is it possible to create an orchestration that would use data from excel file
> that is attached to an email? i found a free pop3 adapter
> (http://www.muranosoft.com/products/...op3Adapter.aspx) and is it
> possible for biztalk to extract an attachment (excel file) from an email, use
> data in that attachment for an orchestration, and on the send port put some
> of that data in a database?
>
> should i do it with web services or...
>
| |
| Yossi Dahan 2005-04-04, 7:47 am |
| Nedim
Itemfield's ContentMaster is a parsing tool that is capable of parsing excel
files even without saving them as CSV files and is natively integrated into
BizTalk 2004 (and other integration tools)
Have a look at www.itemfield.com or email me (yossid@itemfield.com) for more
details
Regards
Yossi Dahan
"Nedim" <Nedim@discussions.microsoft.com> wrote in message
news:7ED8948C-5829-47EF-9AD0-E3BBF43F3BDD@microsoft.com...
> is it possible to create an orchestration that would use data from excel
> file
> that is attached to an email? i found a free pop3 adapter
> (http://www.muranosoft.com/products/...op3Adapter.aspx) and is it
> possible for biztalk to extract an attachment (excel file) from an email,
> use
> data in that attachment for an orchestration, and on the send port put
> some
> of that data in a database?
>
> should i do it with web services or...
>
| |
| Rebecca 2005-04-29, 7:59 am |
| I'm trying option 2, but I can't seem to get the biztalk schema to have the
right namespace to match what comes out of excel. Do you know how to do that?
"Mike Watson" wrote:
[vbcol=seagreen]
> Hi,
>
> It is not possible out of the box. However, you have a few options that you
> could use in Excel.
> 1. Save the Excel sheet as a CSV file. This can then be read into BizTalk.
> 2. Excel 2003 gives you the option to save the file as an Xml file. Both
> Custom and the SpreadsheetML standards.
> 3. Custom, code to build the Xml (as per Saravana posts).
>
> - Mike Watson
>
> "Nedim" wrote:
>
|
|
|
|
|