Is there a way of exporting a FeatureSet to XLSX?

Chris Dunlop

8. April 2020 15:44

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.

0

• 

  Permanently deleted user

  8. April 2020 16:34

  @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
• 

  Berend Veldkamp

  9. April 2020 12:29

  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
• 

  Peter Milenkovic

  6. Mai 2024 05:58

  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
• 

  Berend Veldkamp

  7. Mai 2024 06:46 Bearbeitet

  No, I think I'd use the results.from-graphics, and results.convert-to-csv operations in a client workflow.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.