Is there a way of exporting a FeatureSet to XLSX?
I used a Query Layer activity to create a feature set, and I'm wondering how to go about converting it to XLSX. I'm using the GeoWidgets toolbox supplied by DDS to do this on the client side, but I also want to be able to do it using out-of-the-box Geocortex (for our stand-alone emergency operations setup, where there might not be any internet access). I only see an activity to convert a Data Table to XLSX. Is there a way of converting a Feature Set to XLSX, or a way of converting a Feature Set to a Data Table? Seems like there should be a way.
-
@Chris Dunlop? The DataTable to XLSX activity requires the Run SQL Query. AFAIK, there is no reciprocal of the DataTable to FeatureSet activity currently in Workflow 5.
If you want to do this with server-side, you could pass in a variable which times a FeatureSet to its associated sql table to execute the query to return a DataTable or use the Workflow 4 FeatureSet to DataTable. Neither are elegant solutions.
0 -
I haven't tried this, but I think it should be straightforward to convert a featureset to CSV, and then use the Convert CSV To Data Table activity to create a datatable that can be used in Convert Data Table To XLSX.
0 -
Hi Berend,
How would you go about converting a featureset to a csv? Appending to a string value while looping through all the features/attributes?
0 -
No, I think I'd use the results.from-graphics, and results.convert-to-csv operations in a client workflow.
0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
4 kommentarer