Issue 18831 - Import from OO spreadsheet and other external sources to datasource
Summary: Import from OO spreadsheet and other external sources to datasource
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC All
: P4 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-29 21:03 UTC by arnechaa
Modified: 2013-02-07 22:42 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
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 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".