This suite contains a database which is pure ****; it will not import a simple csv file of 684k rows in my 64 bit linux laptop, but the same file loads flawlessly in windows 32 bit access 2002.
Sorry your post doesn’t make sense or I am missing something. 684,000 rows (lines)?? Have you checked compatibility? access 2002 uses a very rare database format where access 2000 & 2003 uses a more normalized M$ format. IMHO openOffice does for me way more than M$ office suite and better than koffice suite but YMMV.
My post appears like a simple rant, but I guess I should explain because it is not my purpose. Overall, I like openoffice for simple spreadsheet or word processing, but I have a tab delimited file which I exported from a commercial database product and which is a table of 684k rows and about 100 columns. I have been experimenting with R using this file. I wanted to view the contents of the file in a table form, and openoffice has this supposedly great database system builtin which is supposedly at least as good as access. The %%^& file will not load and I have spent hours on it.
It loads fine under Access 2002, so I am certain the file is not corrupted. From this perspective, I find openoffice to be a disappointment.
On 2010-11-24 12:06, RichardET wrote:
> It loads fine under Access 2002, so I am certain the file is not
> corrupted. From this perspective, I find openoffice to be a
> disappointment.
Regarding databases, me too.
There is no way to use linked tables.
I know that OO can import csv files into the calc program, I have never
tried into a database. In fact, I think I did that with accces to: import
to excel first, then to access. Or was it with OOo? I don’t remember… You
could try.
Another tool to use could be rekall. It is kde3 only, though.
–
Cheers / Saludos,
Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)
Since I have also mixed experience with the OO database I started to look
around for a good tool (which is actively maintained) I came across
http://druid.sourceforge.net/
But I did not yet have a chance to try it in real life, so take this
proposal with a grain of salt.
–
openSUSE 11.3 64 bit | Intel Core2 Quad Q8300@2.50GHz | KDE 4.5 | GeForce
9600 GT | 4GB Ram
openSUSE 11.3 64 bit | Intel Core2 Duo T9300@2.50GHz | KDE 4.5 | Quadro FX
3600M | 4GB Ram
You’re posting in ‘Get Help here’-‘Applications’-‘openoffice’, what exactly is your question?
I use Base and Calc a lot to get a flat table view of databases, but you don’t provide enough information to say anything usefull about your problem.
RichardET wrote:
> a table of 684k rows and
> about 100 columns. I have been experimenting with R using this file. I
> wanted to view the contents of the file in a table form,
If it is not essential to have it in a database and a spreadsheet is good
enough you can try to import it in gnumeric. As far as I know it has not the
limitation to the number of rows that is in OO for spreadsheets.
–
openSUSE 11.3 64 bit | Intel Core2 Quad Q8300@2.50GHz | KDE 4.5 | GeForce
9600 GT | 4GB Ram
openSUSE 11.3 64 bit | Intel Core2 Duo T9300@2.50GHz | KDE 4.5 | Quadro FX
3600M | 4GB Ram
My question is simple - 'how does one import a csv file (tab delimited) which has roughly 100 columns and about 684k rows directly into oo base? I have tried repeatedly over the last few days to achieve this simple goal and have always failed. I am not a database guru, but have knocked around Access and Paradox enough to know that this is a trivial matter for most commercial grade personal database systems as far back as 20 yrs ago.
Thanks.
Put the .csv file in a folder of it’s own.
Start Base
In the opening screen, select ‘Connect to existing database’, select ‘Text’, Next
In the next screen, select the path to the csv file, choose the appropriate values ( for example TAB as a field delimiter )
Save it as whatever name you want, done.
Just did one, with multiple csv’s in one folder, Base treats them as files in the new database. Which is good.
BTW Done in LibreOffice, but that should be the same in OO.o.
What about trying with LibreOffice and chatting with the developers on
IRC #libreoffice
Else sounds like a candidate for a bug report.
–
Cheers Malcolm °¿° (Linux Counter #276890)
SUSE Linux Enterprise Desktop 11 (x86_64) Kernel 2.6.32.24-0.2-default
up 1 day 13:54, 3 users, load average: 0.10, 0.13, 0.05
GPU GeForce 8600 GTS Silent - Driver Version: 260.19.21
Thanks for the tip! I did it and the access is very fast, very impressive. It is curious to me though why the basic help screens of oo base want me to go through opening the file, etc. that simply never worked.
On 2010-11-24 13:57, martin_helm wrote:
> Since I have also mixed experience with the OO database I started to look
> around for a good tool (which is actively maintained) I came across
> http://druid.sourceforge.net/
>
> But I did not yet have a chance to try it in real life, so take this
> proposal with a grain of salt.
It certainly does look interesting!
…]
Mmm… it is java…
That link is for version 1, they are at version 3.11 now. I will have a look.
–
Cheers / Saludos,
Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)
Carlos E. R. wrote:
> On 2010-11-24 13:57, martin_helm wrote:
>
> That link is for version 1, they are at version 3.11 now. I will have a
> look.
>
They did not update the main page but the link at the “More Info” on that
page goes for me directly to the current version download.
One thing I always check is to look then at “View all files” to see how
continuosly the project is updated to get an idea how vital it is.
It is updated for ten years now which is for me a good sign (of course I
still have to check how ussefull it is and so on).
–
openSUSE 11.3 64 bit | Intel Core2 Quad Q8300@2.50GHz | KDE 4.5 | GeForce
9600 GT | 4GB Ram
openSUSE 11.3 64 bit | Intel Core2 Duo T9300@2.50GHz | KDE 4.5 | Quadro FX
3600M | 4GB Ram
On 2010-11-24 13:57, martin_helm wrote:
> Since I have also mixed experience with the OO database I started to look
> around for a good tool (which is actively maintained) I came across
> http://druid.sourceforge.net/
>
> But I did not yet have a chance to try it in real life, so take this
> proposal with a grain of salt.
I can not even make it find an existing database!
Project -> new.
Right click, add database. A wizard opens: Create empty database, create a
minimal database (recomended), create the database from a template.
This is useless! Whossshh! Druid goes down the drain. :-/
Ok, I’ll try again. Click help… says to read the manual.
There is a tutorial.pdf, dated 2003. It has a chapter:
> 1.8 Using the JDBC drivers to access the database
> Through Druid you can directly access the databases you’re working on using one or more JDBC
> drivers. In order to add a driver, let’s go to the Config menu and select JDBC drivers. Let’s
> click the new button and browse to the jar file which contains the driver we need. Here we can
> see how Druid is able to work at the same time with different JDBC drivers; in this case I’ve
> installed the PostgreSQL and MySQL drivers (figure 1.8).
Ok, I go there, click “new” driver, none appears, file browser points to my
home folder. I know the jdbc driver exists, OO uses it, and finds it
automatically. Why do I have to search for it in 2010!? I don’t even know
the name of the file!
Good grief! Down the drain again. :-/
–
Cheers / Saludos,
Carlos E. R.
(from 11.2 x86_64 “Emerald” at Telcontar)
Fantastic! Very useful this method. Thanks from me too.
Yes, it is the same.