topic Re: excel widget problem in ArcGIS Viewer for Flex Questions

excel widget problem

anjelinaponker — Mon, 30 Jul 2012 18:28:48 GMT

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

Re: excel widget problem

AnthonyGiles — Mon, 30 Jul 2012 18:45:28 GMT

Anjelina,

It looks like the popuprender class has moved package in API 3.0 to com.esri.ags.portal:

http://resources.arcgis.com/en/help/flex-api/apiref/index.html

I have not had chance to try it but change the class on the import statement from

import com.esri.ags.webmap.PopUpRenderer;

to

import com.esri.ags.portal.PopUpRenderer;

Regards

Anthony

Re: excel widget problem

RhettZufelt — Mon, 30 Jul 2012 22:56:42 GMT

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_

Re: excel widget problem

anjelinaponker — Mon, 30 Jul 2012 23:27:33 GMT

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?

Re: excel widget problem

RhettZufelt — Mon, 30 Jul 2012 23:32:17 GMT

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_

Re: excel widget problem

AnthonyGiles — Tue, 31 Jul 2012 06:32:24 GMT

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

Re: excel widget problem

KennethLyons — Tue, 04 Sep 2012 18:10:06 GMT

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?

Re: excel widget problem

RhettZufelt — Tue, 04 Sep 2012 18:19:04 GMT

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_

Re: excel widget problem

KennethLyons — Tue, 04 Sep 2012 18:30:30 GMT

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.

Re: excel widget problem

RhettZufelt — Sat, 11 Dec 2021 12:33:13 GMT

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;

Re: excel widget problem

scottbassingthwaite1 — Fri, 14 Sep 2012 12:09:25 GMT

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

Re: excel widget problem

GeorgeHaskett — Fri, 08 Feb 2013 22:48:16 GMT

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

Re: excel widget problem

AnthonyGiles — Wed, 13 Feb 2013 15:17:40 GMT

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

Re: excel widget problem

GeorgeHaskett — Wed, 13 Feb 2013 19:24:35 GMT

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

Re: excel widget problem

AnthonyGiles — Thu, 14 Feb 2013 13:40:08 GMT

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

Re: excel widget problem

GeorgeHaskett — Wed, 20 Feb 2013 14:48:45 GMT

Thanks Anthony,

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

Haskett

Re: excel widget problem

GeorgeHaskett — Wed, 20 Feb 2013 15:14:16 GMT

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

Re: excel widget problem

RhettZufelt — Sat, 11 Dec 2021 12:33:15 GMT

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_

Re: excel widget problem

AnthonyGiles — Wed, 20 Feb 2013 22:27:46 GMT

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

Re: excel widget problem

RhettZufelt — Wed, 20 Feb 2013 22:52:24 GMT

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_