Re: Simple mapping question

Randal,

got there in the end ...

Yeap created the XSD for the source and destination, but still struggling ...

Then found this about the Table Loop functoid ...
http://geekswithblogs.net/evankoch/archive/2007/08/07/114470.aspx
which had a link to a downloadable working example

Thanks for the help

--
Cheers,
Steve C.


"Randal van Splunteren" wrote:

Hi Steve,

The only way you can work with the BizTalk mapper is when you have a
source and destination schema (XSD).
If you do not have the XSD schemas you'll need to create (or generate
(BizTalk has a tool which creates a XSD from an XML instance)) them.
The destination schema in your case should be a flat file schema. The
easiest way to create a flat file schema is to manually create a flat
file instance sample file and use that with the BizTalk flat file
generation Wizard to generate the schema.

When the schemas are created, you can select them as source and
destination in the mapper and start mapping.

Please let me know if this helps,

Regards,

Randal van Splunteren
http://biztalkmessages.wordpress.com

On Jul 29, 10:22 am, SteveC <steveculs...@xxxxxxxxxxxxxxxx> wrote:
Randal,

thanks for the response

There isn't an XML schema ...
- the extract I attempted to type comes from an office system that simply
"fills in the blanks", i.e. it adds element values to corresponding elements
in a provided XML "template"
- the values come from a form, and there is a config file which sets which
element name gets which value
- I left out the rest of the XML as it's more of the same ... field / value
pairs, some nested
- everything is pure string, no validation, no XSD, nada ...

Conversely the other system has to have a CSV data file with one line per
document type

--
Cheers,
Steve C.



"Randal van Splunteren" wrote:
Hi Steve,

The solutions to this really depens on the structure of the schemas
behind the xml instances in your post. I think people in this
newsgroup can help you better if you post (relevant part) of your
source and destination schema and also a sample instance. It is for
example important to know the multiplicity rules of the elements in
your xml.

Regards,

Randal van Splunteren
http://biztalkmessages.wordpress.com

On Jul 28, 8:01 pm, SteveC <steveculs...@xxxxxxxxxxxxxxxx> wrote:
Hi there

Absolute beginner with BizTalk (... I know it shows ...)

I've got an XML message which I want to map but I'm really confused over
what needs to go in the map ...
I've been looking at the Looping, Table Looping functoids but not getting it

Basic problem is I have XML like so
...
<DocTypes>
<Primary>
<Secondary>
<Alternative>
<DocTypes>
<AccountRef>
....

And I'm trying to get three records so I can output a flat file
...
<Primary> <AccountRef>
<Secondary> <AccountRef>
<Auxilary> <AccountRef>
...

--
Cheers,
Steve C.- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: XML Literals in VB9 - Whats wring with this?
    ... As for generating xsd scheme, .net framework does provide a tool "xsd.exe", ... it can help you generate xsd from a given sample XML document or generate ... However, since it's code logic is quite simple, the generated schema or ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQLXMLBulkLoad of text child nodes vs. attributes?
    ... You could use the XSDInference tool to get a XSD schema from xml. ... annotations to make it a proper sqlxml schema. ...
    (microsoft.public.sqlserver.xml)
  • RE: 2.0 dataset issues - again
    ... As for the first question on XML error, ... met is due to the XSD validation of the XML Editor... ... schemas and VS IDE's install directory will contains a copy of these schema ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: XML mapping
    ... XDR to XSD ... Generates an XML schema from an XML-Data-Reduced schema file. ... Generates common language runtime DataSet classes from an XSD schema file. ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • XSLT Conditional creation of destination Node
    ... The destination XML schema has an optional State element. ... if the source node is present but blank, I want to NOT create the ...
    (comp.text.xml)