Would using an XMLListCollection help? http://livedocs.adobe.com/flex/201/langref/mx/collections/XMLListCollection.html
On 6/7/07, Jason Ervin <[EMAIL PROTECTED]> wrote:
If I can just get my xml into an array that would be great. I guess I am going to have to skip ArrayUtil and hand code this as before with proxyObject. Sure wish Adobe would update the arrayutil in Flex 3, or better yet make importing data a drag and drop operation. Would make this much simpiliar. Dragging in certain nodes from XML into an array would ease the pain. J --- In [email protected] <flexcoders%40yahoogroups.com>, "Alex Harui" <[EMAIL PROTECTED]> wrote: > > I don't think ArrayUtil is as smart as you wish it was. You may have to > write your own conversion. > > > > ________________________________ > > From: [email protected] <flexcoders%40yahoogroups.com> [mailto: [email protected] <flexcoders%40yahoogroups.com>] On > Behalf Of Jason Ervin > Sent: Wednesday, June 06, 2007 6:50 PM > To: [email protected] <flexcoders%40yahoogroups.com> > Subject: [flexcoders] Re: ArrayCollection not working? Pulling out my > HAIR!!! > > > > Well I am using one data source via the singleton pattern as I have > approx. 20 screen feeding of the xml data. I am sure xml will work > with that. I wanted to use an Array or Arraycollection because I am > going to be using several hsliders to splice the data in arrays. > > I think it would be easier with an array than xml. Do you have an > example of how to splice up the data with xml rather than an array? > > Thanks in advance for any help. > > J > > --- In [email protected] <flexcoders%40yahoogroups.com><mailto: flexcoders% <flexcoders%25>40yahoogroups.com> > , "Brendan Meutzner" <bmeutzner@> > wrote: > > > > Any reason you're going through the trouble of converting to an > > ArrayCollection? The following will work with your XML data just > fine... > > > > <mx:ColumnChart id="mybarchart" dataProvider="{billData.bill}" > > showDataTips="true" paddingLeft="5" paddingRight="5" width="100%" > > height="100%"> > > <mx:horizontalAxis> > > <mx:CategoryAxis categoryField="@account"/> > > </mx:horizontalAxis> > > <mx:series> > > <mx:ColumnSeries displayName="Electric Bill" > xField="@account" > > yField="electricitybillamount" /> > > <mx:ColumnSeries displayName="Gas Bill" xField="@account" > > yField="gasbillamount" /> > > <mx:ColumnSeries displayName="Water Bill" xField="@account" > > yField="waterbillamount" /> > > </mx:series> > > </mx:ColumnChart> > > > > > > Brendan > > > > > > > > On 6/6/07, Jason Ervin <jason_newport@> wrote: > > > > > > Hey everyone I am having issues with using an arraycollection as a > > > dataprovider. I start with an xml variable (see below) then I > convert > > > it to an ArrayCollection using ArrayUtil.toArray and I use the > result > > > as a dataprovider. If I trace the dataprovider it prints out the xml > > > data, but my chart is empty. Can you use ArrayUtil on xml data with > > > this many nodes? I have spent way to much time on this. > > > > > > Here is what I have starting with my XML file. > > > > > > XML CODE START > > > > > > public var billData:XML = > > > <data> > > > <bill account="100-1234567"> > > > <month>May-05</month> > > > <active>true</active> > > > <electricitybillamount>60.00</electricitybillamount> > > > <gasbillamount>45.00</gasbillamount> > > > <waterbillamount>15.00</waterbillamount> > > > <totalbill>120.00</totalbill> > > > <electricityusage>500</electricityusage> > > > <gasusage>71.4</gasusage> > > > <waterusage>200</waterusage> > > > <electricityservicecharge>18.00</electricityservicecharge> > > > <gasservicecharge>9.00</gasservicecharge> > > > <waterservicecharge>2.00</waterservicecharge> > > > <totalserviccharge>29.00</totalserviccharge> > > > <electricitytax>4.00</electricitytax> > > > <gastax>2.00</gastax> > > > <watertax>1.00</watertax> > > > <totaltax>7.00</totaltax> > > > <elecperdaycost>2.00</elecperdaycost> > > > <gasperdaycost>1.00</gasperdaycost> > > > <waterperdaycost>.50</waterperdaycost> > > > <totalperdaycost>3.50</totalperdaycost> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>33</billingdays> > > > <billdate>5/01/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>manual</readtype> > > > <elecmeterreadend>152868</elecmeterreadend> > > > </bill> > > > <bill account="123-2345678"> > > > <month>Apr-05</month> > > > <active>true</active> > > > <electricitybillamount>88.88</electricitybillamount> > > > <gasbillamount>50.00</gasbillamount> > > > <waterbillamount>15.00</waterbillamount> > > > <totalbill>115.00</totalbill> > > > <electricityusage>300</electricityusage> > > > <gasusage>62.9</gasusage> > > > <waterusage>189</waterusage> > > > <electricityservicecharge>15.00</electricityservicecharge> > > > <gasservicecharge>6.00</gasservicecharge> > > > <waterservicecharge>3.00</waterservicecharge> > > > <totalserviccharge>24.00</totalserviccharge> > > > <electricitytax>4.50</electricitytax> > > > <gastax>2.50</gastax> > > > <watertax>1.25</watertax> > > > <totaltax>8.25</totaltax> > > > <elecperdaycost>2.10</elecperdaycost> > > > <gasperdaycost>1.90</gasperdaycost> > > > <waterperdaycost>.50</waterperdaycost> > > > <totalperdaycost>4.50</totalperdaycost> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>28</billingdays> > > > <billdate>3/29/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>amr</readtype> > > > <elecmeterreadend>150008</elecmeterreadend> > > > </bill> > > > <bill account="145-3456789"> > > > <month>Mar-05</month> > > > <active>true</active> > > > <electricitybillamount>62.00</electricitybillamount> > > > <gasbillamount>45.10</gasbillamount> > > > <waterbillamount>10.00</waterbillamount> > > > <totalbill>118.10</totalbill> > > > <electricityusage>300</electricityusage> > > > <gasusage>50.4</gasusage> > > > <waterusage>210</waterusage> > > > <electricityservicecharge>13.00</electricityservicecharge> > > > <gasservicecharge>7.00</gasservicecharge> > > > <waterservicecharge>1.00</waterservicecharge> > > > <totalserviccharge>21.00</totalserviccharge> > > > <electricitytax>5.00</electricitytax> > > > <gastax>2.20</gastax> > > > <watertax>1.10</watertax> > > > <totaltax>8.30</totaltax> > > > <elecperdaycost>2.20</elecperdaycost> > > > <gasperdaycost>1.70</gasperdaycost> > > > <waterperdaycost>.50</waterperdaycost> > > > <totalperdaycost>4.40</totalperdaycost> > > > <email>ccoenraets@ <ccoenraets%40fictitious.com></email> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>30</billingdays> > > > <billdate>3/01/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>manual</readtype> > > > <elecmeterreadend>146968</elecmeterreadend> > > > </bill> > > > </data> > > > /* starting another xml document */ > > > > > > /* public var billData2:XML = > > > <root> > > > <account id="1234567"> > > > <month date="May-05"> > > > <active>true</active> > > > <electricitybillamount>60.00</electricitybillamount> > > > <gasbillamount>45.00</gasbillamount> > > > <waterbillamount>15.00</waterbillamount> > > > <totalbill>120.00</totalbill> > > > <electricityusage>500</electricityusage> > > > <gasusage>71.4</gasusage> > > > <waterusage>200</waterusage> > > > <electricityservicecharge>18.00</electricityservicecharge> > > > <gasservicecharge>9.00</gasservicecharge> > > > <waterservicecharge>2.00</waterservicecharge> > > > <totalserviccharge>29.00</totalserviccharge> > > > <electricitytax>4.00</electricitytax> > > > <gastax>2.00</gastax> > > > <watertax>1.00</watertax> > > > <totaltax>7.00</totaltax> > > > <elecperdaycost>2.00</elecperdaycost> > > > <gasperdaycost>1.00</gasperdaycost> > > > <waterperdaycost>.50</waterperdaycost> > > > <totalperdaycost>3.50</totalperdaycost> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>33</billingdays> > > > <billdate>5/01/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>manual</readtype> > > > <elecmeterreadend>152868</elecmeterreadend> > > > </month> > > > <month date="Apr-05"> > > > <active>true</active> > > > <electricitybillamount>50.44</electricitybillamount> > > > <gasbillamount>23.77</gasbillamount> > > > <waterbillamount>15.12</waterbillamount> > > > <totalbill>115.11</totalbill> > > > <electricityusage>300</electricityusage> > > > <gasusage>62.9</gasusage> > > > <waterusage>189</waterusage> > > > <electricityservicecharge>15.00</electricityservicecharge> > > > <gasservicecharge>6.00</gasservicecharge> > > > <waterservicecharge>3.00</waterservicecharge> > > > <totalserviccharge>24.00</totalserviccharge> > > > <electricitytax>4.50</electricitytax> > > > <gastax>2.50</gastax> > > > <watertax>1.25</watertax> > > > <totaltax>8.25</totaltax> > > > <elecperdaycost>2.10</elecperdaycost> > > > <gasperdaycost>1.90</gasperdaycost> > > > <waterperdaycost>.52</waterperdaycost> > > > <totalperdaycost>4.50</totalperdaycost> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>28</billingdays> > > > <billdate>3/29/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>amr</readtype> > > > <elecmeterreadend>150008</elecmeterreadend> > > > </month> > > > <month date="Mar-05"> > > > <active>true</active> > > > <electricitybillamount>62.00</electricitybillamount> > > > <gasbillamount>45.10</gasbillamount> > > > <waterbillamount>10.00</waterbillamount> > > > <totalbill>118.10</totalbill> > > > <electricityusage>300</electricityusage> > > > <gasusage>50.4</gasusage> > > > <waterusage>210</waterusage> > > > <electricityservicecharge>13.00</electricityservicecharge> > > > <gasservicecharge>7.00</gasservicecharge> > > > <waterservicecharge>1.00</waterservicecharge> > > > <totalserviccharge>21.00</totalserviccharge> > > > <electricitytax>5.00</electricitytax> > > > <gastax>2.20</gastax> > > > <watertax>1.10</watertax> > > > <totaltax>8.30</totaltax> > > > <elecperdaycost>2.20</elecperdaycost> > > > <gasperdaycost>1.70</gasperdaycost> > > > <waterperdaycost>.50</waterperdaycost> > > > <totalperdaycost>4.40</totalperdaycost> > > > <email>ccoenraets@ <ccoenraets%40fictitious.com></email> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>30</billingdays> > > > <billdate>3/01/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>manual</readtype> > > > <elecmeterreadend>146968</elecmeterreadend> > > > </month> > > > </account> > > > <account id="2345678"> > > > <month date="May-05"> > > > <active>true</active> > > > <electricitybillamount>12.34</electricitybillamount> > > > <gasbillamount>45.00</gasbillamount> > > > <waterbillamount>15.00</waterbillamount> > > > <totalbill>120.00</totalbill> > > > <electricityusage>500</electricityusage> > > > <gasusage>71.4</gasusage> > > > <waterusage>200</waterusage> > > > <electricityservicecharge>18.00</electricityservicecharge> > > > <gasservicecharge>9.00</gasservicecharge> > > > <waterservicecharge>2.00</waterservicecharge> > > > <totalserviccharge>29.00</totalserviccharge> > > > <electricitytax>4.00</electricitytax> > > > <gastax>2.00</gastax> > > > <watertax>1.00</watertax> > > > <totaltax>7.00</totaltax> > > > <elecperdaycost>2.00</elecperdaycost> > > > <gasperdaycost>1.00</gasperdaycost> > > > <waterperdaycost>.50</waterperdaycost> > > > <totalperdaycost>3.50</totalperdaycost> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>33</billingdays> > > > <billdate>5/01/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>manual</readtype> > > > <elecmeterreadend>152868</elecmeterreadend> > > > </month> > > > <month date="Apr-05"> > > > <active>true</active> > > > <electricitybillamount>44.44</electricitybillamount> > > > <gasbillamount>23.77</gasbillamount> > > > <waterbillamount>15.12</waterbillamount> > > > <totalbill>115.11</totalbill> > > > <electricityusage>300</electricityusage> > > > <gasusage>62.9</gasusage> > > > <waterusage>189</waterusage> > > > <electricityservicecharge>15.00</electricityservicecharge> > > > <gasservicecharge>6.00</gasservicecharge> > > > <waterservicecharge>3.00</waterservicecharge> > > > <totalserviccharge>24.00</totalserviccharge> > > > <electricitytax>4.50</electricitytax> > > > <gastax>2.50</gastax> > > > <watertax>1.25</watertax> > > > <totaltax>8.25</totaltax> > > > <elecperdaycost>2.10</elecperdaycost> > > > <gasperdaycost>1.90</gasperdaycost> > > > <waterperdaycost>.52</waterperdaycost> > > > <totalperdaycost>4.50</totalperdaycost> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>28</billingdays> > > > <billdate>3/29/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>amr</readtype> > > > <elecmeterreadend>150008</elecmeterreadend> > > > </month> > > > <month date="Mar-05"> > > > <active>true</active> > > > <electricitybillamount>62.00</electricitybillamount> > > > <gasbillamount>45.10</gasbillamount> > > > <waterbillamount>10.00</waterbillamount> > > > <totalbill>118.10</totalbill> > > > <electricityusage>300</electricityusage> > > > <gasusage>50.4</gasusage> > > > <waterusage>210</waterusage> > > > <electricityservicecharge>13.00</electricityservicecharge> > > > <gasservicecharge>7.00</gasservicecharge> > > > <waterservicecharge>1.00</waterservicecharge> > > > <totalserviccharge>21.00</totalserviccharge> > > > <electricitytax>5.00</electricitytax> > > > <gastax>2.20</gastax> > > > <watertax>1.10</watertax> > > > <totaltax>8.30</totaltax> > > > <elecperdaycost>2.20</elecperdaycost> > > > <gasperdaycost>1.70</gasperdaycost> > > > <waterperdaycost>.50</waterperdaycost> > > > <totalperdaycost>4.40</totalperdaycost> > > > <email>ccoenraets@ <ccoenraets%40fictitious.com></email> > > > <pastdueamount>0.00</pastdueamount> > > > <billingdays>30</billingdays> > > > <billdate>3/01/2007</billdate> > > > <budgetbillamount>155.00</budgetbillamount> > > > <readtype>manual</readtype> > > > <elecmeterreadend>146968</elecmeterreadend> > > > </month> > > > </account> > > > </root> */ > > > /* private var billDataXMLList:XMLList = new XMLList(billData); */ > > > public var billXML:XML = new XML(billData); > > > public var billDataAC:XMLListCollection = new > > > XMLListCollection(billData.bill); > > > public var accountDataAC:XMLListCollection = new > > > XMLListCollection([EMAIL PROTECTED]); > > > /* public var billDataLC:XMLListCollection = new > > > XMLListCollection(billData2.account[0].month); */ > > > public var billDataAC2:ArrayCollection = new > > > ArrayCollection(ArrayUtil.toArray(billXML.bill)); > > > > > > HERE IS HOW I AM USING IT > > > > > > <mx:ColumnChart id="mybarchart" dataProvider="{model.billDataAC2}" > > > showDataTips="true" paddingLeft="5" paddingRight="5" > > > width="100%" height="100%" click="traceIT();"> > > > <mx:horizontalAxis> > > > <mx:CategoryAxis categoryField="account"/> > > > </mx:horizontalAxis> > > > <mx:series> > > > <mx:ColumnSeries displayName="Electric Bill" xField="month" > > > yField="electricitybillamount"/> > > > <mx:ColumnSeries displayName="Gas Bill" xField="month" > > > yField="gasbillamount"/> > > > <mx:ColumnSeries displayName="Water Bill" xField="month" > > > yField="waterbillamount"/> > > > </mx:series> > > > </mx:ColumnChart> > > > > > > > > > > > > > > > > > -- > > Brendan Meutzner > > Stretch Media - RIA Adobe Flex Development > > brendan.meutzner@ > > http://www.stretchmedia.ca <http://www.stretchmedia.ca> > > >
