excel widget problem

[anjelinaponker]

Hi
I,m using Add Excel widget in flex 3, but I have this Error:


1046: Type was not found or was not a compile-time constant: PopUpRenderer.


This is related code for this Error:  private var popUpRenderer:PopUpRenderer = new PopUpRenderer();


What should I do for solving this problem?

Best regards
A.ponker

[scottbassingthwaite1]

See that several folks have AddExcel working, will there be a 3.0 complied version posted soon?

[GeorgeHaskett]

Hello,

I downloaded the new version for Flex 3.1 and seem to be having problems with it.

All my data is lumped together in the Gulf of Guinea...

The coordinates appear to be correct as they work in other applications.

I formated the spreadsheet Latitude and Longitude columns to number with 5 digits past the decimal.

Any suggestions?

I am using ArcGIS 10.1 Desktop and Server software with Viewer for Flex 3.1.

Thanks,

Haskett

[AnthonyGiles]

George,

Do the coordinates in your excel spreadsheet share the same projection as your application, and do you have the x and y values the correct way round?

Regards

Anthony

[GeorgeHaskett]

Anthony,

Okay, maybe that's my problem.  My web application is using the 102100 wkid and I was trying to add an excel using Decimal Degrees.  I've used other convertor programs out there in the past, but do not remember the Web Mercator Projection as an option.

What is the best way or tool to use to convert decimal degrees into Web Mercator Projection?
Our do I just convert them into UTMs?

Thanks for your advice in advance,

Haskett

[AnthonyGiles]

George,

Do you have the ability to amend the source code? If so the fix you require to add an excel spreadsheet in decimal degrees to a web Mercator application is as follows:

Add the following import statement:

import com.esri.ags.utils.WebMercatorUtil;

Change the gmapPoint variable as illustrated below:

var long:Number = Number(tempData.getItemAt(i)[longNumb].value);
var lat:Number = Number(tempData.getItemAt(i)[latNumb].value);
// var gmapPoint:MapPoint = new MapPoint(long,lat,new SpatialReference(4326));
var gmapPoint:MapPoint = new MapPoint(long,lat);
gmapPoint = WebMercatorUtil.geographicToWebMercator(gmapPoint) as MapPoint;

Regards

Anthony

[GeorgeHaskett]

Thanks Anthony,

That is definately above my ability at this time, however I would like to get there at some point.

Haskett

[GeorgeHaskett]

Anthony,

If I am correct, you are the author of this widget, yes?

If so, I think its a great tool and has the potential of really helping the community maximize the Viewer for Flex.

If you are the author, would it be possible to have the next version inclued a button for either the DD or DMS coordinates?  As a community, it seems that we have forced our co-workers into obtaining DD coordinates for events so that they can play well with ESRI software.

My usual conversion process doesn't include the web mecator option.  To get it to work I had to pull in the spreadsheet first into ArcGIS and then create my XY data.

I've noticed that you have the MGRS option, which I think is great and extremely useful.  You may want to make note that the MGRS function works only if you have a 10 digit grid.  That stumped me for a bit.

Anyways, thanks again for such a great widget and please consider either the DD or the DMS option...

Haskett

[RhettZufelt]

Hi Anthony,

Decided to update my version of the AddExcel widget into FV3.1 but now it is not able to find a couple imports.

   import com.esri.ags.geod.Ellipsoid;
   import com.esri.ags.geod.geom.MoreUtils;

Says these imports are "not found".  I'm using the api build 12/12/12 is there a newer one that I am missing, or does one need to find these imports elsewhere?

Thanks,

R_

[AnthonyGiles]

Rhett,

Not sure off the top of my head but I think you may need to download the full flex API for the ags class library

Regards

Anthony

[RhettZufelt]

This is the only version that I was aware of agslib-3.1-2012-12-12.swc.

Guess I'm off to glean the web to try to find the "full" version as I don't remember seeing a separate link anywhere.

I don't even see ANY reference to that package in the API All Packages/classes reference page.  Is there a different dowload and help page for the "full" version or is this just un-documented?

R_