search

MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
75 stars 22 forks source link

Feature Request : csv export #368

Closed sybaris closed 4 months ago

sybaris commented 1 year ago

Hi,

Sql4Cds has become an essential tool for me. Thanks a lot for this... Something that should be usefull for me : When you right click on the datagrid a new menu item to make a csv export. A good settings should be also to choose the delimiter (comma, semi column etc...)

CsvHelper could be usefull for this feature request...

image

Thanks for advance. Sybaris

MarkMpn commented 1 year ago

Ideally this would also support exporting to Excel - the Excel export could also include the hyperlinks to records. It should also support the standard query/saveCsv and query/saveExcel commands in Azure Data Studio, reusing the same logic.

MatthewTheRaven commented 7 months ago

I just wanted to bump this request. As is, I can copy the results and paste into notepad as a tab separated list, and then replace all the tabs with commas. However, being able to save directly from the results to CSV or Excel would be an outstanding feature.

MarkMpn commented 4 months ago

Looking at adding this in to the next release. What would be best for null values - an empty string or the word NULL?

sybaris commented 4 months ago

Looking at adding this in to the next release. What would be best for null values - an empty string or the word NULL?

Good question :-) Today, when we make a copy/paste to Excel, NULL is displayed as NULL. So I would have a preference to keep this. And thanks for your very good job...

Example : image