Select to view content in your preferred language

Unable to Add Feature Layer Item from Spreadsheet

1241
8
08-18-2021 04:46 AM
NeilMcLysaght
Emerging Contributor

Hi everyone, 

Pretty new to ArcGIS so please bear with me 🙂

I am running on ArcGIS Online with a Professional Basic License.

I'm trying to add a Feature Layer by importing an Excel DataSheet which includes Lat/Long Coordinates for Location. I am selecting the Locate Features By Corordinates option and mapping the Lat/Long Fields in the Spreadsheet accordingly.

When I then try to Save/Publish the Item I am getting a persistent high-level errors (depending on the upload path I take e.g. Drag Drop File into Content->Item Add, then Save or Upload Spreadsheet first and then publish it)

 

(Via Content Upload->Add Item)
Error
There was an error while adding this item.
 
(Via Publish for an uploaded Spreadsheet)
Error

There was an error publishing the service.

There are no other Error Details being shown..

Any suggestions greatly appreciated.

N

 

 
 

 

 

0 Kudos
8 Replies
JayantaPoddar
MVP Esteemed Contributor

Could you share a sample of the excel sheet with the headers (first row) and 5 value rows intact? Also ensure all field names are unique.



Think Location
0 Kudos
NeilMcLysaght
Emerging Contributor

Hi, thanks for your reply.

Sure - see attached..

 

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

I could publish it successfully, without any error.

How many records do you have?

Does the Lat and Long fieldtype reflect as Double (while adding it to ArcGIS Online)?

Are there any gaps (No Value) or spaces in the Lat/Long values? If yes, you need to correct them before proceeding ahead.

 

JayantaPoddar_2-1629290334925.png

 

JayantaPoddar_0-1629290057176.png

 

JayantaPoddar_1-1629290199927.png

 



Think Location
0 Kudos
NeilMcLysaght
Emerging Contributor

Hi again, Many thanks for trying and confirming that.

  • Total Records count is 1300 approx
  • Lat/Long are reflecting as Type Double on Import in ArcGIS Online
  • I have just tried with the same 5 Record DataSet that I shared here, however the Error persists. So am am now thinking this is account related perhaps?..

 

LatLong is Type double

LatLongDouble.PNG

 

Location Settings

Location Settings.PNG

Save Error

SaveError.PNG

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

Try the following steps (one at a time and check).

1. Clear browser cache and cookies

2. Restart your system

3. Check the steps in a different browser/ incognito mode

4. Test on a different machine/ network



Think Location
0 Kudos
NeilMcLysaght
Emerging Contributor

Hello again, 

We have tried..

  • Clear Cache/Cookies, on different Browsers Same Machine same logged in User.
  • Different Browsers on Different Machine (PC) same Network, same logged in User
  • Different Browsers on Different Machine (Mac), different Network & different logged in User
  • Restarting all Systems/Repeat.

The issue still persists in all cases. 

Any ideas? 🤔

0 Kudos
JayantaPoddar
MVP Esteemed Contributor
I assume credits are still available.
Please contact Esri Technical Support to resolve any account related issue.
https://support.esri.com/en/contact-tech-support

Also convey that the workflow is working for me, as mentioned above.


Think Location
0 Kudos
NeilMcLysaght
Emerging Contributor

No issue with available credits.

I'll contact support as suggested.

Thanks again.!

0 Kudos