Error linking Google Sheet to webmap

1129
15
Jump to solution
01-30-2020 09:27 AM
sdegroot
New Contributor III

I used to link Google Sheets to a webmap just by publishing the Sheet, then adding it as CSV to my webmap. Two weeks ago, this worked fine. Today I get errors, with the same Sheets, which are still shared in the same way. When I try to add the Google Sheet as CSV I get an error that the Sheet 'is not accessible':

When I open a webmap that used to have Google Sheets linked as CSV I also get an error that the Sheet 'is not accessible':

Can anyone offer a work-around or tell me how I can get these sheets linked in to my webmaps again? We are using these to coordinate among a bunch of project partners, and not being able to see our data on the map is frustrating.

Thanks for your help.

1 Solution

Accepted Solutions
Peter_Klingman
Esri Regular Contributor

Hi s degroot

Development has fixed this issue and Google Sheet workflows are again functioning as expected. 

Thanks,

-Peter

View solution in original post

0 Kudos
15 Replies
Peter_Klingman
Esri Regular Contributor

Hi s degroot‌,

It looks like you're running into an issue that was logged as a bug in our system about a week ago - Development has taken a look and is hoping to get a fix out as soon as possible. I'll make sure to update the thread once the fix is out.

Here is the BUG that you can subscribe to from MyEsri: BUG-000128074: A public CSV file published using Google Sheets and .. You can also Contact Support and attach your customer number as well. Feel free to send me a DM or email pklingman@esri.com and I can help with this process. 

In the meantime does the Alternate Solution listed in the BUG suffice as a workaround? 

Share documents as Excel files using either Microsoft OneDrive or Dropbox using the second workflow in How To: Add and update Google Sheets data in ArcGIS Online. This method requires manual update to reflect any changes.

  • Add as an item in the ArcGIS Online Content tab:
  1. Open the Content tab.
  2. Click Add Item > From a cloud drive.
  3. Select either Dropbox or OneDrive. Specify File Type and the sheet.
  • To update changes in the published hosted feature layer:
    1. Open the item details page.
    2. Click Update Data Overwrite Entire Layer.

Hope this helps and let me know if there are any other questions ~

-Peter

0 Kudos
sdegroot
New Contributor III

Thank you for the reply.

I tried adding a file from the cloud drive, and received this error: "Cloud

drive file is invalid or not found." However I can open it in Google Sheets

and edit it just fine.

If I can get the workaround to work, it could suffice temporarily, but the

real benefit from linking a Google Sheet is that the map is automatically

updated when any changes are made to the Sheet. I just don't have time to

do manual updates whenever there's a change (there will be a lot).

I'm not sure if this is an ArcGIS Online problem, or a Google Sheets

problem. I just know that on Jan. 16 all my sheets were linking to

webmaps just fine, and as of today (Jan. 30) they are not, and I changed

nothing in between there.

0 Kudos
sdegroot
New Contributor III

If it helps, the other error I get when trying to add from a cloud drive is

"!CONT_00272!"

0 Kudos
Peter_Klingman
Esri Regular Contributor

Thanks for the reply here - right, the workaround would only be temporary. Our Development team hopes to get a fix out as soon as possible for the issue, then the auto-update from the Google Sheet will work again. The !CONT_00272! error should also be fixed at that time. 

 

Can you try from One Drive or Dropbox, or upload the CSV file to the ArcGIS Online Content tab manually?

 

I'm out of office tomorrow but will make sure to check back here and respond Monday. 

 

Thanks,

 

-Peter

0 Kudos
sdegroot
New Contributor III

I don't have access to One Drive or Dropbox, but I downloaded a Google

Sheet as .csv, uploaded to AGOL and published as a feature layer, and added

to a webmap with no problem.

0 Kudos
Peter_Klingman
Esri Regular Contributor

Hi s degroot

Development has fixed this issue and Google Sheet workflows are again functioning as expected. 

Thanks,

-Peter

View solution in original post

0 Kudos
sdegroot
New Contributor III

Thank you! Noticed a few hours ago that it was working again. This is a big

help for us.

Sarah

KasimirOrlowski
New Contributor II

Hey Peter, 

Unfortunately, the problem is not fixed yet. Data from GoogleSheets can be loaded and shown on the map BUT popups don't show the attribute data. Instead, 'No information available' is indicated. In the attribute table the data is visible. 

Can you please let development know about this issue?!

Thanks a lot!

Best,

Kasimir 

0 Kudos
sdegroot
New Contributor III

Popups from Google Sheets seem to be working on my map, with all the

attribute data showing.

A few years ago I had the problem of popups from a Google Sheet listing the

field names but not the data (just blank), and the problem was that the

field names contained double colons :: Replacing those with _ solved the

problem.