Export to csv
Is there any way to use the "export to csv" functionality from right clicking on a selection ...but as a standalone tool?
I'd like to incorporate this into a button on the toolbar, but I can't find it as an existing module.
Any suggestions?
Thanks
-
Right now export to CSV grabs all the fields in the feature class, regardless of configured visibility. I will file a feature improvement for this, as this will certainly be unwanted more often than not.
0 -
Hi Ralph,
Is your viewer on a publicly accessible site by chance? If so, I'd like to explore this a little more.
Kevin
0 -
Hi Kevin
unfortunately these services are yet to be exposed (as far as I can tell).
Is there any digging that I can do to help?
Thanks
Ralph
0 -
Is there any progress on this? Will this fix be part of a future release?
0 -
Hi Andrea,
It's still on our list of things to do. I've added your name to the issue.
Regards,
-Malcolm
0 -
Is there anyway to remove this from the list menu? I see where to remove it from the LayerListSelectionActionsMenu...
0 -
Why is it when I export to CSV, it instead create a ZIP file with the CSV file I needed in it plus the feature layer fields?
0 -
Good morning Edgardo
from my point of view the zip view makes sense when there are Datalinks and/or related tables for layer but when there are not then it should be just the single .csv
Getting the related data is very helpful
Thanks
Ralph
0 -
Thanks Ralph for the response to my question.
In our case, having them zipped together (both the data link fields & feature layer fields) causes confusion since most of our users are technology-challenged folks :-) All of our related property data are in a separate table and none of the feature layer fields other than the link field is important hence a direct CSV export output is preferable. Wish there is an option to NOT include feature layer fields at all.
thanks,
edgardo
0 -
Hi Edgardo
I guess one way to achieve this would be a workflow.run from a button in the tool bar. The user could be prompted for what layer(s) to be exported or rather the selected features from those layer if there was more than one layer with selections.
Regards
Ralph
0 -
Hi Malcolm,
Any update on when this functionality will be incorporated (for limiting which fields are shown on csv export)?
Thanks
0 -
Looks like this has been fixed in SLV1.7 & GXE11.
0 -
I don't understand what you really want to achieve.
However, these are the options you can use:
First of all, on the default GVS, there are three commands available: ExportFeaturesToCsv, ExportFeaturesToCsvSemicolonDelimited, ExportFeaturesToCsvWithExtras, which all takes Geocortex FeatureSet (Gcx) object.
Viewer.Defaults.xml on GVS confiures to execute a command 'ExportFeaturesToCsvWithExtras' on Selection and Results custommodule where Gcx FeatureSet available.
So to use these command, you need to have a Gcx FeatureSet object.
Secondly, there is an Workflow Activity called 'DataTable To Csv' under Conversion group which is for 'to create the content of a CSV file that you wish to make available for download.'
Therefor, you can utilize this activity, by starting your own workflow where you can implement the workflow you want to achieve like
(1) run QueryTask, which returns Esri FeatureSet
(2) use 'FeatureSet To DataTable' activity to convert FS (from step 1) to DataTable
(3) use 'DataTable To CSV' activity to convert from DataTable to CSV string to download, then convert a CSV string to the Byte Array using VB.NET 'System.Text.Encoding.ASCII.GetBytes(csv)'
(4) use 'Create Temp File' activity to get the url, and use 'Display Hyperlink' activity for a user to download the csv.
Wish this helps you to achieve what you want to do.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
13 Kommentare