Issue 125655 - Cannot save into CSV format
Summary: Cannot save into CSV format
Status: CLOSED DUPLICATE of issue 59369
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.1.0
Hardware: All Windows 8, 8.1
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2014-09-22 16:01 UTC by stephen adams
Modified: 2014-09-22 20:09 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description stephen adams 2014-09-22 16:01:22 UTC 
Base can only save in .ODF format.
To transfer data to other databases in needs to be able to save in more than one format. UK Government exchange format is CSV, but this is not available.
When is this and other formats, Dbase, Excel Spreadsheet etc. going to made available?
Comment 1 Regina Henschel 2014-09-22 16:07:38 UTC 
What do you want to save? Base itself is a container and it makes no sense to save it to CSV. Saving a single table to .csv is a task of the database engine Base links to.
Comment 2 stephen adams 2014-09-22 18:30:26 UTC 
The table data cannot be saved into csv format only .odf  format. "Base is the container and the database engine does the work", but it appears nowhere in the application.
There is no option to saved the database table data into another format in the application for use by another database, spreadsheet etc. The data can be created in Base, but not used anywhere else!
It is not necessarily linked to another database if that is what you mean, why run two?
Comment 3 Regina Henschel 2014-09-22 20:09:11 UTC 
If you do not have linked it to an external database engine, then likely the embedded HSQL engine is used. You should see "HSQL Database engine" in the status bar. This is a HSQL ver. 1.8.

This database engine does not know a single command to export to csv. You need several steps:
Create a HSQL "text table": CREATE TEXT TABLE
Connect this text table to the desired .csv file and determine such things as delimiter and character encoding: SET TABLE
Copy your data from your table into the new, and up to now empty, text table: INSERT INTO
Perhaps delete the text table or disconnect it from the .csv file.
Find details on text tables in http://hsqldb.org/doc/guide/ch06.html.
That way will give you full control over the export.

But perhaps this simple solution might already work for you:
In menu Tools > SQL...
Write command
SELECT * INTO TEXT "<file name of export without .csv>" FROM "<name of table to be exported>"
Click Execute
The .csv file is generated in the same directory as the .odb file.
Of cause you have to use your own names instead of the <..> parts.

So "Cannot" is not correct. But you are right, it would be nice to have a UI for such export. But that is already tracked in issue 59369. There are other similar request mentioned there.

*** This issue has been marked as a duplicate of issue 59369 ***