topic Re: Export featureTable to CSV in ArcGIS JavaScript Maps SDK Questions

Export featureTable to CSV

DonCaviness — Thu, 21 Apr 2016 16:17:22 GMT

I'm using the featureTable dijit in my application. I am able to populate the table based on different featureLayers in the map. I would like to be able to export the table to a CSV file the user can download. The number of features in table can be any where from less than 10 to upwards of 10,000. Is there any samples or known ways to export the featureTable to CSV? I have tried several things but have been unsuccessful.

Re: Export featureTable to CSV

YueWu1 — Thu, 21 Apr 2016 16:55:34 GMT

Hi Don,

Here is a sample shows how to Extract Data from a map service: :"http://developers.arcgis.com/javascript/sandbox/sandbox.html?sample=gp_clipasync"

Basically, you need to use "esri/tasks/Geoprocessor". which means you have to create your own geoprocessing tool and then publish as gp service.

For more information, you can take a look about this online documentation about "geoprocessing specifically in ArcGIS Server 10.2 version" http://resources.arcgis.com/en/help/main/10.2/index.html#//002s00000002000000

Or 10.3 ArcGIS Server: http://server.arcgis.com/en/server/10.3/publish-services/windows/a-quick-tour-of-publishing-a-geoprocessing-service.htm

Hope this can help.

Re: Export featureTable to CSV

DonCaviness — Thu, 21 Apr 2016 17:16:10 GMT

Thanks but this is not a path I'm interesting in going down. I'm not looking to clip and ship the data. I'm just wanting to export out the featureTable to a CSV file. In my application I have a featureTable similar to the table in this example Using FeatureTable | ArcGIS API for JavaScript . I do not have my application formatted like this example, but I am using the featureTable dijit.

Re: Export featureTable to CSV

YueWu1 — Thu, 21 Apr 2016 20:39:23 GMT

Hi Don,

You have to write code to implement this new function. Currently FeatureTable widget doesn't have csv export function.

Essentially, you need to get all the data that loaded in dgrid and export to csv file.

GitHub - kfranqueiro/dojo-smore: Dojo stores are great! Here, have s'more.

Re: Export featureTable to CSV

DonCaviness — Fri, 22 Apr 2016 14:41:48 GMT

Yes that is exactly what I'm attempting to do. I was aware the featureTable does not have the export capability (would be a fantastic addition) and that I would need to write a custom piece. That is what my original question was for. I will look at the sample in the link you posted to see if that is something that can work in my application.

In the mean time, has anyone been able to figure out a way to do this?

Re: Export featureTable to CSV

DonCaviness — Fri, 22 Apr 2016 14:46:19 GMT

Looking at that repo, I'm have no idea how to even begin to try to implement it in my application. There isn't a very clear example there. Any suggestion?

Re: Export featureTable to CSV

ReneRubalcava — Fri, 22 Apr 2016 22:42:23 GMT

Shamelessly borrowed code from here Use JavaScript to Export Your Data as CSV - Chris Grimes

http://codepen.io/odoe/pen/rerdrm

Only exports what the table has downloaded though and only the raw data. Could tweak to export using column data probably.

Re: Export featureTable to CSV

YueWu1 — Mon, 25 Apr 2016 20:26:17 GMT

Hi Don,

Based on Rene Rubalcava 's code, here I combine this new Export CSV function within the dropdown menu in our FeatureTable sample. You can try view this live demo http://jsbin.com/bubutucoqa/edit?html,output using Chrome browser.

Re: Export featureTable to CSV

DonCaviness — Tue, 26 Apr 2016 15:06:45 GMT

Thanks guys! I knew there had to be a simplier way of doing this. I had come up with a solution but it was a bit hacky, this is much cleaner. I will give it a try in my app.

Yue, you said to view the live demo in Chrome. Why is that? Will the functionality not work in other browsers or is it just jsbin?

Re: Export featureTable to CSV

DonCaviness — Tue, 26 Apr 2016 15:39:15 GMT

Only issue I'm seeing is what Rene pointed out about only exporting what has been downloaded. This is something I need to get around. For example if I have a table with 2793 records, only the first 1000 get exported. Now if i scroll through the table, then all 2793 records get exported because now all records have been downloaded to the client but that is something I can't ask the user to do each time when they want to export the table. How can I get around this using this method?

Re: Export featureTable to CSV

DavidChrest — Fri, 10 Dec 2021 20:23:20 GMT

I ran into this same kind of thing a while back when creating a dgrid to show my selection. I found the solution here: Custom Feature layer on loading on dgrid .

It's basically this on line of code when you construct you construct/initialize/create your dgrid/attribute table.

bufferRows: Infinity,

This allows all rows to be loaded without having to scroll down to do so.

Not sure how this would get inserted into the Feature Attribute code but here is what I do when I create my attribute table using dgrid:

//Initialize the Activities grid
  var gridActivitiesDay1 = new(declare([OnDemandGrid, Selection]))({
  bufferRows: Infinity,
  columns: {
  OBJECTID: {
  label: "GPSid"
  },
  Day1Date: {
  label: "Day"
  },
  TimeofDay: {
  label: "Time"
  },
  Latitude: "Latitude",
  Longitude: "Longitude"
  }
  },
  "divGridActivities");

If you can't do this with the Feature Attribute Table widget, setting "Maximum Number of Records Returned by Server" to 3,000 would work?

Re: Export featureTable to CSV

JamesOsundwa — Wed, 14 Jun 2017 16:07:13 GMT

Hi Rene Rubalcava this sample that you put together is precisely what I need but it doesn't seem to work for me 😞 I simply took it exactly as-is and put it in a HTML...no error in my console but no download either...