I've got a receive location where I'm doing a sql statement, that
dumps out an XML file to a send port.  The sql is below

SELECT top 1 header.sannumber, detail.ponum, detail.podate, detail.vendorid,
detail.isbnupc, detail.Newused, detail.poreqqty FROM         tblPOs detail,
edi_vendor_info header WHERE     detail.status = 'opn' AND detail.vendorid =
header.vendorid and header.pubnet_indicator = 1 FOR xml auto, elements

I get a good formatted XML file.
Next, I'm trying to pull in the XML file into a receive location bound to
a project... I was using covast to run the data over to an 850 (PO)
schema, and I started to have problems.  I was getting a lot of NULL data.
So, I tried to simply dump the read XML file... out to another XML file.
The output XML file doesn't have any data in it.
Here is the starting XML file.

- <Root xmlns="http://SQLReceivePubnet850">
- <header>
<sannumber>2813769</sannumber>
- <detail>
<ponum>369269</ponum>
<podate>20041105</podate>
<vendorid>10400</vendorid>
<isbnupc>0406949972</isbnupc>
<Newused>N</Newused>
<poreqqty>1</poreqqty>
</detail>
</header>
</Root>

The output XML is below.

- <ns0:Root xmlns:ns0="http://TestXMLProject1.Schema1">
- <header>
<sannumber />
- <detail>
<ponum />
<podate />
<vendorid />
<isbnupc />
<Newused />
<poreqqty />
</detail>
</header>
</ns0:Root>

I'm not getting any errors... it just doesn't show anything in the output
file.
Anyone have any ideas?
The orchestration is a straight field to field mapping.

[ Post a follow-up to this message ]

How did you map the data between the two messages?  Can you show the map
that you used?  did you test your map outside of the orchestration to make
sure it worked for you?

matt

"Scot S" <ScotS@discussions.microsoft.com> wrote in message
news:6B9374AA-F8C2-4635-80BD-435CE4BADE1A@microsoft.com...
> I've got a receive location where I'm doing a sql statement, that
> dumps out an XML file to a send port.  The sql is below
>
> SELECT top 1 header.sannumber, detail.ponum, detail.podate,
> detail.vendorid,
> detail.isbnupc, detail.Newused, detail.poreqqty FROM         tblPOs
> detail,
> edi_vendor_info header WHERE     detail.status = 'opn' AND detail.vendorid
> =
> header.vendorid and header.pubnet_indicator = 1 FOR xml auto, elements
>
> I get a good formatted XML file.
> Next, I'm trying to pull in the XML file into a receive location bound to
> a project... I was using covast to run the data over to an 850 (PO)
> schema, and I started to have problems.  I was getting a lot of NULL data.
> So, I tried to simply dump the read XML file... out to another XML file.
> The output XML file doesn't have any data in it.
> Here is the starting XML file.
>
> - <Root xmlns="http://SQLReceivePubnet850">
> - <header>
>  <sannumber>2813769</sannumber>
> - <detail>
>  <ponum>369269</ponum>
>  <podate>20041105</podate>
>  <vendorid>10400</vendorid>
>  <isbnupc>0406949972</isbnupc>
>  <Newused>N</Newused>
>  <poreqqty>1</poreqqty>
>  </detail>
>  </header>
>  </Root>
>
> The output XML is below.
>
> - <ns0:Root xmlns:ns0="http://TestXMLProject1.Schema1">
> - <header>
>  <sannumber />
> - <detail>
>  <ponum />
>  <podate />
>  <vendorid />
>  <isbnupc />
>  <Newused />
>  <poreqqty />
>  </detail>
>  </header>
>  </ns0:Root>
>
> I'm not getting any errors... it just doesn't show anything in the output
> file.
> Anyone have any ideas?
> The orchestration is a straight field to field mapping.

[ Post a follow-up to this message ]

The map is a one for one, on each element... I'd post the picture, but it
doesn't
look like I can attach documents.  How do I go about testing the
map outside the orchestration?  Do I tie it to the receive location?
The strangest thing is that I'm not getting any errors.  Like it is reading
the xml file properly... just not pushing them over to the new schema

"Matt Milner" wrote:

> How did you map the data between the two messages?  Can you show the map
> that you used?  did you test your map outside of the orchestration to make
> sure it worked for you?
>
> matt
>
> "Scot S" <ScotS@discussions.microsoft.com> wrote in message
> news:6B9374AA-F8C2-4635-80BD-435CE4BADE1A@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

I tied the map I used directly to the send port, and used the receive port
as the filter.
I got the same results...  Still not sure if the data was read correctly
into the first schema.  I would assume that it wasn't

"Matt Milner" wrote:

> How did you map the data between the two messages?  Can you show the map
> that you used?  did you test your map outside of the orchestration to make
> sure it worked for you?
>
> matt
>
> "Scot S" <ScotS@discussions.microsoft.com> wrote in message
> news:6B9374AA-F8C2-4635-80BD-435CE4BADE1A@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

In the VS.Net, right click your map in the solution explorer and choose
properties.  Provide an input instance and indicate if it is in XML
(default) or native format.  Then make sure you change the source to be the
input item and not "generated".

Now you should be able to right click your map in the solution explorer and
choose "test map".  this will give you output in the output window including
a link to your outbound document if the map succeeds.

Matt


"Scot S" <ScotS@discussions.microsoft.com> wrote in message
news:BA4B51B6-D821-4D5B-8B7A-9B449462C605@microsoft.com...[vbcol=seagreen]
> The map is a one for one, on each element... I'd post the picture, but it
> doesn't
> look like I can attach documents.  How do I go about testing the
> map outside the orchestration?  Do I tie it to the receive location?
> The strangest thing is that I'm not getting any errors.  Like it is
> reading
> the xml file properly... just not pushing them over to the new schema
>
> "Matt Milner" wrote:
> 

[ Post a follow-up to this message ]