Hey everyone,

I am migrating a Biztalk project over and have gotten
stuck on a piece of functionality that hasn't migrated
very well.

Inside of my mapper, I have a counting mechanism in place
that counts multiple attributes.  The sample XML is as
follows:

- <LineItem>
<PartNumber>MEM-I/O-FLD64M=</PartNumber>
<Waybill>1ZAT07536648351796</Waybill>
<Serial SerialNumber="1419140" />
<Serial SerialNumber="1430669" />
</LineItem>
- <LineItem>
<PartNumber>MEM-RSP-FLC32M=</PartNumber>
<Waybill>1ZAT07536648351796</Waybill>
<Serial SerialNumber="171399-1275248" />
<Serial SerialNumber="171399-1275249" />
<Serial SerialNumber="181478-1322150" />
</LineItem>

In Biztalk 2002, I was able to craete a mechanism using
Logical Existence, Value Mapping, and Cumulative Sum
funtoids to add the SerialNumbers for each line Item.
However, in the migration, I have lost this functionality.

Does anyone know how I can count these serialnumbers in
BT 2004?

Thanks!
Rey

[ Post a follow-up to this message ]

I am investigating your request.  As soon as I have an answer I will post
it here.


Mike Vallier
Microsoft BizTalk Support Professional

- A good backup is the key to success; you never know when you might need
one -


Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
Microsoft Corporation Copyright 2004
All Rights Reserved

--------------------
Content-Class: urn:content-classes:message
From: "Rey" <rdiaz@hotmail.com>
Sender: "Rey" <rdiaz@hotmail.com>
Subject: Counting Attributes in BT 2004
Date: Tue, 24 Aug 2004 11:53:24 -0700
Lines: 35
Message-ID: <c9a201c48a0b$a2236b00$a601280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcSKC6IjdQsFddDtQAWxte5Y+Zi37w==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.biztalk.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:18937
NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
X-Tomcat-NG: microsoft.public.biztalk.general

Hey everyone,

I am migrating a Biztalk project over and have gotten
stuck on a piece of functionality that hasn't migrated
very well.

Inside of my mapper, I have a counting mechanism in place
that counts multiple attributes.  The sample XML is as
follows:

- <LineItem>
<PartNumber>MEM-I/O-FLD64M=</PartNumber>
<Waybill>1ZAT07536648351796</Waybill>
<Serial SerialNumber="1419140" />
<Serial SerialNumber="1430669" />
</LineItem>
- <LineItem>
<PartNumber>MEM-RSP-FLC32M=</PartNumber>
<Waybill>1ZAT07536648351796</Waybill>
<Serial SerialNumber="171399-1275248" />
<Serial SerialNumber="171399-1275249" />
<Serial SerialNumber="181478-1322150" />
</LineItem>

In Biztalk 2002, I was able to craete a mechanism using
Logical Existence, Value Mapping, and Cumulative Sum
funtoids to add the SerialNumbers for each line Item.
However, in the migration, I have lost this functionality.

Does anyone know how I can count these serialnumbers in
BT 2004?

Thanks!
Rey

[ Post a follow-up to this message ]

If you want a count of the serial numbers, then you should be able to use
the "record count" functoid on the advanced tab.

Matt


"Rey" <rdiaz@hotmail.com> wrote in message
news:c9a201c48a0b$a2236b00$a601280a@phx.gbl...
> Hey everyone,
>
> I am migrating a Biztalk project over and have gotten
> stuck on a piece of functionality that hasn't migrated
> very well.
>
> Inside of my mapper, I have a counting mechanism in place
> that counts multiple attributes.  The sample XML is as
> follows:
>
> - <LineItem>
>   <PartNumber>MEM-I/O-FLD64M=</PartNumber>
>   <Waybill>1ZAT07536648351796</Waybill>
>   <Serial SerialNumber="1419140" />
>   <Serial SerialNumber="1430669" />
>   </LineItem>
> - <LineItem>
>   <PartNumber>MEM-RSP-FLC32M=</PartNumber>
>   <Waybill>1ZAT07536648351796</Waybill>
>   <Serial SerialNumber="171399-1275248" />
>   <Serial SerialNumber="171399-1275249" />
>   <Serial SerialNumber="181478-1322150" />
>   </LineItem>
>
> In Biztalk 2002, I was able to craete a mechanism using
> Logical Existence, Value Mapping, and Cumulative Sum
> funtoids to add the SerialNumbers for each line Item.
> However, in the migration, I have lost this functionality.
>
> Does anyone know how I can count these serialnumbers in
> BT 2004?
>
> Thanks!
> Rey
>

[ Post a follow-up to this message ]

Hey matt,

I tried that, but the record count functoid counts ALL of
the instances of the record.  In the example I gave, it
would return a total of 5 (there are 5 serial numbers).
What I need it to do is count the records per line item.
In other words, I need '3' for the first line, and '2'
for the second.

Thanks for your help!


>-----Original Message-----
>If you want a count of the serial numbers, then you
should be able to use
>the "record count" functoid on the advanced tab.
>
>Matt
>
>
>"Rey" <rdiaz@hotmail.com> wrote in message
>news:c9a201c48a0b$a2236b00$a601280a@phx.gbl... 
place[vbcol=seagreen] 
functionality.[vbcol=seagreen] 
>
>
>.
>

[ Post a follow-up to this message ]

Hi Rey,

Try using some xpath...

Something like this:

numerOfSerielNumbers = xpath (msg, "number (count (//LineItem[1]/Serial)
)");

Regards,

Alan


"Rey" wrote:

> Hey matt,
>
> I tried that, but the record count functoid counts ALL of
> the instances of the record.  In the example I gave, it
> would return a total of 5 (there are 5 serial numbers).
> What I need it to do is count the records per line item.
> In other words, I need '3' for the first line, and '2'
> for the second.
>
> Thanks for your help!
>
> 
> should be able to use 
> place 
> functionality. 
>

[ Post a follow-up to this message ]

Thanks Mike!

I eagerly await your response.

>-----Original Message-----
>I am investigating your request.  As soon as I have an
answer I will post
>it here.
>
>
>Mike Vallier
>Microsoft BizTalk Support Professional
>
>- A good backup is the key to success; you never know
when you might need
>one -
>
>
>Note: This posting is provided "AS IS" with no
warranties, and confers no
>rights.
>Microsoft Corporation Copyright 2004
>All Rights Reserved
>
>--------------------
>Content-Class: urn:content-classes:message
>From: "Rey" <rdiaz@hotmail.com>
>Sender: "Rey" <rdiaz@hotmail.com>
>Subject: Counting Attributes in BT 2004
>Date: Tue, 24 Aug 2004 11:53:24 -0700
>Lines: 35
>Message-ID: <c9a201c48a0b$a2236b00$a601280a@phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
>	charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Thread-Index: AcSKC6IjdQsFddDtQAWxte5Y+Zi37w==
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Newsgroups: microsoft.public.biztalk.general
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.biztalk.general:18937
>NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Hey everyone,
>
>I am migrating a Biztalk project over and have gotten
>stuck on a piece of functionality that hasn't migrated
>very well.
>
>Inside of my mapper, I have a counting mechanism in
place
>that counts multiple attributes.  The sample XML is as
>follows:
>
>- <LineItem>
>  <PartNumber>MEM-I/O-FLD64M=</PartNumber>
>  <Waybill>1ZAT07536648351796</Waybill>
>  <Serial SerialNumber="1419140" />
>  <Serial SerialNumber="1430669" />
>  </LineItem>
>- <LineItem>
>  <PartNumber>MEM-RSP-FLC32M=</PartNumber>
>  <Waybill>1ZAT07536648351796</Waybill>
>  <Serial SerialNumber="171399-1275248" />
>  <Serial SerialNumber="171399-1275249" />
>  <Serial SerialNumber="181478-1322150" />
>  </LineItem>
>
>In Biztalk 2002, I was able to craete a mechanism using
>Logical Existence, Value Mapping, and Cumulative Sum
>funtoids to add the SerialNumbers for each line Item.
>However, in the migration, I have lost this
functionality.
>
>Does anyone know how I can count these serialnumbers in
>BT 2004?
>
>Thanks!
>Rey
>
>
>
>.
>

[ Post a follow-up to this message ]

If you put a looping functoid on the LineItem, then I think this will get
you what you want, but not knowing what your resulting schema is looking
like, I'm not sure how the loop might fit in.
Matt


"Rey" <rdiaz@hotmail.com> wrote in message
news:c9ba01c48a2d$638e5450$a401280a@phx.gbl...[vbcol=seagreen]
> Hey matt,
>
> I tried that, but the record count functoid counts ALL of
> the instances of the record.  In the example I gave, it
> would return a total of 5 (there are 5 serial numbers).
> What I need it to do is count the records per line item.
> In other words, I need '3' for the first line, and '2'
> for the second.
>
> Thanks for your help!
>
> 
> should be able to use 
> place 
> functionality. 

[ Post a follow-up to this message ]

Hey Matt,

My result (including the LineItem loop) is as follows:

- <LineItem>
<Line>1</Line>
<UOM>EA</UOM>
<ReceivedQty>1</ReceivedQty>
<ReceivedQty>1</ReceivedQty>
<ReceivedQty>1</ReceivedQty>
<ItemId>CISCO2610</ItemId>
<Waybill>1ZAT07536647082801</Waybill>
<Serial>1429109</Serial>
<Serial>153311-1073956</Serial>
<Serial>211042-1462147</Serial>
</LineItem>

As you can see, my problem is in ReceivedQty.  I need a
number 3.  The Record Count functoid will not work,
because it will count every instance od SerialNumber, and
I can have multiple LineItems.

The above result was obtained using a Logical, Value
Mapping, and Cumulative functoid.
>-----Original Message-----
>If you put a looping functoid on the LineItem, then I
think this will get
>you what you want, but not knowing what your resulting
schema is looking
>like, I'm not sure how the loop might fit in.
>Matt
>
>
>"Rey" <rdiaz@hotmail.com> wrote in message
>news:c9ba01c48a2d$638e5450$a401280a@phx.gbl... 
of[vbcol=seagreen] 
item.[vbcol=seagreen] 
gotten[vbcol=seagreen] 
migrated[vbcol=seagreen] 
as[vbcol=seagreen] 
using[vbcol=seagreen] 
Item.[vbcol=seagreen] 
serialnumbers in[vbcol=seagreen] 
>
>
>.
>

[ Post a follow-up to this message ]

Rey,
There is a hotfix I have been able to identify that appears to address
this issue and I would like you to try.  Please contact MS support
referencing hotfix #841275.  This will be a grace case and will be at no
cost to you.  This case is a simple formality used to track hotfix
utilization.

Thanks,


Mike Vallier
Microsoft BizTalk Support Professional

- A good backup is the key to success; you never know when you might need
one -

Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
Microsoft Corporation Copyright 2004
All Rights Reserved

--------------------
Content-Class: urn:content-classes:message
From: "Rey" <rdiaz@hotmail.com>
Sender: "Rey" <rdiaz@hotmail.com>
References: <c9a201c48a0b$a2236b00$a601280a@phx.gbl>
<O8ZKgOiiEHA.2544@TK2MSFTNGP10.phx.gbl>
<c9ba01c48a2d$638e5450$a401280a@phx.gbl>
<#ibqL9riEHA.2664@TK2MSFTNGP11.phx.gbl>
Subject: Re: Counting Attributes in BT 2004
Date: Wed, 25 Aug 2004 09:48:17 -0700
Lines: 110
Message-ID: <d49401c48ac3$51f4a5a0$a601280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcSKw1HyMlgItPeSRSaH2Y4hcBD/iQ==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.biztalk.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:18986
NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
X-Tomcat-NG: microsoft.public.biztalk.general

Hey Matt,

My result (including the LineItem loop) is as follows:

- <LineItem>
<Line>1</Line>
<UOM>EA</UOM>
<ReceivedQty>1</ReceivedQty>
<ReceivedQty>1</ReceivedQty>
<ReceivedQty>1</ReceivedQty>
<ItemId>CISCO2610</ItemId>
<Waybill>1ZAT07536647082801</Waybill>
<Serial>1429109</Serial>
<Serial>153311-1073956</Serial>
<Serial>211042-1462147</Serial>
</LineItem>

As you can see, my problem is in ReceivedQty.  I need a
number 3.  The Record Count functoid will not work,
because it will count every instance od SerialNumber, and
I can have multiple LineItems.

The above result was obtained using a Logical, Value
Mapping, and Cumulative functoid.
>-----Original Message-----
>If you put a looping functoid on the LineItem, then I
think this will get
>you what you want, but not knowing what your resulting
schema is looking
>like, I'm not sure how the loop might fit in.
>Matt
>
>
>"Rey" <rdiaz@hotmail.com> wrote in message
>news:c9ba01c48a2d$638e5450$a401280a@phx.gbl... 
of[vbcol=seagreen] 
item.[vbcol=seagreen] 
gotten[vbcol=seagreen] 
migrated[vbcol=seagreen] 
as[vbcol=seagreen] 
using[vbcol=seagreen] 
Item.[vbcol=seagreen] 
serialnumbers in[vbcol=seagreen] 
>
>
>.
>

[ Post a follow-up to this message ]