topic Re: CSV Feed Bug in ArcGIS Web AppBuilder Questions

CSV Feed Bug

EricPollard2 — Thu, 24 Jul 2014 05:23:44 GMT

I created a web map on AGO and added two CSV web layers. They are both google docs spreadsheets which have been made publicly visible and I have used the sharing link to insert (fyi need to add "/export?format=csv" on the end of the URL for this to work from google docs). They come in just fine on the web map in AGO, points and data and all, and I can make applications from templates, work with the data, etc. When I bring this web map into the app builder, however, the points will not show and the layers are not even shown as being on the map (nothing in legend widget or anywhere else). This may be a bug ? Am I missing a setting?

Re: CSV Feed Bug

RobertScheitlin__GISP — Sat, 26 Jul 2014 23:18:34 GMT

Eric,

Are you familiar with using developer tools in chrome or firefox to look at the http requests and responses? You should check if something is coming back with a 40X error.

Re: CSV Feed Bug

Jianxia — Mon, 28 Jul 2014 21:18:41 GMT

Eric,

Could you load the webmap created in AGOL into JS API sample below and see if it works as expected?

Web map by ID | ArcGIS API for JavaScript‌https://developers.arcgis.com/javascript/jssamples/ags_createwebmapid.html

In this case, you only need to replace the webmap ID with yours. Web AppBuilder is built on top of JS API. If it works with JS API but not Web AppBuilder, then this is a bug.

Thanks,

Jianxia

Re: CSV Feed Bug

ZhifangWang1 — Tue, 29 Jul 2014 08:09:10 GMT

I've tested a online csv directly from google docs (url end with "/export?format=csv" ) in my webmap, it displays fine in both MapViewer of ArcGIS Online and Web AppBuilder for ArcGIS (showed in Layerlist Widget).

Can you share the exact csv url?

Re: CSV Feed Bug

EricPollard2 — Tue, 29 Jul 2014 14:52:37 GMT

The MapViewer definitely displays just fine, and I had "intermittent" periods of the CSV feeds displaying properly while inside the Web Appbuilder, but after downloading and hosting the application nothing would display for the CSV's (most times it did not work within the builder either). Everything should show as public, and the web map is here --> http://www.arcgis.com/home/item.html?id=0dc2664929b74553ac671b8b45887c51‌

URLS for the CSV feeds are here --

Dining:https://docs.google.com/a/sitemarker.com/spreadsheets/d/1mNntYoJuqwXq2HUaZ-OVv--a1wQ2gePviN3Xz_ItMws/export?format=csv

Shopping:https://docs.google.com/spreadsheets/d/1U1qsjKBk-MeoscQmryqYaROkDPWoYJzsISPCJj5W0yY/export?format=csv

Re: CSV Feed Bug

ZhifangWang — Thu, 31 Jul 2014 06:03:18 GMT

Hi Eric,

I've tested your webmap and csv as below:

1. Create an app in builder and replace the webmap to your webmap which is http://www.arcgis.com/home/item.html?id=0dc2664929b74553ac671b8b45887c51‌ and the csv works fine in builder;

2. download the app and deploy it on my IIS, open the app, then the csv can not display.

By looking the network traffic, you can find that the csv file is requested through proxy.js as below:

This is because using proxy is the default option in all app created by builder, but the downloaded app comes out without a proxy file. You can configure one by editing the config.json file in the downloaded app folder as below:

Hope this helps.

BTW, you need to check the "Use Proxy" box in builder to see your csv from google docs.