Export CSV of selected features (from Geometry Picker and ListBox) using VertiGIS Workflow

Amanda Putri

9. August 2024 01:09 Bearbeitet

Hi, 

I'm looking into exporting CSV of selected features in the workflow (as a download item). I am aware that there is out-of the-box Export to CSV command in Studio Web. The reason that I want to do it through workflow is because the workflow is incorporated into producing a report as well. 

So, in summary the activity looks like this:

1. Users select survey marks from the map using Geometry Picker (this is working). 
2. The list of survey marks appear on the List Box. Users then select the survey marks of interest (this is working). 
3. Users click a ‘Create Report’ button. This will create a report (VertiGIS Studio Reporting) which contains configured attributes of selected survey marks. The report is a pdf that opens in a new browser tab (this is also working).
4. Create CSV file of selected marks (this should pass on all the attributes though, not only the subset of attributes). This part is not working at the moment. 

That looks like this in the interface (Studio Web):

The workflow is something like this:

I added a few activities (in the workflow, pink outline above) after the report for the CSV but not sure if that is the way to do it. I am also at loss on what to configure on the Operation Parameter. I have something like this at the moment:

={ features:$getWorkflowInputs1.inputs.context, maps: [$ACTGridgeomform.state.listBox2.value.items.map(x => x.value.data.attributes.OBJECTID)] }

Any pointers would be much appreciated. Thank you! 

1

• 

  Yannick Mijnheer

  9. August 2024 07:26

  Hi Amanda,

  I've been there, it's quite a search with the operation parameters sometimes. We have a workflow to download results as Excel file, and I think csv would work more or less the same. If you have your results in a FeatureSet, the workflow should look like this (but probably with results.convert-to-cvs):

  

  Hope this helps, good luck!

  3
• 

  Amanda Putri

  19. August 2024 06:23

  Hi Yannick, thanks so much for the workflow. It works really well! One thing that I added just above the ‘Create Feature Set’ activity was the Query Layer. 

  Apparently, I need to use the Query Layer again to call the layer of interest. For the input parameters, I added:

  - (*) for the Output Fields, 

  - the OBJECTID of selected features (=$value3.result) that was created beforehand for running the Report. 

   

  

  The CSV download is now coming through. Thanks again!

  2
• 

  Carmen Durham

  10. Juni 2025 17:16

  Thank you both for posting this information.  I was at the same point as Amanda and getting frustrated with trying to export selected items from a itemPicker to an excel spreadsheet.  

  I followed the above suggestions and finally have a spreadsheet that downloaded from selected items from an itemPicker form.

  Now to see if I can limit the fields (with the parameters) that are exported in the workflow like we have on a click event on a results detail panel. In theory, it should be the same.  

  Thanks!

  0

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