Forum Replies Created
-
Posts
-
Thanks Greg.
With the flat file schema and mapping as you suggested I only get 1 output record for Invoice A (expected 2 records) . When I connect the looping funtoid from product record to the output record I get the correct number of output records for each invoice but incorrect serial number on the 2nd product of the invoice.
I have now also connected the looping functoid from the sibling Serial Number record to the output record. The XML output now consists of all product records plus the serial number records that exists (different record formats for each record type but each record containing fields to uniquely identify the invoice and line item number).
I've also looked at Stephen Thomas' Sorting, Grouping, and Debatching in Pure Messaging Sample for BizTalk 2004. Will try to sort and group the records by products using the invoice number and line item number as the key.
Can anyone tell me how to define an xsl composite key ?
After the records are grouped by composite key, I somehow need to output the data from the grouped records to one record per group in a flat file. Any hints for this step?
Cheers
Stable
Nishil, Thank you very much for the help. Can you please post an example or can you email me one example to my email address which shows the drainng. It would be really gr8 if you can help me regarding his issue.
Thanks,
Jessica
Hi Anonymous,
I got the same problem in other scenario, i guess the file adapter makes this problem for not removing the file on error,
My solution was to check on the File Renaming under Advanced settings . That way (as i saw ) the file deleted .
Good luck
A&M IT
If your product line and serial number line are sibling records then you will need to use a custom Xslt and the xsl:key element.
However, an easier way may be to change the flat file schema.
Header record
Invoice A header record
Line
Product 1 for Invoice A record
Serial Number record for Product 1
Line
Product 2 for Invoice A record
Invoice B header record
Line
Product 3 for Invoice B record
Serial Number record for Product 3i.e. create a Line record which has a child Product record and an optional Serial number record.
In the map connect the Line record to the Looping functoid to the output record.
Reply to same post here .. http://www.biztalkgurus.com/forums/thread/7541.aspx.
Another solution that works is after the loop is over to have another loop with the same correlation set(following) to drain these instances for a certain amount of time ( DRAINING ). You can do this before or after you send out the final message . in the latter case you can send these drained ones as a second message or log them as errors .
The Oracle adater does not support User Defined Types or Reference Cursors.
You might want to consider querying a view.
AddNoteRequest is a message that is being setup for a Web Service. ".text" is one the exposed properties for the Web Service call.
The NoteDto message refers to a simple flat file schema. There is only one "Note" node per NoteDto message. Neither of the messages are multi-part. AddNoteRequest.text is not a distinguished field since it is part of the Web Service call, but the "Narrative" attribute is a distinguished field at the moment.
When I dump the NoteDto message back out to a flat file after the construct message shape completes, the value of the attribute I'm trying to extract is there the same as at the start.
I've tried setting .text to some literal string and it works fine, so it has to be with the xpath query I'm using.
Thanks
Wait, what is "text" on AddNoteRequest? Is this a multi-part message? A distinguished field? Make sure you also provide a string/number conversion for the node you're extracting (see Stephen's post here .. http://www.geekswithblogs.net/sthomas/archive/2004/10/25/13269.aspx).
Description of them … http://msdn2.microsoft.com/en-us/library/ms965489.aspx. Examples in the SDK installed with BizTalk as well ..
