Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: openoffice

  1. #1

    Default openoffice

    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.

  2. #2
    Join Date
    Jul 2009
    Location
    Rockyford Alberta Canada
    Posts
    1,290

    Default Re: openoffice

    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.
    When your up to your a** in Alligators it's pretty hard to remember you intended to drain the swamp (author unknown)

  3. #3

    Default Re: openoffice

    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.

  4. #4
    Join Date
    Feb 2009
    Location
    Spain
    Posts
    25,547

    Default Re: openoffice

    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)

  5. #5
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    4,654

    Default Re: openoffice

    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

  6. #6
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    4,654

    Default Re: openoffice

    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

  7. #7
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,590
    Blog Entries
    14

    Default Re: openoffice

    Quote Originally Posted by RichardET View Post
    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.
    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.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  8. #8

    Default Re: openoffice

    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.

  9. #9
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,590
    Blog Entries
    14

    Default Re: openoffice

    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.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  10. #10
    Join Date
    Jun 2008
    Location
    Podunk
    Posts
    26,335
    Blog Entries
    15

    Default Re: openoffice

    Quote Originally Posted by RichardET
    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.
    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


Page 1 of 2 12 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •