topic Re: Map XY data from Excel into Flex in ArcGIS API for Flex Questions

Map XY data from Excel into Flex

ShwetaMorkhandikar — Tue, 29 May 2012 03:58:25 GMT

I have the excel file with X Y location, i need to map these dynamically onto Flex API. I am using Flex API 2.5

Re: Map XY data from Excel into Flex

AnthonyGiles — Tue, 29 May 2012 05:12:09 GMT

Shweta,

There is an example here but it will require you doing soming coding:

http://www.arcgis.com/home/item.html?id=173870a7926c4ef9b2a5121be0b46211

regards

Anthony

Re: Map XY data from Excel into Flex

ShwetaMorkhandikar — Tue, 29 May 2012 22:31:34 GMT

Thanks Anthony, I am not a full fledged programmer/developer. So was looking for a compiled version, if possible.

Re: Map XY data from Excel into Flex

AnthonyGiles — Wed, 30 May 2012 06:08:44 GMT

Shweta,

Sorry I haven't implemented a solution to this problem to date but it is something that I want to do soon. I will post up the solution once I have done the work unless there is someone else out there that has already done this and doesn't mind sharing their compilied/uncompilied code (Zahid if you are reading this!!!).

Regards

Anthony

Re: Map XY data from Excel into Flex

YungKaiChin — Fri, 01 Jun 2012 15:41:24 GMT

I don't know if it will be easier, but you can convert the xls file to cvs, txt, or even xml file.
Then, load it, parse it, and last, loop through them to create point graphics or mappoints.

Re: Map XY data from Excel into Flex

AnthonyGiles — Fri, 01 Jun 2012 17:11:29 GMT

ShwetaM,

Just to keep you up to date, I have just about finished creating a widget that allows you to upload data from an excel spreadsheet. I just need to test it a bit more. Unfortunately I am away from work next week so I will not be able to complete till the week begining the 11th June, hope this is ok.

Regards

Anthony

Re: Map XY data from Excel into Flex

ShwetaMorkhandikar — Sun, 03 Jun 2012 21:35:05 GMT

That should be fine, Anthony. Looking forward for the widget. Thanks so much.

Re: Map XY data from Excel into Flex

parvazparvaz — Mon, 04 Jun 2012 14:07:50 GMT

Hi
I,m looking for this widget. can u help me? my email:anjelinapon@gmail.com
Regards
A.ponker

Re: Map XY data from Excel into Flex

ZahidChaudhry — Fri, 08 Jun 2012 21:42:47 GMT

Shweta,

Sorry I haven't implemented a solution to this problem to date but it is something that I want to do soon. I will post up the solution once I have done the work unless there is someone else out there that has already done this and doesn't mind sharing their compilied/uncompilied code (Zahid if you are reading this!!!).

Regards

Anthony

Anthony,

Let me know if you still needs code for mapping data from XLS. I have a widget working that allow you to upload xls/gpx files and display data on map...
thanks

Re: Map XY data from Excel into Flex

ShwetaMorkhandikar — Tue, 12 Jun 2012 03:51:14 GMT

ShwetaM,

Just to keep you up to date, I have just about finished creating a widget that allows you to upload data from an excel spreadsheet. I just need to test it a bit more. Unfortunately I am away from work next week so I will not be able to complete till the week begining the 11th June, hope this is ok.

Regards

Anthony

Anthony,
How's the testing going on?

Re: Map XY data from Excel into Flex

AnthonyGiles — Tue, 12 Jun 2012 05:10:06 GMT

ShwetaM

Attached is a zip file containing both the compiled and uncompiled code. All you should need is an excel file that has a minimum of two columns one holding your x coords and the other your y coords (in the same spatial reference as your base map). All other columns will come across as attributes. In the config xml specify the column names used for your coords and a title field if required.

Place the images under assets in your assets/images folder.

Regards

Anthony

Re: Map XY data from Excel into Flex

ShwetaMorkhandikar — Tue, 12 Jun 2012 05:22:19 GMT

ShwetaM

Attached is a zip file containing both the compiled and uncompiled code. All you should need is an excel file that has a minimum of two columns one holding your x coords and the other your y coords (in the same spatial reference as your base map). All other columns will come across as attributes. In the config xml specify the column names used for your coords and a title field if required.

Place the images under assets in your assets/images folder.

Regards

Anthony

Thank you so much Anthony.

Re: Map XY data from Excel into Flex

AnthonyGiles — Tue, 12 Jun 2012 16:17:21 GMT

ShewtaM,

Please don't forget to click the Mark as answer check on this post and to click the top arrow (promote).
Follow the steps as shown in the below graphic:

[ATTACH=CONFIG]15136[/ATTACH]

Regards

Anthony

Re: Map XY data from Excel into Flex

ShwetaMorkhandikar — Tue, 12 Jun 2012 23:14:27 GMT

I tried using this in my Flex viewer and it's works wonderfully.

Re: Map XY data from Excel into Flex

AnthonyGiles — Wed, 13 Jun 2012 18:46:13 GMT

Shweta,

Please don't forget to also mark the thread as answered (the tick on the thread with the answer)

Regards

Anthony

Re: Map XY data from Excel into Flex

parvazparvaz — Sun, 17 Jun 2012 14:04:51 GMT

Hi
Any solution for changing Excell coordinate to web map application projection system? for example my map has 102100 WKID but my coordinate has 3546 WKID. in your widget I should change my excell coordinate to my web, that this is not user friendly.
Regards
A.ponker

Re: Map XY data from Excel into Flex

AnthonyGiles — Mon, 18 Jun 2012 16:55:05 GMT

Parvaz,

Sorry but I have no intention of writing the code to perform any projection of the coordinates. I have supplied the source code if you want to develop the widget further but at the moment it meets my needs and I do not have the time to spend developing it.

If you do not have the ability to write flex code you could always look at doing the conversion in excel have a look at something like this http://www.dartmouth.edu/~renshaw/geogtools/ or the attached .xls file

Regards

Anthony

Re: Map XY data from Excel into Flex

PascalDionne — Thu, 05 Jul 2012 16:51:59 GMT

Hi Parvaz,
I developped a widget that is doing what you want. It reads a CSV file that contains two columns with coordinates x and y. It can be in any coordinate system. The coordinate system is identified by the user through a combox box before the file is read and parsed. The parsing result is push into an array and for every record a MapPoint is created and projected on the map. Here are some code elements:

var outSR:SpatialReference = new SpatialReference(wkid.selectedItem.data);
for (var i:int = 0; i < donnees.length; i++)
{
var X:Number = donnees[abs];
var Y:Number = donnees[ord];
var point:MapPoint = new MapPoint(X, Y, outSR);
geometryService.project([point as Geometry], new SpatialReference(32198));
}
private function handlerProjectComplete(e:GeometryServiceEvent):void
{
if (incremente < donnees.length)
{
var pt:MapPoint = (e.result as Array)[0] as MapPoint;
var myGraphic : Graphic = new Graphic();
myGraphic.geometry = pt;
myGraphic.symbol = graphicPointSym;
myGraphic.addEventListener(MouseEvent.MOUSE_OVER, handlerMouseRollOver);
graphicsLayer.add(myGraphic);
donnees[incremente].push(myGraphic);       points.push(myGraphic);
incremente++;
}

The comboxBox dataProvider comes from this list that link the wkid number to project in the map's projection:
   private const projectionList:ArrayCollection = new ArrayCollection(
    [
     { data: 4326, label: "Géographique WGS84" },
     { data: 4269, label: "Géographique NAD83" },
     { data: 102113, label: "Web_Mercator WGS84 (Google)" }, /* Use 102100 instead */
     { data: 26917, label:"UTM fuseau 17N NAD_1983" },
     { data: 26918, label:"UTM fuseau 18N NAD_1983" },
     { data: 26919, label:"UTM fuseau 19N NAD_1983" },
     { data: 26920, label:"UTM fuseau 20N NAD_1983" },
     { data: 26921, label:"UTM fuseau 21N NAD_1983" },
     { data: 32183, label:"MTM fuseau 3 NAD_1983" },
     { data: 32184, label:"MTM fuseau 4 NAD_1983" },
     { data: 32185, label:"MTM fuseau 5 NAD_1983" },
     { data: 32186, label:"MTM fuseau 6 NAD_1983" },
     { data: 32187, label:"MTM fuseau 7 NAD_1983" },
     { data: 32188, label:"MTM fuseau 8 NAD_1983" },
     { data: 32189, label:"MTM fuseau 9 NAD_1983" },
     { data: 32190, label:"MTM fuseau 10 NAD_1983" },
     { data: 32198, label: "Lambert conique conforme - Québec" }
    ]);

Hope that helped.

pdio

Re: Map XY data from Excel into Flex

anjelinaponker — Fri, 20 Jul 2012 15:40:57 GMT

Hi
How can I use this code?
Regards
Anjelina

Re: Map XY data from Excel into Flex

anjelinaponker — Thu, 26 Jul 2012 22:31:16 GMT

Hi Parvaz,
I developped a widget that is doing what you want. It reads a CSV file that contains two columns with coordinates x and y. It can be in any coordinate system. The coordinate system is identified by the user through a combox box before the file is read and parsed. The parsing result is push into an array and for every record a MapPoint is created and projected on the map. Here are some code elements:

var outSR:SpatialReference = new SpatialReference(wkid.selectedItem.data);
for (var i:int = 0; i < donnees.length; i++)
{
var X:Number = donnees[abs];
var Y:Number = donnees[ord];
var point:MapPoint = new MapPoint(X, Y, outSR);
geometryService.project([point as Geometry], new SpatialReference(32198));
}
private function handlerProjectComplete(e:GeometryServiceEvent):void
{
if (incremente < donnees.length)
{
var pt:MapPoint = (e.result as Array)[0] as MapPoint;
var myGraphic : Graphic = new Graphic();
myGraphic.geometry = pt;
myGraphic.symbol = graphicPointSym;
myGraphic.addEventListener(MouseEvent.MOUSE_OVER, handlerMouseRollOver);
graphicsLayer.add(myGraphic);
donnees[incremente].push(myGraphic);       points.push(myGraphic);
incremente++;
}

The comboxBox dataProvider comes from this list that link the wkid number to project in the map's projection:
   private const projectionList:ArrayCollection = new ArrayCollection(
    [
     { data: 4326, label: "Géographique WGS84" },
     { data: 4269, label: "Géographique NAD83" },
     { data: 102113, label: "Web_Mercator WGS84 (Google)" }, /* Use 102100 instead */
     { data: 26917, label:"UTM fuseau 17N NAD_1983" },
     { data: 26918, label:"UTM fuseau 18N NAD_1983" },
     { data: 26919, label:"UTM fuseau 19N NAD_1983" },
     { data: 26920, label:"UTM fuseau 20N NAD_1983" },
     { data: 26921, label:"UTM fuseau 21N NAD_1983" },
     { data: 32183, label:"MTM fuseau 3 NAD_1983" },
     { data: 32184, label:"MTM fuseau 4 NAD_1983" },
     { data: 32185, label:"MTM fuseau 5 NAD_1983" },
     { data: 32186, label:"MTM fuseau 6 NAD_1983" },
     { data: 32187, label:"MTM fuseau 7 NAD_1983" },
     { data: 32188, label:"MTM fuseau 8 NAD_1983" },
     { data: 32189, label:"MTM fuseau 9 NAD_1983" },
     { data: 32190, label:"MTM fuseau 10 NAD_1983" },
     { data: 32198, label: "Lambert conique conforme - Québec" }
    ]);

Hope that helped.

pdio

Hi
How can I use this code? can you send your Widget source code?
Regards
Anjelina