Copy data as csv is not working
Copy data as csv is not working
I select a column of numbers in the results grid and select copy data as csv and the output is the column of numbers instead of a list of comma separated values. It's also copying the header which it shouldn't.
Using SQL Complete 6.2.23.
Using SQL Complete 6.2.23.
Re: Copy data as csv is not working
We will fix this issue in one of the next product builds.
Re: Copy data as csv is not working
I noticed that the update from few days ago didn't include a fix for this issue. I hope it's coming soon.
Re: Copy data as csv is not working
This has not been fixed in 6.3.16. The two bugs I reported haven't been fixed!
Re: Copy data as csv is not working
Sorry for the delay on this.
Due to unforeseen circumstances, this was moved forward to version 6.4.
Due to unforeseen circumstances, this was moved forward to version 6.4.
Re: Copy data as csv is not working
Hello,
Options to tune the behavior of the data coping is implemented in a new version of SQL Complete (v6.6).
Go to SSMS main menu -> SQL Complete -> Options... -> Data Export -> CSV then uncheck "Show a table header" and choose comma in "Field separator".
Best Regards.
Re: Copy data as csv is not working
That setting has no effect.
Do a select from any table.
Select a bunch of values in a single column.
Select Copy data as CSV,
Paste.
The result is just the values exactly as if I did a regular copy. The result should be the values separated by a comma in one line. It needs to work just like how Generate Script As Insert works. Generate insert creates a comma delimited list. Make Copy as CSV work in a similar fashion.
Do a select from any table.
Select a bunch of values in a single column.
Select Copy data as CSV,
Paste.
The result is just the values exactly as if I did a regular copy. The result should be the values separated by a comma in one line. It needs to work just like how Generate Script As Insert works. Generate insert creates a comma delimited list. Make Copy as CSV work in a similar fashion.
Re: Copy data as csv is not working
If you want to have the following:
you have to either execute the the query:
or use another feature of dbForge by right-clicking in the grid and selecting 'Generate Script As -> WHERE IN()' from the popup menu.
Code: Select all
Buchanan, Callahan, Davolio, Dodsworth, Fuller, King, Leverling, Peacock, Suyama
Code: Select all
USE [Northwind];
DECLARE @str nvarchar(max);
select @str = coalesce(@str + ', ', '') + [LastName] from [Employees]
PRINT @str;
Re: Copy data as csv is not working
Why don't you just fix it!?? I don't want to remember and write a special long query. I don't want to use some other option and edit its result. The option says copy data as csv. . What's the problem of creating csv values from my selection??
It's over a year now. You already said earlier that it will be fixed. Did you decide not to fix it?
I bought your tool and pay for upgrades so that I don't have to write that kind of query you're suggesting to use.
It's over a year now. You already said earlier that it will be fixed. Did you decide not to fix it?
I bought your tool and pay for upgrades so that I don't have to write that kind of query you're suggesting to use.
Re: Copy data as csv is not working
Hello,
Thanks for the reply.
Anyway, you are able to add this feature to vote on our UserVoice site.
Top-rated ideas will be included in SQL Complete roadmap.
Best Regards.
Thanks for the reply.
We classify this as the expected behavior (but not a bug) and it works as the same feature of SSMS (Data Result -> Save results As...).Why don't you just fix it!??
Anyway, you are able to add this feature to vote on our UserVoice site.
Top-rated ideas will be included in SQL Complete roadmap.
Best Regards.
Re: Copy data as csv is not working
By the way, as a workaround, you can add an empty virtual column to your query next to the data and export the column data to CSV the way you want.
This query
Please have a look at the following example.
Have you managed to copy data to CSV with help of SQL Complete the way you want?
This query
should be transformed into the following querySELECT data1, data2, data3, data4
FROM table1;
In the results grid make a selection of both data3 and empty_virtual then perform copying data to CSV.SELECT data1, data2, data3, '' as empty_virtual, data4
FROM table1;
Please have a look at the following example.
Have you managed to copy data to CSV with help of SQL Complete the way you want?
Re: Copy data as csv is not working
The workaround is to select the values in that single column in the grid. Select Generate Script AS WHERE IN() and copy to the clipboard. Paste it and then copy the csv part.