>Hi all,
>
>I wonder if anyone knows of a way, tool, web site or anything that can help me to get data from a Lotus Notes based system into dbf format or anything else that later I can export to it.
>
>The export feature on the program is really bad (or maybe I don't know how to use it), because when trying to export the visible data into a worksheet all it exports is just those columns visible on document and not ALL the columns as I need them.
>
>I imagine that there's got to be a tool that will read an .nsf file and show me all the components and tables within the file (does it work like Access's mdb's or am I dreaming?)
>
>
>Thanks a WHOLE HECK of a lot

Getting data from Notes is near impossible. Lotus has an ODBC driver that sucks at best [at least when I tried it]. What we do is either create a special Notes agent that writes all the fields for a specific table out to a delimited text file that we can import into a dbf. I also created a PRG [see File #9568] that creates a VFP export file in the format needed to import data into a Notes database.

The other trick we do is have our Notes developers include Notes agents in the data entry forms that write data to Oracle tables on the fly [as changes, deletes and new records are added to Notes databases]. We then use VFP to access the data in Oracle. We also have geniuses that think Notes is a relational database system and is the ideal product for creating such systems. What a laugher.