excel widget problem

ArcGIS API for Flex | ArcGIS for Developers

Ayesha,

Those packages will be in the API download not the viewer download, the download should come with the instructions of how to add the packages to the viewer, you will need the same version of the API to the viewer you are using:

regards

Anthony

Ayesha_

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,

HI.............can anyone help me to remove these errors as ags class package is not given in dowloadable link on esri site.....from where i can get these two packages

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

reply plz

NicoleJohnson_2-1785963646711.png

Rhett,

You can take the point that is created from the latitude and longitude and use the project function in the geometry service to reproject the point to the coordinate system you require, then add this to the graphic layer:

http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Geometry/GeometryServer/project?inSR=4236&outSR=32149&geometries=%7B%0D%0A%22geometryType%22+%3A+%22esriGeometryPoint%22%2C%0D%0A%22geometries%22+%3A+%5B%0D%0A+%7B%22x%22+%3A+-104.53%2C+%22y%22+%3A+34.74%7D%0D%0A%5D%0D%0A%7D&f=HTML

If you look at how Robert handles this in his shapefile widget by creating an array of geometries from the array of graphics, sending this array to the project function then using the returned array of new geometries to update the geometry of each graphic in the original array.

Regards

Anthony

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

Hi Anthony,

the webmercatorutil is a nice feature, wish there was geopraphicToStatePlane utility. Since there isn't, do you happen to know the "snippet" that one would modify to allow this widget to take in geographic yet display in a map in state plane (WKID=32149)?

Not even sure if this is possible without some major code, but if so, would be a great feature to have.

Anyway, I'm open to suggestions,

R_

Anthony,

Once I followed the directions in this post http://forums.arcgis.com/threads/50767-MGRS-Widget-for-Flex-Viewer?p=201105&viewfull=1#post201105 the errors went away.

Is it possible these libs should be included in the AddExcel widget download, or should 3.1 actually be able to find these imports without the respective swc's?

R_

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_

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

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_

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

Thanks Anthony,

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

Haskett

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

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

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

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

scottbassingthwaite1

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

I just downloaded the version from here:
http://www.arcgis.com/home/item.html...ddfdd2d32244e8

and incorporated into a "new" FV 3.0 final app (using SDK 4.6) and all directories, etc. seem to be correct. However, it appears as if there are still some old import statements in the mxml that need to be updated.
If you are running uncompiled version, all I did was make this change, and it is working with no issues:

   import com.esri.ags.webmap.PopUpRenderer;
   import com.esri.ags.webmap.supportClasses.PopUpInfo;
   import com.esri.ags.webmap.supportClasses.PopUpMediaInfo;

and change them to:

   import com.esri.ags.portal.PopUpRenderer;
   import com.esri.ags.portal.supportClasses.PopUpInfo;
   import com.esri.ags.portal.supportClasses.PopUpMediaInfo;

KennethLyons

R_,
Yeah I copied all the files you recommended before I attempted to run it. The as3xls is in the COM folder, I did have to change the directory for the .as files I mentioned in the AddExcel.mxml so that they were properly referenced. But I still get the "red x" on only those 2 files.

Did you remember tocopy the as3xls folder into the com folder of your project?

Did you add the dpUInt_b_v09_2_Flex_3.swc into your libs folder, OR include it in your build path library list?

That is what gave me the red x's when I first incorporated it into version 3.

Hope this helps,

R_

KennethLyons

I'm attempting to include this code into my FlexViewer 3.0 and the issue I'm running into errors with the ExcelFile.as and the Sheet.as. Flashbuilder gives me the "red x" on both files, but does not tell me where the error is located as it does with .mxml's. I also have not changed any of the code from the version I downloaded. Can anyone assist me with this problem?

All,

Sorry I did not realise that I had not included the AS3XLS folder in the download. I have updated the code to include the files here:

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

Regards

Anthony

It is the Excel actionscript library required for the AddExcel to work (at least for the uncompiled version).

I followed the link here: http://www.arcgis.com/home/item.html?id=173870a7926c4ef9b2a5121be0b46211 to get mine.

R_

anjelinaponker

Thank you.

Was so close, but could not get it to work.

Made this change AND made sure my as3xls src stuff was in the com folder and all is working and happy.

R_

I have not as3xls.
What is this?

Thank you.

Was so close, but could not get it to work.

Made this change AND made sure my as3xls src stuff was in the com folder and all is working and happy.

R_