Re: Accessing iSeries data from OpenOffice

["Steve Landess" <sjl_abc@xxxxxxxxxxx>]

Peter -

I haven't tried using it with the iSeries, but I don't believe that Open 
Office Base (the database) is ready for prime-time yet.  I wouldn't waste my 
time trying to use it right now.  I recently spent several weeks in my spare 
time playing around with Base.  I was trying to convert some tables and 
queries that I had created in MS Access over to Base, but it repeatedly 
crashed on me when I was importing data into the Base tables when importing 
over a few thousands records, and it was also was incredibly slow during the 
import process.

I would follow Rick's advice and use cpytoimpf to copy the iSeries data to a 
csv file and import that into your Open Office spreadsheet.

- sjl

----- Original Message ----- 
From: <Peter.Colpaert@xxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, December 07, 2006 8:37 AM
Subject: Accessing iSeries data from OpenOffice


> Hi group,
>
> At home I already use OpenOffice exclusively, but here at work I still
> rely on the iSeries Data Transfer plugin for Excel if I need to download
> massive amounts of data into a spreadsheet.
>
> For small recordsets, I use the export to excel functionality in the
> Quantum plugin for WDSCi, but once over a certain amount of data, it will
> crash WDSCi (memory problems).
>
> Has anybody been able to get iSeries data into an OpenOffice spreadsheet
> directly?  Either through a data source or an OpenOffice database
> (probably using JDBC)?
>
> Thanks in advance,
>
> Peter Colpaert
> Application Developer
> PLI - IT - Kontich, Belgium
> -----
> Yoda of Borg are we.  Futile is resistance, assimilated will you be.
> -----
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.