Flex View Import Excel File with Coordinates

[PiotrWojciechowski]

I downloaded the Flex Viewer onto my server, installed, and it runs great.  Now, is it possible to link it to an excel file that has Long/Lat Coordinates?  I want to display, say 10 points on the Flex map from this Excel file.  I want to be able to hover over the displayed points so that it shows the other information in the row of the excel file. 

This seems simple enough, and I already did it in ArcGIS 9.3 but would now like to deploy it company wide.

Does anyone have any tips or suggestions?  Thank You all in advance for your help!

Mike G
Bronx, NY

[SimonMorgan]

I downloaded the Flex Viewer onto my server, installed, and it runs great.  Now, is it possible to link it to an excel file that has Long/Lat Coordinates?  I want to display, say 10 points on the Flex map from this Excel file.  I want to be able to hover over the displayed points so that it shows the other information in the row of the excel file. 

This seems simple enough, and I already did it in ArcGIS 9.3 but would now like to deploy it company wide.

Does anyone have any tips or suggestions?  Thank You all in advance for your help!

Mike G
Bronx, NY

Try adding the excel file to ArcMap, then add it as an event layer (File-->Add Data-->Add XY Data). Then publish the MXD and add it as a layer to your viewer.

[PiotrWojciechowski]

Thanks Simon!  I'm at the last step though...how do I add my MXD as a layer in Flex?  It seems to only want XML or SWF files....

Thanks again for your help.

Mike

[MikeHargreaves]

Are you publishing any of your own services, or are you just using the online services that come with the Flexviewer?  If you do not have ArcGIS Server, then you can not do this...

[PiotrWojciechowski]

Are you publishing any of your own services, or are you just using the online services that come with the Flexviewer?  If you do not have ArcGIS Server, then you can not do this...

Yes, I have ArcGIS Server installed on the same server I installed Flex on.  So I have an excel file with Long/Lat and other data and I want to simply plot it.  I got it to work how I like in ArcGIS 9.3 but now just want to show it on this nice map that I can deploy on our Intranet.  (Show active gas leaks in NYC)

Thanks!

[MikeHargreaves]

So, once you have an mxd, and you publish it as a map service, then you go into the flexviewer folder and open config.xml and add your service in the operationallayers section.

 <operationallayers>
   <layer label="Parcels" type="dynamic" visible="true"
                url="http://agsmaps.ci.santa-rosa.ca.us//ArcGIS/rest/services/Parcels/MapServer"/>

You will find the url for your service by looking in http://servername//ArcGIS/rest/services and then clicking on the particular service you want to add and copying the url from your browser.  This will work for internal users.  For the public, you will want to create a virtual directory or something similar that lets them thru your firewall.  Feel free to give me a call if you want: 707-543-3112

[MikeHargreaves]

Mike,

Also, unlike some other areas, ESRI has actually done a fairly good job with their documentation for Flexviewer:  http://help.arcgis.com/en/webapps/flexviewer/help/index.html

[ZahidChaudhry]

Mike,

Also, unlike some other areas, ESRI has actually done a fairly good job with their documentation for Flexviewer:  http://help.arcgis.com/en/webapps/flexviewer/help/index.html

you do not have to publish your xls to view in flex viewer. you can create your own widget using AS3xls library and display data dynamically....look at this post

http://zachsgeospatial.blogspot.com/2010/06/mapping-point-data-from-excel.html

Thanks

[PiotrWojciechowski]

Mike,

Also, unlike some other areas, ESRI has actually done a fairly good job with their documentation for Flexviewer:  http://help.arcgis.com/en/webapps/flexviewer/help/index.html

Thanks a lot for your help, mhargreaves! I had a guy from ESRI help me over the phone and we did exactly just as you suggested, a Map Service layer.

[PiotrWojciechowski]

you do not have to publish your xls to view in flex viewer. you can create your own widget using AS3xls library and display data dynamically....look at this post

http://zachsgeospatial.blogspot.com/2010/06/mapping-point-data-from-excel.html

Thanks

Thanks Zahid, I tried your Import Excel thing and, while it did display the coordinates, it was at the client level only; I wanted to display it for everyone.  So that Map Services publish feature for ArcGIS Server worked out good.