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

Amanda Putri

August 09, 2024 01:09 Edited

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

  August 09, 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!

  1
• 

  Amanda Putri

  August 19, 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!

  1

Please sign in to leave a comment.