vieten / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Exporting results with NULL values always produces NULL regardless of what is entered in export display window #1162

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Run query which results some NULL values
2. Export results as CSV, ensuring that the 'NULL values:' box contains 
something other than 'NULL', for example, a '.' or even leaving it blank.

What is the expected output? What do you see instead?
I would expect that the output would contain all the results but that cells 
contain NULL would be displayed using the string entered in the dialog box. 
Instead, the CSV file always contains the string "NULL".

What version of Sequel Pro are you using? 0.9.9 (build 3348)
What version of MySQL are you connecting to on the server? 5.5.10

Please provide any additional information below.
I want to export results from Sequel Pro and import them into a stats package, 
namely Stata. On import Stata detects what information is contained in each 
column and sets the variable type accordingly. Consequently, a variable that 
contains floating points values, intermingled with the string "NULL" is 
detected as a string variable instead of a float. Sequel Pro 0.9.9 has a 
feature to determine how NULL values are exported but this doesn't seem to be 
working - regardless of what is entered in the export dialog box, the string 
"NULL" always appears in the exported file. This is, I think, related to issue 
67 which was fixed some time ago. However, I don't think the resulting fix is 
the most useful or intuitive implementation.

Original issue reported on code.google.com by p.h.jo...@liverpool.ac.uk on 26 Aug 2011 at 10:13

GoogleCodeExporter commented 9 years ago
This issue was resolved in build r3365. See the nightly builds 
(http://nightly.sequelpro.com/) to verify it works as expected.

Original comment by avenja...@gmail.com on 26 Aug 2011 at 10:19