nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

PiotrWojciechowski

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!

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.

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.

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

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

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

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

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

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

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.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.