topic Re: Exporting Selected Records from Feature Layer to .CSV File? in ArcGIS JavaScript Maps SDK Questions

Exporting Selected Records from Feature Layer to .CSV File?

IanPeebles — Fri, 20 Dec 2013 14:52:41 GMT

I am interested in adding in functionality that allows the user to select records from a feature layer and then have them export them to a .csv file. I checked the JS API and samples and did not see this functionality. I do not want a shapefile or feature class exported, just a table. Users who will be using this will not have an ArcGIS Desktop install.

Has anyone been able to get something like this to work? Would be very interested in your ideas. Thanks.

Re: Exporting Selected Records from Feature Layer to .CSV File?

JakeSkinner — Fri, 20 Dec 2013 16:32:41 GMT

Hi Ian,

Attached is a toolbox with an added python script. The script will export a table, or feature class's table, to a CSV or XLS file. You can publish this as an ArcGIS Server GP Service, and then use the Geoprocessor class to run this in your application.

Re: Exporting Selected Records from Feature Layer to .CSV File?

GaneshSolai_Sambandam — Mon, 23 Dec 2013 10:34:15 GMT

Hi Jskinner
Thank you for ARCPY script. Unfortunately, when I try to run your model in ARCGtool box with my sample featureclass or shapefile,
I am getting the following error. I changed the data input parameter setting to featureclass and output data type to derived.

<class 'pywintypes.com_error'>:(-2147221005, 'Invalid Class String', None, None).
Failed to excute

Re: Exporting Selected Records from Feature Layer to .CSV File?

JakeSkinner — Mon, 23 Dec 2013 10:39:47 GMT

You won't have to make any changes to the parameters. The script should run on a feature class with the input as a 'Table View' and the output type as 'Required'.

Re: Exporting Selected Records from Feature Layer to .CSV File?

IanPeebles — Mon, 23 Dec 2013 11:47:23 GMT

Thanks for the script. I just want to clarify. . this will work within a javascript application using a feature layer correct? You mentioned feature class, which tells me that this will work for a desktop application?

I will have selection tools that will select the feature layer within the application. Are you saying I can create a geoprocessing service that I can run to export the selected records within the application?

If so, I will try this out when I return to the office next week. I am out of the office, so I cannot test until next week.

Re: Exporting Selected Records from Feature Layer to .CSV File?

GaneshSolai_Sambandam — Mon, 23 Dec 2013 12:20:10 GMT

Hi Jskinner
This time, I didn't change of your code and just used it.
for input data type - i chose "Table View" - required
for output data type - i chose "File" - required.

But, still I am getting same error as mentioned above.

<class 'pywintypes.com_error'>-2147221005, 'Invalid Class String', None, None).
Failed to excute

Finally, I looked at your code, the input and output files are is hard coded.
Something like this:
tablePath = r"C:\TEMP\Python\Test.gdb\XY"
filePath = r"C:\TEMP\Python\XY.xlsx"

So, In this case, it won't work I believe.
Inorder to get user input and output files - should we not use something like this:
inputFile = arcpy.GetParameterAsText(0)
outputFile = arcpy.GetParameterAsText(0)

If I am wrong please correct me.

Regards
Ganesh

Re: Exporting Selected Records from Feature Layer to .CSV File?

JakeSkinner — Mon, 23 Dec 2013 13:10:56 GMT

That was my mistake. I sent the wrong script. I've attached the correct one.

Re: Exporting Selected Records from Feature Layer to .CSV File?

GaneshSolai_Sambandam — Mon, 23 Dec 2013 14:04:34 GMT

HI Jskinner
Can you also explain the output datatype for your parameter, please.

Regards
Ganesh

Re: Exporting Selected Records from Feature Layer to .CSV File?

IanPeebles — Tue, 07 Jan 2014 19:10:02 GMT

That was my mistake. I sent the wrong script. I've attached the correct one.

How can I use this tool for the Javascript application? For instance, I want to be able to select records and just export those records to a .csv file.

I need this to work against a feature service. How do I use this tool with a feature service?

Is this more of an ArcGIS Desktop tool?

Re: Exporting Selected Records from Feature Layer to .CSV File?

JeffJacobson — Wed, 08 Jan 2014 23:23:13 GMT

Instead of trying to use a GeoProcessing service, I would write a server-side component in your web site. The handler would take the user selected data as input, serialize the JSON to classes, and then write the CSV equivalent.

What kind of server are you running? If you are running ASP.NET I would recommend using the following libraries for this.

ServiceStack: This is for easily creating a REST endpoint. There is also a library for JSON serialization.

CsvHelper This library is for converting your classes into CSV. [Edit: I think ServiceStack on its own suports CSV output, so you probably don't need CSVHelper after all.]

Re: Exporting Selected Records from Feature Layer to .CSV File?

TimCollyer — Thu, 09 Jan 2014 05:05:52 GMT

I more or less use jacobsj's approach (I have a tomcat/java server).

I did investigate ways of doing this using the File API, but I gave up because IE8 doesn't support it if I recall correctly. I'm not sure if it is possible or not though.

Re: Exporting Selected Records from Feature Layer to .CSV File?

ReneRubalcava — Thu, 09 Jan 2014 12:28:03 GMT

How about coverting the features to JSON and convert the JSON to csv directly on the client?
http://stackoverflow.com/questions/4130849/convert-json-format-to-csv-format-for-ms-excel

Re: Exporting Selected Records from Feature Layer to .CSV File?

JeffJacobson — Thu, 09 Jan 2014 14:58:10 GMT

I more or less use jacobsj's approach (I have a tomcat/java server).

I did investigate ways of doing this using the File API, but I gave up because IE8 doesn't support it if I recall correctly. I'm not sure if it is possible or not though.

You are correct, IE8 doesn't support File API. I think you would also need FileWriter, which most browsers don't support.

Re: Exporting Selected Records from Feature Layer to .CSV File?

TimCollyer — Thu, 09 Jan 2014 22:41:54 GMT

How about coverting the features to JSON and convert the JSON to csv directly on the client?
http://stackoverflow.com/questions/4130849/convert-json-format-to-csv-format-for-ms-excel

Yeah, this looks nice.

Re: Exporting Selected Records from Feature Layer to .CSV File?

JohnRitsko1 — Wed, 06 Dec 2017 00:40:18 GMT

Was looking for a recent solution to this and I downloaded your python and attempted to publish and it simply crashes in Catalog when trying to publish. I have tried looking into the Export Item as well with no luck on how to set that up either. If you can provide some insight into setting this up that would be greatly appreciated. If not I'll start a new question. Thank you.