Hello, We have many users who works daily with excel speardsheets or csv files which containts coordinates but our basemaps are on a special SpatialReference (2039).
As from what I know, ESRI doesn't support this Spatial for Excel.
When Loading the files directly into a new map view in the portal, the map is able to do Projection and the data shows up fine as part of the map.
When trying to load the data through Maps for office or any other way, such as uploading a new file to the personal content area, there is no Projection and the layer is created empty! / unavailable to show / corrupted.
I'm not sure if BUG is the right word but this is obviously wrong - if I can upload a file, I would expect him to show up on the map perfectly, otherwise I would expect an explanation for the problem rather than opening an investigation all the way to the documentation to find out the Spatial Reference isn't supported.
I cannot conitue use this as a work method and our users easily lose their interest when such a vital and basic operation is not available!
Is there anyone who can recommend on a way to load files with coordinates to the Portal as layer items?
The only 2 workarounds I can think of is a middleware tool to do one of the following:
1. Translate coordinates to Web Mercator
2. Translate coordinates to Addresses and let the Portal/Excel do the translation for coordinates
Any advice??
Kind Regards,
Shay.