BizTalk Server General - export to .csv

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > March 2006 > export to .csv





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 export to .csv
Mercurius.ter.Maximus@gmail.com

2006-03-21, 3:09 am

Hi all,

How do I get Biztalk 2004 to write to a .csv file ? I'm trying to
learn by reading from an XML file and converting that.

I have the Biztalk Server 2004 Unleashed book and have made the project
that goes csv to xml with no problem. Can't quickly figure out xml to
csv though.

Cheers

Doug Girard [MSFT]

2006-03-25, 11:38 am

On the receive pipeline, a Flat File disassembler is used to convert
messages from FF to XML for BTS processing. Similarly, on the send
pipeline a FF assembler can be used to convert XML to FF for outbound
sends. You'll use and configure these in very much the same way. An XSD
schema with BizTalk flat file annotations will provide instructions to the
disassembler or assembler for processing. I would consult the product
documentation on the FF assembler and would recommend using the FF
utilities that ship with BTS 2004 for debugging of the schema against
document instances.

HTH,
Doug Girard [MSFT]

Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>From: Mercurius.ter.Maximus@gmail.com
>Newsgroups: microsoft.public.biztalk.general
>Subject: export to .csv
>Date: 19 Mar 2006 23:46:56 -0800
>Organization: http://groups.google.com
>Lines: 11
>Message-ID: <1142840816.703926.179000@z34g2000cwc.googlegroups.com>
>NNTP-Posting-Host: 203.36.117.195
>Mime-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>X-Trace: posting.google.com 1142840823 17747 127.0.0.1 (20 Mar 2006

07:47:03 GMT)
>X-Complaints-To: groups-abuse@google.com
>NNTP-Posting-Date: Mon, 20 Mar 2006 07:47:03 +0000 (UTC)
>User-Agent: G2/0.2
>X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8)

Gecko/20051111 Firefox/1.5,gzip(gfe),gzip(gfe)
>X-HTTP-Via: 1.1 DMZPROXY
>Complaints-To: groups-abuse@google.com
>Injection-Info: z34g2000cwc.googlegroups.com; posting-host=203.36.117.195;
> posting-account=MeKzRw0AAACFoUTZVgw7fltLs5B--KeK
>Path:

TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!postnews.google.com!z34g2000cwc.googlegroups.com!not-for-mail
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.biztalk.general:35843
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Hi all,
>
>How do I get Biztalk 2004 to write to a .csv file ? I'm trying to
>learn by reading from an XML file and converting that.
>
>I have the Biztalk Server 2004 Unleashed book and have made the project
>that goes csv to xml with no problem. Can't quickly figure out xml to
>csv though.
>
>Cheers
>
>


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com