Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.
Learn More
SOLVED

Accessing XML Data File

Avatar

Level 1
Level 1
7/18/06 12:10:48 PM
Ok I need a quick lesson on accessing various tags in a xml
file and displaying them. I have a rather messy xml file that
dynamically created and the structure cannot be changed due to an
Excel application that is already accessing it.




Here's the xml:


<?xml version="1.0" encoding="utf-8" standalone="yes"?>

<Files>

<active>

<record>

<sendto>Joe D</sendto>

<head>

<level1>

<submited>true</submited>

<name>MIKE B</name>

<str>1</str>

<date>7/18/2006</date>

<notes>get this loaded!!!!!!!!!!!!!!!!!</notes>

</level1>

<level2>

<submited>false</submited>

<name></name>

<str></str>

<date></date>

<notes></notes>

</level2>

<level3>

<submited>false</submited>

<name></name>

<str></str>

<date></date>

<notes></notes>

</level3>

<level4>

<submited>false</submited>

<name></name>

<str></str>

<date></date>

<notes></notes>

</level4>

</head>

<itemcd>1234567</itemcd>

<desc>TEST</desc>

<retail>5</retail>

<aisle>AA01</aisle>

<replcst>2</replcst>

<pack>1</pack>

<upc>123456789999</upc>

<vendor>EMRYW</vendor>

<venditemcd>1234567</venditemcd>

<grp>2</grp>

<sec></sec>

<insaft></insaft>

<sellum default="each"></sellum>

<fracu default="i"></fracu>

<decp default="0"></decp>

<allowfr default=" "></allowfr>

<prium default="each"></prium>

<selluf default="1.00000"></selluf>

<priscal default="1"></priscal>

<stockum default="each"></stockum>

<itemstyp default="0"></itemstyp>

<traqoh default="y"></traqoh>

<rcvum default="each"></rcvum>

<rcvuf default="1.00000"></rcvuf>

<rcvscal default="1"></rcvscal>

<shipum default="each"></shipum>

<shipuf default="1.00000"></shipuf>

<stockingstr>

<str1>true</str1>

<str2>false</str2>

<str3>false</str3>

</stockingstr>

<pricematlev default="0"></pricematlev>

<qbreaktable default="0"></qbreaktable>

<taxflg default="y"></taxflg>

<gstcd default="0"></gstcd>

<tradedisf default="n"></tradedisf>

<promptpayf default="y"></promptpayf>

<commflg default="y"></commflg>

<additdescf default="n"></additdescf>

<talleyitemf default="n"></talleyitemf>

<nonstkitem default="n"></nonstkitem>

<assemblyitemf default="n"></assemblyitemf>

<assemblyitemtype
default="0"></assemblyitemtype>

<assemblyledtm default="0"></assemblyledtm>

<assemblywrkuts default="n/a"></assemblywrkuts>

<billmattyp default="0"></billmattyp>

<serialnumf default="n"></serialnumf>

<bascomitemf default="n"></bascomitemf>

<bascomitemcd></bascomitemcd>

<lotctrlf default="n"></lotctrlf>

<lotctrlnum default="0"></lotctrlnum>

<relitemmsgnum default="0"></relitemmsgnum>

<hazmatnum default="0"></hazmatnum>

<strydf default="s"></strydf>

<keyitemf default="n"></keyitemf>

<ctrlitemf default="n"></ctrlitemf>

<talleyindiv></talleyindiv>

<textfld2></textfld2>

<numfld1 default="0"></numfld1>

<numfld2 default="0"></numfld2>

<glacctcd default=""></glacctcd>

<stkitemrptf default="y"></stkitemrptf>

<lifopolnum default="0"></lifopolnum>

<lifosampf default="n"></lifosampf>

<pricetabname default=""></pricetabname>

<invcstperc default="0.00">

<str1></str1>

<str2></str2>

<str3></str3>

</invcstperc>

<invcritfac
default="0.00"><str1></str1><str2></str2><str3></str3></invcritfac>

<invglnum
default="0"><str1></str1><str2></str2><str3></str3></invglnum>

<invlngrngfac
default="0.00"><str1></str1><str2></str2><str3></str3></invlngrngfac>

<invminq default="1">

<str1></str1>

<str2></str2>

<str3></str3>

</invminq>

<invmaxq default="2">

<str1></str1>

<str2></str2>

<str3></str3>

</invmaxq>

<minmaxtab default="DO_NOT_ORDER">

<str1></str1>

<str2></str2>

<str3></str3>

</minmaxtab>

<invmingpperc default="49">

<str1></str1>

<str2></str2>

<str3></str3>

</invmingpperc>

<invordq
default="0"><str1></str1><str2></str2><str3></str3></invordq>


<price1><str1></str1><str2></str2><str3></str3></price1>


<price2><str1></str1><str2></str2><str3></str3></price2>


<price3><str1></str1><str2></str2><str3></str3></price3>


<price4><str1></str1><str2></str2><str3></str3></price4>


<price5><str1></str1><str2></str2><str3></str3></price5>


<price6><str1></str1><str2></str2><str3></str3></price6>


<price7><str1></str1><str2></str2><str3></str3></price7>


<price8><str1></str1><str2></str2><str3></str3></price8>

<aisle default="XXXXX">

<str1>AA01</str1>

<str2></str2>

<str3></str3>

</aisle>


<bin><str1></str1><str2></str2><str3></str3></bin>


<shelf><str1></str1><str2></str2><str3></str3></shelf>


<invstdcst><str1></str1><str2></str2><str3></str3></invstdcst>


<manminmax><str1></str1><str2></str2><str3></str3></manminmax>


<text2><str1></str1><str2></str2><str3></str3></text2>


<numer1><str1></str1><str2></str2><str3></str3></numer1>


<numer2><str1></str1><str2></str2><str3></str3></numer2>

<keyword default=""></keyword>

<note default="">get this
loaded!!!!!!!!!!!!!!!!!</note>

</record>

</active>

</Files>






Here's the code I have so far:


<?xml version="1.0" encoding="utf-8"?>

<Application xmlns="
http://www.adobe.com/2006/mxml"
layout="absolute" xmlns:local="*">

<XML id="feedData" source="index.xml"/>

<DataGrid dataProvider="{feedData..active.record}"
x="324" y="138" width="500">

<columns>

<DataGridColumn id="SubmittedBy" headerText="Submitted
By" dataField=""/>

<DataGridColumn headerText="Item" dataField="itemcd"/>

<DataGridColumn headerText="Description"
dataField="desc"/>

</columns>

</DataGrid>

</Application>



What I want to know is how to access and put into the "
Submitted By" column
<Files><active><record><head><level1><name>



Any help would be great since I'm stuck.

Views

698

Replies

2
Sign in to like this content

Total Likes

Translate
Translate
1 Accepted Solution

Avatar

Correct answer by
Level 1
Level 1
7/27/06 5:28:39 AM
After a little digging and a couple cups of coffee, I managed
to pull some data extracting from xml into a datagrid. I can access
attributes, node values, etc...



One thing I did notice, is that you have to refresh the
application if you have dynamic data constantly being updated. So
here is some code to help some of you out:





First some sample XML (index.xml):





<?xml version="1.0" encoding="utf-8" standalone="yes"?>

<records>

<active name="John" id="1234" location="New York">

<job>Architect</job>

<address>111 Salisbury Rd</address>

</active>



<inactive name="Chris" id="5432" location="California">

<job>Web Designer</job>

<address>888 Orchard Rd</address>

</inactive>



</records>







Code with two tabs one name (
Active), other named (
Inactive):





<mx:Application xmlns:mx="
http://www.adobe.com/2006/mxml"
layout="absolute" xmlns:local="*" pageTitle="Test App"
creationComplete="srv.send()">



<mx:HTTPService id="srv" url="
http://www.domain.com/index.xml?rand=math.random();"
resultFormat="e4x" useProxy="false" showBusyCursor="true" />

<mx:XMLListCollection id="xActive"
source="{srv.lastResult.active}" />

<mx:XMLListCollection id="xInActive"
source="{srv.lastResult.inactive}" />



<mx:script>

<[[

private function RefreshData():void{

xActive.refresh();

xInActive.refresh();

}

]]>

</mx:Script>



<mx:TabNavigator>

<mx:Canvas label="Active" width="100%" height="100%"
id="canvas1" initialize="RefreshData();">

<mx:DataGrid id="activeData" dataProvider="{xActive}"
selectedIndex="0" editable="true" enabled="true">

<mx:columns>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@name" headerText="Name"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@id" headerText="ID"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@location" headerText="Location"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="job" headerText="Job"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="address" headerText="Address"/>

</mx:columns>

</mx:DataGrid>

</mx:Canvas>



<mx:Canvas label="Inactive" width="100%" height="100%"
id="canvas2" initialize="RefreshData();">

<mx:DataGrid id="inactiveData" dataProvider="{xInActive}"
selectedIndex="0" editable="true" enabled="true">

<mx:columns>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@name" headerText="Name"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@id" headerText="ID"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@location" headerText="Location"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="job" headerText="Job"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="address" headerText="Address"/>

</mx:columns>

</mx:DataGrid>

</mx:Canvas>

</mx:TabNavigator>

</mx:Application>

View solution in original post

Views

485

Replies

0
Sign in to like this content

Total Likes

Translate
Translate
Jump to reply
2 Replies

Avatar

Level 3
Level 3
7/25/06 6:55:17 PM
Looking at the examples I found this



<mx:HTTPService id="srv" url="catalog.xml"
result="list.filter(filterItem, true)"/>



<AnimatedTileList id="list"
dataProvider="{srv.lastResult.catalog.product}"

itemRenderer="Thumbnail" width="700" height="528"/>



Notice the lastResult not result.

Views

463

Replies

0
Sign in to like this content

Total Likes

Translate
Translate

Avatar

Correct answer by
Level 1
Level 1
7/27/06 5:28:39 AM
After a little digging and a couple cups of coffee, I managed
to pull some data extracting from xml into a datagrid. I can access
attributes, node values, etc...



One thing I did notice, is that you have to refresh the
application if you have dynamic data constantly being updated. So
here is some code to help some of you out:





First some sample XML (index.xml):





<?xml version="1.0" encoding="utf-8" standalone="yes"?>

<records>

<active name="John" id="1234" location="New York">

<job>Architect</job>

<address>111 Salisbury Rd</address>

</active>



<inactive name="Chris" id="5432" location="California">

<job>Web Designer</job>

<address>888 Orchard Rd</address>

</inactive>



</records>







Code with two tabs one name (
Active), other named (
Inactive):





<mx:Application xmlns:mx="
http://www.adobe.com/2006/mxml"
layout="absolute" xmlns:local="*" pageTitle="Test App"
creationComplete="srv.send()">



<mx:HTTPService id="srv" url="
http://www.domain.com/index.xml?rand=math.random();"
resultFormat="e4x" useProxy="false" showBusyCursor="true" />

<mx:XMLListCollection id="xActive"
source="{srv.lastResult.active}" />

<mx:XMLListCollection id="xInActive"
source="{srv.lastResult.inactive}" />



<mx:script>

<[[

private function RefreshData():void{

xActive.refresh();

xInActive.refresh();

}

]]>

</mx:Script>



<mx:TabNavigator>

<mx:Canvas label="Active" width="100%" height="100%"
id="canvas1" initialize="RefreshData();">

<mx:DataGrid id="activeData" dataProvider="{xActive}"
selectedIndex="0" editable="true" enabled="true">

<mx:columns>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@name" headerText="Name"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@id" headerText="ID"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@location" headerText="Location"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="job" headerText="Job"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="address" headerText="Address"/>

</mx:columns>

</mx:DataGrid>

</mx:Canvas>



<mx:Canvas label="Inactive" width="100%" height="100%"
id="canvas2" initialize="RefreshData();">

<mx:DataGrid id="inactiveData" dataProvider="{xInActive}"
selectedIndex="0" editable="true" enabled="true">

<mx:columns>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@name" headerText="Name"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@id" headerText="ID"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="@location" headerText="Location"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="job" headerText="Job"/>

<mx:DataGridColumn textAlign="center" resizable="false"
dataField="address" headerText="Address"/>

</mx:columns>

</mx:DataGrid>

</mx:Canvas>

</mx:TabNavigator>

</mx:Application>

Views

486

Replies

0
Sign in to like this content

Total Likes

Translate
Translate
Jump to reply
Related Conversations
My data source works in Preview PDF mode but not when I generate the form Solved

Views

2.0K

Likes

0

Replies

2
How to binding the same Data View Table item in several tables - SAP Cloud Solved

Views

6.1K

Likes

0

Replies

2
Xml does not import correctly... Solved

Views

638

Likes

0

Replies

1
Flow table data horizontally like columns Solved

Views

682

Likes

0

Replies

2
Create CSV file

Views

505

Likes

0

Replies

1