|
Home > Archive > BizTalk Server General > August 2004 > Counting Attributes in BT 2004
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Counting Attributes in BT 2004
|
|
|
| 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
| |
| Mike V 2004-08-24, 6:59 pm |
| 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
| |
| Matt Milner 2004-08-24, 6:59 pm |
| 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
>
| |
|
| 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]
>
>
>.
>
| |
| Alan Smith 2004-08-25, 4:19 am |
| 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.
>
| |
|
| 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
>
>
>
>.
>
| |
| Matt Milner 2004-08-25, 5:54 pm |
| 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.
| |
|
| 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]
>
>
>.
>
| |
| Mike V 2004-08-27, 6:07 pm |
| 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]
>
>
>.
>
|
|
|
|
|