nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exporting Selected Records from Feature Layer to .CSV File?

ipeebles

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.

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

JohnRitsko1

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.

TimCollyer

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.

JeffJacobson

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.

ReneRubalcava

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

TimCollyer

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.

JeffJacobson

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.]

ipeebles

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?

GaneshSolai_Sambandam

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

Regards
Ganesh

JakeSkinner

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

TableConversion.zip

compiled_FV2.4.zip

GaneshSolai_Sambandam

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

ipeebles

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.

JakeSkinner

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'.

GaneshSolai_Sambandam

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

JakeSkinner

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.

TabletoCSV.zip

select_points.jpg

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.