Re: Space in a Field name

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kamal (kali_at_bca-group.comNOSPAMPLEASE)
Date: 02/09/05 

Date: Wed, 9 Feb 2005 13:54:29 -0000

Ok thanks guys. i think i got the idea. that's great.

Just one more questions, you know when u send a XML schema and would like to
receive a CSV (Flat file) File. I've created the schemas for both (XML &
CSV), the map between them, is that enough to create the ports and get the
file in csv? or do I have to use a pipeline and add the Flat file assembler
? Is there any other ways of doing it without having to create this
pipeline?

Appreciate your help and support. thanks to all of you.

Kamal

"Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
news:e97PrqeDFHA.3324@TK2MSFTNGP15.phx.gbl...
> The easiest way to accomplish this for a flat file is probably to define a
> header schema that has one row which is your column headers. name the
> elements whatever you like,then give them a fixed text value that is your
> column name. In your send pipeline, choose this header schema along with
> your document schema.
>
> matt
>
>
> "Greg Forsythe" <greg.forsythe@unisys.com> wrote in message
> news:uquULecDFHA.1936@TK2MSFTNGP14.phx.gbl...
> > You cannot have a space in a node name within Xml.
> > This is not a restriction with Biztalk, it is inherent in all Xml.
> >
> > This should not be a problem as the Xml node names cannot be output by
the
> > FlatFileAssembler (which converts Xml to Csv) only the data (content in
a
> > tag) can be output.
> > If you wish to output field names in the Csv, then you will need to
define
> > attributes or elements within you Xml which will hold the field names.
> > These
> > fields names will be data and so can have a space.
> >
> > <UserName><fieldName>User
> > Name</fieldName><fieldContent>Fred</fieldContent></UserName>
> > or <UserName fieldName="User Name">Fred</UserName>
> > would become:
> > User Name,Fred
> >
> >
> > Greg
> >
> >
> >
> > "Kamal" <kali@bca-group.comNOSPAMPLEASE> wrote in message
> > news:umNd97PDFHA.3732@TK2MSFTNGP14.phx.gbl...
> >> I'm afraid that's has not answered my question.
> >>
> >> My question is very simple, a Field name (a node in a schema OR A Child
> >> Field Element) called ( User Name), as you can see there is a space
> > between
> >> User and Name. When I try to insert the node name with the space, the
> > schema
> >> designer doesn't like it and would add _x0020_ as a value for the
space.
> > so
> >> the element name will be User_x0020_Name. However, when sending the CSV
> >> file, I want it to have the space (i.e. I want it to appear as User
Name
> >> with the space).
> >>
> >> I hope i've made my question clearer.
> >>
> >>
> >>
> >>
> >> "Etienne Combaud" <etienne.combaud@laposte.net> wrote in message
> >> news:uFa0gkqCFHA.2676@TK2MSFTNGP12.phx.gbl...
> >> > Read documentation about the core system of BTS : it uses XSLT as the
> > core
> >> > translator, so each format for inbound document are parsed to XML
> > (except
> >> > XML of course) and the XML result of the XSLT translation (result of
> >> > the
> >> > mapping) is serialized to the outbound format.
> >> >
> >> >
> >> > "Kamal" <kali@bca-group.comNOSPAMPLEASE> wrote in message
> >> > news:eVMMqogCFHA.3596@TK2MSFTNGP12.phx.gbl...
> >> > > how about flat file and/or CSV file??
> >> > >
> >> > > I'm translating an XML file without spaces to a flat file/ CSV with
> >> spaces
> >> > > in the field names!!
> >> > >
> >> > >
> >> > >
> >> > > "Etienne Combaud" <etienne.combaud@laposte.net> wrote in message
> >> > > news:uY$UGUgCFHA.3908@TK2MSFTNGP12.phx.gbl...
> >> > >> Hi Kamal,
> >> > >>
> >> > >> You could not include space in field or record names as they are
> >> > >> translate
> >> > >> into XML attribute and element names respectively and XML doesn't
> > allow
> >> > >> white space for them.
> >> > >>
> >> > >> Etienne
> >> > >>
> >> > >> "Kamal" <kali@bca-group.comNOSPAMPLEASE> wrote in message
> >> > >> news:%23wLvmFgCFHA.2600@TK2MSFTNGP09.phx.gbl...
> >> > >> > Hi everyone,
> >> > >> >
> >> > >> > Just wanted to know whether it is possible to have a space in
the
> >> > >> > schema
> >> > >> > element field name such as (User Name) in Biztalk 2004.
> >> > >> >
> >> > >> > and also what are the characters that not allowed in a schema
> > element
> >> > >> > field
> >> > >> > name.
> >> > >> >
> >> > >> > it's kinda urgent so please help,
> >> > >> >
> >> > >> > Thank you .
> >> > >> >
> >> > >> >
> >> > >>
> >> > >>
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: What is the logic of storing XML in a Database?
    ... can't do with CSV. ... In what a header does constitute a schema. ... So a schema is the standard structure by which the user sending a file ... in much the same way that XML standards are. ...
    (comp.databases.theory)
  • Re: How to split a flat file using Document and Envelope Schemas
    ... The example in the SDK directory that demonstrates how to split a flat file ... Run the sample and save the output xml file for later use. ... > I defined schema for Employees and Employee separately. ... > samples regarding flat file disassembler but there is no sample for XML ...
    (microsoft.public.biztalk.general)
  • Re: I get Object reference not set to an instance of an object in a simple application
    ... One flatFile csv text file as input and a flatfile schema for this csv ... One example of how xml output should look like and generate a schema ... I have created a Map between the OpenSourceSchema and the ... OpenSourceSchema is the schema for the csv flat file. ...
    (microsoft.public.biztalk.general)
  • Re: how to return xml document from a web service
    ... what specific XML you expect. ... If you have a schema that defines what you expect, ... The second issue with this approach is that XML is not a string. ... >> methods from the wire transport. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • my first Tck/Tk program... and an XML question
    ... program which takes an XML Schema file, ... a basic XML tree and allows the user to save it. ... proc open_schema { ...
    (comp.lang.tcl)