Home » Archived » BIRT » Data reduction(I am trying to figure out how to limit the data I put in my final report)
Data reduction [message #686247] |
Tue, 21 June 2011 22:11 |
Bob Messages: 7 Registered: June 2011 |
Junior Member |
|
|
Hello,
I am new to BIRT and I am trying to find a way to read only part of an item in a data set. My source is a TLE datasource and I am trying to create a report out of a JDBC dataset where one of the items is in XML code. I only want a small section of the XML code, specifically the title that the code refers to. How do I extract it from this big chunk of text for my table in my report?
example:<xml><metadata><general><title>Surveying - Pacing Video</title><description>This is a short video to demonstrate how to appropriately do pacing in a surveying setting.</description></general><wizard><media.type>File</media.type></wizard><classification><division>Physical and Biological Sciences</division><department>Physics</department></classification></metadata><item key="0" id="9df6c611-7e9a-940c-ad6a-2d3dd5b533ed" version="1" itemdefid="be0273d4-ed41-31c2-dc50-4a13a17d5ac3" itemstatus="draft"><staging/><name>Surveying - Pacing Video</name><description>This is a short video to demonstrate how to appropriately do pacing in a surveying setting.</description><newitem>true</newitem><owner>ddcd8f4b-42af-4fbd-49c2-f520e0ca3927</owner><rating average="-1.0"/><attachments><attachment type="local"><conversion>false</conversion><size>16892681</size><uuid>22621947-e19e-4476-ad4f-b004759482f9</uuid><file>pacingfinal.wmv</file><description>pacingfinal.wmv</description></attachment></attachments><badurls/><history/><moderation/><navigationNodes/></item></xml>
I need to get out "Surveying - Pacing Video" from the first line.
Do I do this via parameters, filters, or something else?
I am pretty lost so a decent explanation of what needs to be done would be appreciated.
Thank you,
[Updated on: Tue, 21 June 2011 22:13] Report message to a moderator
|
|
|
Re: Data reduction [message #686648 is a reply to message #686247] |
Wed, 22 June 2011 16:40 |
|
I assume that if you create a dataset off the table one of the columns has the complete xml as a string? If so try creating a computed column on the dataset with this expression:
importPackage( Packages.javax.xml.parsers);
importPackage( Packages.org.xml.sax);
importPackage( Packages.org.w3c.dom);
importPackage(Packages.java.io);
function getTagValue(mystr, tagName) {
factory = DocumentBuilderFactory.newInstance();
builder = factory.newDocumentBuilder();
JavaStr = new java.lang.String( mystr );
bais = new ByteArrayInputStream( JavaStr.getBytes());
document = builder.parse(bais);
nlist = document.getElementsByTagName(tagName);
return nlist.item(0).getFirstChild().getNodeValue();
}
getTagValue(row["xmlcol"], "title");
Attached is an example that does this on a table because I had to use a scripted data source to reproduce your scenario. But the same concept should work for a computed column.
Jason
|
|
| |
Re: Data reduction [message #688344 is a reply to message #688059] |
Fri, 24 June 2011 13:30 |
|
Bob,
In the expression you could have put
getTagValue(row["xmlcol"], "title") + "--" +getTagValue(row["name"], "title");
or something like that. You could also modify the getTagValue to take more than one tag
and return a formatted string.
Jason
|
|
|
Re: Data reduction [message #690079 is a reply to message #688344] |
Tue, 28 June 2011 23:26 |
Bob Messages: 7 Registered: June 2011 |
Junior Member |
|
|
Hello Jason,
Today I was trying to use the code you gave me as a dynamic text in a new report. This time the report came up with the dynamic text column blank. Besides the information I included here I attached my report design that has everything below.
My JDBC query statement is:
select item.id, item.date_for_index, item.owner, item_xml.xml, item_xml.id, tleuser.uuid, tleuser.first_name, tleuser.last_name
from item
join item_xml on item_xml.id = item.id
left join tleuser on item.owner = tleuser.uuid
and the code I am using in the dynamic text column is:
importPackage( Packages.javax.xml.parsers);
importPackage( Packages.org.xml.sax);
importPackage( Packages.org.w3c.dom);
importPackage(Packages.java.io);
function getTagValue(mystr, tagName) {
factory = DocumentBuilderFactory.newInstance();
builder = factory.newDocumentBuilder();
JavaStr = new java.lang.String( mystr );
bais = new ByteArrayInputStream( JavaStr.getBytes());
document = builder.parse(bais);
nlist = document.getElementsByTagName(tagName);
return nlist.item(0).getFirstChild().getNodeValue();
}
getTagValue(row["xml"], "title")
Also, whenever I use this code (on every report I have made) I consistently get error messages saying that:
There are errors evaluating script "importPackage( Packages.javax.xml.parsers);
The choice of Java method java.lang.String.java.lang.String matching JavaScript argument types (null) is ambiguous; candidate methods are:
String(java.lang.String)
String(char[])
String(java.lang.StringBuilder)
String(byte[])
String(java.lang.StringBuffer) (<inline>#10)
Cannot call method "getFirstChild" of null (<inline>#14).
|
|
|
(no subject) [message #690081 is a reply to message #688344] |
Tue, 28 June 2011 23:26 |
Bob Messages: 44 Registered: July 2009 |
Member |
|
|
Hello Jason,
Today I was trying to use the code you gave me as a dynamic text in a new report. This time the report came up with the dynamic text column blank. Besides the information I included here I attached my report design that has everything below.
My JDBC query statement is:
select item.id, item.date_for_index, item.owner, item_xml.xml, item_xml.id, tleuser.uuid, tleuser.first_name, tleuser.last_name
from item
join item_xml on item_xml.id = item.id
left join tleuser on item.owner = tleuser.uuid
and the code I am using in the dynamic text column is:
importPackage( Packages.javax.xml.parsers);
importPackage( Packages.org.xml.sax);
importPackage( Packages.org.w3c.dom);
importPackage(Packages.java.io);
function getTagValue(mystr, tagName) {
factory = DocumentBuilderFactory.newInstance();
builder = factory.newDocumentBuilder();
JavaStr = new java.lang.String( mystr );
bais = new ByteArrayInputStream( JavaStr.getBytes());
document = builder.parse(bais);
nlist = document.getElementsByTagName(tagName);
return nlist.item(0).getFirstChild().getNodeValue();
}
getTagValue(row["xml"], "title")
Also, whenever I use this code (on every report I have made) I consistently get error messages saying that:
There are errors evaluating script "importPackage( Packages.javax.xml.parsers);
The choice of Java method java.lang.String.java.lang.String matching JavaScript argument types (null) is ambiguous; candidate methods are:
String(java.lang.String)
String(char[])
String(java.lang.StringBuilder)
String(byte[])
String(java.lang.StringBuffer) (<inline>#10)
Cannot call method "getFirstChild" of null (<inline>#14).
begin 644 Linking Reports.rptdesign
M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB551&+3@B/SX*/')E<&]R
M="!X;6QN<STB:'1T<#HO+W=W=RYE8VQI<'-E+F]R9R]B:7)T+S(P,#4O9&5S
M:6=N(B!V97)S:6]N/2(S+C(N,3<B(&ED/2(Q(CX*("`@(#QP<F]P97)T>2!N
M86UE/2)C<F5A=&5D0GDB/D5C;&EP<V4@0DE25"!$97-I9VYE<B!697)S:6]N
M(#(N,RXQ+G8R,#`X,#DQ,2!"=6EL9"`F;'0[,BXS+C$N=C(P,#@P.3(R+3$Q
M-3$^/"]P<F]P97)T>3X*("`@(#QP<F]P97)T>2!N86UE/2)U;FET<R(^:6X\
M+W!R;W!E<G1Y/@H@("`@/'!R;W!E<G1Y(&YA;64](FEC;VY&:6QE(CXO=&5M
M<&QA=&5S+W-I;7!L95]L:7-T:6YG+F=I9CPO<')O<&5R='D^"B`@("`\<')O
M<&5R='D@;F%M93TB8VAE8713:&5E="(^;W)G+F5C;&EP<V4N8FER="YR97!O
M<G0N9&5S:6=N97(N=6DN8VAE871S:&5E="YS:6UP;&5L:7-T:6YG/"]P<F]P
M97)T>3X*("`@(#QP<F]P97)T>2!N86UE/2)B:61I3&%Y;W5T3W)I96YT871I
M;VXB/FQT<CPO<')O<&5R='D^"B`@("`\9&%T82US;W5R8V5S/@H@("`@("`@
M(#QO9&$M9&%T82US;W5R8V4@97AT96YS:6]N240](F-O;2YT;&4N<F5P;W)T
M:6YG+F]D82YD871A<V]U<F-E(B!N86UE/2)%<75E;&QA($1A=&%B87-E(B!I
M9#TB,C8B/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB=V5B<V5R=FEC
M955R;"(^:'1T<#HO+V]E<BYC86YY;VYS+F5D=2]C86YY;VYS/"]P<F]P97)T
M>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G=E8G-E<G9I8V55<V5R
M(CYM:6QL97)?;3PO<')O<&5R='D^"B`@("`@("`@("`@(#QE;F-R>7!T960M
M<')O<&5R='D@;F%M93TB=V5B<V5R=FEC95!A<W-W;W)D(B!E;F-R>7!T:6]N
M240](F)A<V4V-"(^4DAG>DUZ43!.5%4]/"]E;F-R>7!T960M<')O<&5R='D^
M"B`@("`@("`@/"]O9&$M9&%T82US;W5R8V4^"B`@("`\+V1A=&$M<V]U<F-E
M<SX*("`@(#QD871A+7-E=',^"B`@("`@("`@/&]D82UD871A+7-E="!E>'1E
M;G-I;VY)1#TB8V]M+G1L92YR97!O<G1I;F<N;V1A+F1A=&%S970N:F1B8R(@
M;F%M93TB1&%T82!3970B(&ED/2(R-R(^"B`@("`@("`@("`@(#QL:7-T+7!R
M;W!E<G1Y(&YA;64](F-O;7!U=&5D0V]L=6UN<R(^"B`@("`@("`@("`@("`@
M("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)N86UE(CY4;W1A;"!)=&5M($-O=6YT/"]P<F]P97)T>3X*("`@("`@
M("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB9&%T851Y<&4B/FEN=&5G
M97(\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)A9V=R96=A=&5&=6YC=&EO;B(^0T]53E1$25-424Y#5#PO<')O<&5R
M='D^"B`@("`@("`@("`@("`@("`@("`@/&QI<W0M<')O<&5R='D@;F%M93TB
M87)G=6UE;G1S(CX*("`@("`@("`@("`@("`@("`@("`@("`@/'-T<G5C='5R
M93X*("`@("`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)N86UE(CY%>'!R97-S:6]N/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@
M("`@("`@("`@("`@(#QE>'!R97-S:6]N(&YA;64](G9A;'5E(CYR;W=;(FED
M(ET\+V5X<')E<W-I;VX^"B`@("`@("`@("`@("`@("`@("`@("`@(#PO<W1R
M=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#PO;&ES="UP<F]P97)T>3X*
M("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`\+VQI
M<W0M<')O<&5R='D^"B`@("`@("`@("`@(#QS=')U8W1U<F4@;F%M93TB8V%C
M:&5D365T841A=&$B/@H@("`@("`@("`@("`@("`@/&QI<W0M<')O<&5R='D@
M;F%M93TB<F5S=6QT4V5T(CX*("`@("`@("`@("`@("`@("`@("`\<W1R=6-T
M=7)E/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB
M<&]S:71I;VXB/C$\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@
M("`\<')O<&5R='D@;F%M93TB;F%M92(^:60\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB9&%T851Y<&4B/F1E
M8VEM86P\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#PO<W1R=6-T
M=7)E/@H@("`@("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)P;W-I=&EO;B(^,CPO
M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)N86UE(CYD871E7V9O<E]I;F1E>#PO<')O<&5R='D^"B`@("`@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^9&%T
M92UT:6UE/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\+W-T<G5C
M='5R93X*("`@("`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB<&]S:71I;VXB/C,\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@
M;F%M93TB;F%M92(^;W=N97(\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB9&%T851Y<&4B/G-T<FEN9SPO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@
M("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G!O<VET:6]N(CXT/"]P<F]P97)T>3X*
M("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA;64B
M/GAM;#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)D871A5'EP92(^<W1R:6YG/"]P<F]P97)T>3X*("`@("`@
M("`@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@
M("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@("`@("`\<')O<&5R
M='D@;F%M93TB<&]S:71I;VXB/C4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%M92(^:61?-3PO<')O<&5R
M='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D
M871A5'EP92(^9&5C:6UA;#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@
M("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@/'-T<G5C='5R
M93X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G!O
M<VET:6]N(CXV/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@
M/'!R;W!E<G1Y(&YA;64](FYA;64B/G5U:60\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB9&%T851Y<&4B/G-T
M<FEN9SPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/"]S=')U8W1U
M<F4^"B`@("`@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@
M("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G!O<VET:6]N(CXW/"]P
M<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](FYA;64B/F9I<G-T7VYA;64\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@("`@("`\<')O<&5R='D@;F%M93TB9&%T851Y<&4B/G-T<FEN9SPO
M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@
M("`@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@
M("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G!O<VET:6]N(CXX/"]P<F]P97)T
M>3X*("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA
M;64B/FQA<W1?;F%M93PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^<W1R:6YG/"]P<F]P97)T
M>3X*("`@("`@("`@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@
M("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@("`@
M("`\<')O<&5R='D@;F%M93TB<&]S:71I;VXB/CD\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%M92(^5&]T
M86P@271E;2!#;W5N=#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^:6YT96=E<CPO<')O<&5R
M='D^"B`@("`@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@
M("`@("`@("`\+VQI<W0M<')O<&5R='D^"B`@("`@("`@("`@(#PO<W1R=6-T
M=7)E/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB9&%T85-O=7)C92(^
M17%U96QL82!$871A8F%S93PO<')O<&5R='D^"B`@("`@("`@("`@(#QL:7-T
M+7!R;W!E<G1Y(&YA;64](G)E<W5L=%-E="(^"B`@("`@("`@("`@("`@("`\
M<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)P;W-I=&EO;B(^,3PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@
M/'!R;W!E<G1Y(&YA;64](FYA;64B/FED/"]P<F]P97)T>3X*("`@("`@("`@
M("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T:79E3F%M92(^:60\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D
M871A5'EP92(^9&5C:6UA;#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\
M+W-T<G5C='5R93X*("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@
M("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G!O<VET:6]N(CXR/"]P
M<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB
M;F%M92(^9&%T95]F;W)?:6YD97@\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)N871I=F5.86UE(CYD871E7V9O<E]I
M;F1E>#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y
M(&YA;64](F1A=&%4>7!E(CYD871E+71I;64\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R=6-T
M=7)E/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)P;W-I
M=&EO;B(^,SPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](FYA;64B/F]W;F5R/"]P<F]P97)T>3X*("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T:79E3F%M92(^;W=N97(\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D
M871A5'EP92(^<W1R:6YG/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@(#PO
M<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@
M("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB<&]S:71I;VXB/C0\+W!R
M;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N
M86UE(CYX;6P\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P
M97)T>2!N86UE/2)N871I=F5.86UE(CYX;6P\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^<W1R:6YG
M/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@(#PO<W1R=6-T=7)E/@H@("`@
M("`@("`@("`@("`@/'-T<G5C='5R93X*("`@("`@("`@("`@("`@("`@("`\
M<')O<&5R='D@;F%M93TB<&]S:71I;VXB/C4\+W!R;W!E<G1Y/@H@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)N86UE(CYI9%\U/"]P<F]P
M97)T>3X*("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%T
M:79E3F%M92(^:60\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP
M<F]P97)T>2!N86UE/2)D871A5'EP92(^9&5C:6UA;#PO<')O<&5R='D^"B`@
M("`@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@("`@(#QS
M=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(G!O<VET:6]N(CXV/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\
M<')O<&5R='D@;F%M93TB;F%M92(^=75I9#PO<')O<&5R='D^"B`@("`@("`@
M("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA=&EV94YA;64B/G5U:60\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)D871A5'EP92(^<W1R:6YG/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@
M(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB<&]S:71I;VXB/C<\
M+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)N86UE(CYF:7)S=%]N86UE/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@
M("`@("`\<')O<&5R='D@;F%M93TB;F%T:79E3F%M92(^9FER<W1?;F%M93PO
M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(F1A=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@
M/"]S=')U8W1U<F4^"B`@("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)P;W-I=&EO;B(^.#PO
M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(FYA;64B/FQA<W1?;F%M93PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@
M("`@/'!R;W!E<G1Y(&YA;64](FYA=&EV94YA;64B/FQA<W1?;F%M93PO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F1A
M=&%4>7!E(CYS=')I;F<\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S
M=')U8W1U<F4^"B`@("`@("`@("`@(#PO;&ES="UP<F]P97)T>3X*("`@("`@
M("`@("`@/'!R;W!E<G1Y(&YA;64](G%U97)Y5&5X="(^<V5L96-T(&ET96TN
M:60L(&ET96TN9&%T95]F;W)?:6YD97@L(&ET96TN;W=N97(L(&ET96U?>&UL
M+GAM;"P@:71E;5]X;6PN:60L('1L975S97(N=75I9"P@=&QE=7-E<BYF:7)S
M=%]N86UE+"!T;&5U<V5R+FQA<W1?;F%M90IF<F]M(&ET96T*"6IO:6X@:71E
M;5]X;6P@;VX@:71E;5]X;6PN:60@/2!I=&5M+FED"@EL969T(&IO:6X@=&QE
M=7-E<B!O;B!I=&5M+F]W;F5R(#T@=&QE=7-E<BYU=6ED/"]P<F]P97)T>3X*
M("`@("`@("`\+V]D82UD871A+7-E=#X*("`@(#PO9&%T82US971S/@H@("`@
M/'-T>6QE<SX*("`@("`@("`\<W1Y;&4@;F%M93TB8W)O<W-T86(M8V5L;"(@
M:60](C(T(CX*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F)O<F1E<D)O
M='1O;4-O;&]R(CXC0T-#0T-#/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R
M;W!E<G1Y(&YA;64](F)O<F1E<D)O='1O;5-T>6QE(CYS;VQI9#PO<')O<&5R
M='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)B;W)D97)";W1T;VU7
M:61T:"(^,7!T/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](F)O<F1E<DQE9G1#;VQO<B(^(T-#0T-#0SPO<')O<&5R='D^"B`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)B;W)D97),969T4W1Y;&4B/G-O;&ED
M/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F)O<F1E
M<DQE9G17:61T:"(^,7!T/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](F)O<F1E<E)I9VAT0V]L;W(B/B-#0T-#0T,\+W!R;W!E<G1Y
M/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB8F]R9&5R4FEG:'13='EL
M92(^<V]L:60\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB8F]R9&5R4FEG:'17:61T:"(^,7!T/"]P<F]P97)T>3X*("`@("`@("`@
M("`@/'!R;W!E<G1Y(&YA;64](F)O<F1E<E1O<$-O;&]R(CXC0T-#0T-#/"]P
M<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F)O<F1E<E1O
M<%-T>6QE(CYS;VQI9#PO<')O<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T
M>2!N86UE/2)B;W)D97)4;W!7:61T:"(^,7!T/"]P<F]P97)T>3X*("`@("`@
M("`\+W-T>6QE/@H@("`@("`@(#QS='EL92!N86UE/2)C<F]S<W1A8B(@:60]
M(C(U(CX*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F)O<F1E<D)O='1O
M;4-O;&]R(CXC0T-#0T-#/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](F)O<F1E<D)O='1O;5-T>6QE(CYS;VQI9#PO<')O<&5R='D^
M"B`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)B;W)D97)";W1T;VU7:61T
M:"(^,7!T/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64]
M(F)O<F1E<DQE9G1#;VQO<B(^(T-#0T-#0SPO<')O<&5R='D^"B`@("`@("`@
M("`@(#QP<F]P97)T>2!N86UE/2)B;W)D97),969T4W1Y;&4B/G-O;&ED/"]P
M<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F)O<F1E<DQE
M9G17:61T:"(^,7!T/"]P<F]P97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y
M(&YA;64](F)O<F1E<E)I9VAT0V]L;W(B/B-#0T-#0T,\+W!R;W!E<G1Y/@H@
M("`@("`@("`@("`\<')O<&5R='D@;F%M93TB8F]R9&5R4FEG:'13='EL92(^
M<V]L:60\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB
M8F]R9&5R4FEG:'17:61T:"(^,7!T/"]P<F]P97)T>3X*("`@("`@("`@("`@
M/'!R;W!E<G1Y(&YA;64](F)O<F1E<E1O<$-O;&]R(CXC0T-#0T-#/"]P<F]P
M97)T>3X*("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F)O<F1E<E1O<%-T
M>6QE(CYS;VQI9#PO<')O<&5R='D^"B`@("`@("`@("`@(#QP<F]P97)T>2!N
M86UE/2)B;W)D97)4;W!7:61T:"(^,7!T/"]P<F]P97)T>3X*("`@("`@("`\
M+W-T>6QE/@H@("`@/"]S='EL97,^"B`@("`\<&%G92US971U<#X*("`@("`@
M("`\<VEM<&QE+6UA<W1E<BUP86=E(&YA;64](E-I;7!L92!-87-T97)086=E
M(B!I9#TB,B(^"B`@("`@("`@("`@(#QP86=E+69O;W1E<CX*("`@("`@("`@
M("`@("`@(#QT97AT(&ED/2(S(CX*("`@("`@("`@("`@("`@("`@("`\<')O
M<&5R='D@;F%M93TB8V]N=&5N=%1Y<&4B/FAT;6P\+W!R;W!E<G1Y/@H@("`@
M("`@("`@("`@("`@("`@(#QT97AT+7!R;W!E<G1Y(&YA;64](F-O;G1E;G0B
M/CPA6T-$051!6SQV86QU92UO9CYN97<@1&%T92@I/"]V86QU92UO9CY=73X\
M+W1E>'0M<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W1E>'0^"B`@("`@
M("`@("`@(#PO<&%G92UF;V]T97(^"B`@("`@("`@/"]S:6UP;&4M;6%S=&5R
M+7!A9V4^"B`@("`\+W!A9V4M<V5T=7`^"B`@("`\8F]D>3X*("`@("`@("`\
M=&%B;&4@:60](C0B/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB=VED
M=&@B/C$P,"4\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M
M93TB9&%T85-E="(^1&%T82!3970\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\
M;&ES="UP<F]P97)T>2!N86UE/2)B;W5N9$1A=&%#;VQU;6YS(CX*("`@("`@
M("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@/'!R
M;W!E<G1Y(&YA;64](FYA;64B/FED/"]P<F]P97)T>3X*("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB9&ES<&QA>4YA;64B/FED/"]P<F]P
M97)T>3X*("`@("`@("`@("`@("`@("`@("`\97AP<F5S<VEO;B!N86UE/2)E
M>'!R97-S:6]N(CYD871A4V5T4F]W6R)I9")=/"]E>'!R97-S:6]N/@H@("`@
M("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D871A5'EP92(^9&5C
M:6UA;#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`\+W-T<G5C='5R93X*
M("`@("`@("`@("`@("`@(#QS=')U8W1U<F4^"B`@("`@("`@("`@("`@("`@
M("`@/'!R;W!E<G1Y(&YA;64](FYA;64B/F]W;F5R/"]P<F]P97)T>3X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB9&ES<&QA>4YA;64B
M/F]W;F5R/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\97AP<F5S
M<VEO;B!N86UE/2)E>'!R97-S:6]N(CYD871A4V5T4F]W6R)O=VYE<B)=/"]E
M>'!R97-S:6]N/@H@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)D871A5'EP92(^<W1R:6YG/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@
M(#PO<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@/'-T<G5C='5R93X*("`@
M("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB;F%M92(^9FER<W1?
M;F%M93PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y
M(&YA;64](F1I<W!L87E.86UE(CYF:7)S=%]N86UE/"]P<F]P97)T>3X*("`@
M("`@("`@("`@("`@("`@("`\97AP<F5S<VEO;B!N86UE/2)E>'!R97-S:6]N
M(CYD871A4V5T4F]W6R)F:7)S=%]N86UE(ET\+V5X<')E<W-I;VX^"B`@("`@
M("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F1A=&%4>7!E(CYS=')I
M;F<\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@/"]S=')U8W1U<F4^"B`@
M("`@("`@("`@("`@("`\<W1R=6-T=7)E/@H@("`@("`@("`@("`@("`@("`@
M(#QP<F]P97)T>2!N86UE/2)N86UE(CYL87-T7VYA;64\+W!R;W!E<G1Y/@H@
M("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)D:7-P;&%Y3F%M
M92(^;&%S=%]N86UE/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`\
M97AP<F5S<VEO;B!N86UE/2)E>'!R97-S:6]N(CYD871A4V5T4F]W6R)L87-T
M7VYA;64B73PO97AP<F5S<VEO;CX*("`@("`@("`@("`@("`@("`@("`\<')O
M<&5R='D@;F%M93TB9&%T851Y<&4B/G-T<FEN9SPO<')O<&5R='D^"B`@("`@
M("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@("`@(#QS=')U
M8W1U<F4^"B`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](FYA
M;64B/E1O=&%L($ET96T@0V]U;G0\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)D:7-P;&%Y3F%M92(^5&]T86P@271E
M;2!#;W5N=#PO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@/&5X<')E
M<W-I;VX@;F%M93TB97AP<F5S<VEO;B(^9&%T85-E=%)O=ULB5&]T86P@271E
M;2!#;W5N=")=/"]E>'!R97-S:6]N/@H@("`@("`@("`@("`@("`@("`@(#QP
M<F]P97)T>2!N86UE/2)D871A5'EP92(^:6YT96=E<CPO<')O<&5R='D^"B`@
M("`@("`@("`@("`@("`\+W-T<G5C='5R93X*("`@("`@("`@("`@/"]L:7-T
M+7!R;W!E<G1Y/@H@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB<&%G94)R
M96%K26YT97)V86PB/C4P/"]P<F]P97)T>3X*("`@("`@("`@("`@/&-O;'5M
M;B!I9#TB,C`B/@H@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](G=I
M9'1H(CXP+C0V.#<U:6X\+W!R;W!E<G1Y/@H@("`@("`@("`@("`\+V-O;'5M
M;CX*("`@("`@("`@("`@/&-O;'5M;B!I9#TB-#(B+SX*("`@("`@("`@("`@
M/&-O;'5M;B!I9#TB-#8B+SX*("`@("`@("`@("`@/&-O;'5M;B!I9#TB,C$B
M+SX*("`@("`@("`@("`@/&-O;'5M;B!I9#TB,C(B+SX*("`@("`@("`@("`@
M/&-O;'5M;B!I9#TB,C,B+SX*("`@("`@("`@("`@/&AE861E<CX*("`@("`@
M("`@("`@("`@(#QR;W<@:60](C4B/@H@("`@("`@("`@("`@("`@("`@(#QC
M96QL(&ED/2(V(CX*("`@("`@("`@("`@("`@("`@("`@("`@/&QA8F5L(&ED
M/2(R."(^"B`@("`@("`@("`@("`@("`@("`@("`@("`@("`\=&5X="UP<F]P
M97)T>2!N86UE/2)T97AT(CY)=&5M($E$/"]T97AT+7!R;W!E<G1Y/@H@("`@
M("`@("`@("`@("`@("`@("`@("`\+VQA8F5L/@H@("`@("`@("`@("`@("`@
M("`@(#PO8V5L;#X*("`@("`@("`@("`@("`@("`@("`\8V5L;"!I9#TB,SDB
M/@H@("`@("`@("`@("`@("`@("`@("`@("`\=&5X="!I9#TB-#<B/@H@("`@
M("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F-O;G1E
M;G14>7!E(CYA=71O/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@
M("`@("`@(#QT97AT+7!R;W!E<G1Y(&YA;64](F-O;G1E;G0B/CPA6T-$051!
M6TET96T@3F%M95U=/CPO=&5X="UP<F]P97)T>3X*("`@("`@("`@("`@("`@
M("`@("`@("`@/"]T97AT/@H@("`@("`@("`@("`@("`@("`@(#PO8V5L;#X*
M("`@("`@("`@("`@("`@("`@("`\8V5L;"!I9#TB-#,B/@H@("`@("`@("`@
M("`@("`@("`@("`@("`\=&5X="!I9#TB-#@B/@H@("`@("`@("`@("`@("`@
M("`@("`@("`@("`@/'!R;W!E<G1Y(&YA;64](F-O;G1E;G14>7!E(CYA=71O
M/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@("`@(#QT97AT
M+7!R;W!E<G1Y(&YA;64](F-O;G1E;G0B/CPA6T-$051!6T%L=&5R;F%T92!)
M=&5M#0I.86UE75T^/"]T97AT+7!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@
M("`@("`@("`\+W1E>'0^"B`@("`@("`@("`@("`@("`@("`@/"]C96QL/@H@
M("`@("`@("`@("`@("`@("`@(#QC96QL(&ED/2(W(CX*("`@("`@("`@("`@
M("`@("`@("`@("`@/&QA8F5L(&ED/2(S,"(^"B`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)T97AT(CY/=VYE<B!3
M>7-T96T@240\+W1E>'0M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@
M("`@(#PO;&%B96P^"B`@("`@("`@("`@("`@("`@("`@/"]C96QL/@H@("`@
M("`@("`@("`@("`@("`@(#QC96QL(&ED/2(X(CX*("`@("`@("`@("`@("`@
M("`@("`@("`@/&QA8F5L(&ED/2(S,B(^"B`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)T97AT(CY/=VYE<B=S($9I
M<G-T($YA;64\+W1E>'0M<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@
M("`@(#PO;&%B96P^"B`@("`@("`@("`@("`@("`@("`@/"]C96QL/@H@("`@
M("`@("`@("`@("`@("`@(#QC96QL(&ED/2(Y(CX*("`@("`@("`@("`@("`@
M("`@("`@("`@/&QA8F5L(&ED/2(S-"(^"B`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)T97AT(CY/=VYE<B=S($QA
M<W0@3F%M93PO=&5X="UP<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@
M("`@/"]L86)E;#X*("`@("`@("`@("`@("`@("`@("`\+V-E;&P^"B`@("`@
M("`@("`@("`@("`\+W)O=SX*("`@("`@("`@("`@/"]H96%D97(^"B`@("`@
M("`@("`@(#QD971A:6P^"B`@("`@("`@("`@("`@("`\<F]W(&ED/2(Q,"(^
M"B`@("`@("`@("`@("`@("`@("`@/&-E;&P@:60](C$Q(CX*("`@("`@("`@
M("`@("`@("`@("`@("`@/&1A=&$@:60](C(Y(CX*("`@("`@("`@("`@("`@
M("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)T97AT06QI9VXB/F-E;G1E
M<CPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@("`@("`\<')O
M<&5R='D@;F%M93TB<F5S=6QT4V5T0V]L=6UN(CYI9#PO<')O<&5R='D^"B`@
M("`@("`@("`@("`@("`@("`@("`@(#PO9&%T83X*("`@("`@("`@("`@("`@
M("`@("`\+V-E;&P^"B`@("`@("`@("`@("`@("`@("`@/&-E;&P@:60](C0P
M(CX*("`@("`@("`@("`@("`@("`@("`@("`@/'1E>'0M9&%T82!I9#TB-C4B
M/@H@("`@("`@("`@("`@("`@("`@("`@("`@("`@/&5X<')E<W-I;VX@;F%M
M93TB=F%L=65%>'!R(CYI;7!O<G1086-K86=E*"!086-K86=E<RYJ879A>"YX
M;6PN<&%R<V5R<RD[(`T*:6UP;W)T4&%C:V%G92@@4&%C:V%G97,N;W)G+GAM
M;"YS87@I.R`-"FEM<&]R=%!A8VMA9V4H(%!A8VMA9V5S+F]R9RYW,V,N9&]M
M*3L@#0II;7!O<G1086-K86=E*%!A8VMA9V5S+FIA=F$N:6\I.PT*#0IF=6YC
M=&EO;B!G971486=686QU92AM>7-T<BP@=&%G3F%M92D@>PT*("`-"@EF86-T
M;W)Y(#T@1&]C=6UE;G1"=6EL9&5R1F%C=&]R>2YN97=);G-T86YC92@I.R`@
M("`-"@EB=6EL9&5R(#T@9F%C=&]R>2YN97=$;V-U;65N=$)U:6QD97(H*3L-
M"@E*879A4W1R(#T@;F5W(&IA=F$N;&%N9RY3=')I;F<H(&UY<W1R("D[#0H)
M8F%I<R`](&YE=R!">71E07)R87E);G!U=%-T<F5A;2@@2F%V85-T<BYG971"
M>71E<R@I*3L-"@ED;V-U;65N="`](&)U:6QD97(N<&%R<V4H8F%I<RD[("`-
M"B`@;FQI<W0@/2!D;V-U;65N="YG971%;&5M96YT<T)Y5&%G3F%M92AT86=.
M86UE*3L-"B`@<F5T=7)N(&YL:7-T+FET96TH,"DN9V5T1FER<W1#:&EL9"@I
M+F=E=$YO9&5686QU92@I.PT*?0T*#0IG971486=686QU92AR;W=;(GAM;")=
M+"`B=&ET;&4B*3PO97AP<F5S<VEO;CX*("`@("`@("`@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)C;VYT96YT5'EP92(^:'1M;#PO<')O
M<&5R='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#PO=&5X="UD871A/@H@
M("`@("`@("`@("`@("`@("`@(#PO8V5L;#X*("`@("`@("`@("`@("`@("`@
M("`\8V5L;"!I9#TB-#0B/@H@("`@("`@("`@("`@("`@("`@("`@("`\=&5X
M="UD871A(&ED/2(V-B(^"B`@("`@("`@("`@("`@("`@("`@("`@("`@("`\
M97AP<F5S<VEO;B!N86UE/2)V86QU945X<'(B/FEM<&]R=%!A8VMA9V4H(%!A
M8VMA9V5S+FIA=F%X+GAM;"YP87)S97)S*3L@#0II;7!O<G1086-K86=E*"!0
M86-K86=E<RYO<F<N>&UL+G-A>"D[(`T*:6UP;W)T4&%C:V%G92@@4&%C:V%G
M97,N;W)G+G<S8RYD;VTI.R`-"FEM<&]R=%!A8VMA9V4H4&%C:V%G97,N:F%V
M82YI;RD[#0H-"F9U;F-T:6]N(&=E=%1A9U9A;'5E*&UY<W1R+"!T86=.86UE
M*2![#0H@(`T*"69A8W1O<GD@/2!$;V-U;65N=$)U:6QD97)&86-T;W)Y+FYE
M=TEN<W1A;F-E*"D[("`@(`T*"6)U:6QD97(@/2!F86-T;W)Y+FYE=T1O8W5M
M96YT0G5I;&1E<B@I.PT*"4IA=F%3='(@/2!N97<@:F%V82YL86YG+E-T<FEN
M9R@@;7ES='(@*3L-"@EB86ES(#T@;F5W($)Y=&5!<G)A>4EN<'5T4W1R96%M
M*"!*879A4W1R+F=E=$)Y=&5S*"DI.PT*"61O8W5M96YT(#T@8G5I;&1E<BYP
M87)S92AB86ES*3L@(`T*("!N;&ES="`](&1O8W5M96YT+F=E=$5L96UE;G1S
M0GE486=.86UE*'1A9TYA;64I.PT*("!R971U<FX@;FQI<W0N:71E;2@P*2YG
M971&:7)S=$-H:6QD*"DN9V5T3F]D959A;'5E*"D[#0I]#0H-"F=E=%1A9U9A
M;'5E*')O=ULB>&UL(ETL(")N86UE(BD\+V5X<')E<W-I;VX^"B`@("`@("`@
M("`@("`@("`@("`@("`@("`@("`\<')O<&5R='D@;F%M93TB8V]N=&5N=%1Y
M<&4B/FAT;6P\+W!R;W!E<G1Y/@H@("`@("`@("`@("`@("`@("`@("`@("`\
M+W1E>'0M9&%T83X*("`@("`@("`@("`@("`@("`@("`\+V-E;&P^"B`@("`@
M("`@("`@("`@("`@("`@/&-E;&P@:60](C$R(CX*("`@("`@("`@("`@("`@
M("`@("`@("`@/&1A=&$@:60](C,Q(CX*("`@("`@("`@("`@("`@("`@("`@
M("`@("`@(#QP<F]P97)T>2!N86UE/2)R97-U;'13971#;VQU;6XB/F]W;F5R
M/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@("`@/"]D871A/@H@
M("`@("`@("`@("`@("`@("`@(#PO8V5L;#X*("`@("`@("`@("`@("`@("`@
M("`\8V5L;"!I9#TB,3,B/@H@("`@("`@("`@("`@("`@("`@("`@("`\9&%T
M82!I9#TB,S,B/@H@("`@("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E
M<G1Y(&YA;64](G)E<W5L=%-E=$-O;'5M;B(^9FER<W1?;F%M93PO<')O<&5R
M='D^"B`@("`@("`@("`@("`@("`@("`@("`@(#PO9&%T83X*("`@("`@("`@
M("`@("`@("`@("`\+V-E;&P^"B`@("`@("`@("`@("`@("`@("`@/&-E;&P@
M:60](C$T(CX*("`@("`@("`@("`@("`@("`@("`@("`@/&1A=&$@:60](C,U
M(CX*("`@("`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE
M/2)R97-U;'13971#;VQU;6XB/FQA<W1?;F%M93PO<')O<&5R='D^"B`@("`@
M("`@("`@("`@("`@("`@("`@(#PO9&%T83X*("`@("`@("`@("`@("`@("`@
M("`\+V-E;&P^"B`@("`@("`@("`@("`@("`\+W)O=SX*("`@("`@("`@("`@
M/"]D971A:6P^"B`@("`@("`@("`@(#QF;V]T97(^"B`@("`@("`@("`@("`@
M("`\<F]W(&ED/2(Q-2(^"B`@("`@("`@("`@("`@("`@("`@/&-E;&P@:60]
M(C$V(CX*("`@("`@("`@("`@("`@("`@("`@("`@/'1E>'0@:60](C,W(CX*
M("`@("`@("`@("`@("`@("`@("`@("`@("`@(#QP<F]P97)T>2!N86UE/2)C
M;VYT96YT5'EP92(^875T;SPO<')O<&5R='D^"B`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`\=&5X="UP<F]P97)T>2!N86UE/2)C;VYT96YT(CX\(5M#
M1$%405L-"E1O=&%L($ET96T@0V]U;G0Z75T^/"]T97AT+7!R;W!E<G1Y/@H@
M("`@("`@("`@("`@("`@("`@("`@("`\+W1E>'0^"B`@("`@("`@("`@("`@
M("`@("`@("`@(#QD871A(&ED/2(S-B(^"B`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`\<')O<&5R='D@;F%M93TB<F5S=6QT4V5T0V]L=6UN(CY4;W1A
M;"!)=&5M($-O=6YT/"]P<F]P97)T>3X*("`@("`@("`@("`@("`@("`@("`@
M("`@/"]D871A/@H@("`@("`@("`@("`@("`@("`@("`@("`\=&5X="!I9#TB
M,S@B/@H@("`@("`@("`@("`@("`@("`@("`@("`@("`@/'!R;W!E<G1Y(&YA
M;64](F-O;G1E;G14>7!E(CYA=71O/"]P<F]P97)T>3X*("`@("`@("`@("`@
M("`@("`@("`@("`@/"]T97AT/@H@("`@("`@("`@("`@("`@("`@(#PO8V5L
M;#X*("`@("`@("`@("`@("`@("`@("`\8V5L;"!I9#TB-#$B+SX*("`@("`@
M("`@("`@("`@("`@("`\8V5L;"!I9#TB-#4B+SX*("`@("`@("`@("`@("`@
M("`@("`\8V5L;"!I9#TB,3<B+SX*("`@("`@("`@("`@("`@("`@("`\8V5L
M;"!I9#TB,3@B+SX*("`@("`@("`@("`@("`@("`@("`\8V5L;"!I9#TB,3DB
M+SX*("`@("`@("`@("`@("`@(#PO<F]W/@H@("`@("`@("`@("`\+V9O;W1E
J<CX*("`@("`@("`\+W1A8FQE/@H@("`@/"]B;V1Y/@H\+W)E<&]R=#X*
`
end
|
|
|
Re: Data reduction [message #690145 is a reply to message #690081] |
Wed, 29 June 2011 03:27 |
|
Bob,
My guess is row["xml"] is null for a particular row.
Jason
On 6/28/2011 7:26 PM, Bob wrote:
> Hello Jason,
> Today I was trying to use the code you gave me as a dynamic text in a new report. This time the report came up with the dynamic text column blank. Besides the information I included here I attached my report design that has everything below.
>
> My JDBC query statement is:
>
> select item.id, item.date_for_index, item.owner, item_xml.xml, item_xml.id, tleuser.uuid, tleuser.first_name, tleuser.last_name
> from item
> join item_xml on item_xml.id = item.id
> left join tleuser on item.owner = tleuser.uuid
>
> and the code I am using in the dynamic text column is:
>
> importPackage( Packages.javax.xml.parsers);
> importPackage( Packages.org.xml.sax);
> importPackage( Packages.org.w3c.dom);
> importPackage(Packages.java.io);
>
> function getTagValue(mystr, tagName) {
>
> factory = DocumentBuilderFactory.newInstance();
> builder = factory.newDocumentBuilder();
> JavaStr = new java.lang.String( mystr );
> bais = new ByteArrayInputStream( JavaStr.getBytes());
> document = builder.parse(bais);
> nlist = document.getElementsByTagName(tagName);
> return nlist.item(0).getFirstChild().getNodeValue();
> }
>
> getTagValue(row["xml"], "title")
>
>
> Also, whenever I use this code (on every report I have made) I consistently get error messages saying that:
>
> There are errors evaluating script "importPackage( Packages.javax.xml.parsers);
>
> The choice of Java method java.lang.String.java.lang.String matching JavaScript argument types (null) is ambiguous; candidate methods are:
> String(java.lang.String)
> String(char[])
> String(java.lang.StringBuilder)
> String(byte[])
> String(java.lang.StringBuffer) (<inline>#10)
>
> Cannot call method "getFirstChild" of null (<inline>#14).
>
>
>
>
|
|
| |
Re: Data reduction [message #691513 is a reply to message #691138] |
Fri, 01 July 2011 16:05 |
|
Bob,
Can you change this method:
function getTagValue(mystr, tagName) {
factory = DocumentBuilderFactory.newInstance();
builder = factory.newDocumentBuilder();
JavaStr = new java.lang.String( mystr );
bais = new ByteArrayInputStream( JavaStr.getBytes());
document = builder.parse(bais);
nlist = document.getElementsByTagName(tagName);
return nlist.item(0).getFirstChild().getNodeValue();
}
to
function getTagValue(mystr, tagName) {
if( mystr == null ){
return "blank";
}
factory = DocumentBuilderFactory.newInstance();
builder = factory.newDocumentBuilder();
JavaStr = new java.lang.String( mystr );
bais = new ByteArrayInputStream( JavaStr.getBytes());
document = builder.parse(bais);
nlist = document.getElementsByTagName(tagName);
return nlist.item(0).getFirstChild().getNodeValue();
}
Just to check?
Jason
On 6/30/2011 3:44 PM, Bob wrote:
> I have not found any row that is null for xml, and how would one null
> row get me a completely empty column?
|
|
| |
Re: Data reduction [message #693681 is a reply to message #693168] |
Thu, 07 July 2011 01:43 |
|
Bob,
Did it add any table bindings?
Jason
On 7/5/2011 7:51 PM, Bob wrote:
> I tried the code that you gave me, but it did not change anything. It
> was curious though, I got the system to work by first introducing the
> xml column on the table with the code as dynamic text in the next
> column. The code worked with the xml column there, and then when I
> removed the xml column it still worked. No other changes other than
> that. Curious...
>
> Thanks for all the assistance Jason,
>
> Bob
|
|
| |
Re: Data reduction [message #694420 is a reply to message #694074] |
Fri, 08 July 2011 14:23 |
|
Thanks Bob. I am not certain what happened. With the error you were
getting I assumed is was something with the source data.
Jason
On 7/7/2011 2:40 PM, Bob wrote:
> Jason
>
> I have attached an image of the requested information
>
> Bob
>
>
|
|
|
Goto Forum:
Current Time: Wed Sep 25 21:52:31 GMT 2024
Powered by FUDForum. Page generated in 0.05048 seconds
|