Hi, thanks to you both.

I read of making a horizontal scroll dataGrid, we will need vertical also, is this possible ?

As for our gappy apostrophe settlement names visible for the end user, with flash requiring gapless and apostrophe less, where can this be best dealt with and how ? If AS3 is there a simple code to do this and where in all this would that sit ?

If anyone has an example of how excel has been fed into a datagrid it would be useful to see.

Envirographics

Hi,

Many thanks for that coding, trying it out on gapless content initially to see that the csv data feed works...

Why this error ?

I have the code in a new Flash.fla AS3 file , file new AS3 ok then drag dropped a datagrid to stage and saved file as SimpleDataGrid_UseCSV_test.fla  and created a most simple test excel file saved as simple.csv both sitting in the same folder.

Excel is three columns called col1  col2  col3 and two rows with fictional two character no gap entries per cell. A2  B2  C2   A3  B3  C3 and so on !

Error #2044: Unhandled ioError:. text=Error #2032: Stream Error. URL: file:///C|/DOCUME%7E1/Envirographics/LOCALS%7E1/Temp/Simple.csv

                at Untitled_fla::MainTimeline/frame1()[Untitled_fla.MainTimeline::frame1 :7]

Thinking it may be lack of an instance name, I then name the datagrid instance in properties as DataGrid and test movie, address error now vanishes and instead the data grid is in bits which are flashing on and off.

Why ?

import flash.net.URLLoader;

import flash.events.Event;

import flash.net.URLRequest;

import fl.data.DataProvider;

import fl.controls.DataGrid;

var urlLoader:URLLoader = new URLLoader();

1. urlLoader.addEventListener(Event.COMPLETE,completeF);
2. urlLoader.load(new URLRequest("Simple.csv"));

var dg:DataGrid

function completeF(e:Event):void{

    var dataS:String = e.target.data;

    var dataA:Array = dataS.split("\n").join("").split("\r");

    var dpA:Array = [];

    var itemA:Array;

    for(var i:int=0;i<dataA.length;i++){

        itemA = dataA[i].split(",");

        dpA.push({"col1":itemA[0],"col2":itemA[1],"col3":itemA[2]});

    }

    var dp:DataProvider = new DataProvider(dpA);

    dg.columns = ["col1","col2","col3"]

    dg.dataProvider = dp;

}

Envirographics.

Hi,

I do have in a folder both the fla and the csv file, csv name is Simple.csv

address is P:\C\Envirographics\Flash Projects\test simple csv datagrid

I have also now saved the fla to a new folder, then re created the csv from the xls excel file and put the csv into that new folder.

Still I get the same problem.

Compiler errors has:-

Scene 1, Layer 'Layer 1', Frame 1, Line 10 1046: Type was not found or was not a compile-time constant: DataGrid.

line 10 is       var dg:DataGrid

Its in the library as DataGrid and its instance name is DataGrid

So lets start over !

File new AS3 ok

name layer1 as AS3 (layer name shouldnt make a difference but I'll do so.

select frame 1, drag drop DataGrid to stage and name it DataGrid in properties instance name.

look in lib , its there, ctrl x it off stage and drag drop from lib back to stage anyway.

Select frame 1 and hit F9, Make sure Scene 1 AS3:frame 1 selected, Paste code in.

Save fla to new folder. Create a new csv from the xls to that same folder.

test movie.

Now the datagrid is not in bits, but Compile error has 4 lines of errors.

Lets try again, same procedure and test movie, again datagrid stable but this time output error has :-

Error #2044: Unhandled ioError:. text=Error #2032: Stream Error. URL: file:///P|/C/Envirographics%20DATA/Flash%20Projects/5th%20test%20simpl e%20csv%20datagrid/Simple.csv

at SimpleDataGrid_UseCSV_freshStarttest5_fla::MainTimeline/frame1()

Thats different from just now, looking back in on that one it also now instead has output error reading this and complier error is now empty !

Envirographics

Hi,

but thats already there, 5th line down

Envirographics

Code is:-

import flash.net.URLLoader;

import flash.events.Event;

import flash.net.URLRequest;

import fl.data.DataProvider;

import fl.controls.DataGrid;

var urlLoader:URLLoader = new URLLoader();

urlLoader.addEventListener(Event.COMPLETE,completeF);

urlLoader.load(new URLRequest("Simple.csv"));

var dg:DataGrid

function completeF(e:Event):void{

    var dataS:String = e.target.data;

    var dataA:Array = dataS.split("\n").join("").split("\r");

    var dpA:Array = [];

    var itemA:Array;

    for(var i:int=0;i<dataA.length;i++){

        itemA = dataA[i].split(",");

        dpA.push({"col1":itemA[0],"col2":itemA[1],"col3":itemA[2]});

    }

    var dp:DataProvider = new DataProvider(dpA);

    dg.columns = ["col1","col2","col3"]

    dg.dataProvider = dp;

}

and there is a DataGrid in the lib and it exists on stage. It has no instance name in properties.

test movie and I get in Output tab :-

TypeError: Error #1009: Cannot access a property or method of a null object reference.

at SimpleDataGrid_UseCSV_test4_fla::MainTimeline/completeF()

at flash.events::EventDispatcher/dispatchEventFunction()

at flash.events::EventDispatcher/dispatchEvent()

at flash.net::URLLoader/onComplete()

If I then name it in properties instance as DataGrid and test movie, I instead get:-

data grid as bits flashing and

Scene 1, Layer 'AS3', Frame 1, Line 10 1046: Type was not found or was not a compile-time constant: DataGrid.

Envirographics

The fact that I had tried both DataGrid and dg in instance name and failed seems odd, as dg now works.  The code could do with some extra 'you need to also ensure' notes.

Success !  Thanks.

we have seen a 1046 error,   a 2044 error and a 1009 error and thats with all elements being in place, the only thing not right was the instance name. One instance name throwing out red herrings.

It is so odd there is nothing on the www on csv into DataGrid.

Now to try the coding for blank cells and gappy entries.

Envirographics

One hurdle over, another one faced. This code you supplied was to remove gaps and populate a dataGrid from an excel table saved as csv. It works without gaps so far. Adding another row of data to excel and saving as csv sees flash fail to show additions, even altering cell data. Then I experienced movie failure in another test.

update to findings...if I close down Flash and relaunch it then run the fla again, it then works.

FURTHER UPDATE...no it doesnt on the next file I try, unable to get Flash test movie to show anything but the swf it creates when I run that from windows explorer DOES show the changes.

so why does an update to the csv file with flash running cause test movie to fail ?

To see just what was happening.....

csv file changes make or break Flash. why ? (using option in excel called comma delimited, not macintosh csv )

If I open the excel file from which Simple.csv was made and remake the csv without altering any data the Flash movie then fails, if I reinstate the original Simple.csv it works again.

Prior to this discovery on the original code taken from your posting, on a different test yesterday I had firstly renamed the dataGrid on stage in instance as MyDataGrid and then also right clicked on it in lib and went properties and named it there as MyDataGrid.

On the latter I did get a warning 'this symbol wont support frame scripts' and clicked Ok.

File still worked.

Code is:-

import flash.net.URLLoader;

import flash.events.Event;

import flash.net.URLRequest;

import fl.data.DataProvider;

import fl.controls.DataGrid;

var urlLoader:URLLoader = new URLLoader();

urlLoader.addEventListener(Event.COMPLETE,completeF);

urlLoader.load(new URLRequest("Simple.csv"));

var MyDataGrid:DataGrid

function completeF(e:Event):void{

    var dataS:String = e.target.data;

    var dataA:Array = dataS.split("\n").join("").split("\r");

    var dpA:Array = [];

    var itemA:Array;

    for(var i:int=0;i<dataA.length;i++){

        itemA = dataA[i].split(",");

        dpA.push({"col1":itemA[0],"col2":itemA[1],"col3":itemA[2]});

    }

    var dp:DataProvider = new DataProvider(dpA);

    MyDataGrid.columns = ["col1","col2","col3"]

    MyDataGrid.dataProvider = dp;

}

Saved it by a new name to a new folder.   6th test_DataGrid_csvWithGaps

Now to test this degapping code. I then added to the names of the first row of excell cells so they read A1 a    B1 b   C1 c and save file as SimpleWithGaps.xlsx saving to that new folder and then did a save as SimpleWithGaps.csv and save also to the same folder.

I altered the csv name in the code to SimpleWithGaps.csv

test movie

it failed

Error #2044: Unhandled ioError:. text=Error #2032: Stream Error. URL: #file:///P|/C/Envirographicsfile:///P|/C/Envirographics%20DATA/Flash%20Projects/6th%20test%5FDataG rid%5FcsvWithGaps/SimpleWithGaps.csv%20DATA/Flash%20Projects/6th%20test%5FDataGrid%5FcsvWithGaps/SimpleWit hGaps.csv

at SimpleDataGrid_UseCSV_freshStarttest6gaps_fla::MainTimeline/frame1()

Try it out on the dg code pasting across to that folder the csv file and it worked. Try again on the 6th test folder altering lib property back to DataGrid and it worked, altered that to MyDataGrid and Ok the frame scripts warning and it still workd ! why did it fail ? this is so weird. 

Code and csv seems very easily upset or is it just my luck !

Envirographics