RE: Notes View to iSeries/400 Database File

["Scott Johnson" <sjohnson@xxxxxxxxxxxxx>]

With a little work, this can be easy.

1. Load a DB2 connector onto the NT server. The ODBC driver from client access
should work.

2. Write a lotusscript agent in the Notes db that reads the view and writes to
the DB2 file.

3. Schedule the agent to run as needed.

Here is a link to a redpaper that has examples of how to write the agent:
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/redp0115.html?Open


Another option would be to use JAVA.  There is a JDBC for lotus notes that you
could load and use to access the view.


-- Scott Johnson


> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> bill.reger@xxxxxxxxxxxxx
> Sent: Wednesday, September 24, 2003 7:50 AM
> To: Midrange-L@xxxxxxxxxxxx
> Subject: Notes View to iSeries/400 Database File
>
>
> I need to download a Lotus Notes View (Notes running on an NT
> BTW) to an
> iSeries/400 database file.  The Documents in the View have
> field elements
> made up of Text values and Dates.  I know I can export a
> Notes View to a
> spreadsheet, cleanup the spreadsheet data, and then download the
> spreadsheet to the 400, but it seems to me there ought to be
> an easier way
> that isn't manual.
>
> Is there a way I can automate all this and end up with a
> database file I
> can actually use on my 400 that has field types I can work
> with?  Oh yeah,
> I almost forgot ... I'd prefer something that won't require a
> lot of time
> or training as I have little time available to me.  <g>
>
> Bill
>