topic Re: Flex View Import Excel File with Coordinates in ArcGIS Viewer for Flex Questions

Flex View Import Excel File with Coordinates

PiotrWojciechowski — Sat, 23 Oct 2010 01:23:06 GMT

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

Re: Flex View Import Excel File with Coordinates

SimonMorgan — Mon, 25 Oct 2010 10:27:13 GMT

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.

Re: Flex View Import Excel File with Coordinates

PiotrWojciechowski — Wed, 27 Oct 2010 12:49:46 GMT

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

Re: Flex View Import Excel File with Coordinates

MikeHargreaves — Wed, 27 Oct 2010 15:52:47 GMT

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...

Re: Flex View Import Excel File with Coordinates

PiotrWojciechowski — Wed, 27 Oct 2010 20:36:09 GMT

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!

Re: Flex View Import Excel File with Coordinates

MikeHargreaves — Sat, 11 Dec 2021 07:11:21 GMT

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

Re: Flex View Import Excel File with Coordinates

MikeHargreaves — Wed, 27 Oct 2010 21:14:11 GMT

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

Re: Flex View Import Excel File with Coordinates

ZahidChaudhry — Sun, 31 Oct 2010 14:13:57 GMT

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

Re: Flex View Import Excel File with Coordinates

PiotrWojciechowski — Fri, 05 Nov 2010 04:28:23 GMT

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.

Re: Flex View Import Excel File with Coordinates

PiotrWojciechowski — Fri, 05 Nov 2010 04:29:50 GMT

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.

Re: Flex View Import Excel File with Coordinates

PiotrWojciechowski — Sat, 11 Dec 2021 07:11:23 GMT

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

Thanks Mike, we did this and it worked out great!