Add Excel Widget uploaded to the Resource Center

AnthonyGiles · ‎07-23-2012

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

AnthonyGiles · ‎06-20-2013

Michael,

Sorry its taken me a while to respond, i was not planning on upgrading my projects to 3.3 as 3.4 is out very soon and I just cannot keep up with how fast the releases are coming out. I have quickly thrown together a 3.3 project and recompiled the widget for you. I have not fully tested it but hopefully it should be ok.

Regards

Anthony

JackJoseph · ‎06-27-2013

I've been having issues with the graphics created from this tool carrying over to any print output. The graphics seem to disappear when I print using the standard print widget. Is anyone else having this issue? Any workarounds?

Thanks,
Jack

deleted-user-yA_w_FC9FKe5 · ‎07-01-2013

Sorry I thought I would try this one more time. Has anyone updated the addexcel widget for 3.3 that they care to share.

I'm not real familiar with how to do this and figured/hoped someone else had already taken the steps to do this. If you have could you please take a moment to upload it for those of us who are not as experienced please. This would be a nice widget just to have with the main flex builder.

Thanks so much. Going to try it now. Was away for Vacation.

RhettZufelt · ‎07-01-2013

I don't see them on the print either.

Workaround is to use Robert's Export Map widget. It captures them. http://www.arcgis.com/home/item.html?id=12430e982e534fdabe15635828405e45

R_

More testing, the "basic" print task seems to print them. It is when you use the print server ExportWebMapTask that it doesn't print the added icons.

deleted-user-yA_w_FC9FKe5 · ‎07-11-2013

So I got this bad boy to load up into 3.3! It actually even imports the points! Sweet! However, all of the points end up in the ocean. 😞 Bummer!

I've read the whole thread and it seems as though a couple of people have figured out to handle this. Currently my points are in esriSRGeoCS_NAD1983. I've tried several things to try and solve this issue. Any suggestions? I tried changing the wkid on the config file to 4326 and also 4269 and Flex just seems to hate that.

I want my users to be able to upload their own data. I can use ArcGIS server to upload any of my data. The key here is for my users to be able to upload their data. How do you handle this? How do your users get coordinates?

I was going to create a table that had our stores listed with the web mercator coordinates listed so they could just match it up with store number and their data. However, I can't figure out how to do this myself!

Any thoughts, suggestions or ideas. I would really love to have this feature as it makes a lot of sense.

RhettZufelt · ‎07-11-2013

How do I handle this? I have my Flexview app in the coordinate system of my data.

Any excel file that is in the same coordinate system will overlay properly.

You could use ArcMap projection tool to re-project your stores FC to webmercator and add coordinates to it, then export the table. that would give you the "lookup table" that you mentioned.

R_

deleted-user-yA_w_FC9FKe5 · ‎07-11-2013

How do I handle this? I have my Flexview app in the coordinate system of my data.

Any excel file that is in the same coordinate system will overlay properly.

You could use ArcMap projection tool to re-project your stores FC to webmercator and add coordinates to it, then export the table. that would give you the "lookup table" that you mentioned.

R_

Thanks for the quick response. Currently I have everything reprojected to web mercator because I am just using the default basemaps. This includes my shapefile. Should I project all of my layers as NAD1983 and then change the WKID to 4269? I should clarify, Change the WKID inside the flex config file.

deleted-user-yA_w_FC9FKe5 · ‎07-11-2013

Thanks for the quick response. Currently I have everything reprojected to web mercator because I am just using the default basemaps. This includes my shapefile. Should I project all of my layers as NAD1983 and then change the WKID to 4269? I should clarify, Change the WKID inside the flex config file.

Ha so I figured out how to do this via opening the table and right clicking on the field and using calculate Geometry. Then using the data fram projection which I set to web mercator and the units to meters. Bawhaaa it gave me the correct coordinates for my stores. Now I need to automate that using VBA. Yes VBA. We are still using that and probably will be for a while. Not much of a fan of VB. Net or C#. Too much work to convert at this time.

Still have the issue for my users to upload thier information but baby steps

DavidRaijmakers · ‎08-08-2013

When i don't preload the widget and open it i came across a warning:

waarschuwing: De klasse widgets.AddExcel.LocateResult is gebruikt bij een aanroep van net.registerClassAlias() in _AddExcel_FlexInit. Hierdoor zal widgets.AddExcel:AddExcel uitlekken. Definieer widgets.AddExcel.LocateResult in de toepassing op het hoogste niveau om het lek te repareren.

I know it is in dutch, and i will try to explain it:

it says that the class widgets.AddExcel.LocateResult is used at a call from net.registerClassAlias() in _AddExcel_FlexInit. This will cause a leak by widgets.AddExcel:AddExcel uitlekken. Define widgets.AddExcel.LocateResult in the application at the highest level to fix the leak.

Have you seen this before, i just copied your exact code.

Or do you have a fix for this?

Thanks in advance