topic Re: Add Excel Widget uploaded to the Resource Center in ArcGIS Viewer for Flex Questions

Add Excel Widget uploaded to the Resource Center

AnthonyGiles — Mon, 23 Jul 2012 17:29:40 GMT

All,

Please find a link to an add Excel Widget:

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

Thank You Robert for hosting sample application for me

Feedback welcome

Regards

Anthony

Re: Add Excel Widget uploaded to the Resource Center

JeffersonFerreira_Ferreira — Fri, 31 Aug 2012 13:50:42 GMT

Hi Anthony! Great work! Congratulations. It is primordial for a GIS user's somethings like this.

But, A little question: How can I plot the coordinates in DD.DDD (decimal degreees) instead WebMercator metrical coordinates?

The widget recognizes the webmercator coordinates, but it's too confusing to a kind of users. Furthermore all my application display the wgs84 decimal degrees system. I'm not a "hard developer", but I can set up my "Frankensteins" takeing a piece here, another there and customizing my widgets. The CoordinateMenu widget can Go To coordinates entered as WGS decimal degrees, even behind the "backstages" the webmercator is acting. So it would be the same thing with your widget: enter wgs decimal degrees coordinates by the UI, that passes through webmercator and are ploted at the right place.

Is it possible? Do you've done like this? If not, we can think in. I could help you if I can.

Best Regards

Re: Add Excel Widget uploaded to the Resource Center

AnthonyGiles — Fri, 31 Aug 2012 14:01:23 GMT

Jefferson,

If your basemap is projected in geographics then you can just have the values in your spreadsheet as decimal degrees and it will plot ok, this is how I originally developed the widget I only have the demo in web mercator to work with the esri base maps.

Regards

Anthony

Re: Add Excel Widget uploaded to the Resource Center

JeffersonFerreira_Ferreira — Fri, 31 Aug 2012 14:21:28 GMT

Jefferson,

If your basemap is projected in geographics then you can just have the values in your spreadsheet as decimal degrees and it will plot ok, this is how I originally developed the widget I only have the demo in web mercator to work with the esri base maps.

Regards

Anthony

Anthony, thanks for you attention. But "houston, we have a problem...!
When I upload a sheet in decimal degrees they are ploted at webmercator and all at the same place. Exemple, in my sheet:
X Y
-64.84071 -3.04574
-64.85397 -3.03276
-64.85832 -2.98987
-64.83300 -3.06294
-64.84892 -3.04203
-64.77522 -3.10844
-64.79987 -3.10231

The first coordinate pair, for exemple, represent -7218035.058740 -339215.035943 in webmercator, but they are ploted at the -64.84071 -3.04574 webmercator...

Any idea?

Re: Add Excel Widget uploaded to the Resource Center

AnthonyGiles — Fri, 31 Aug 2012 15:06:39 GMT

Jefferson,

I think I understand what you are after now, you want to have your basemap in web Mercator projection then upload coordinates that are in decimal degrees. This is not achievable without modifying the source code as you will need to reproject each point before plotting. If you have the capability to adapt the source code this should be easy to do but it is not something I plan on doing as I have no requirement to do so.

Regards

Anthony

Re: Add Excel Widget uploaded to the Resource Center

JeffersonFerreira_Ferreira — Fri, 31 Aug 2012 16:30:54 GMT

Jefferson,

I think I understand what you are after now, you want to have your basemap in web Mercator projection then upload coordinates that are in decimal degrees. This is not achievable without modifying the source code as you will need to reproject each point before plotting. If you have the capability to adapt the source code this should be easy to do but it is not something I plan on doing as I have no requirement to do so.

Regards

Anthony

Hi Anthony;

In fact, I have 4 basemaps. Three of them are bingmaps mapservice (webmercator) and one is an image service that I've published. Originally it is in WG84. These bing services determine that all my application are in webmercator? Even if all of my operational layers and my image service as a basemap are in WGS geographic?
A schematic image is attached.
Thanks

Thanks

Re: Add Excel Widget uploaded to the Resource Center

AnthonyGiles — Fri, 31 Aug 2012 17:22:01 GMT

Jefferson,

If you add your image service as your first base map then your application will be in WGS84 as the projection of our first base map determines the projection of you application.

You can also set the projection of your application using the wkid attribute in your map tag in the main config file, see:

http://help.arcgis.com/en/webapps/flexviewer/help/index.html#/Main_configuration_file/01m300000018000000/

Regards

Anthony

Re: Add Excel Widget uploaded to the Resource Center

JeffersonFerreira_Ferreira — Fri, 31 Aug 2012 19:58:14 GMT

Jefferson,

If you add your image service as your first base map then your application will be in WGS84 as the projection of our first base map determines the projection of you application.

You can also set the projection of your application using the wkid attribute in your map tag in the main config file, see:

http://help.arcgis.com/en/webapps/flexviewer/help/index.html#/Main_configuration_file/01m300000018000000/

Regards

Anthony

Great Anthony! It was the first basemap. A simple question... Now the points are correctly ploted.
Thanks for your advice!

Re: Add Excel Widget uploaded to the Resource Center

RhettZufelt — Tue, 04 Sep 2012 21:08:22 GMT

Great Anthony! It was the first basemap. A simple question... Now the points are correctly ploted.
Thanks for your advice!

Hi Jefferson,

If they are plotting correctly then you must have got the map wkid to WGS84 so they display correctly.

However, that means that your map is now WGS84 and the Bing maps are tiled in the webmercator system. Did you find a way to load Bing maps as dynamic so they actually overlay, or did you give up on having a bing map as well?

Thanks,

R_

Re: Add Excel Widget uploaded to the Resource Center

KennethLyons — Thu, 06 Sep 2012 12:12:07 GMT

I'm having a similar issue with the points in my spreadsheets not plotting correctly. the Sample that came with the download loads with no issue, but when I create my own the points end up in the middle of the ocean. I'm not sure where the disconnect is on my end. I've tried using several different coordinate types in the spreadsheet, but they all plot in the same area.

Any thoughts??

Thanks

Re: Add Excel Widget uploaded to the Resource Center

AnthonyGiles — Thu, 06 Sep 2012 18:12:42 GMT

Kenneth,

Are the coordinates in your spreadsheet in the same spatial reference as your application?

They must match

Regards

Anthony

Re: Add Excel Widget uploaded to the Resource Center

KennethLyons — Thu, 06 Sep 2012 18:45:40 GMT

Anthony,
If by "Spatial Reference" you mean coordinate system, I'm not sure, and how would I verify that. I've tried all difference types of coordinates Decimal Degrees, MGRS, Easting/Northing. All show up in the same location no matter what order I put them in. Like I said the sample spreadsheet loads with no issue, All points show up in the Pacific NW. I tried to follow the same format as the sample when creating my own test points, but for some reason the point is located in the middle of the Altantic Oceans instead of central Pennsylvania.

I'm not sure where the issue is coming from.

Re: Add Excel Widget uploaded to the Resource Center

RhettZufelt — Thu, 06 Sep 2012 18:49:40 GMT

What does the <map> and <basemaps> section of your config.xml look like?

R_

Re: Add Excel Widget uploaded to the Resource Center

AnthonyGiles — Thu, 06 Sep 2012 18:57:12 GMT

Kenneth,

If you have not specified a wkid in your map tag then the spatial reference ( coordinate system) of your application will be determined from the first base map that is loaded. Check the Rest endpoint for your first basemap this will tell you it's spatial reference.

Your coordinates in your spreadsheet need to be in the same coordinate system as your first base map

Regards

Anthony

Re: Add Excel Widget uploaded to the Resource Center

KennethLyons — Thu, 06 Sep 2012 19:10:23 GMT

Here is the <map> and <basemap> section of my config.xml

<map wraparound180="true" initialextent="-9441000 4769000 -7973000 5229000" fullextent="-20000000 -20000000 20000000 20000000" top="40">

        <basemaps>
            <layer label="Topo Maps"      type="tiled" visible="true" alpha=".8"
                   url="http://server.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer"/>
     <layer label="World Imagery" type="bing" style="aerialWithLabels" visible="false" />
     <layer label="Street Map"   type="osm" visible="false" />
            <layer label="PA Imagery"    type="tiled" visible="false" alpha=".8"
                   url="http://146.186.163.133/ArcGIS/rest/services/AerialPhoto_Color2003-2006/MapServer"/>
        </basemaps>

Re: Add Excel Widget uploaded to the Resource Center

AnthonyGiles — Thu, 06 Sep 2012 19:15:04 GMT

Kenneth,

From your last post your applications spatial reference is Web Mercator so you coordinates in your spreadsheet need to also be in Web Mercator

Regards

Anthony

Re: Add Excel Widget uploaded to the Resource Center

RhettZufelt — Thu, 06 Sep 2012 20:09:50 GMT

This should work for you as a test. (as long as you haven't modified the addexcel.xml to change column names. I noticed if you have the wrong column names, it doesn't error out, it just throws the points in some arbitrary place over in Europe)

R_

Re: Add Excel Widget uploaded to the Resource Center

KennethLyons — Mon, 10 Sep 2012 16:59:15 GMT

Thanks it seems to be working now. I'm going to try generating my own spreadsheet again. Is there a specific column name that needs to be used in order for the pop-up window to work correctly?

Re: Add Excel Widget uploaded to the Resource Center

RhettZufelt — Mon, 10 Sep 2012 17:01:00 GMT

Yes there is. What ever you pick in the AddExcel.xml as the <message> tag in that file states.

R_

Re: Add Excel Widget uploaded to the Resource Center

KennethLyons — Tue, 11 Sep 2012 13:30:30 GMT

Ok, so I understand that these points are based on the initial map background's coordinate system, but out of curiousity is there a way to modify this widget to plot the points based on a street address or road intersection? I would try this on my own, but I'm not NEARLY compitent enough with this to even know where to start.

Thanks for any input..