Azuredatastudio: Can no longer export results to Excel, csv, or json

Created on 31 Aug 2018  路  8Comments  路  Source: microsoft/azuredatastudio

So prior to the new update SQL Ops Studio this was working, after the new update today, all this functionality is lost,

I can attempt to export the file to say excel or csv, but when you go look for it nothing was written, no file anywhere ,

  • SQL Operations Studio Version:

Steps to Reproduce:

Bug

Most helpful comment

If you do not select lines/records in the resultset,
(i.e. you want to export all lines) then the export fails.
work-around: in result set right-click, select-all, export as csv/json/excel

All 8 comments

Same here, on build 0.32.8: it must be noted that, if a single row has been selected, the export succeeds.

Fortunately the previous build (0.32.7) was available to download and works properly, so I'm just avoiding updates at the moment.

looks like if you select all the records right click and export it works, still looking at the new features list.

@abist could you please take a look and see what happened her with the Export change in 0.32.8?

@dbarob @pmanna Can you elaborate the steps to reproduce this issue? Are you directly clicking on the "Export to ..." buttons or Selecting a subset of the grid and right clicking to export into some file?

If you do not select lines/records in the resultset,
(i.e. you want to export all lines) then the export fails.
work-around: in result set right-click, select-all, export as csv/json/excel

@GDmac - what he said

This is now fixed in the new release. I'm going to close this issue, please feel free to reopen it if you see it again!

image

Problem with export to Excel.

  1. If you try to export the result to Excel after it is received, all the rows will be exported.
  2. But if you have selected any rows or all of them - you cant roll back rows selecting and your export will be contains only first row.

Example for reproduce:

  1. Execute some query where response have several rows
  2. Select all rows in the result panel:
    image
  3. Export data to Excel
    The result has just first row
    image
Was this page helpful?
0 / 5 - 0 ratings