[flexcoders] Re: Parsing a flat file in flex?
I understand what your saying.. but I'm not sure how to do that in
actionscript? anyway you can just show me how you would do this part
turn each line into an object with properites (e.g. col1, col2 or
whatever you like
Thanks in advance
--- In flexcoders@yahoogroups.com, Giles Roadnight [EMAIL PROTECTED]
wrote:
If you turn each line into an object with properites (e.g. col1,
col2 or
whatever you like, somethign more descriptive perhaps) put all
these objects
into an ArrayCollection and use this ArrayCollection as the
dataprovider for
your grid.
In the datagrid use the property names of the object as the
datafield for
each column.
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
Hey Gordon,
Thanks for the reply. I got it to work using split like you said.
I'm now stuck trying to put the data in a datagrid. The data is
now
in an array but I'm not sure how you reference each element for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element with
its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has something to
do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com, Gordon
Smith gosmith@
wrote:
Is this a file on the server whose contents you're getting as
a big
String? If so, you could probably just use the split() method
of
String
to first split on carriage-return or newline, and then split
each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
[mailto:flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be done?
I want to parse or convert a flat file separated by spaces into
xml or
some sort of structure I can then use a dataprovider inside
flex..
The
file looks something like this
Date CoreTechInit ServerInit ImportPackets Merge
12/16/04 0 3 43 47
12/17/04 0 9 43 49
12/18/04 0 9 40 53
12/19/04 0 6 40 46
12/20/04 0 6 40 47
01/03/05 0 3 46 56
01/04/05 0 6 46 46
Thanks
Dylan
--
Giles Roadnight
http://giles.roadnight.name
[flexcoders] Re: Parsing a flat file in flex?
Thanks for the quick reply!
I see what you saying.. thanks for that..
My array is sequential tho.. its not a 2d array so records[i][j]
does not work.. I guess I could try one for loop that assigns each
column for one record and then increments i by 8 or something..
I'm thinking that could be trouble tho.
--- In flexcoders@yahoogroups.com, Giles Roadnight [EMAIL PROTECTED]
wrote:
Something liek this:
var records:Array // I'm assuming an array or arrays from your post
var dataProvider:ArrayCollection = new ArrayCollection();
for (var i:int = 0; i records.length; i++)
{
var currentObject:Object = new Object();
for (var j:int = 0; j records[i].length; i++)
{
currentObject[col + j] = records[i][j];
}
dataProvider.addItem(currentObject);
}
then the grid:
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={dataProvider}
mx:columns
mx:DataGridColumn dataField=col0
headerText=Date textAlign=center /
mx:DataGridColumn dataField=col1
headerText=Date textAlign=center /
ect, I hope that helps
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
I understand what your saying.. but I'm not sure how to do
that in
actionscript? anyway you can just show me how you would do this
part
turn each line into an object with properites (e.g. col1, col2 or
whatever you like
Thanks in advance
--- In flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com, Giles
Roadnight giles@
wrote:
If you turn each line into an object with properites (e.g.
col1,
col2 or
whatever you like, somethign more descriptive perhaps) put all
these objects
into an ArrayCollection and use this ArrayCollection as the
dataprovider for
your grid.
In the datagrid use the property names of the object as the
datafield for
each column.
On 9/20/07, djdyland djdyland@ wrote:
Hey Gordon,
Thanks for the reply. I got it to work using split like you
said.
I'm now stuck trying to put the data in a datagrid. The data
is
now
in an array but I'm not sure how you reference each element
for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element
with
its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has
something to
do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com flexcoders%
40yahoogroups.comflexcoders%
40yahoogroups.com, Gordon
Smith gosmith@
wrote:
Is this a file on the server whose contents you're getting
as
a big
String? If so, you could probably just use the split()
method
of
String
to first split on carriage-return or newline, and then
split
each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com flexcoders%
40yahoogroups.comflexcoders%40yahoogroups.com
[mailto:flexcoders@yahoogroups.com flexcoders%
40yahoogroups.comflexcoders%
40yahoogroups.com] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com flexcoders%
40yahoogroups.comflexcoders%40yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be
done?
I want to parse or convert a flat file separated by spaces
into
xml or
some sort of structure I can then use a dataprovider inside
flex..
The
file looks something like this
Date CoreTechInit ServerInit ImportPackets Merge
Re: [flexcoders] Re: Parsing a flat file in flex?
If you turn each line into an object with properites (e.g. col1, col2 or
whatever you like, somethign more descriptive perhaps) put all these objects
into an ArrayCollection and use this ArrayCollection as the dataprovider for
your grid.
In the datagrid use the property names of the object as the datafield for
each column.
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
Hey Gordon,
Thanks for the reply. I got it to work using split like you said.
I'm now stuck trying to put the data in a datagrid. The data is now
in an array but I'm not sure how you reference each element for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element with its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has something to do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com flexcoders%40yahoogroups.com, Gordon
Smith [EMAIL PROTECTED]
wrote:
Is this a file on the server whose contents you're getting as a big
String? If so, you could probably just use the split() method of
String
to first split on carriage-return or newline, and then split each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
[mailto:flexcoders@yahoogroups.com flexcoders%40yahoogroups.com] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be done?
I want to parse or convert a flat file separated by spaces into
xml or
some sort of structure I can then use a dataprovider inside flex..
The
file looks something like this
Date CoreTechInit ServerInit ImportPackets Merge
12/16/04 0 3 43 47
12/17/04 0 9 43 49
12/18/04 0 9 40 53
12/19/04 0 6 40 46
12/20/04 0 6 40 47
01/03/05 0 3 46 56
01/04/05 0 6 46 46
Thanks
Dylan
--
Giles Roadnight
http://giles.roadnight.name
[flexcoders] Re: Parsing a flat file in flex?
I understand what your saying.. but I'm not sure how to do that in
actionscript? anyway you can just show me how you would do this part
turn each line into an object with properites (e.g. col1, col2 or
whatever you like
Thanks in advance
--- In flexcoders@yahoogroups.com, Giles Roadnight [EMAIL PROTECTED]
wrote:
If you turn each line into an object with properites (e.g. col1,
col2 or
whatever you like, somethign more descriptive perhaps) put all
these objects
into an ArrayCollection and use this ArrayCollection as the
dataprovider for
your grid.
In the datagrid use the property names of the object as the
datafield for
each column.
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
Hey Gordon,
Thanks for the reply. I got it to work using split like you said.
I'm now stuck trying to put the data in a datagrid. The data is
now
in an array but I'm not sure how you reference each element for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element with
its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has something to
do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com, Gordon
Smith gosmith@
wrote:
Is this a file on the server whose contents you're getting as
a big
String? If so, you could probably just use the split() method
of
String
to first split on carriage-return or newline, and then split
each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
[mailto:flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be done?
I want to parse or convert a flat file separated by spaces into
xml or
some sort of structure I can then use a dataprovider inside
flex..
The
file looks something like this
Date CoreTechInit ServerInit ImportPackets Merge
12/16/04 0 3 43 47
12/17/04 0 9 43 49
12/18/04 0 9 40 53
12/19/04 0 6 40 46
12/20/04 0 6 40 47
01/03/05 0 3 46 56
01/04/05 0 6 46 46
Thanks
Dylan
--
Giles Roadnight
http://giles.roadnight.name
Re: [flexcoders] Re: Parsing a flat file in flex?
Something liek this:
var records:Array // I'm assuming an array or arrays from your post
var dataProvider:ArrayCollection = new ArrayCollection();
for (var i:int = 0; i records.length; i++)
{
var currentObject:Object = new Object();
for (var j:int = 0; j records[i].length; i++)
{
currentObject[col + j] = records[i][j];
}
dataProvider.addItem(currentObject);
}
then the grid:
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={dataProvider}
mx:columns
mx:DataGridColumn dataField=col0
headerText=Date textAlign=center /
mx:DataGridColumn dataField=col1
headerText=Date textAlign=center /
ect, I hope that helps
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
I understand what your saying.. but I'm not sure how to do that in
actionscript? anyway you can just show me how you would do this part
turn each line into an object with properites (e.g. col1, col2 or
whatever you like
Thanks in advance
--- In flexcoders@yahoogroups.com flexcoders%40yahoogroups.com, Giles
Roadnight [EMAIL PROTECTED]
wrote:
If you turn each line into an object with properites (e.g. col1,
col2 or
whatever you like, somethign more descriptive perhaps) put all
these objects
into an ArrayCollection and use this ArrayCollection as the
dataprovider for
your grid.
In the datagrid use the property names of the object as the
datafield for
each column.
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
Hey Gordon,
Thanks for the reply. I got it to work using split like you said.
I'm now stuck trying to put the data in a datagrid. The data is
now
in an array but I'm not sure how you reference each element for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element with
its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has something to
do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com
flexcoders%40yahoogroups.comflexcoders%
40yahoogroups.com, Gordon
Smith gosmith@
wrote:
Is this a file on the server whose contents you're getting as
a big
String? If so, you could probably just use the split() method
of
String
to first split on carriage-return or newline, and then split
each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com
flexcoders%40yahoogroups.comflexcoders%40yahoogroups.com
[mailto:flexcoders@yahoogroups.com
flexcoders%40yahoogroups.comflexcoders%
40yahoogroups.com] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com
flexcoders%40yahoogroups.comflexcoders%40yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be done?
I want to parse or convert a flat file separated by spaces into
xml or
some sort of structure I can then use a dataprovider inside
flex..
The
file looks something like this
Date CoreTechInit ServerInit ImportPackets Merge
12/16/04 0 3 43 47
12/17/04 0 9 43 49
12/18/04 0 9 40 53
12/19/04 0 6 40 46
12/20/04 0 6 40 47
01/03/05 0 3 46 56
01/04/05 0 6 46 46
Thanks
Dylan
--
Giles Roadnight
http://giles.roadnight.name
--
Giles Roadnight
http://giles.roadnight.name
[flexcoders] Re: Parsing a flat file in flex?
Hey Gordon,
Thanks for the reply. I got it to work using split like you said.
I'm now stuck trying to put the data in a datagrid. The data is now
in an array but I'm not sure how you reference each element for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element with its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has something to do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com, Gordon Smith [EMAIL PROTECTED]
wrote:
Is this a file on the server whose contents you're getting as a big
String? If so, you could probably just use the split() method of
String
to first split on carriage-return or newline, and then split each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com
[mailto:[EMAIL PROTECTED] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be done?
I want to parse or convert a flat file separated by spaces into
xml or
some sort of structure I can then use a dataprovider inside flex..
The
file looks something like this
Date CoreTechInit ServerInit ImportPackets Merge
12/16/04 0 3 43 47
12/17/04 0 9 43 49
12/18/04 0 9 40 53
12/19/04 0 6 40 46
12/20/04 0 6 40 47
01/03/05 0 3 46 56
01/04/05 0 6 46 46
Thanks
Dylan
[flexcoders] Re: Parsing a flat file in flex?
Hey Gordon,
Thanks for the reply. I got it to work using split like you said.
I'm now stuck trying to put the data in a datagrid. The data is now
in an array but I'm not sure how you reference each element for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element with its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has something to do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com, Gordon Smith [EMAIL PROTECTED]
wrote:
Is this a file on the server whose contents you're getting as a big
String? If so, you could probably just use the split() method of
String
to first split on carriage-return or newline, and then split each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com
[mailto:[EMAIL PROTECTED] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be done?
I want to parse or convert a flat file separated by spaces into
xml or
some sort of structure I can then use a dataprovider inside flex..
The
file looks something like this
Date CoreTechInit ServerInit ImportPackets Merge
12/16/04 0 3 43 47
12/17/04 0 9 43 49
12/18/04 0 9 40 53
12/19/04 0 6 40 46
12/20/04 0 6 40 47
01/03/05 0 3 46 56
01/04/05 0 6 46 46
Thanks
Dylan
[flexcoders] Re: Parsing a flat file in flex?
Thanks for everyones help.. I got it to work
Solution
//Split at newline at the end of each record
results2 = new ArrayCollection(loader.data.split(\n));
//Start at newest records
for(i = results2.length; i (results2.length - 200); i--){
//for each record line split string at spaces
var splitString:Array = results2[i-2].toString().split( );
var results:ArrayCollection = new ArrayCollection();
var currentObject:Object = new Object();
//Remove and extra whitespace elements
for(j = 0; j splitString.length; j++){
if(splitString[j].toString() != ){
results.addItem(splitString[j]);
}
}
//Add each element of a record to an Associative Object
for(j = 0; j results.length; j++){
currentObject[col + j] = results[j];
}
//Add Item to data provider
dataProvider.addItem(currentObject);
}
--- In flexcoders@yahoogroups.com, Giles Roadnight [EMAIL PROTECTED]
wrote:
Something liek this:
var records:Array // I'm assuming an array or arrays from your post
var dataProvider:ArrayCollection = new ArrayCollection();
for (var i:int = 0; i records.length; i++)
{
var currentObject:Object = new Object();
for (var j:int = 0; j records[i].length; i++)
{
currentObject[col + j] = records[i][j];
}
dataProvider.addItem(currentObject);
}
then the grid:
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={dataProvider}
mx:columns
mx:DataGridColumn dataField=col0
headerText=Date textAlign=center /
mx:DataGridColumn dataField=col1
headerText=Date textAlign=center /
ect, I hope that helps
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
I understand what your saying.. but I'm not sure how to do
that in
actionscript? anyway you can just show me how you would do this
part
turn each line into an object with properites (e.g. col1, col2 or
whatever you like
Thanks in advance
--- In flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com, Giles
Roadnight giles@
wrote:
If you turn each line into an object with properites (e.g.
col1,
col2 or
whatever you like, somethign more descriptive perhaps) put all
these objects
into an ArrayCollection and use this ArrayCollection as the
dataprovider for
your grid.
In the datagrid use the property names of the object as the
datafield for
each column.
On 9/20/07, djdyland djdyland@ wrote:
Hey Gordon,
Thanks for the reply. I got it to work using split like you
said.
I'm now stuck trying to put the data in a datagrid. The data
is
now
in an array but I'm not sure how you reference each element
for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element
with
its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has
something to
do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com flexcoders%
40yahoogroups.comflexcoders%
40yahoogroups.com, Gordon
Smith gosmith@
wrote:
Is this a file on the server whose contents you're getting
as
a big
String? If so, you could probably just use the split()
method
of
String
to first split on carriage-return or newline, and then
split
each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com flexcoders%
40yahoogroups.comflexcoders%40yahoogroups.com
Re: [flexcoders] Re: Parsing a flat file in flex?
My guess is that the OP will have the records inside a single string and so
will need to iterate through the string picking out the individual fields from
the spaces between them.
Paul
- Original Message -
From: Giles Roadnight
To: flexcoders@yahoogroups.com
Sent: Thursday, September 20, 2007 2:48 PM
Subject: Re: [flexcoders] Re: Parsing a flat file in flex?
Something liek this:
var records:Array // I'm assuming an array or arrays from your post
var dataProvider:ArrayCollection = new ArrayCollection();
for (var i:int = 0; i records.length; i++)
{
var currentObject:Object = new Object();
for (var j:int = 0; j records[i].length; i++)
{
currentObject[col + j] = records[i][j];
}
dataProvider.addItem(currentObject);
}
then the grid:
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={dataProvider}
mx:columns
mx:DataGridColumn dataField=col0
headerText=Date textAlign=center /
mx:DataGridColumn dataField=col1
headerText=Date textAlign=center /
ect, I hope that helps
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
I understand what your saying.. but I'm not sure how to do that in
actionscript? anyway you can just show me how you would do this part
turn each line into an object with properites (e.g. col1, col2 or
whatever you like
Thanks in advance
--- In flexcoders@yahoogroups.com, Giles Roadnight [EMAIL PROTECTED]
wrote:
If you turn each line into an object with properites (e.g. col1,
col2 or
whatever you like, somethign more descriptive perhaps) put all
these objects
into an ArrayCollection and use this ArrayCollection as the
dataprovider for
your grid.
In the datagrid use the property names of the object as the
datafield for
each column.
On 9/20/07, djdyland [EMAIL PROTECTED] wrote:
Hey Gordon,
Thanks for the reply. I got it to work using split like you said.
I'm now stuck trying to put the data in a datagrid. The data is
now
in an array but I'm not sure how you reference each element for a
column in the data provider or the data grid.
The data looks something like this
(Record 1)
09/17/07 element 0
245 element 1
37 etc
36
44
194
100
2
45
4
462
63906
(record 2)
09/18/07
263
41
34
43
197
95
1
45
3
459
63906
And my datagrid would be
mx:DataGrid id=dg width=100%
height=100% rowCount=5 dataProvider={array}
mx:columns
mx:DataGridColumn
headerText=Date textAlign=center /
mx:DataGridColumn
headerText=CoreTechInit textAlign=center/
mx:DataGridColumn
headerText=ServerInit textAlign=center/
mx:DataGridColumn
headerText=ImportPackets textAlign=center/
mx:DataGridColumn
headerText=Merge textAlign=center/
mx:DataGridColumn
headerText=Layout textAlign=center/
mx:DataGridColumn
headerText=Render textAlign=center/
mx:DataGridColumn
headerText=CalcTime textAlign=center/
mx:DataGridColumn
headerText=RenderOverhead textAlign=center/
mx:DataGridColumn
headerText=AppOverhead textAlign=center/
mx:DataGridColumn
headerText=Total textAlign=center/
mx:DataGridColumn
headerText=FileSize textAlign=center/
/mx:columns
/mx:DataGrid
So my question now is How do I associate each array element with
its
proper place holder in the datagrid?? Do I have to create and
associative array or something? I'm assuming it has something to
do
with the datafield of each column?
Any help is greaty appreciated
Thanks
Dylan
--- In flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com, Gordon
Smith gosmith@
wrote:
Is this a file on the server whose contents you're getting as
a big
String? If so, you could probably just use the split() method
of
String
to first split on carriage-return or newline, and then split
each
line
on whitespace.
- Gordon
From: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
[mailto:flexcoders@yahoogroups.com flexcoders%
40yahoogroups.com] On
Behalf Of djdyland
Sent: Wednesday, September 19, 2007 10:36 AM
To: flexcoders@yahoogroups.com flexcoders%40yahoogroups.com
Subject: [flexcoders] Parsing a flat file in flex?
Can anyone point me in the direction of how this might be done?
I want to parse or convert a flat file separated by spaces into
xml or
some sort of structure
