I don't think ArrayUtil is as smart as you wish it was. You may have to write your own conversion.
________________________________ From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jason Ervin Sent: Wednesday, June 06, 2007 6:50 PM To: flexcoders@yahoogroups.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 flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> , "Brendan Meutzner" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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>[EMAIL PROTECTED] <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>[EMAIL PROTECTED] <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>[EMAIL PROTECTED] <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 > [EMAIL PROTECTED] > http://www.stretchmedia.ca <http://www.stretchmedia.ca> >
