AnsweredAssumed Answered

Creating a layer from Excel or CSV to the Portal - no projection

Question asked by sviva.gov.il on Sep 29, 2016
Latest reply on Oct 5, 2016 by sviva.gov.il

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.

Outcomes