Issue 18831

Summary: Import from OO spreadsheet and other external sources to datasource
Product: Base Reporter: arnechaa <arnechaa>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues, pagalmes.lists, xslf
Version: OOo 1.1 RC3   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description arnechaa 2003-08-29 21:03:35 UTC 
It would be very usefull to have an import function so that you can import data 
from a spreadsheet to a datasource. Import from other sources like text ascii 
text files would also be helpfull.

Arne
Comment 1 Frank Schönheit 2003-09-01 09:26:02 UTC 
for the spreadsheets: open the spreadsheet in Calc, mark the data
range in question, and drag'n'drop it onto the tables container of the
data source where you want it to import ...
Comment 2 hans_werner67 2004-02-02 12:47:26 UTC 
change subcomponent to 'none'
Comment 3 Frank Schönheit 2004-07-15 21:46:05 UTC 
confirming as valid RFE (which doesn't mean anything so far :), and assigning to
user experience team for evaluation.

Note that you can always create a data source for the external data in question,
and copy'n'paste (or drag'n'drop) the data to the target data source.

Adjusting priority.
Comment 4 javascriptdude 2005-07-05 17:59:32 UTC 
I stubled on this one for a while and finally found out how to do this from this
issue. New users who are test-driving OOO Base will get rather dissed since
there is absolutely no documentation in the helps on how to use this cool
drag`n`drop feature.

I strongly suggest wording a nice SOP on how to import into OOO Base from text
files and spreadsheets using this functionality. Please write the SOP in such a
way such that help indexes are intuitive.

Thanks for all the great work!

[:.JsD.:]
Comment 5 earthtone 2006-04-10 14:47:01 UTC 
In Base, there should be an import utility like that provided in MS Access. 
This is especially useful when trying to convert a large set of ASCII-based 
data into a HSQL DB without having to cut it up, import it into Calc, convert 
it, etc. It would be great if one could select the type of DB table format and 
also assign column types.
Comment 6 pagalmes.lists 2007-12-14 07:28:20 UTC 
it looks like a duplicates from issue 64093
Comment 7 bettina.haberer 2010-05-21 15:09:44 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".