Everton1878 Posted July 5, 2017 Share Posted July 5, 2017 Hi, When exporting a CSV from a SQL query in Database Direct there aren't any text qualifiers as there are when exporting a CSV from the requests list This causes problems when there are blank fields and where there a commas in the text fields as it puts the items in the wrong columns Would it be possible to change that or give the option to use text qualifiers? thanks, Pete Link to comment Share on other sites More sharing options...
TrevorKillick Posted July 10, 2017 Share Posted July 10, 2017 Hi @Everton1878 Sorry for the late reply this has been fixed in the next release of the Admin Tool (665) and the Server (2779) I will post an update when both of these are available hopefully within the next couple of weeks. Kind Regards Trevor Killick 1 Link to comment Share on other sites More sharing options...
Everton1878 Posted July 10, 2017 Author Share Posted July 10, 2017 Thanks @Trevor Killick Link to comment Share on other sites More sharing options...
TrevorKillick Posted July 19, 2017 Share Posted July 19, 2017 @Everton1878 This is has now been fixed and had made its way to Live along with some additional export formats. Kind Regards Trevor Killick 1 Link to comment Share on other sites More sharing options...
Everton1878 Posted July 19, 2017 Author Share Posted July 19, 2017 Thanks @TrevorKillick I've just exported some queries to CSV and everything is in the columns it should be in Thanks for getting it fixed so quickly 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now