Start a new topic

6.1.1.4 EA @export problem?

[This topic is migrated from our old forums. The original author name has been removed]

Running the below query: @export on; *@export set filename="/tmp/Sample.xls" format="xls" appendfile="true";* select * from test.dummy1; select * from test.dummy2; Yields the following error: @export on; ... Physical database connection acquired for: FTP [baguio] @export set filename="/tmp/Sample.xls" format="xls" appendfile="true"; *10:15:15 [@EXPORT - 0 row(s), 0.000 secs] Invalid value for Format: xls* ... Stopped because of errors ... 2 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.001/0.000 sec [1 successful, 0 warnings, 1 errors] This is on: +Product: DbVisualizer Personal 6.1.1.4+ +Build: #1330 (2008/09/22 18:21)+ +Java VM: Java HotSpot(TM) Server VM+ +Java Version: 1.6.0_07+ +Java Vendor: Sun Microsystems Inc.+ +OS Name: Linux+ +OS Arch: i386+ +OS Version: 2.6.26.5-28.fc8+ Changing from: *@export set filename="/tmp/Sample.xls" format="xls" appendfile="true";* to: *@export set filename="/tmp/Sample.xls" format={color:#ff0000}'{color}xls{color:#ff0000}'{color} appendfile="true";* seems to allow it to execute - but the output file type is not a spreadsheet (i.e. CSV with .xls extension?). Export from the GUI seems ok, however, the data rows of the output xls file are hidden (i.e. need to unhide from the spreadsheet app). Anybody else experiencing the same?
1 Comment

[This reply is migrated from our old forums.]

Re: 6.1.1.4 EA @export problem?
Hi Ricky, Thanks for your post! This is clearly a bug and will be fixed in the next version. Best Regards Roger